Extender Windows (EXT20100)

azurecurveProductsExtender (3107)ProjectExtender Windows (EXT20100)

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

Product: Extender (3107)
Series: Project

Display Name: Extender Windows
Physical Name: EXT20100
Technical Name: EXT_Extender_Windows

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Window_ID SearchExtender Window IDSTR15_LBAUString1615
2Extender_Window_Name SearchExtender Window NameSTR64String6664
3Extender_Window_Type SearchExtender Window TypeExtender Window TypeInteger20
4PRODID SearchProduct IDINT4Integer24
5Long_Form_Name SearchLong Form NameSTR255String256255
6Long_Window_Name SearchLong Window NameSTR100String102100
7INACTIVE SearchInactiveCB_InactiveBoolean20
8Extender_Key_Windows_1 SearchExtender Key Windows[1]STR100String102100
9Extender_Key_Windows_2 SearchExtender Key Windows[2]STR100String102100
10Extender_Key_Windows_3 SearchExtender Key Windows[3]STR100String102100
11Extender_Key_Windows_4 SearchExtender Key Windows[4]STR100String102100
12Extender_Key_Windows_5 SearchExtender Key Windows[5]STR100String102100
13Extender_Key_Fields_1 SearchExtender Key Fields[1]STR100String102100
14Extender_Key_Fields_2 SearchExtender Key Fields[2]STR100String102100
15Extender_Key_Fields_3 SearchExtender Key Fields[3]STR100String102100
16Extender_Key_Fields_4 SearchExtender Key Fields[4]STR100String102100
17Extender_Key_Fields_5 SearchExtender Key Fields[5]STR100String102100
18Extender_Field_IDs_1 SearchExtender Field IDs[1]Long IntLong Integer48
19Extender_Field_IDs_2 SearchExtender Field IDs[2]Long IntLong Integer48
20Extender_Field_IDs_3 SearchExtender Field IDs[3]Long IntLong Integer48
21Extender_Field_IDs_4 SearchExtender Field IDs[4]Long IntLong Integer48
22Extender_Field_IDs_5 SearchExtender Field IDs[5]Long IntLong Integer48
23Extender_Field_IDs_6 SearchExtender Field IDs[6]Long IntLong Integer48
24Extender_Field_IDs_7 SearchExtender Field IDs[7]Long IntLong Integer48
25Extender_Field_IDs_8 SearchExtender Field IDs[8]Long IntLong Integer48
26Extender_Field_IDs_9 SearchExtender Field IDs[9]Long IntLong Integer48
27Extender_Field_IDs_10 SearchExtender Field IDs[10]Long IntLong Integer48
28Extender_Field_IDs_11 SearchExtender Field IDs[11]Long IntLong Integer48
29Extender_Field_IDs_12 SearchExtender Field IDs[12]Long IntLong Integer48
30Extender_Field_IDs_13 SearchExtender Field IDs[13]Long IntLong Integer48
31Extender_Field_IDs_14 SearchExtender Field IDs[14]Long IntLong Integer48
32Extender_Field_IDs_15 SearchExtender Field IDs[15]Long IntLong Integer48
33AddExtenderWindowDetails SearchAdd Extender Window DetailsAdd Extender Window DetailsBoolean20
34Expand_Scrolling_Default SearchExpand Scrolling Grid by DefaultExpand Scrolling Grid By DefaultBoolean20
35AddExtenderWindowNotes SearchAdd Extender Window NotesAdd Extender Window NotesBoolean20
36Detail_Field_IDs_1 SearchExtender Detail Field IDs[1]Long IntLong Integer48
37Detail_Field_IDs_2 SearchExtender Detail Field IDs[2]Long IntLong Integer48
38Detail_Field_IDs_3 SearchExtender Detail Field IDs[3]Long IntLong Integer48
39Detail_Field_IDs_4 SearchExtender Detail Field IDs[4]Long IntLong Integer48
40Detail_Field_IDs_5 SearchExtender Detail Field IDs[5]Long IntLong Integer48
41Detail_Field_IDs_6 SearchExtender Detail Field IDs[6]Long IntLong Integer48
42Detail_Field_IDs_7 SearchExtender Detail Field IDs[7]Long IntLong Integer48
43Detail_Field_IDs_8 SearchExtender Detail Field IDs[8]Long IntLong Integer48
44Detail_Field_IDs_9 SearchExtender Detail Field IDs[9]Long IntLong Integer48
45Detail_Field_IDs_10 SearchExtender Detail Field IDs[10]Long IntLong Integer48
46Detail_Field_IDs_2_1 SearchExtender Detail Field IDs 2[1]Long IntLong Integer48
47Detail_Field_IDs_2_2 SearchExtender Detail Field IDs 2[2]Long IntLong Integer48
48Detail_Field_IDs_2_3 SearchExtender Detail Field IDs 2[3]Long IntLong Integer48
49Detail_Field_IDs_2_4 SearchExtender Detail Field IDs 2[4]Long IntLong Integer48
50Detail_Field_IDs_2_5 SearchExtender Detail Field IDs 2[5]Long IntLong Integer48
51Detail_Field_IDs_2_6 SearchExtender Detail Field IDs 2[6]Long IntLong Integer48
52Detail_Field_IDs_2_7 SearchExtender Detail Field IDs 2[7]Long IntLong Integer48
53Detail_Field_IDs_2_8 SearchExtender Detail Field IDs 2[8]Long IntLong Integer48
54Detail_Field_IDs_2_9 SearchExtender Detail Field IDs 2[9]Long IntLong Integer48
55Detail_Field_IDs_2_10 SearchExtender Detail Field IDs 2[10]Long IntLong Integer48
56Show_Total_CB SearchShow Total CBShow Total CBBoolean20
57Total_Field_ID SearchTotal Field IDLong IntLong Integer48
58Read_Only_CB SearchRead Only CBRead Only CBBoolean20
59Display_In_Tab SearchDisplay In TabDisplay In Tab CBBoolean20
60Tab_Name SearchTab NameSTR50String5250
61PT_Open_Method1 SearchExtender Open MethodExtender Open MethodInteger20
62Auto_Open SearchAuto OpenAuto Open CBBoolean20
63Auto_Close SearchAuto CloseAuto CloseBoolean20
64Hide_User SearchHide UserCB_Hide_UserBoolean20
65Hide_Note_Type SearchHide Note TypeCB_Hide_NoteTypeBoolean20
66Hide_Date SearchHide DateCB_Hide_DateBoolean20
67Hide_Time SearchHide TimeCB_Hide_TimeBoolean20
68Extender_Hot_Key SearchExtender Hot KeySTR1String21
69Long_Field_Name SearchLong Field NameSTR100String102100
70Extender_Template_ID SearchExtender Template IDLong IntLong Integer48
71Template_SelectionMethod SearchTemplate Selection MethodTemplate Selection MethodInteger20
72Special_Case_Number SearchSpecial Case NumberINT5Integer24
73NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extender Windows'].NOTEINDX AS 'Extender Windows-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT20100 AS ['Extender Windows']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extender Windows'].NOTEINDX = ['Record Notes Master'].NOTEINDX
74CREATDDT SearchCreated DateDTDate48
75CRUSRID SearchCreated User IDSTR15_User_IDString1615
76MODIFDT SearchModified DateDTDate48
77MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender Windows'].MDFUSRID AS 'Extender Windows-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT20100 AS ['Extender Windows']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender Windows'].MDFUSRID = ['Users Master'].USERID
azurecurveProductsExtender (3107)ProjectExtender Windows (EXT20100)

Leave a Reply

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