Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP92
Product: SmartList (1493)
Series:
Display Name: ASI_SmartList_Favorites_Columns Group Display Name: SmartList Master
Physical Name: ASIEXP92
Technical Name: ASI_Explorer_Favorites_Columns
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/hideSELECT
['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 | |