SmartList Favorites Columns Master (ASIEXP86)

azurecurveProductsSmartList (1493)SystemSmartList Favorites Columns Master (ASIEXP86)

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

Product: SmartList (1493)
Series: System

Display Name: SmartList Favorites Columns Master
Physical Name: ASIEXP86
Technical Name: ASI_MSTR_Explorer_Favorites_Columns

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDINTInteger20
2ASI_Favorite_Type SearchASI_Favorite_TypeINTInteger20
3ASI_Favorite_Save_Level SearchASI_Favorite_Save_LevelASI_Favorite_Save_LevelInteger20
4CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['SmartList Favorites Columns Master'].CMPANYID AS 'SmartList Favorites Columns Master-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP86 AS ['SmartList Favorites Columns Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['SmartList Favorites Columns Master'].CMPANYID = ['Company Master'].CMPANYID
5USRCLASS SearchUser ClassSTR15_User_ClassString1615
6USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Favorites Columns Master'].USERID AS 'SmartList Favorites Columns Master-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP86 AS ['SmartList Favorites Columns Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Favorites Columns Master'].USERID = ['Users Master'].USERID
7ASI_Favorite_Name SearchASI_Favorite_NameSTR80String8280
8ASI_Field_Sequence SearchASI_Field_SequenceINTInteger20
9ASI_Include_Column SearchASI_Include_ColumnASI_CB_Include_ColumnBoolean20
10ASI_Display_Column SearchASI_Display_ColumnASI_CB_Display_ColumnBoolean20
11ASI_Field_Number_Dict_ID SearchASI_Field_Number_Dict_IDINTInteger20
12ASI_Field_Number SearchASI_Field_NumberINTInteger20
13ASI_Column_Display_Name SearchASI_Column_Display_NameSTR80String8280
14ASI_Display_Column_Width SearchASI_Display_Column_WidthINTInteger20
15DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsSmartList (1493)SystemSmartList Favorites Columns Master (ASIEXP86)

Leave a Reply

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