ASI_SmartList_Favorites_Columns (ASIEXP92)

azurecurveProductsSmartList (1493)PathnameASI_SmartList_Favorites_Columns (ASIEXP92)

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

Product: SmartList (1493)
Series: Pathname

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDINTInteger20
3ASI_Favorite_Type SearchASI_Favorite_TypeINTInteger20
4ASI_Favorite_Name SearchASI_Favorite_NameSTR80String8280
5CMPANYID SearchCompany IDINT5Integer24
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
6ASI_Field_Sequence SearchASI_Field_SequenceINTInteger20
7ASI_Include_Column SearchASI_Include_ColumnASI_CB_Include_ColumnBoolean20
8ASI_Display_Column SearchASI_Display_ColumnASI_CB_Display_ColumnBoolean20
9ASI_Field_Number_Dict_ID SearchASI_Field_Number_Dict_IDINTInteger20
10ASI_Field_Number SearchASI_Field_NumberINTInteger20
11ASI_Field_Name SearchASI_Field_NameSTR80String8280
12ASI_Column_Display_Name SearchASI_Column_Display_NameSTR80String8280
13ASI_Field_Display_Name SearchASI_Field_Display_NameSTR80String8280
14ASI_Display_Column_Width SearchASI_Display_Column_WidthINTInteger20
15ASI_Field_Datatype SearchASI_Field_DatatypeASI_Field_DatatypeInteger20
azurecurveProductsSmartList (1493)PathnameASI_SmartList_Favorites_Columns (ASIEXP92)

Leave a Reply

Your email address will not be published. Required fields are marked *