Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT40300
Product: Extender (3107)
Series: Project
Display Name: v11 - Extender Forms
Physical Name: EXT40300
Technical Name: PT_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 Extender_Description_Pro Extender Description Prompt STR50 String 50 5 User_Defined_Prompts_1 User Defined Prompts[1] STR30 String 30 6 User_Defined_Prompts_2 User Defined Prompts[2] STR30 String 30 7 User_Defined_Prompts_3 User Defined Prompts[3] STR30 String 30 8 User_Defined_Prompts_4 User Defined Prompts[4] STR30 String 30 9 User_Defined_Prompts_5 User Defined Prompts[5] STR30 String 30 10 User_Defined_Prompts_6 User Defined Prompts[6] STR30 String 30 11 User_Defined_Prompts_7 User Defined Prompts[7] STR30 String 30 12 User_Defined_Prompts_8 User Defined Prompts[8] STR30 String 30 13 User_Defined_Prompts_9 User Defined Prompts[9] STR30 String 30 14 User_Defined_Prompts_10 User Defined Prompts[10] STR30 String 30 15 User_Defined_Prompts_11 User Defined Prompts[11] STR30 String 30 16 User_Defined_Prompts_12 User Defined Prompts[12] STR30 String 30 17 User_Defined_Prompts_13 User Defined Prompts[13] STR30 String 30 18 User_Defined_Prompts_14 User Defined Prompts[14] STR30 String 30 19 User_Defined_Prompts_15 User Defined Prompts[15] STR30 String 30 20 User_Defined_Prompts_16 User Defined Prompts[16] STR30 String 30 21 User_Defined_Prompts_17 User Defined Prompts[17] STR30 String 30 22 User_Defined_Prompts_18 User Defined Prompts[18] STR30 String 30 23 User_Defined_Prompts_19 User Defined Prompts[19] STR30 String 30 24 User_Defined_Prompts_20 User Defined Prompts[20] STR30 String 30 25 User_Defined_Prompts_2_1 User Defined Prompts 2[1] STR30 String 30 26 User_Defined_Prompts_2_2 User Defined Prompts 2[2] STR30 String 30 27 User_Defined_Prompts_2_3 User Defined Prompts 2[3] STR30 String 30 28 User_Defined_Prompts_2_4 User Defined Prompts 2[4] STR30 String 30 29 User_Defined_Prompts_2_5 User Defined Prompts 2[5] STR30 String 30 30 User_Defined_Prompts_2_6 User Defined Prompts 2[6] STR30 String 30 31 User_Defined_Prompts_2_7 User Defined Prompts 2[7] STR30 String 30 32 User_Defined_Prompts_2_8 User Defined Prompts 2[8] STR30 String 30 33 User_Defined_Prompts_2_9 User Defined Prompts 2[9] STR30 String 30 34 User_Defined_Prompts_2_10 User Defined Prompts 2[10] STR30 String 30 35 User_Defined_Prompts_2_11 User Defined Prompts 2[11] STR30 String 30 36 User_Defined_Prompts_2_12 User Defined Prompts 2[12] STR30 String 30 37 User_Defined_Prompts_2_13 User Defined Prompts 2[13] STR30 String 30 38 User_Defined_Prompts_2_14 User Defined Prompts 2[14] STR30 String 30 39 User_Defined_Prompts_2_15 User Defined Prompts 2[15] STR30 String 30 40 User_Defined_Prompts_2_16 User Defined Prompts 2[16] STR30 String 30 41 User_Defined_Prompts_2_17 User Defined Prompts 2[17] STR30 String 30 42 User_Defined_Prompts_2_18 User Defined Prompts 2[18] STR30 String 30 43 User_Defined_Prompts_2_19 User Defined Prompts 2[19] STR30 String 30 44 User_Defined_Prompts_2_20 User Defined Prompts 2[20] STR30 String 30 45 User_Defined_Field_Type_1 User Defined Field Type[1] User Defined Field Type Integer 0 46 User_Defined_Field_Type_2 User Defined Field Type[2] User Defined Field Type Integer 0 47 User_Defined_Field_Type_3 User Defined Field Type[3] User Defined Field Type Integer 0 48 User_Defined_Field_Type_4 User Defined Field Type[4] User Defined Field Type Integer 0 49 User_Defined_Field_Type_5 User Defined Field Type[5] User Defined Field Type Integer 0 50 User_Defined_Field_Type_6 User Defined Field Type[6] User Defined Field Type Integer 0 51 User_Defined_Field_Type_7 User Defined Field Type[7] User Defined Field Type Integer 0 52 User_Defined_Field_Type_8 User Defined Field Type[8] User Defined Field Type Integer 0 53 User_Defined_Field_Type_9 User Defined Field Type[9] User Defined Field Type Integer 0 54 User_Defined_Field_Type_10 User Defined Field Type[10] User Defined Field Type Integer 0 55 User_Defined_Field_Type_11 User Defined Field Type[11] User Defined Field Type Integer 0 56 User_Defined_Field_Type_12 User Defined Field Type[12] User Defined Field Type Integer 0 57 User_Defined_Field_Type_13 User Defined Field Type[13] User Defined Field Type Integer 0 58 User_Defined_Field_Type_14 User Defined Field Type[14] User Defined Field Type Integer 0 59 User_Defined_Field_Type_15 User Defined Field Type[15] User Defined Field Type Integer 0 60 User_Defined_Field_Type_16 User Defined Field Type[16] User Defined Field Type Integer 0 61 User_Defined_Field_Type_17 User Defined Field Type[17] User Defined Field Type Integer 0 62 User_Defined_Field_Type_18 User Defined Field Type[18] User Defined Field Type Integer 0 63 User_Defined_Field_Type_19 User Defined Field Type[19] User Defined Field Type Integer 0 64 User_Defined_Field_Type_20 User Defined Field Type[20] User Defined Field Type Integer 0 65 User_Defined_Field_Types_1 User Defined Field Types 2[1] User Defined Field Type Integer 0 66 User_Defined_Field_Types_2 User Defined Field Types 2[2] User Defined Field Type Integer 0 67 User_Defined_Field_Types_3 User Defined Field Types 2[3] User Defined Field Type Integer 0 68 User_Defined_Field_Types_4 User Defined Field Types 2[4] User Defined Field Type Integer 0 69 User_Defined_Field_Types_5 User Defined Field Types 2[5] User Defined Field Type Integer 0 70 User_Defined_Field_Types_6 User Defined Field Types 2[6] User Defined Field Type Integer 0 71 User_Defined_Field_Types_7 User Defined Field Types 2[7] User Defined Field Type Integer 0 72 User_Defined_Field_Types_8 User Defined Field Types 2[8] User Defined Field Type Integer 0 73 User_Defined_Field_Types_9 User Defined Field Types 2[9] User Defined Field Type Integer 0 74 User_Defined_Field_Types_10 User Defined Field Types 2[10] User Defined Field Type Integer 0 75 User_Defined_Field_Types_11 User Defined Field Types 2[11] User Defined Field Type Integer 0 76 User_Defined_Field_Types_12 User Defined Field Types 2[12] User Defined Field Type Integer 0 77 User_Defined_Field_Types_13 User Defined Field Types 2[13] User Defined Field Type Integer 0 78 User_Defined_Field_Types_14 User Defined Field Types 2[14] User Defined Field Type Integer 0 79 User_Defined_Field_Types_15 User Defined Field Types 2[15] User Defined Field Type Integer 0 80 User_Defined_Field_Types_16 User Defined Field Types 2[16] User Defined Field Type Integer 0 81 User_Defined_Field_Types_17 User Defined Field Types 2[17] User Defined Field Type Integer 0 82 User_Defined_Field_Types_18 User Defined Field Types 2[18] User Defined Field Type Integer 0 83 User_Defined_Field_Types_19 User Defined Field Types 2[19] User Defined Field Type Integer 0 84 User_Defined_Field_Types_20 User Defined Field Types 2[20] User Defined Field Type Integer 0 85 Tab_Order Tab Order Tab Order Integer 0 86 Insert_Gap_CB Insert Gap CB Insert Gap CB Boolean 0 87 Gap Gap INT2 Integer 2 88 Add_To_Explorer Add To Explorer Add To Explorer CB Boolean 0 89 Add_To_Lookup_List Add To Lookup List Add To Lookup CB Boolean 0 90 Extender_Lookup_Name Extender Lookup Name STR64 String 64 91 Extender_Explorer_Desc Extender Explorer Description STR64 String 64 92 Extender_Explorer_Series_1 Extender Explorer Series[1] Long_10U Long Integer 10 93 Extender_Explorer_Series_2 Extender Explorer Series[2] Long_10U Long Integer 10 94 Required_CB_1 Required CB[1] CB Boolean 0 95 Required_CB_2 Required CB[2] CB Boolean 0 96 Required_CB_3 Required CB[3] CB Boolean 0 97 Required_CB_4 Required CB[4] CB Boolean 0 98 Required_CB_5 Required CB[5] CB Boolean 0 99 Required_CB_6 Required CB[6] CB Boolean 0 100 Required_CB_7 Required CB[7] CB Boolean 0 101 Required_CB_8 Required CB[8] CB Boolean 0 102 Required_CB_9 Required CB[9] CB Boolean 0 103 Required_CB_10 Required CB[10] CB Boolean 0 104 Required_CB_11 Required CB[11] CB Boolean 0 105 Required_CB_12 Required CB[12] CB Boolean 0 106 Required_CB_13 Required CB[13] CB Boolean 0 107 Required_CB_14 Required CB[14] CB Boolean 0 108 Required_CB_15 Required CB[15] CB Boolean 0 109 Required_CB_16 Required CB[16] CB Boolean 0 110 Required_CB_17 Required CB[17] CB Boolean 0 111 Required_CB_18 Required CB[18] CB Boolean 0 112 Required_CB_19 Required CB[19] CB Boolean 0 113 Required_CB_20 Required CB[20] CB Boolean 0 114 Required_2_CB_1 Required 2 CB[1] CB Boolean 0 115 Required_2_CB_2 Required 2 CB[2] CB Boolean 0 116 Required_2_CB_3 Required 2 CB[3] CB Boolean 0 117 Required_2_CB_4 Required 2 CB[4] CB Boolean 0 118 Required_2_CB_5 Required 2 CB[5] CB Boolean 0 119 Required_2_CB_6 Required 2 CB[6] CB Boolean 0 120 Required_2_CB_7 Required 2 CB[7] CB Boolean 0 121 Required_2_CB_8 Required 2 CB[8] CB Boolean 0 122 Required_2_CB_9 Required 2 CB[9] CB Boolean 0 123 Required_2_CB_10 Required 2 CB[10] CB Boolean 0 124 Required_2_CB_11 Required 2 CB[11] CB Boolean 0 125 Required_2_CB_12 Required 2 CB[12] CB Boolean 0 126 Required_2_CB_13 Required 2 CB[13] CB Boolean 0 127 Required_2_CB_14 Required 2 CB[14] CB Boolean 0 128 Required_2_CB_15 Required 2 CB[15] CB Boolean 0 129 Required_2_CB_16 Required 2 CB[16] CB Boolean 0 130 Required_2_CB_17 Required 2 CB[17] CB Boolean 0 131 Required_2_CB_18 Required 2 CB[18] CB Boolean 0 132 Required_2_CB_19 Required 2 CB[19] CB Boolean 0 133 Required_2_CB_20 Required 2 CB[20] CB Boolean 0 134 PRODID Product ID INT4 Integer 4 135 FORMNAME Form Name STR79 String 79 136 Autoincrement Autoincrement Autoincrement ID Field Boolean 0 137 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['v11 - Extender Forms'].NOTEINDX AS 'v11 - Extender Forms-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT40300 AS ['v11 - Extender Forms']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['v11 - Extender Forms'].NOTEINDX = ['Record Notes Master'].NOTEINDX138 CREATDDT Created Date DT Date 8 139 CRUSRID Created User ID STR15_User_ID String 15 140 MODIFDT Modified Date DT Date 8 141 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['v11 - Extender Forms'].MDFUSRID AS 'v11 - Extender Forms-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT40300 AS ['v11 - Extender Forms']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['v11 - Extender Forms'].MDFUSRID = ['Users Master'].USERID142 LookupsDDL_1 Lookups DDL[1] Lookups DDL Integer 0 143 LookupsDDL_2 Lookups DDL[2] Lookups DDL Integer 0 144 LookupsDDL_3 Lookups DDL[3] Lookups DDL Integer 0 145 LookupsDDL_4 Lookups DDL[4] Lookups DDL Integer 0 146 LookupsDDL_5 Lookups DDL[5] Lookups DDL Integer 0 147 LookupsDDL_6 Lookups DDL[6] Lookups DDL Integer 0 148 LookupsDDL_7 Lookups DDL[7] Lookups DDL Integer 0 149 LookupsDDL_8 Lookups DDL[8] Lookups DDL Integer 0 150 LookupsDDL_9 Lookups DDL[9] Lookups DDL Integer 0 151 LookupsDDL_10 Lookups DDL[10] Lookups DDL Integer 0 152 LookupsDDL_11 Lookups DDL[11] Lookups DDL Integer 0 153 LookupsDDL_12 Lookups DDL[12] Lookups DDL Integer 0 154 LookupsDDL_13 Lookups DDL[13] Lookups DDL Integer 0 155 LookupsDDL_14 Lookups DDL[14] Lookups DDL Integer 0 156 LookupsDDL_15 Lookups DDL[15] Lookups DDL Integer 0 157 LookupsDDL_16 Lookups DDL[16] Lookups DDL Integer 0 158 LookupsDDL_17 Lookups DDL[17] Lookups DDL Integer 0 159 LookupsDDL_18 Lookups DDL[18] Lookups DDL Integer 0 160 LookupsDDL_19 Lookups DDL[19] Lookups DDL Integer 0 161 LookupsDDL_20 Lookups DDL[20] Lookups DDL Integer 0 162 Lookups_DDL_2_1 Lookups DDL 2[1] Lookups DDL Integer 0 163 Lookups_DDL_2_2 Lookups DDL 2[2] Lookups DDL Integer 0 164 Lookups_DDL_2_3 Lookups DDL 2[3] Lookups DDL Integer 0 165 Lookups_DDL_2_4 Lookups DDL 2[4] Lookups DDL Integer 0 166 Lookups_DDL_2_5 Lookups DDL 2[5] Lookups DDL Integer 0 167 Lookups_DDL_2_6 Lookups DDL 2[6] Lookups DDL Integer 0 168 Lookups_DDL_2_7 Lookups DDL 2[7] Lookups DDL Integer 0 169 Lookups_DDL_2_8 Lookups DDL 2[8] Lookups DDL Integer 0 170 Lookups_DDL_2_9 Lookups DDL 2[9] Lookups DDL Integer 0 171 Lookups_DDL_2_10 Lookups DDL 2[10] Lookups DDL Integer 0 172 Lookups_DDL_2_11 Lookups DDL 2[11] Lookups DDL Integer 0 173 Lookups_DDL_2_12 Lookups DDL 2[12] Lookups DDL Integer 0 174 Lookups_DDL_2_13 Lookups DDL 2[13] Lookups DDL Integer 0 175 Lookups_DDL_2_14 Lookups DDL 2[14] Lookups DDL Integer 0 176 Lookups_DDL_2_15 Lookups DDL 2[15] Lookups DDL Integer 0 177 Lookups_DDL_2_16 Lookups DDL 2[16] Lookups DDL Integer 0 178 Lookups_DDL_2_17 Lookups DDL 2[17] Lookups DDL Integer 0 179 Lookups_DDL_2_18 Lookups DDL 2[18] Lookups DDL Integer 0 180 Lookups_DDL_2_19 Lookups DDL 2[19] Lookups DDL Integer 0 181 Lookups_DDL_2_20 Lookups DDL 2[20] Lookups DDL Integer 0 182 PT_Decimal_Places_1 PT Decimal Places[1] DDL_Decimal_Places_Dollars Integer 0 183 PT_Decimal_Places_2 PT Decimal Places[2] DDL_Decimal_Places_Dollars Integer 0 184 PT_Decimal_Places_3 PT Decimal Places[3] DDL_Decimal_Places_Dollars Integer 0 185 PT_Decimal_Places_4 PT Decimal Places[4] DDL_Decimal_Places_Dollars Integer 0 186 PT_Decimal_Places_5 PT Decimal Places[5] DDL_Decimal_Places_Dollars Integer 0 187 PT_Decimal_Places_6 PT Decimal Places[6] DDL_Decimal_Places_Dollars Integer 0 188 PT_Decimal_Places_7 PT Decimal Places[7] DDL_Decimal_Places_Dollars Integer 0 189 PT_Decimal_Places_8 PT Decimal Places[8] DDL_Decimal_Places_Dollars Integer 0 190 PT_Decimal_Places_9 PT Decimal Places[9] DDL_Decimal_Places_Dollars Integer 0 191 PT_Decimal_Places_10 PT Decimal Places[10] DDL_Decimal_Places_Dollars Integer 0 192 PT_Decimal_Places_11 PT Decimal Places[11] DDL_Decimal_Places_Dollars Integer 0 193 PT_Decimal_Places_12 PT Decimal Places[12] DDL_Decimal_Places_Dollars Integer 0 194 PT_Decimal_Places_13 PT Decimal Places[13] DDL_Decimal_Places_Dollars Integer 0 195 PT_Decimal_Places_14 PT Decimal Places[14] DDL_Decimal_Places_Dollars Integer 0 196 PT_Decimal_Places_15 PT Decimal Places[15] DDL_Decimal_Places_Dollars Integer 0 197 PT_Decimal_Places_16 PT Decimal Places[16] DDL_Decimal_Places_Dollars Integer 0 198 PT_Decimal_Places_17 PT Decimal Places[17] DDL_Decimal_Places_Dollars Integer 0 199 PT_Decimal_Places_18 PT Decimal Places[18] DDL_Decimal_Places_Dollars Integer 0 200 PT_Decimal_Places_19 PT Decimal Places[19] DDL_Decimal_Places_Dollars Integer 0 201 PT_Decimal_Places_20 PT Decimal Places[20] DDL_Decimal_Places_Dollars Integer 0 202 PT_Decimal_Places_2_1 PT Decimal Places 2[1] DDL_Decimal_Places_Dollars Integer 0 203 PT_Decimal_Places_2_2 PT Decimal Places 2[2] DDL_Decimal_Places_Dollars Integer 0 204 PT_Decimal_Places_2_3 PT Decimal Places 2[3] DDL_Decimal_Places_Dollars Integer 0 205 PT_Decimal_Places_2_4 PT Decimal Places 2[4] DDL_Decimal_Places_Dollars Integer 0 206 PT_Decimal_Places_2_5 PT Decimal Places 2[5] DDL_Decimal_Places_Dollars Integer 0 207 PT_Decimal_Places_2_6 PT Decimal Places 2[6] DDL_Decimal_Places_Dollars Integer 0 208 PT_Decimal_Places_2_7 PT Decimal Places 2[7] DDL_Decimal_Places_Dollars Integer 0 209 PT_Decimal_Places_2_8 PT Decimal Places 2[8] DDL_Decimal_Places_Dollars Integer 0 210 PT_Decimal_Places_2_9 PT Decimal Places 2[9] DDL_Decimal_Places_Dollars Integer 0 211 PT_Decimal_Places_2_10 PT Decimal Places 2[10] DDL_Decimal_Places_Dollars Integer 0 212 PT_Decimal_Places_2_11 PT Decimal Places 2[11] DDL_Decimal_Places_Dollars Integer 0 213 PT_Decimal_Places_2_12 PT Decimal Places 2[12] DDL_Decimal_Places_Dollars Integer 0 214 PT_Decimal_Places_2_13 PT Decimal Places 2[13] DDL_Decimal_Places_Dollars Integer 0 215 PT_Decimal_Places_2_14 PT Decimal Places 2[14] DDL_Decimal_Places_Dollars Integer 0 216 PT_Decimal_Places_2_15 PT Decimal Places 2[15] DDL_Decimal_Places_Dollars Integer 0 217 PT_Decimal_Places_2_16 PT Decimal Places 2[16] DDL_Decimal_Places_Dollars Integer 0 218 PT_Decimal_Places_2_17 PT Decimal Places 2[17] DDL_Decimal_Places_Dollars Integer 0 219 PT_Decimal_Places_2_18 PT Decimal Places 2[18] DDL_Decimal_Places_Dollars Integer 0 220 PT_Decimal_Places_2_19 PT Decimal Places 2[19] DDL_Decimal_Places_Dollars Integer 0 221 PT_Decimal_Places_2_20 PT Decimal Places 2[20] DDL_Decimal_Places_Dollars Integer 0 222 Use_Secondary_Key Use Secondary Key Use Secondary Key Boolean 0 223 Extender_Second_Prompt Extender Secondary ID Prompt STR50 String 50 224 Use_Existing_Lookup Use Existing Lookup Use Existing Lookup Boolean 0 225 Lookup_Number Lookup Number Long_10U Long Integer 10