Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DDB10000
Product: SmartList Builder (3830)
Series: System
Display Name: Drill Downs
Physical Name: DDB10000
Technical Name: DDB_Drill_DownsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Drill_Down_ID Drill Down ID STR15_LBAU String 15 2 Drill_Down_Description Drill Down Description STR64 String 64 3 Drill_Down_Type Drill Down Type INT5 Integer 4 4 PRODID Product ID INT4 Integer 4 5 FORMNAME Form Name STR79 String 79 6 Extender_Type Extender Type INT5 Integer 4 7 Extender_ID Extender ID STR15_LBAU String 15 8 SmartList_Number SmartList Number INT5 Integer 4 9 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Drill Downs'].NOTEINDX AS 'Drill Downs-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
DDB10000 AS ['Drill Downs']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Drill Downs'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10 MODIFDT Modified Date DT Date 8 11 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Drill Downs'].MDFUSRID AS 'Drill Downs-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
DDB10000 AS ['Drill Downs']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Drill Downs'].MDFUSRID = ['Users Master'].USERID
12 CREATDDT Created Date DT Date 8 13 CRUSRID Created User ID STR15_User_ID String 15