Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT20600
Product: Extender (3107)
Series: Project
Display Name: Extender Actions
Physical Name: EXT20600
Technical Name: EXT_Extender_ActionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Action_ID 
Extender Action ID STR15_LBAU String 15 2 Extender_Action_Name Extender Action Name STR64 String 64 3 Extender_Event_Type Extender Event Type Extender Event Type Integer 0 4 Extender_Event_ID Extender Event ID Long Int Long Integer 8 5 PRODID Product ID INT4 Integer 4 6 INACTIVE Inactive CB_Inactive Boolean 0 7 Long_Form_Name Long Form Name STR255 String 255 8 Long_Window_Name Long Window Name STR100 String 100 9 Long_Field_Name Long Field Name STR100 String 100 10 TABLTECH Table Technical Name STR79 String 79 11 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Extender Actions'].NOTEINDX AS 'Extender Actions-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT20600 AS ['Extender Actions']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extender Actions'].NOTEINDX = ['Record Notes Master'].NOTEINDX12 MODIFDT Modified Date DT Date 8 13 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Actions'].MDFUSRID AS 'Extender Actions-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT20600 AS ['Extender Actions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Actions'].MDFUSRID = ['Users Master'].USERID14 CREATDDT Created Date DT Date 8 15 CRUSRID Created User ID STR15_User_ID String 15