Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT20200
Product: Extender (3107)
Series: Project
Display Name: Extender Forms
Physical Name: EXT20200
Technical Name: EXT_Extender_FormsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Form_ID 
Extender Form ID STR15_LBAU String 15 2 Extender_Form_Name Extender Form Name STR64 String 64 3 Extender_Form_ID_Prompt Extender Form ID Prompt STR50 String 50 4 INACTIVE Inactive CB_Inactive Boolean 0 5 Use_Existing_Lookup Use Existing Lookup Use Existing Lookup Boolean 0 6 Lookup_Number Lookup Number Long_10U Long Integer 10 7 Autoincrement Autoincrement Autoincrement ID Field Boolean 0 8 Extender_Description_Pro Extender Description Prompt STR50 String 50 9 Description_Field_Req Description Field Required Description Field Required Boolean 0 10 Use_Secondary_Key Use Secondary Key Use Secondary Key Boolean 0 11 Extender_Second_Prompt Extender Secondary ID Prompt STR50 String 50 12 Extender_Field_IDs_1 Extender Field IDs[1] Long Int Long Integer 8 13 Extender_Field_IDs_2 Extender Field IDs[2] Long Int Long Integer 8 14 Extender_Field_IDs_3 Extender Field IDs[3] Long Int Long Integer 8 15 Extender_Field_IDs_4 Extender Field IDs[4] Long Int Long Integer 8 16 Extender_Field_IDs_5 Extender Field IDs[5] Long Int Long Integer 8 17 Extender_Field_IDs_6 Extender Field IDs[6] Long Int Long Integer 8 18 Extender_Field_IDs_7 Extender Field IDs[7] Long Int Long Integer 8 19 Extender_Field_IDs_8 Extender Field IDs[8] Long Int Long Integer 8 20 Extender_Field_IDs_9 Extender Field IDs[9] Long Int Long Integer 8 21 Extender_Field_IDs_10 Extender Field IDs[10] Long Int Long Integer 8 22 Extender_Field_IDs_11 Extender Field IDs[11] Long Int Long Integer 8 23 Extender_Field_IDs_12 Extender Field IDs[12] Long Int Long Integer 8 24 Extender_Field_IDs_13 Extender Field IDs[13] Long Int Long Integer 8 25 Extender_Field_IDs_14 Extender Field IDs[14] Long Int Long Integer 8 26 Extender_Field_IDs_15 Extender Field IDs[15] Long Int Long Integer 8 27 Extender_Field_IDs_2_1 Extender Field IDs 2[1] Long Int Long Integer 8 28 Extender_Field_IDs_2_2 Extender Field IDs 2[2] Long Int Long Integer 8 29 Extender_Field_IDs_2_3 Extender Field IDs 2[3] Long Int Long Integer 8 30 Extender_Field_IDs_2_4 Extender Field IDs 2[4] Long Int Long Integer 8 31 Extender_Field_IDs_2_5 Extender Field IDs 2[5] Long Int Long Integer 8 32 Extender_Field_IDs_2_6 Extender Field IDs 2[6] Long Int Long Integer 8 33 Extender_Field_IDs_2_7 Extender Field IDs 2[7] Long Int Long Integer 8 34 Extender_Field_IDs_2_8 Extender Field IDs 2[8] Long Int Long Integer 8 35 Extender_Field_IDs_2_9 Extender Field IDs 2[9] Long Int Long Integer 8 36 Extender_Field_IDs_2_10 Extender Field IDs 2[10] Long Int Long Integer 8 37 Extender_Field_IDs_2_11 Extender Field IDs 2[11] Long Int Long Integer 8 38 Extender_Field_IDs_2_12 Extender Field IDs 2[12] Long Int Long Integer 8 39 Extender_Field_IDs_2_13 Extender Field IDs 2[13] Long Int Long Integer 8 40 Extender_Field_IDs_2_14 Extender Field IDs 2[14] Long Int Long Integer 8 41 Extender_Field_IDs_2_15 Extender Field IDs 2[15] Long Int Long Integer 8 42 Detail_Field_IDs_1 Extender Detail Field IDs[1] Long Int Long Integer 8 43 Detail_Field_IDs_2 Extender Detail Field IDs[2] Long Int Long Integer 8 44 Detail_Field_IDs_3 Extender Detail Field IDs[3] Long Int Long Integer 8 45 Detail_Field_IDs_4 Extender Detail Field IDs[4] Long Int Long Integer 8 46 Detail_Field_IDs_5 Extender Detail Field IDs[5] Long Int Long Integer 8 47 Detail_Field_IDs_6 Extender Detail Field IDs[6] Long Int Long Integer 8 48 Detail_Field_IDs_7 Extender Detail Field IDs[7] Long Int Long Integer 8 49 Detail_Field_IDs_8 Extender Detail Field IDs[8] Long Int Long Integer 8 50 Detail_Field_IDs_9 Extender Detail Field IDs[9] Long Int Long Integer 8 51 Detail_Field_IDs_10 Extender Detail Field IDs[10] Long Int Long Integer 8 52 Detail_Field_IDs_2_1 Extender Detail Field IDs 2[1] Long Int Long Integer 8 53 Detail_Field_IDs_2_2 Extender Detail Field IDs 2[2] Long Int Long Integer 8 54 Detail_Field_IDs_2_3 Extender Detail Field IDs 2[3] Long Int Long Integer 8 55 Detail_Field_IDs_2_4 Extender Detail Field IDs 2[4] Long Int Long Integer 8 56 Detail_Field_IDs_2_5 Extender Detail Field IDs 2[5] Long Int Long Integer 8 57 Detail_Field_IDs_2_6 Extender Detail Field IDs 2[6] Long Int Long Integer 8 58 Detail_Field_IDs_2_7 Extender Detail Field IDs 2[7] Long Int Long Integer 8 59 Detail_Field_IDs_2_8 Extender Detail Field IDs 2[8] Long Int Long Integer 8 60 Detail_Field_IDs_2_9 Extender Detail Field IDs 2[9] Long Int Long Integer 8 61 Detail_Field_IDs_2_10 Extender Detail Field IDs 2[10] Long Int Long Integer 8 62 Read_Only_CB Read Only CB Read Only CB Boolean 0 63 Add_Extender_Form_Detail Add Extender Form Details Add Extender Form Details Boolean 0 64 Expand_Scrolling_Default Expand Scrolling Grid by Default Expand Scrolling Grid By Default Boolean 0 65 Show_Total_CB Show Total CB Show Total CB Boolean 0 66 Total_Field_ID Total Field ID Long Int Long Integer 8 67 Multicurrency_CB Multicurrency CB Multicurrency CB Boolean 0 68 Currency_Field_ID Currency Field ID Long Int Long Integer 8 69 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['Extender Forms'].RATETPID AS 'Extender Forms-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
EXT20200 AS ['Extender Forms']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Extender Forms'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID70 Currency_Default_FieldID Currency Default Field ID Long Int Long Integer 8 71 Currency_Default_Method Currency Default Method Currency Default Method Integer 0 72 Default_From_Field_ID Default From Field ID Long Int Long Integer 8 73 Extender_Template_ID Extender Template ID Long Int Long Integer 8 74 Template_SelectionMethod Template Selection Method Template Selection Method Integer 0 75 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Extender Forms'].NOTEINDX AS 'Extender Forms-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT20200 AS ['Extender Forms']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extender Forms'].NOTEINDX = ['Record Notes Master'].NOTEINDX76 CREATDDT Created Date DT Date 8 77 CRUSRID Created User ID STR15_User_ID String 15 78 MODIFDT Modified Date DT Date 8 79 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Forms'].MDFUSRID AS 'Extender Forms-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT20200 AS ['Extender Forms']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Forms'].MDFUSRID = ['Users Master'].USERID