ASI_SmartList_Favorites_Columns (ASIEXP92)

azurecurve Products SmartList (1493)PathnameASI_SmartList_Favorites_Columns (ASIEXP92)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP92

Display Name: ASI_SmartList_Favorites_Columns
Physical Name: ASIEXP92
Technical Name: ASI_Explorer_Favorites_Columns

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
2	ASI_Favorite_Dict_ID	ASI_Favorite_Dict_ID	Integer	INT	0
3	ASI_Favorite_Type	ASI_Favorite_Type	Integer	INT	0
4	ASI_Favorite_Name	ASI_Favorite_Name	String	STR80	80
5	CMPANYID	Company ID	Integer	INT5	4
	Key to the Company Master (SY01500). Click to show/hide SELECT ['ASI_SmartList_Favorites_Columns'].CMPANYID AS 'ASI_SmartList_Favorites_Columns-Company ID' ,['Company Master'].CMPANYID AS 'Company Master-Company ID' FROM ASIEXP92 AS ['ASI_SmartList_Favorites_Columns'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['ASI_SmartList_Favorites_Columns'].CMPANYID = ['Company Master'].CMPANYID
6	ASI_Field_Sequence	ASI_Field_Sequence	Integer	INT	0
7	ASI_Include_Column	ASI_Include_Column	Boolean	ASI_CB_Include_Column	0
8	ASI_Display_Column	ASI_Display_Column	Boolean	ASI_CB_Display_Column	0
9	ASI_Field_Number_Dict_ID	ASI_Field_Number_Dict_ID	Integer	INT	0
10	ASI_Field_Number	ASI_Field_Number	Integer	INT	0
11	ASI_Field_Name	ASI_Field_Name	String	STR80	80
12	ASI_Column_Display_Name	ASI_Column_Display_Name	String	STR80	80
13	ASI_Field_Display_Name	ASI_Field_Display_Name	String	STR80	80
14	ASI_Display_Column_Width	ASI_Display_Column_Width	Integer	INT	0
15	ASI_Field_Datatype	ASI_Field_Datatype	Integer	ASI_Field_Datatype	0

azurecurve Products SmartList (1493)PathnameASI_SmartList_Favorites_Columns (ASIEXP92)