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

Click to show/hide

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

Click to show/hide

       ['Extender Forms'].NOTEINDX AS 'Extender Forms-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
       EXT20200 AS ['Extender Forms']
       SY03900 AS ['Record Notes Master']
                     ['Extender Forms'].NOTEINDX = ['Record Notes Master'].NOTEINDX
76CREATDDT SearchCreated DateDTDate8
77CRUSRID SearchCreated User IDSTR15_User_IDString15
78MODIFDT SearchModified DateDTDate8
79MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

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

Leave a Reply

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