Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT01100
Product: Extender (3107)
Series: Project
Display Name: Extender Window Records
Physical Name: EXT01100
Technical Name: EXT_Window_RecordsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Record_ID 
Extender Record ID Long Int Long Integer 8 2 Extender_Window_ID Extender Window ID STR15_LBAU String 15 3 Extender_Key_Values_1 Extender Key Values[1] STR50 String 50 4 Extender_Key_Values_2 Extender Key Values[2] STR50 String 50 5 Extender_Key_Values_3 Extender Key Values[3] STR50 String 50 6 Extender_Key_Values_4 Extender Key Values[4] STR50 String 50 7 Extender_Key_Values_5 Extender Key Values[5] STR50 String 50 8 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Extender Window Records'].NOTEINDX AS 'Extender Window Records-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT01100 AS ['Extender Window Records']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extender Window Records'].NOTEINDX = ['Record Notes Master'].NOTEINDX9 MODIFDT Modified Date DT Date 8 10 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Window Records'].MDFUSRID AS 'Extender Window Records-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT01100 AS ['Extender Window Records']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Window Records'].MDFUSRID = ['Users Master'].USERID11 CREATDDT Created Date DT Date 8 12 CRUSRID Created User ID STR15_User_ID String 15