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 TypeLength
1ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDINTInteger0
2ASI_Favorite_Type SearchASI_Favorite_TypeINTInteger0
3ASI_Favorite_Save_Level SearchASI_Favorite_Save_LevelASI_Favorite_Save_LevelInteger0
4CMPANYID SearchCompany IDINT5Integer4
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_ClassString15
6USERID SearchUser IDSTR15_User_IDString15
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_NameSTR80String80
8ASI_Field_Sequence SearchASI_Field_SequenceINTInteger0
9ASI_Include_Column SearchASI_Include_ColumnASI_CB_Include_ColumnBoolean0
10ASI_Display_Column SearchASI_Display_ColumnASI_CB_Display_ColumnBoolean0
11ASI_Field_Number_Dict_ID SearchASI_Field_Number_Dict_IDINTInteger0
12ASI_Field_Number SearchASI_Field_NumberINTInteger0
13ASI_Column_Display_Name SearchASI_Column_Display_NameSTR80String80
14ASI_Display_Column_Width SearchASI_Display_Column_WidthINTInteger0
15DEX_ROW_ID Searchintint10

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 *