@luca.puccini I’m not sure I understand what you are trying to achieve.

Basically there you see:

OutlineNames: all the column names of Customs_Stat_Number_CFT table (including the CG_HTSCODE custom field).

DefColOrder: the order in which the columns are displayed for this profile. Will change if the user re-orders the columns and saves the changes to the profile

ColVisibility: 0 → hidden | 1 → visible. Meaning OBJID,OBJVERSION are hidden | CustomsStatNo, Description, UoM are visible. → these could be changed from Customs Statistic page RMB → Column Chooser

I’m not sure if this is what you’re looking for, but maybe it helps.

Hello @Marcel.Ausan,

Thank you very much.

Yes it was not clear, I’m searching for a view name or an API to invoke to obtain those field.

Thanks.

@luca.puccini I don’t have access to an Apps10 environment, but you could open the debugger → CTRL + Alt → Tools => Open Debug and then refresh the page. There you could see what is the SQL executed to get the info on the client page.

Hi Luca,

Is the view CUSTOMS_STATISTICS_NUMBER the one you are looking for?

Hi @WyrDavidB,

No, this is only an example, but now I found it !!

Fndrr_Client_Profile_Value