Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NLB10000
Product: SmartList Builder (3830)
Series: System
Display Name: Navigation Lists
Physical Name: NLB10000
Technical Name: NLB_Navigation_ListsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Navigation_ID 
Navigation List ID STR15_LBAU String 15 2 Navigation_Name Navigation List Name STR64 String 64 3 Navigation_Number Navigation List Number INT5 Integer 4 4 Navigation_List_Type Navigation List Type Navigation List Type Integer 0 5 Command_Number Ribbon Command Number INT5 Integer 4 6 Series_Number Series Number INT5 Integer 4 7 Display_Status_Image Display Status Image Display status image Boolean 0 8 Table_Number Table Number INT5 Integer 4 9 Field_Number Field Number INT2 Integer 2 10 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Navigation Lists'].NOTEINDX AS 'Navigation Lists-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NLB10000 AS ['Navigation Lists']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Navigation Lists'].NOTEINDX = ['Record Notes Master'].NOTEINDX11 CREATDDT Created Date DT Date 8 12 CRUSRID Created User ID STR15_User_ID String 15 13 MODIFDT Modified Date DT Date 8 14 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Navigation Lists'].MDFUSRID AS 'Navigation Lists-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NLB10000 AS ['Navigation Lists']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Navigation Lists'].MDFUSRID = ['Users Master'].USERID15 ASI_Search_Type ASI_Search_Type ASI_Search_Type Integer 0