v11 – Extender Forms (EXT40300)

azurecurveProductsExtender (3107)Projectv11 - Extender Forms (EXT40300)

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_Forms

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
2Extender_Form_Name SearchExtender Form NameSTR64String6664
3Extender_Form_ID_Prompt SearchExtender Form ID PromptSTR50String5250
4Extender_Description_Pro SearchExtender Description PromptSTR50String5250
5User_Defined_Prompts_1 SearchUser Defined Prompts[1]STR30String3230
6User_Defined_Prompts_2 SearchUser Defined Prompts[2]STR30String3230
7User_Defined_Prompts_3 SearchUser Defined Prompts[3]STR30String3230
8User_Defined_Prompts_4 SearchUser Defined Prompts[4]STR30String3230
9User_Defined_Prompts_5 SearchUser Defined Prompts[5]STR30String3230
10User_Defined_Prompts_6 SearchUser Defined Prompts[6]STR30String3230
11User_Defined_Prompts_7 SearchUser Defined Prompts[7]STR30String3230
12User_Defined_Prompts_8 SearchUser Defined Prompts[8]STR30String3230
13User_Defined_Prompts_9 SearchUser Defined Prompts[9]STR30String3230
14User_Defined_Prompts_10 SearchUser Defined Prompts[10]STR30String3230
15User_Defined_Prompts_11 SearchUser Defined Prompts[11]STR30String3230
16User_Defined_Prompts_12 SearchUser Defined Prompts[12]STR30String3230
17User_Defined_Prompts_13 SearchUser Defined Prompts[13]STR30String3230
18User_Defined_Prompts_14 SearchUser Defined Prompts[14]STR30String3230
19User_Defined_Prompts_15 SearchUser Defined Prompts[15]STR30String3230
20User_Defined_Prompts_16 SearchUser Defined Prompts[16]STR30String3230
21User_Defined_Prompts_17 SearchUser Defined Prompts[17]STR30String3230
22User_Defined_Prompts_18 SearchUser Defined Prompts[18]STR30String3230
23User_Defined_Prompts_19 SearchUser Defined Prompts[19]STR30String3230
24User_Defined_Prompts_20 SearchUser Defined Prompts[20]STR30String3230
25User_Defined_Prompts_2_1 SearchUser Defined Prompts 2[1]STR30String3230
26User_Defined_Prompts_2_2 SearchUser Defined Prompts 2[2]STR30String3230
27User_Defined_Prompts_2_3 SearchUser Defined Prompts 2[3]STR30String3230
28User_Defined_Prompts_2_4 SearchUser Defined Prompts 2[4]STR30String3230
29User_Defined_Prompts_2_5 SearchUser Defined Prompts 2[5]STR30String3230
30User_Defined_Prompts_2_6 SearchUser Defined Prompts 2[6]STR30String3230
31User_Defined_Prompts_2_7 SearchUser Defined Prompts 2[7]STR30String3230
32User_Defined_Prompts_2_8 SearchUser Defined Prompts 2[8]STR30String3230
33User_Defined_Prompts_2_9 SearchUser Defined Prompts 2[9]STR30String3230
34User_Defined_Prompts_2_10 SearchUser Defined Prompts 2[10]STR30String3230
35User_Defined_Prompts_2_11 SearchUser Defined Prompts 2[11]STR30String3230
36User_Defined_Prompts_2_12 SearchUser Defined Prompts 2[12]STR30String3230
37User_Defined_Prompts_2_13 SearchUser Defined Prompts 2[13]STR30String3230
38User_Defined_Prompts_2_14 SearchUser Defined Prompts 2[14]STR30String3230
39User_Defined_Prompts_2_15 SearchUser Defined Prompts 2[15]STR30String3230
40User_Defined_Prompts_2_16 SearchUser Defined Prompts 2[16]STR30String3230
41User_Defined_Prompts_2_17 SearchUser Defined Prompts 2[17]STR30String3230
42User_Defined_Prompts_2_18 SearchUser Defined Prompts 2[18]STR30String3230
43User_Defined_Prompts_2_19 SearchUser Defined Prompts 2[19]STR30String3230
44User_Defined_Prompts_2_20 SearchUser Defined Prompts 2[20]STR30String3230
45User_Defined_Field_Type_1 SearchUser Defined Field Type[1]User Defined Field TypeInteger20
46User_Defined_Field_Type_2 SearchUser Defined Field Type[2]User Defined Field TypeInteger20
47User_Defined_Field_Type_3 SearchUser Defined Field Type[3]User Defined Field TypeInteger20
48User_Defined_Field_Type_4 SearchUser Defined Field Type[4]User Defined Field TypeInteger20
49User_Defined_Field_Type_5 SearchUser Defined Field Type[5]User Defined Field TypeInteger20
50User_Defined_Field_Type_6 SearchUser Defined Field Type[6]User Defined Field TypeInteger20
51User_Defined_Field_Type_7 SearchUser Defined Field Type[7]User Defined Field TypeInteger20
52User_Defined_Field_Type_8 SearchUser Defined Field Type[8]User Defined Field TypeInteger20
53User_Defined_Field_Type_9 SearchUser Defined Field Type[9]User Defined Field TypeInteger20
54User_Defined_Field_Type_10 SearchUser Defined Field Type[10]User Defined Field TypeInteger20
55User_Defined_Field_Type_11 SearchUser Defined Field Type[11]User Defined Field TypeInteger20
56User_Defined_Field_Type_12 SearchUser Defined Field Type[12]User Defined Field TypeInteger20
57User_Defined_Field_Type_13 SearchUser Defined Field Type[13]User Defined Field TypeInteger20
58User_Defined_Field_Type_14 SearchUser Defined Field Type[14]User Defined Field TypeInteger20
59User_Defined_Field_Type_15 SearchUser Defined Field Type[15]User Defined Field TypeInteger20
60User_Defined_Field_Type_16 SearchUser Defined Field Type[16]User Defined Field TypeInteger20
61User_Defined_Field_Type_17 SearchUser Defined Field Type[17]User Defined Field TypeInteger20
62User_Defined_Field_Type_18 SearchUser Defined Field Type[18]User Defined Field TypeInteger20
63User_Defined_Field_Type_19 SearchUser Defined Field Type[19]User Defined Field TypeInteger20
64User_Defined_Field_Type_20 SearchUser Defined Field Type[20]User Defined Field TypeInteger20
65User_Defined_Field_Types_1 SearchUser Defined Field Types 2[1]User Defined Field TypeInteger20
66User_Defined_Field_Types_2 SearchUser Defined Field Types 2[2]User Defined Field TypeInteger20
67User_Defined_Field_Types_3 SearchUser Defined Field Types 2[3]User Defined Field TypeInteger20
68User_Defined_Field_Types_4 SearchUser Defined Field Types 2[4]User Defined Field TypeInteger20
69User_Defined_Field_Types_5 SearchUser Defined Field Types 2[5]User Defined Field TypeInteger20
70User_Defined_Field_Types_6 SearchUser Defined Field Types 2[6]User Defined Field TypeInteger20
71User_Defined_Field_Types_7 SearchUser Defined Field Types 2[7]User Defined Field TypeInteger20
72User_Defined_Field_Types_8 SearchUser Defined Field Types 2[8]User Defined Field TypeInteger20
73User_Defined_Field_Types_9 SearchUser Defined Field Types 2[9]User Defined Field TypeInteger20
74User_Defined_Field_Types_10 SearchUser Defined Field Types 2[10]User Defined Field TypeInteger20
75User_Defined_Field_Types_11 SearchUser Defined Field Types 2[11]User Defined Field TypeInteger20
76User_Defined_Field_Types_12 SearchUser Defined Field Types 2[12]User Defined Field TypeInteger20
77User_Defined_Field_Types_13 SearchUser Defined Field Types 2[13]User Defined Field TypeInteger20
78User_Defined_Field_Types_14 SearchUser Defined Field Types 2[14]User Defined Field TypeInteger20
79User_Defined_Field_Types_15 SearchUser Defined Field Types 2[15]User Defined Field TypeInteger20
80User_Defined_Field_Types_16 SearchUser Defined Field Types 2[16]User Defined Field TypeInteger20
81User_Defined_Field_Types_17 SearchUser Defined Field Types 2[17]User Defined Field TypeInteger20
82User_Defined_Field_Types_18 SearchUser Defined Field Types 2[18]User Defined Field TypeInteger20
83User_Defined_Field_Types_19 SearchUser Defined Field Types 2[19]User Defined Field TypeInteger20
84User_Defined_Field_Types_20 SearchUser Defined Field Types 2[20]User Defined Field TypeInteger20
85Tab_Order SearchTab OrderTab OrderInteger20
86Insert_Gap_CB SearchInsert Gap CBInsert Gap CBBoolean20
87Gap SearchGapINT2Integer22
88Add_To_Explorer SearchAdd To ExplorerAdd To Explorer CBBoolean20
89Add_To_Lookup_List SearchAdd To Lookup ListAdd To Lookup CBBoolean20
90Extender_Lookup_Name SearchExtender Lookup NameSTR64String6664
91Extender_Explorer_Desc SearchExtender Explorer DescriptionSTR64String6664
92Extender_Explorer_Series_1 SearchExtender Explorer Series[1]Long_10ULong Integer410
93Extender_Explorer_Series_2 SearchExtender Explorer Series[2]Long_10ULong Integer410
94Required_CB_1 SearchRequired CB[1]CBBoolean20
95Required_CB_2 SearchRequired CB[2]CBBoolean20
96Required_CB_3 SearchRequired CB[3]CBBoolean20
97Required_CB_4 SearchRequired CB[4]CBBoolean20
98Required_CB_5 SearchRequired CB[5]CBBoolean20
99Required_CB_6 SearchRequired CB[6]CBBoolean20
100Required_CB_7 SearchRequired CB[7]CBBoolean20
101Required_CB_8 SearchRequired CB[8]CBBoolean20
102Required_CB_9 SearchRequired CB[9]CBBoolean20
103Required_CB_10 SearchRequired CB[10]CBBoolean20
104Required_CB_11 SearchRequired CB[11]CBBoolean20
105Required_CB_12 SearchRequired CB[12]CBBoolean20
106Required_CB_13 SearchRequired CB[13]CBBoolean20
107Required_CB_14 SearchRequired CB[14]CBBoolean20
108Required_CB_15 SearchRequired CB[15]CBBoolean20
109Required_CB_16 SearchRequired CB[16]CBBoolean20
110Required_CB_17 SearchRequired CB[17]CBBoolean20
111Required_CB_18 SearchRequired CB[18]CBBoolean20
112Required_CB_19 SearchRequired CB[19]CBBoolean20
113Required_CB_20 SearchRequired CB[20]CBBoolean20
114Required_2_CB_1 SearchRequired 2 CB[1]CBBoolean20
115Required_2_CB_2 SearchRequired 2 CB[2]CBBoolean20
116Required_2_CB_3 SearchRequired 2 CB[3]CBBoolean20
117Required_2_CB_4 SearchRequired 2 CB[4]CBBoolean20
118Required_2_CB_5 SearchRequired 2 CB[5]CBBoolean20
119Required_2_CB_6 SearchRequired 2 CB[6]CBBoolean20
120Required_2_CB_7 SearchRequired 2 CB[7]CBBoolean20
121Required_2_CB_8 SearchRequired 2 CB[8]CBBoolean20
122Required_2_CB_9 SearchRequired 2 CB[9]CBBoolean20
123Required_2_CB_10 SearchRequired 2 CB[10]CBBoolean20
124Required_2_CB_11 SearchRequired 2 CB[11]CBBoolean20
125Required_2_CB_12 SearchRequired 2 CB[12]CBBoolean20
126Required_2_CB_13 SearchRequired 2 CB[13]CBBoolean20
127Required_2_CB_14 SearchRequired 2 CB[14]CBBoolean20
128Required_2_CB_15 SearchRequired 2 CB[15]CBBoolean20
129Required_2_CB_16 SearchRequired 2 CB[16]CBBoolean20
130Required_2_CB_17 SearchRequired 2 CB[17]CBBoolean20
131Required_2_CB_18 SearchRequired 2 CB[18]CBBoolean20
132Required_2_CB_19 SearchRequired 2 CB[19]CBBoolean20
133Required_2_CB_20 SearchRequired 2 CB[20]CBBoolean20
134PRODID SearchProduct IDINT4Integer24
135FORMNAME SearchForm NameSTR79String8079
136Autoincrement SearchAutoincrementAutoincrement ID FieldBoolean20
137NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
138CREATDDT SearchCreated DateDTDate48
139CRUSRID SearchCreated User IDSTR15_User_IDString1615
140MODIFDT SearchModified DateDTDate48
141MDFUSRID SearchModified User IDSTR15String1615
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'].USERID
142LookupsDDL_1 SearchLookups DDL[1]Lookups DDLInteger20
143LookupsDDL_2 SearchLookups DDL[2]Lookups DDLInteger20
144LookupsDDL_3 SearchLookups DDL[3]Lookups DDLInteger20
145LookupsDDL_4 SearchLookups DDL[4]Lookups DDLInteger20
146LookupsDDL_5 SearchLookups DDL[5]Lookups DDLInteger20
147LookupsDDL_6 SearchLookups DDL[6]Lookups DDLInteger20
148LookupsDDL_7 SearchLookups DDL[7]Lookups DDLInteger20
149LookupsDDL_8 SearchLookups DDL[8]Lookups DDLInteger20
150LookupsDDL_9 SearchLookups DDL[9]Lookups DDLInteger20
151LookupsDDL_10 SearchLookups DDL[10]Lookups DDLInteger20
152LookupsDDL_11 SearchLookups DDL[11]Lookups DDLInteger20
153LookupsDDL_12 SearchLookups DDL[12]Lookups DDLInteger20
154LookupsDDL_13 SearchLookups DDL[13]Lookups DDLInteger20
155LookupsDDL_14 SearchLookups DDL[14]Lookups DDLInteger20
156LookupsDDL_15 SearchLookups DDL[15]Lookups DDLInteger20
157LookupsDDL_16 SearchLookups DDL[16]Lookups DDLInteger20
158LookupsDDL_17 SearchLookups DDL[17]Lookups DDLInteger20
159LookupsDDL_18 SearchLookups DDL[18]Lookups DDLInteger20
160LookupsDDL_19 SearchLookups DDL[19]Lookups DDLInteger20
161LookupsDDL_20 SearchLookups DDL[20]Lookups DDLInteger20
162Lookups_DDL_2_1 SearchLookups DDL 2[1]Lookups DDLInteger20
163Lookups_DDL_2_2 SearchLookups DDL 2[2]Lookups DDLInteger20
164Lookups_DDL_2_3 SearchLookups DDL 2[3]Lookups DDLInteger20
165Lookups_DDL_2_4 SearchLookups DDL 2[4]Lookups DDLInteger20
166Lookups_DDL_2_5 SearchLookups DDL 2[5]Lookups DDLInteger20
167Lookups_DDL_2_6 SearchLookups DDL 2[6]Lookups DDLInteger20
168Lookups_DDL_2_7 SearchLookups DDL 2[7]Lookups DDLInteger20
169Lookups_DDL_2_8 SearchLookups DDL 2[8]Lookups DDLInteger20
170Lookups_DDL_2_9 SearchLookups DDL 2[9]Lookups DDLInteger20
171Lookups_DDL_2_10 SearchLookups DDL 2[10]Lookups DDLInteger20
172Lookups_DDL_2_11 SearchLookups DDL 2[11]Lookups DDLInteger20
173Lookups_DDL_2_12 SearchLookups DDL 2[12]Lookups DDLInteger20
174Lookups_DDL_2_13 SearchLookups DDL 2[13]Lookups DDLInteger20
175Lookups_DDL_2_14 SearchLookups DDL 2[14]Lookups DDLInteger20
176Lookups_DDL_2_15 SearchLookups DDL 2[15]Lookups DDLInteger20
177Lookups_DDL_2_16 SearchLookups DDL 2[16]Lookups DDLInteger20
178Lookups_DDL_2_17 SearchLookups DDL 2[17]Lookups DDLInteger20
179Lookups_DDL_2_18 SearchLookups DDL 2[18]Lookups DDLInteger20
180Lookups_DDL_2_19 SearchLookups DDL 2[19]Lookups DDLInteger20
181Lookups_DDL_2_20 SearchLookups DDL 2[20]Lookups DDLInteger20
182PT_Decimal_Places_1 SearchPT Decimal Places[1]DDL_Decimal_Places_DollarsInteger20
183PT_Decimal_Places_2 SearchPT Decimal Places[2]DDL_Decimal_Places_DollarsInteger20
184PT_Decimal_Places_3 SearchPT Decimal Places[3]DDL_Decimal_Places_DollarsInteger20
185PT_Decimal_Places_4 SearchPT Decimal Places[4]DDL_Decimal_Places_DollarsInteger20
186PT_Decimal_Places_5 SearchPT Decimal Places[5]DDL_Decimal_Places_DollarsInteger20
187PT_Decimal_Places_6 SearchPT Decimal Places[6]DDL_Decimal_Places_DollarsInteger20
188PT_Decimal_Places_7 SearchPT Decimal Places[7]DDL_Decimal_Places_DollarsInteger20
189PT_Decimal_Places_8 SearchPT Decimal Places[8]DDL_Decimal_Places_DollarsInteger20
190PT_Decimal_Places_9 SearchPT Decimal Places[9]DDL_Decimal_Places_DollarsInteger20
191PT_Decimal_Places_10 SearchPT Decimal Places[10]DDL_Decimal_Places_DollarsInteger20
192PT_Decimal_Places_11 SearchPT Decimal Places[11]DDL_Decimal_Places_DollarsInteger20
193PT_Decimal_Places_12 SearchPT Decimal Places[12]DDL_Decimal_Places_DollarsInteger20
194PT_Decimal_Places_13 SearchPT Decimal Places[13]DDL_Decimal_Places_DollarsInteger20
195PT_Decimal_Places_14 SearchPT Decimal Places[14]DDL_Decimal_Places_DollarsInteger20
196PT_Decimal_Places_15 SearchPT Decimal Places[15]DDL_Decimal_Places_DollarsInteger20
197PT_Decimal_Places_16 SearchPT Decimal Places[16]DDL_Decimal_Places_DollarsInteger20
198PT_Decimal_Places_17 SearchPT Decimal Places[17]DDL_Decimal_Places_DollarsInteger20
199PT_Decimal_Places_18 SearchPT Decimal Places[18]DDL_Decimal_Places_DollarsInteger20
200PT_Decimal_Places_19 SearchPT Decimal Places[19]DDL_Decimal_Places_DollarsInteger20
201PT_Decimal_Places_20 SearchPT Decimal Places[20]DDL_Decimal_Places_DollarsInteger20
202PT_Decimal_Places_2_1 SearchPT Decimal Places 2[1]DDL_Decimal_Places_DollarsInteger20
203PT_Decimal_Places_2_2 SearchPT Decimal Places 2[2]DDL_Decimal_Places_DollarsInteger20
204PT_Decimal_Places_2_3 SearchPT Decimal Places 2[3]DDL_Decimal_Places_DollarsInteger20
205PT_Decimal_Places_2_4 SearchPT Decimal Places 2[4]DDL_Decimal_Places_DollarsInteger20
206PT_Decimal_Places_2_5 SearchPT Decimal Places 2[5]DDL_Decimal_Places_DollarsInteger20
207PT_Decimal_Places_2_6 SearchPT Decimal Places 2[6]DDL_Decimal_Places_DollarsInteger20
208PT_Decimal_Places_2_7 SearchPT Decimal Places 2[7]DDL_Decimal_Places_DollarsInteger20
209PT_Decimal_Places_2_8 SearchPT Decimal Places 2[8]DDL_Decimal_Places_DollarsInteger20
210PT_Decimal_Places_2_9 SearchPT Decimal Places 2[9]DDL_Decimal_Places_DollarsInteger20
211PT_Decimal_Places_2_10 SearchPT Decimal Places 2[10]DDL_Decimal_Places_DollarsInteger20
212PT_Decimal_Places_2_11 SearchPT Decimal Places 2[11]DDL_Decimal_Places_DollarsInteger20
213PT_Decimal_Places_2_12 SearchPT Decimal Places 2[12]DDL_Decimal_Places_DollarsInteger20
214PT_Decimal_Places_2_13 SearchPT Decimal Places 2[13]DDL_Decimal_Places_DollarsInteger20
215PT_Decimal_Places_2_14 SearchPT Decimal Places 2[14]DDL_Decimal_Places_DollarsInteger20
216PT_Decimal_Places_2_15 SearchPT Decimal Places 2[15]DDL_Decimal_Places_DollarsInteger20
217PT_Decimal_Places_2_16 SearchPT Decimal Places 2[16]DDL_Decimal_Places_DollarsInteger20
218PT_Decimal_Places_2_17 SearchPT Decimal Places 2[17]DDL_Decimal_Places_DollarsInteger20
219PT_Decimal_Places_2_18 SearchPT Decimal Places 2[18]DDL_Decimal_Places_DollarsInteger20
220PT_Decimal_Places_2_19 SearchPT Decimal Places 2[19]DDL_Decimal_Places_DollarsInteger20
221PT_Decimal_Places_2_20 SearchPT Decimal Places 2[20]DDL_Decimal_Places_DollarsInteger20
222Use_Secondary_Key SearchUse Secondary KeyUse Secondary KeyBoolean20
223Extender_Second_Prompt SearchExtender Secondary ID PromptSTR50String5250
224Use_Existing_Lookup SearchUse Existing LookupUse Existing LookupBoolean20
225Lookup_Number SearchLookup NumberLong_10ULong Integer410
azurecurveProductsExtender (3107)Projectv11 - Extender Forms (EXT40300)

Leave a Reply

Your email address will not be published. Required fields are marked *