Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT20120
Product: Extender (3107)
Series: Project
Display Name: Extender Enquiry Setup
Physical Name: EXT20120
Technical Name: EXT_Extender_EnquiriesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Enquiry_ID 
Extender Enquiry ID Long Int Long Integer 8 2 Extender_Window_Name Extender Window Name STR64 String 64 3 Extender_Window_ID Extender Window ID STR15_LBAU String 15 4 PRODID Product ID INT4 Integer 4 5 Long_Form_Name Long Form Name STR255 String 255 6 Long_Window_Name Long Window Name STR100 String 100 7 Extender_Hot_Key Extender Hot Key STR1 String 1 8 Read_Only_CB Read Only CB Read Only CB Boolean 0 9 Use_Alternate_Key_CB Use Alternate Key CB Use Alternate Key CB Boolean 0 10 Extender_Key_Fields_1 Extender Key Fields[1] STR100 String 100 11 Extender_Key_Fields_2 Extender Key Fields[2] STR100 String 100 12 Extender_Key_Fields_3 Extender Key Fields[3] STR100 String 100 13 Extender_Key_Fields_4 Extender Key Fields[4] STR100 String 100 14 Extender_Key_Fields_5 Extender Key Fields[5] STR100 String 100 15 Extender_Key_Windows_1 Extender Key Windows[1] STR100 String 100 16 Extender_Key_Windows_2 Extender Key Windows[2] STR100 String 100 17 Extender_Key_Windows_3 Extender Key Windows[3] STR100 String 100 18 Extender_Key_Windows_4 Extender Key Windows[4] STR100 String 100 19 Extender_Key_Windows_5 Extender Key Windows[5] STR100 String 100 20 CREATDDT Created Date DT Date 8 21 CRUSRID Created User ID STR15_User_ID String 15 22 MODIFDT Modified Date DT Date 8 23 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Enquiry Setup'].MDFUSRID AS 'Extender Enquiry Setup-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT20120 AS ['Extender Enquiry Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Enquiry Setup'].MDFUSRID = ['Users Master'].USERID24 Display_In_Tab Display In Tab Display In Tab CB Boolean 0 25 Tab_Name Tab Name STR50 String 50