Extender Forms (EXT20200)

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

Product: Extender (3107)
Series: Project

Display Name: Extender Forms
Physical Name: EXT20200
Technical Name: EXT_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
4INACTIVE SearchInactiveCB_InactiveBoolean20
5Use_Existing_Lookup SearchUse Existing LookupUse Existing LookupBoolean20
6Lookup_Number SearchLookup NumberLong_10ULong Integer410
7Autoincrement SearchAutoincrementAutoincrement ID FieldBoolean20
8Extender_Description_Pro SearchExtender Description PromptSTR50String5250
9Description_Field_Req SearchDescription Field RequiredDescription Field RequiredBoolean20
10Use_Secondary_Key SearchUse Secondary KeyUse Secondary KeyBoolean20
11Extender_Second_Prompt SearchExtender Secondary ID PromptSTR50String5250
12Extender_Field_IDs_1 SearchExtender Field IDs[1]Long IntLong Integer48
13Extender_Field_IDs_2 SearchExtender Field IDs[2]Long IntLong Integer48
14Extender_Field_IDs_3 SearchExtender Field IDs[3]Long IntLong Integer48
15Extender_Field_IDs_4 SearchExtender Field IDs[4]Long IntLong Integer48
16Extender_Field_IDs_5 SearchExtender Field IDs[5]Long IntLong Integer48
17Extender_Field_IDs_6 SearchExtender Field IDs[6]Long IntLong Integer48
18Extender_Field_IDs_7 SearchExtender Field IDs[7]Long IntLong Integer48
19Extender_Field_IDs_8 SearchExtender Field IDs[8]Long IntLong Integer48
20Extender_Field_IDs_9 SearchExtender Field IDs[9]Long IntLong Integer48
21Extender_Field_IDs_10 SearchExtender Field IDs[10]Long IntLong Integer48
22Extender_Field_IDs_11 SearchExtender Field IDs[11]Long IntLong Integer48
23Extender_Field_IDs_12 SearchExtender Field IDs[12]Long IntLong Integer48
24Extender_Field_IDs_13 SearchExtender Field IDs[13]Long IntLong Integer48
25Extender_Field_IDs_14 SearchExtender Field IDs[14]Long IntLong Integer48
26Extender_Field_IDs_15 SearchExtender Field IDs[15]Long IntLong Integer48
27Extender_Field_IDs_2_1 SearchExtender Field IDs 2[1]Long IntLong Integer48
28Extender_Field_IDs_2_2 SearchExtender Field IDs 2[2]Long IntLong Integer48
29Extender_Field_IDs_2_3 SearchExtender Field IDs 2[3]Long IntLong Integer48
30Extender_Field_IDs_2_4 SearchExtender Field IDs 2[4]Long IntLong Integer48
31Extender_Field_IDs_2_5 SearchExtender Field IDs 2[5]Long IntLong Integer48
32Extender_Field_IDs_2_6 SearchExtender Field IDs 2[6]Long IntLong Integer48
33Extender_Field_IDs_2_7 SearchExtender Field IDs 2[7]Long IntLong Integer48
34Extender_Field_IDs_2_8 SearchExtender Field IDs 2[8]Long IntLong Integer48
35Extender_Field_IDs_2_9 SearchExtender Field IDs 2[9]Long IntLong Integer48
36Extender_Field_IDs_2_10 SearchExtender Field IDs 2[10]Long IntLong Integer48
37Extender_Field_IDs_2_11 SearchExtender Field IDs 2[11]Long IntLong Integer48
38Extender_Field_IDs_2_12 SearchExtender Field IDs 2[12]Long IntLong Integer48
39Extender_Field_IDs_2_13 SearchExtender Field IDs 2[13]Long IntLong Integer48
40Extender_Field_IDs_2_14 SearchExtender Field IDs 2[14]Long IntLong Integer48
41Extender_Field_IDs_2_15 SearchExtender Field IDs 2[15]Long IntLong Integer48
42Detail_Field_IDs_1 SearchExtender Detail Field IDs[1]Long IntLong Integer48
43Detail_Field_IDs_2 SearchExtender Detail Field IDs[2]Long IntLong Integer48
44Detail_Field_IDs_3 SearchExtender Detail Field IDs[3]Long IntLong Integer48
45Detail_Field_IDs_4 SearchExtender Detail Field IDs[4]Long IntLong Integer48
46Detail_Field_IDs_5 SearchExtender Detail Field IDs[5]Long IntLong Integer48
47Detail_Field_IDs_6 SearchExtender Detail Field IDs[6]Long IntLong Integer48
48Detail_Field_IDs_7 SearchExtender Detail Field IDs[7]Long IntLong Integer48
49Detail_Field_IDs_8 SearchExtender Detail Field IDs[8]Long IntLong Integer48
50Detail_Field_IDs_9 SearchExtender Detail Field IDs[9]Long IntLong Integer48
51Detail_Field_IDs_10 SearchExtender Detail Field IDs[10]Long IntLong Integer48
52Detail_Field_IDs_2_1 SearchExtender Detail Field IDs 2[1]Long IntLong Integer48
53Detail_Field_IDs_2_2 SearchExtender Detail Field IDs 2[2]Long IntLong Integer48
54Detail_Field_IDs_2_3 SearchExtender Detail Field IDs 2[3]Long IntLong Integer48
55Detail_Field_IDs_2_4 SearchExtender Detail Field IDs 2[4]Long IntLong Integer48
56Detail_Field_IDs_2_5 SearchExtender Detail Field IDs 2[5]Long IntLong Integer48
57Detail_Field_IDs_2_6 SearchExtender Detail Field IDs 2[6]Long IntLong Integer48
58Detail_Field_IDs_2_7 SearchExtender Detail Field IDs 2[7]Long IntLong Integer48
59Detail_Field_IDs_2_8 SearchExtender Detail Field IDs 2[8]Long IntLong Integer48
60Detail_Field_IDs_2_9 SearchExtender Detail Field IDs 2[9]Long IntLong Integer48
61Detail_Field_IDs_2_10 SearchExtender Detail Field IDs 2[10]Long IntLong Integer48
62Read_Only_CB SearchRead Only CBRead Only CBBoolean20
63Add_Extender_Form_Detail SearchAdd Extender Form DetailsAdd Extender Form DetailsBoolean20
64Expand_Scrolling_Default SearchExpand Scrolling Grid by DefaultExpand Scrolling Grid By DefaultBoolean20
65Show_Total_CB SearchShow Total CBShow Total CBBoolean20
66Total_Field_ID SearchTotal Field IDLong IntLong Integer48
67Multicurrency_CB SearchMulticurrency CBMulticurrency CBBoolean20
68Currency_Field_ID SearchCurrency Field IDLong IntLong Integer48
69RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Extender Forms'].RATETPID AS 'Extender Forms-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       EXT20200 AS ['Extender Forms']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Extender Forms'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
70Currency_Default_FieldID SearchCurrency Default Field IDLong IntLong Integer48
71Currency_Default_Method SearchCurrency Default MethodCurrency Default MethodInteger20
72Default_From_Field_ID SearchDefault From Field IDLong IntLong Integer48
73Extender_Template_ID SearchExtender Template IDLong IntLong Integer48
74Template_SelectionMethod SearchTemplate Selection MethodTemplate Selection MethodInteger20
75NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Click to show/hide

SELECT
       ['Extender Forms'].MDFUSRID AS 'Extender Forms-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT20200 AS ['Extender Forms']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender Forms'].MDFUSRID = ['Users Master'].USERID

Leave a Reply

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