ASI_MSTR_SmartList_Favorites_OrderBy (ASIEXP83)

azurecurveProductsSmartList (1493)SystemASI_MSTR_SmartList_Favorites_OrderBy (ASIEXP83)

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

Product: SmartList (1493)
Series: System

Display Name: ASI_MSTR_SmartList_Favorites_OrderBy
Physical Name: ASIEXP83
Technical Name: ASI_MSTR_Explorer_Favorites_OrderBy

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
       ['ASI_MSTR_SmartList_Favorites_OrderBy'].CMPANYID AS 'ASI_MSTR_SmartList_Favorites_OrderBy-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP83 AS ['ASI_MSTR_SmartList_Favorites_OrderBy']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['ASI_MSTR_SmartList_Favorites_OrderBy'].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
       ['ASI_MSTR_SmartList_Favorites_OrderBy'].USERID AS 'ASI_MSTR_SmartList_Favorites_OrderBy-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP83 AS ['ASI_MSTR_SmartList_Favorites_OrderBy']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ASI_MSTR_SmartList_Favorites_OrderBy'].USERID = ['Users Master'].USERID
7ASI_Favorite_Name SearchASI_Favorite_NameSTR80String80
8ASI_Sequence SearchASI_SequenceINTInteger0
9ASI_Field_Number SearchASI_Field_NumberINTInteger0
10ASI_Field_Number_Dict_ID SearchASI_Field_Number_Dict_IDINTInteger0
11ASI_Ascending SearchASI_AscendingASI_AscendingInteger0
12DEX_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)SystemASI_MSTR_SmartList_Favorites_OrderBy (ASIEXP83)

Leave a Reply

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