Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT40100
Product: Extender (3107)
Series: Project
Display Name: v11 - Extender Window Setup Group Display Name: Extender Windows
Physical Name: EXT40100
Technical Name: PT_User_Defined_Window_SETP
Group Technical Name: Extender Windows
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PT_Window_ID | PT Window ID | STR15_Address_Code | String | 15 | |
2 | PT_Window_Description | PT Window Description | STR64 | String | 64 | |
3 | PRODID | Product ID | INT4 | Integer | 4 | |
4 | FORMNAME | Form Name | STR79 | String | 79 | |
5 | WINNAME | Window Name | STR79 | String | 79 | |
6 | FIELDNAM | Field Name | STR30 | String | 30 | |
7 | Auto_Open | Auto Open | Auto Open CB | Boolean | 0 | |
8 | PT_Open_Method | PT Open Method | PT Open Method | Integer | 0 | |
9 | HotKey | PT HotKey | STR1 | String | 1 | |
10 | User_Defined_Field_Type_1 | User Defined Field Type[1] | User Defined Field Type | Integer | 0 | |
11 | User_Defined_Field_Type_2 | User Defined Field Type[2] | User Defined Field Type | Integer | 0 | |
12 | User_Defined_Field_Type_3 | User Defined Field Type[3] | User Defined Field Type | Integer | 0 | |
13 | User_Defined_Field_Type_4 | User Defined Field Type[4] | User Defined Field Type | Integer | 0 | |
14 | User_Defined_Field_Type_5 | User Defined Field Type[5] | User Defined Field Type | Integer | 0 | |
15 | User_Defined_Field_Type_6 | User Defined Field Type[6] | User Defined Field Type | Integer | 0 | |
16 | User_Defined_Field_Type_7 | User Defined Field Type[7] | User Defined Field Type | Integer | 0 | |
17 | User_Defined_Field_Type_8 | User Defined Field Type[8] | User Defined Field Type | Integer | 0 | |
18 | User_Defined_Field_Type_9 | User Defined Field Type[9] | User Defined Field Type | Integer | 0 | |
19 | User_Defined_Field_Type_10 | User Defined Field Type[10] | User Defined Field Type | Integer | 0 | |
20 | User_Defined_Field_Type_11 | User Defined Field Type[11] | User Defined Field Type | Integer | 0 | |
21 | User_Defined_Field_Type_12 | User Defined Field Type[12] | User Defined Field Type | Integer | 0 | |
22 | User_Defined_Field_Type_13 | User Defined Field Type[13] | User Defined Field Type | Integer | 0 | |
23 | User_Defined_Field_Type_14 | User Defined Field Type[14] | User Defined Field Type | Integer | 0 | |
24 | User_Defined_Field_Type_15 | User Defined Field Type[15] | User Defined Field Type | Integer | 0 | |
25 | User_Defined_Field_Type_16 | User Defined Field Type[16] | User Defined Field Type | Integer | 0 | |
26 | User_Defined_Field_Type_17 | User Defined Field Type[17] | User Defined Field Type | Integer | 0 | |
27 | User_Defined_Field_Type_18 | User Defined Field Type[18] | User Defined Field Type | Integer | 0 | |
28 | User_Defined_Field_Type_19 | User Defined Field Type[19] | User Defined Field Type | Integer | 0 | |
29 | User_Defined_Field_Type_20 | User Defined Field Type[20] | User Defined Field Type | Integer | 0 | |
30 | User_Defined_Prompts_1 | User Defined Prompts[1] | STR30 | String | 30 | |
31 | User_Defined_Prompts_2 | User Defined Prompts[2] | STR30 | String | 30 | |
32 | User_Defined_Prompts_3 | User Defined Prompts[3] | STR30 | String | 30 | |
33 | User_Defined_Prompts_4 | User Defined Prompts[4] | STR30 | String | 30 | |
34 | User_Defined_Prompts_5 | User Defined Prompts[5] | STR30 | String | 30 | |
35 | User_Defined_Prompts_6 | User Defined Prompts[6] | STR30 | String | 30 | |
36 | User_Defined_Prompts_7 | User Defined Prompts[7] | STR30 | String | 30 | |
37 | User_Defined_Prompts_8 | User Defined Prompts[8] | STR30 | String | 30 | |
38 | User_Defined_Prompts_9 | User Defined Prompts[9] | STR30 | String | 30 | |
39 | User_Defined_Prompts_10 | User Defined Prompts[10] | STR30 | String | 30 | |
40 | User_Defined_Prompts_11 | User Defined Prompts[11] | STR30 | String | 30 | |
41 | User_Defined_Prompts_12 | User Defined Prompts[12] | STR30 | String | 30 | |
42 | User_Defined_Prompts_13 | User Defined Prompts[13] | STR30 | String | 30 | |
43 | User_Defined_Prompts_14 | User Defined Prompts[14] | STR30 | String | 30 | |
44 | User_Defined_Prompts_15 | User Defined Prompts[15] | STR30 | String | 30 | |
45 | User_Defined_Prompts_16 | User Defined Prompts[16] | STR30 | String | 30 | |
46 | User_Defined_Prompts_17 | User Defined Prompts[17] | STR30 | String | 30 | |
47 | User_Defined_Prompts_18 | User Defined Prompts[18] | STR30 | String | 30 | |
48 | User_Defined_Prompts_19 | User Defined Prompts[19] | STR30 | String | 30 | |
49 | User_Defined_Prompts_20 | User Defined Prompts[20] | STR30 | String | 30 | |
50 | Explorer_Description | Explorer Description | STR100 | String | 100 | |
51 | PT_Explorer_Object | PT Explorer Object | INT5 | Integer | 4 | |
52 | PT_Auto_Close | PT Auto Close | Auto Close | Boolean | 0 | |
53 | PT_Explorer_Product_ID | PT Explorer Product ID | INT5 | Integer | 4 | |
54 | PT_Explorer_Number_Prefi | PT Explorer Number Prefix | INT5 | Integer | 4 | |
55 | LookupsDDL_1 | Lookups DDL[1] | Lookups DDL | Integer | 0 | |
56 | LookupsDDL_2 | Lookups DDL[2] | Lookups DDL | Integer | 0 | |
57 | LookupsDDL_3 | Lookups DDL[3] | Lookups DDL | Integer | 0 | |
58 | LookupsDDL_4 | Lookups DDL[4] | Lookups DDL | Integer | 0 | |
59 | LookupsDDL_5 | Lookups DDL[5] | Lookups DDL | Integer | 0 | |
60 | LookupsDDL_6 | Lookups DDL[6] | Lookups DDL | Integer | 0 | |
61 | LookupsDDL_7 | Lookups DDL[7] | Lookups DDL | Integer | 0 | |
62 | LookupsDDL_8 | Lookups DDL[8] | Lookups DDL | Integer | 0 | |
63 | LookupsDDL_9 | Lookups DDL[9] | Lookups DDL | Integer | 0 | |
64 | LookupsDDL_10 | Lookups DDL[10] | Lookups DDL | Integer | 0 | |
65 | LookupsDDL_11 | Lookups DDL[11] | Lookups DDL | Integer | 0 | |
66 | LookupsDDL_12 | Lookups DDL[12] | Lookups DDL | Integer | 0 | |
67 | LookupsDDL_13 | Lookups DDL[13] | Lookups DDL | Integer | 0 | |
68 | LookupsDDL_14 | Lookups DDL[14] | Lookups DDL | Integer | 0 | |
69 | LookupsDDL_15 | Lookups DDL[15] | Lookups DDL | Integer | 0 | |
70 | LookupsDDL_16 | Lookups DDL[16] | Lookups DDL | Integer | 0 | |
71 | LookupsDDL_17 | Lookups DDL[17] | Lookups DDL | Integer | 0 | |
72 | LookupsDDL_18 | Lookups DDL[18] | Lookups DDL | Integer | 0 | |
73 | LookupsDDL_19 | Lookups DDL[19] | Lookups DDL | Integer | 0 | |
74 | LookupsDDL_20 | Lookups DDL[20] | Lookups DDL | Integer | 0 | |
75 | Required_CB_1 | Required CB[1] | CB | Boolean | 0 | |
76 | Required_CB_2 | Required CB[2] | CB | Boolean | 0 | |
77 | Required_CB_3 | Required CB[3] | CB | Boolean | 0 | |
78 | Required_CB_4 | Required CB[4] | CB | Boolean | 0 | |
79 | Required_CB_5 | Required CB[5] | CB | Boolean | 0 | |
80 | Required_CB_6 | Required CB[6] | CB | Boolean | 0 | |
81 | Required_CB_7 | Required CB[7] | CB | Boolean | 0 | |
82 | Required_CB_8 | Required CB[8] | CB | Boolean | 0 | |
83 | Required_CB_9 | Required CB[9] | CB | Boolean | 0 | |
84 | Required_CB_10 | Required CB[10] | CB | Boolean | 0 | |
85 | Required_CB_11 | Required CB[11] | CB | Boolean | 0 | |
86 | Required_CB_12 | Required CB[12] | CB | Boolean | 0 | |
87 | Required_CB_13 | Required CB[13] | CB | Boolean | 0 | |
88 | Required_CB_14 | Required CB[14] | CB | Boolean | 0 | |
89 | Required_CB_15 | Required CB[15] | CB | Boolean | 0 | |
90 | Required_CB_16 | Required CB[16] | CB | Boolean | 0 | |
91 | Required_CB_17 | Required CB[17] | CB | Boolean | 0 | |
92 | Required_CB_18 | Required CB[18] | CB | Boolean | 0 | |
93 | Required_CB_19 | Required CB[19] | CB | Boolean | 0 | |
94 | Required_CB_20 | Required CB[20] | CB | Boolean | 0 | |
95 | PT_Decimal_Places_1 | PT Decimal Places[1] | DDL_Decimal_Places_Dollars | Integer | 0 | |
96 | PT_Decimal_Places_2 | PT Decimal Places[2] | DDL_Decimal_Places_Dollars | Integer | 0 | |
97 | PT_Decimal_Places_3 | PT Decimal Places[3] | DDL_Decimal_Places_Dollars | Integer | 0 | |
98 | PT_Decimal_Places_4 | PT Decimal Places[4] | DDL_Decimal_Places_Dollars | Integer | 0 | |
99 | PT_Decimal_Places_5 | PT Decimal Places[5] | DDL_Decimal_Places_Dollars | Integer | 0 | |
100 | PT_Decimal_Places_6 | PT Decimal Places[6] | DDL_Decimal_Places_Dollars | Integer | 0 | |
101 | PT_Decimal_Places_7 | PT Decimal Places[7] | DDL_Decimal_Places_Dollars | Integer | 0 | |
102 | PT_Decimal_Places_8 | PT Decimal Places[8] | DDL_Decimal_Places_Dollars | Integer | 0 | |
103 | PT_Decimal_Places_9 | PT Decimal Places[9] | DDL_Decimal_Places_Dollars | Integer | 0 | |
104 | PT_Decimal_Places_10 | PT Decimal Places[10] | DDL_Decimal_Places_Dollars | Integer | 0 | |
105 | PT_Decimal_Places_11 | PT Decimal Places[11] | DDL_Decimal_Places_Dollars | Integer | 0 | |
106 | PT_Decimal_Places_12 | PT Decimal Places[12] | DDL_Decimal_Places_Dollars | Integer | 0 | |
107 | PT_Decimal_Places_13 | PT Decimal Places[13] | DDL_Decimal_Places_Dollars | Integer | 0 | |
108 | PT_Decimal_Places_14 | PT Decimal Places[14] | DDL_Decimal_Places_Dollars | Integer | 0 | |
109 | PT_Decimal_Places_15 | PT Decimal Places[15] | DDL_Decimal_Places_Dollars | Integer | 0 | |
110 | PT_Decimal_Places_16 | PT Decimal Places[16] | DDL_Decimal_Places_Dollars | Integer | 0 | |
111 | PT_Decimal_Places_17 | PT Decimal Places[17] | DDL_Decimal_Places_Dollars | Integer | 0 | |
112 | PT_Decimal_Places_18 | PT Decimal Places[18] | DDL_Decimal_Places_Dollars | Integer | 0 | |
113 | PT_Decimal_Places_19 | PT Decimal Places[19] | DDL_Decimal_Places_Dollars | Integer | 0 | |
114 | PT_Decimal_Places_20 | PT Decimal Places[20] | DDL_Decimal_Places_Dollars | Integer | 0 | |
115 | Synchronize_CB | Synchronize CB | Synchronize CB | Boolean | 0 | |
116 | NOTEINDX | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['v11 - Extender Window Setup'].NOTEINDX AS 'v11 - Extender Window Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT40100 AS ['v11 - Extender Window Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['v11 - Extender Window Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
117 | CREATDDT | Created Date | DT | Date | 8 | |
118 | CRUSRID | Created User ID | STR15_User_ID | String | 15 | |
119 | MODIFDT | Modified Date | DT | Date | 8 | |
120 | MDFUSRID | Modified User ID | STR15 | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['v11 - Extender Window Setup'].MDFUSRID AS 'v11 - Extender Window Setup-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT40100 AS ['v11 - Extender Window Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['v11 - Extender Window Setup'].MDFUSRID = ['Users Master'].USERID |