v11 – Extender Detail Windows (EXT40150)

azurecurveProductsExtender (3107)Projectv11 - Extender Detail Windows (EXT40150)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT40150

Product: Extender (3107)
Series: Project

Display Name: v11 - Extender Detail Windows
Physical Name: EXT40150
Technical Name: PT_Extender_Detail_Windows

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PT_Window_ID SearchPT Window IDSTR15_Address_CodeString1615
2PT_Window_Description SearchPT Window DescriptionSTR64String6664
3PRODID SearchProduct IDINT4Integer24
4Long_Form_Name SearchLong Form NameSTR255String256255
5Long_Window_Name SearchLong Window NameSTR100String102100
6Detail_Prompts_1 SearchDetail Prompts[1]STR64String6664
7Detail_Prompts_2 SearchDetail Prompts[2]STR64String6664
8Detail_Prompts_3 SearchDetail Prompts[3]STR64String6664
9Detail_Prompts_4 SearchDetail Prompts[4]STR64String6664
10Detail_Prompts_5 SearchDetail Prompts[5]STR64String6664
11Detail_Prompts_6 SearchDetail Prompts[6]STR64String6664
12Detail_Prompts_7 SearchDetail Prompts[7]STR64String6664
13Detail_Prompts_8 SearchDetail Prompts[8]STR64String6664
14Detail_Prompts_9 SearchDetail Prompts[9]STR64String6664
15Detail_Prompts_10 SearchDetail Prompts[10]STR64String6664
16Detail_Prompts_11 SearchDetail Prompts[11]STR64String6664
17Detail_Prompts_12 SearchDetail Prompts[12]STR64String6664
18Detail_Prompts_13 SearchDetail Prompts[13]STR64String6664
19Detail_Prompts_14 SearchDetail Prompts[14]STR64String6664
20Detail_Prompts_15 SearchDetail Prompts[15]STR64String6664
21Detail_Prompts_16 SearchDetail Prompts[16]STR64String6664
22Detail_Prompts_17 SearchDetail Prompts[17]STR64String6664
23Detail_Prompts_18 SearchDetail Prompts[18]STR64String6664
24Detail_Prompts_19 SearchDetail Prompts[19]STR64String6664
25Detail_Prompts_20 SearchDetail Prompts[20]STR64String6664
26Detail_Field_Type_1 SearchDetail Field Type[1]DDLInteger20
27Detail_Field_Type_2 SearchDetail Field Type[2]DDLInteger20
28Detail_Field_Type_3 SearchDetail Field Type[3]DDLInteger20
29Detail_Field_Type_4 SearchDetail Field Type[4]DDLInteger20
30Detail_Field_Type_5 SearchDetail Field Type[5]DDLInteger20
31Detail_Field_Type_6 SearchDetail Field Type[6]DDLInteger20
32Detail_Field_Type_7 SearchDetail Field Type[7]DDLInteger20
33Detail_Field_Type_8 SearchDetail Field Type[8]DDLInteger20
34Detail_Field_Type_9 SearchDetail Field Type[9]DDLInteger20
35Detail_Field_Type_10 SearchDetail Field Type[10]DDLInteger20
36Detail_Field_Type_11 SearchDetail Field Type[11]DDLInteger20
37Detail_Field_Type_12 SearchDetail Field Type[12]DDLInteger20
38Detail_Field_Type_13 SearchDetail Field Type[13]DDLInteger20
39Detail_Field_Type_14 SearchDetail Field Type[14]DDLInteger20
40Detail_Field_Type_15 SearchDetail Field Type[15]DDLInteger20
41Detail_Field_Type_16 SearchDetail Field Type[16]DDLInteger20
42Detail_Field_Type_17 SearchDetail Field Type[17]DDLInteger20
43Detail_Field_Type_18 SearchDetail Field Type[18]DDLInteger20
44Detail_Field_Type_19 SearchDetail Field Type[19]DDLInteger20
45Detail_Field_Type_20 SearchDetail Field Type[20]DDLInteger20
46Detail_Lookups_1 SearchDetail Lookups[1]DDLInteger20
47Detail_Lookups_2 SearchDetail Lookups[2]DDLInteger20
48Detail_Lookups_3 SearchDetail Lookups[3]DDLInteger20
49Detail_Lookups_4 SearchDetail Lookups[4]DDLInteger20
50Detail_Lookups_5 SearchDetail Lookups[5]DDLInteger20
51Detail_Lookups_6 SearchDetail Lookups[6]DDLInteger20
52Detail_Lookups_7 SearchDetail Lookups[7]DDLInteger20
53Detail_Lookups_8 SearchDetail Lookups[8]DDLInteger20
54Detail_Lookups_9 SearchDetail Lookups[9]DDLInteger20
55Detail_Lookups_10 SearchDetail Lookups[10]DDLInteger20
56Detail_Lookups_11 SearchDetail Lookups[11]DDLInteger20
57Detail_Lookups_12 SearchDetail Lookups[12]DDLInteger20
58Detail_Lookups_13 SearchDetail Lookups[13]DDLInteger20
59Detail_Lookups_14 SearchDetail Lookups[14]DDLInteger20
60Detail_Lookups_15 SearchDetail Lookups[15]DDLInteger20
61Detail_Lookups_16 SearchDetail Lookups[16]DDLInteger20
62Detail_Lookups_17 SearchDetail Lookups[17]DDLInteger20
63Detail_Lookups_18 SearchDetail Lookups[18]DDLInteger20
64Detail_Lookups_19 SearchDetail Lookups[19]DDLInteger20
65Detail_Lookups_20 SearchDetail Lookups[20]DDLInteger20
66Detail_Required_1 SearchDetail Required[1]CBBoolean20
67Detail_Required_2 SearchDetail Required[2]CBBoolean20
68Detail_Required_3 SearchDetail Required[3]CBBoolean20
69Detail_Required_4 SearchDetail Required[4]CBBoolean20
70Detail_Required_5 SearchDetail Required[5]CBBoolean20
71Detail_Required_6 SearchDetail Required[6]CBBoolean20
72Detail_Required_7 SearchDetail Required[7]CBBoolean20
73Detail_Required_8 SearchDetail Required[8]CBBoolean20
74Detail_Required_9 SearchDetail Required[9]CBBoolean20
75Detail_Required_10 SearchDetail Required[10]CBBoolean20
76Detail_Required_11 SearchDetail Required[11]CBBoolean20
77Detail_Required_12 SearchDetail Required[12]CBBoolean20
78Detail_Required_13 SearchDetail Required[13]CBBoolean20
79Detail_Required_14 SearchDetail Required[14]CBBoolean20
80Detail_Required_15 SearchDetail Required[15]CBBoolean20
81Detail_Required_16 SearchDetail Required[16]CBBoolean20
82Detail_Required_17 SearchDetail Required[17]CBBoolean20
83Detail_Required_18 SearchDetail Required[18]CBBoolean20
84Detail_Required_19 SearchDetail Required[19]CBBoolean20
85Detail_Required_20 SearchDetail Required[20]CBBoolean20
86Detail_Decimal_Places_1 SearchDetail Decimal Places[1]DDL_Decimal_Places_DollarsInteger20
87Detail_Decimal_Places_2 SearchDetail Decimal Places[2]DDL_Decimal_Places_DollarsInteger20
88Detail_Decimal_Places_3 SearchDetail Decimal Places[3]DDL_Decimal_Places_DollarsInteger20
89Detail_Decimal_Places_4 SearchDetail Decimal Places[4]DDL_Decimal_Places_DollarsInteger20
90Detail_Decimal_Places_5 SearchDetail Decimal Places[5]DDL_Decimal_Places_DollarsInteger20
91Detail_Decimal_Places_6 SearchDetail Decimal Places[6]DDL_Decimal_Places_DollarsInteger20
92Detail_Decimal_Places_7 SearchDetail Decimal Places[7]DDL_Decimal_Places_DollarsInteger20
93Detail_Decimal_Places_8 SearchDetail Decimal Places[8]DDL_Decimal_Places_DollarsInteger20
94Detail_Decimal_Places_9 SearchDetail Decimal Places[9]DDL_Decimal_Places_DollarsInteger20
95Detail_Decimal_Places_10 SearchDetail Decimal Places[10]DDL_Decimal_Places_DollarsInteger20
96Detail_Decimal_Places_11 SearchDetail Decimal Places[11]DDL_Decimal_Places_DollarsInteger20
97Detail_Decimal_Places_12 SearchDetail Decimal Places[12]DDL_Decimal_Places_DollarsInteger20
98Detail_Decimal_Places_13 SearchDetail Decimal Places[13]DDL_Decimal_Places_DollarsInteger20
99Detail_Decimal_Places_14 SearchDetail Decimal Places[14]DDL_Decimal_Places_DollarsInteger20
100Detail_Decimal_Places_15 SearchDetail Decimal Places[15]DDL_Decimal_Places_DollarsInteger20
101Detail_Decimal_Places_16 SearchDetail Decimal Places[16]DDL_Decimal_Places_DollarsInteger20
102Detail_Decimal_Places_17 SearchDetail Decimal Places[17]DDL_Decimal_Places_DollarsInteger20
103Detail_Decimal_Places_18 SearchDetail Decimal Places[18]DDL_Decimal_Places_DollarsInteger20
104Detail_Decimal_Places_19 SearchDetail Decimal Places[19]DDL_Decimal_Places_DollarsInteger20
105Detail_Decimal_Places_20 SearchDetail Decimal Places[20]DDL_Decimal_Places_DollarsInteger20
106Detail_Row_1 SearchDetail Row[1]INT1Integer21
107Detail_Row_2 SearchDetail Row[2]INT1Integer21
108Detail_Row_3 SearchDetail Row[3]INT1Integer21
109Detail_Row_4 SearchDetail Row[4]INT1Integer21
110Detail_Row_5 SearchDetail Row[5]INT1Integer21
111Detail_Row_6 SearchDetail Row[6]INT1Integer21
112Detail_Row_7 SearchDetail Row[7]INT1Integer21
113Detail_Row_8 SearchDetail Row[8]INT1Integer21
114Detail_Row_9 SearchDetail Row[9]INT1Integer21
115Detail_Row_10 SearchDetail Row[10]INT1Integer21
116Detail_Row_11 SearchDetail Row[11]INT1Integer21
117Detail_Row_12 SearchDetail Row[12]INT1Integer21
118Detail_Row_13 SearchDetail Row[13]INT1Integer21
119Detail_Row_14 SearchDetail Row[14]INT1Integer21
120Detail_Row_15 SearchDetail Row[15]INT1Integer21
121Detail_Row_16 SearchDetail Row[16]INT1Integer21
122Detail_Row_17 SearchDetail Row[17]INT1Integer21
123Detail_Row_18 SearchDetail Row[18]INT1Integer21
124Detail_Row_19 SearchDetail Row[19]INT1Integer21
125Detail_Row_20 SearchDetail Row[20]INT1Integer21
126HotKey SearchPT HotKeySTR1String21
127Long_Field_Name SearchLong Field NameSTR100String102100
128PT_Open_Method SearchPT Open MethodPT Open MethodInteger20
129Auto_Open SearchAuto OpenAuto Open CBBoolean20
130PT_Auto_Close SearchPT Auto CloseAuto CloseBoolean20
131Show_Total_CB SearchShow Total CBShow Total CBBoolean20
132Total_Field SearchTotal FieldINT5Integer24
133NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['v11 - Extender Detail Windows'].NOTEINDX AS 'v11 - Extender Detail Windows-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT40150 AS ['v11 - Extender Detail Windows']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['v11 - Extender Detail Windows'].NOTEINDX = ['Record Notes Master'].NOTEINDX
134MODIFDT SearchModified DateDTDate48
135MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['v11 - Extender Detail Windows'].MDFUSRID AS 'v11 - Extender Detail Windows-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT40150 AS ['v11 - Extender Detail Windows']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['v11 - Extender Detail Windows'].MDFUSRID = ['Users Master'].USERID
136CREATDDT SearchCreated DateDTDate48
137CRUSRID SearchCreated User IDSTR15_User_IDString1615
azurecurveProductsExtender (3107)Projectv11 - Extender Detail Windows (EXT40150)

Leave a Reply

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