Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT20100
Product: Extender (3107)
Series: Project
Display Name: Extender Windows
Physical Name: EXT20100
Technical Name: EXT_Extender_WindowsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Window_ID 
Extender Window ID STR15_LBAU String 15 2 Extender_Window_Name Extender Window Name STR64 String 64 3 Extender_Window_Type Extender Window Type Extender Window Type Integer 0 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 INACTIVE Inactive CB_Inactive Boolean 0 8 Extender_Key_Windows_1 Extender Key Windows[1] STR100 String 100 9 Extender_Key_Windows_2 Extender Key Windows[2] STR100 String 100 10 Extender_Key_Windows_3 Extender Key Windows[3] STR100 String 100 11 Extender_Key_Windows_4 Extender Key Windows[4] STR100 String 100 12 Extender_Key_Windows_5 Extender Key Windows[5] STR100 String 100 13 Extender_Key_Fields_1 Extender Key Fields[1] STR100 String 100 14 Extender_Key_Fields_2 Extender Key Fields[2] STR100 String 100 15 Extender_Key_Fields_3 Extender Key Fields[3] STR100 String 100 16 Extender_Key_Fields_4 Extender Key Fields[4] STR100 String 100 17 Extender_Key_Fields_5 Extender Key Fields[5] STR100 String 100 18 Extender_Field_IDs_1 Extender Field IDs[1] Long Int Long Integer 8 19 Extender_Field_IDs_2 Extender Field IDs[2] Long Int Long Integer 8 20 Extender_Field_IDs_3 Extender Field IDs[3] Long Int Long Integer 8 21 Extender_Field_IDs_4 Extender Field IDs[4] Long Int Long Integer 8 22 Extender_Field_IDs_5 Extender Field IDs[5] Long Int Long Integer 8 23 Extender_Field_IDs_6 Extender Field IDs[6] Long Int Long Integer 8 24 Extender_Field_IDs_7 Extender Field IDs[7] Long Int Long Integer 8 25 Extender_Field_IDs_8 Extender Field IDs[8] Long Int Long Integer 8 26 Extender_Field_IDs_9 Extender Field IDs[9] Long Int Long Integer 8 27 Extender_Field_IDs_10 Extender Field IDs[10] Long Int Long Integer 8 28 Extender_Field_IDs_11 Extender Field IDs[11] Long Int Long Integer 8 29 Extender_Field_IDs_12 Extender Field IDs[12] Long Int Long Integer 8 30 Extender_Field_IDs_13 Extender Field IDs[13] Long Int Long Integer 8 31 Extender_Field_IDs_14 Extender Field IDs[14] Long Int Long Integer 8 32 Extender_Field_IDs_15 Extender Field IDs[15] Long Int Long Integer 8 33 AddExtenderWindowDetails Add Extender Window Details Add Extender Window Details Boolean 0 34 Expand_Scrolling_Default Expand Scrolling Grid by Default Expand Scrolling Grid By Default Boolean 0 35 AddExtenderWindowNotes Add Extender Window Notes Add Extender Window Notes Boolean 0 36 Detail_Field_IDs_1 Extender Detail Field IDs[1] Long Int Long Integer 8 37 Detail_Field_IDs_2 Extender Detail Field IDs[2] Long Int Long Integer 8 38 Detail_Field_IDs_3 Extender Detail Field IDs[3] Long Int Long Integer 8 39 Detail_Field_IDs_4 Extender Detail Field IDs[4] Long Int Long Integer 8 40 Detail_Field_IDs_5 Extender Detail Field IDs[5] Long Int Long Integer 8 41 Detail_Field_IDs_6 Extender Detail Field IDs[6] Long Int Long Integer 8 42 Detail_Field_IDs_7 Extender Detail Field IDs[7] Long Int Long Integer 8 43 Detail_Field_IDs_8 Extender Detail Field IDs[8] Long Int Long Integer 8 44 Detail_Field_IDs_9 Extender Detail Field IDs[9] Long Int Long Integer 8 45 Detail_Field_IDs_10 Extender Detail Field IDs[10] Long Int Long Integer 8 46 Detail_Field_IDs_2_1 Extender Detail Field IDs 2[1] Long Int Long Integer 8 47 Detail_Field_IDs_2_2 Extender Detail Field IDs 2[2] Long Int Long Integer 8 48 Detail_Field_IDs_2_3 Extender Detail Field IDs 2[3] Long Int Long Integer 8 49 Detail_Field_IDs_2_4 Extender Detail Field IDs 2[4] Long Int Long Integer 8 50 Detail_Field_IDs_2_5 Extender Detail Field IDs 2[5] Long Int Long Integer 8 51 Detail_Field_IDs_2_6 Extender Detail Field IDs 2[6] Long Int Long Integer 8 52 Detail_Field_IDs_2_7 Extender Detail Field IDs 2[7] Long Int Long Integer 8 53 Detail_Field_IDs_2_8 Extender Detail Field IDs 2[8] Long Int Long Integer 8 54 Detail_Field_IDs_2_9 Extender Detail Field IDs 2[9] Long Int Long Integer 8 55 Detail_Field_IDs_2_10 Extender Detail Field IDs 2[10] Long Int Long Integer 8 56 Show_Total_CB Show Total CB Show Total CB Boolean 0 57 Total_Field_ID Total Field ID Long Int Long Integer 8 58 Read_Only_CB Read Only CB Read Only CB Boolean 0 59 Display_In_Tab Display In Tab Display In Tab CB Boolean 0 60 Tab_Name Tab Name STR50 String 50 61 PT_Open_Method1 Extender Open Method Extender Open Method Integer 0 62 Auto_Open Auto Open Auto Open CB Boolean 0 63 Auto_Close Auto Close Auto Close Boolean 0 64 Hide_User Hide User CB_Hide_User Boolean 0 65 Hide_Note_Type Hide Note Type CB_Hide_NoteType Boolean 0 66 Hide_Date Hide Date CB_Hide_Date Boolean 0 67 Hide_Time Hide Time CB_Hide_Time Boolean 0 68 Extender_Hot_Key Extender Hot Key STR1 String 1 69 Long_Field_Name Long Field Name STR100 String 100 70 Extender_Template_ID Extender Template ID Long Int Long Integer 8 71 Template_SelectionMethod Template Selection Method Template Selection Method Integer 0 72 Special_Case_Number Special Case Number INT5 Integer 4 73 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Extender Windows'].NOTEINDX AS 'Extender Windows-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT20100 AS ['Extender Windows']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extender Windows'].NOTEINDX = ['Record Notes Master'].NOTEINDX74 CREATDDT Created Date DT Date 8 75 CRUSRID Created User ID STR15_User_ID String 15 76 MODIFDT Modified Date DT Date 8 77 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Windows'].MDFUSRID AS 'Extender Windows-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT20100 AS ['Extender Windows']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Windows'].MDFUSRID = ['Users Master'].USERID