Extender SOP Setup (EXT41800)

azurecurveProductsExtender (3107)ProjectExtender SOP Setup (EXT41800)

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

Product: Extender (3107)
Series: Project

Display Name: Extender SOP Setup
Physical Name: EXT41800
Technical Name: PT_Extender_SOP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_SOP_ID SearchExtender SOP IDSTR15_LBAUString1615
2Extender_SOP_Description SearchExtender SOP DescriptionSTR64String6664
3Extender_Type SearchExtender TypeINT5Integer24
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
5SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
6DOCID SearchDocument IDSTR15_LBAUString1615
7Ext_SOP_Document_From SearchExt_SOP_Document_FromExtender SOP Document FromInteger20
8Ext_SOP_Batch_From SearchExt_SOP_Batch_FromExtender SOP Batch FromInteger20
9Ext_SOP_Debtor_From SearchExt_SOP_Debtor_FromExtender SOP Debtor FromInteger20
10Ext_SOP_Site_From SearchExt_SOP_Site_FromExtender SOP Site FromInteger20
11Ext_SOP_PO_From SearchExt_SOP_PO_FromExtender SOP PO FromInteger20
12Ext_SOP_Item_From SearchExt_SOP_Item_FromExtender SOP Item FromInteger20
13Ext_SOP_QTY_From SearchExt_SOP_QTY_FromExtender SOP QTY FromInteger20
14Ext_SOP_UofM_From SearchExt_SOP_UofM_FromExtender SOP UofM FromInteger20
15Ext_SOP_Cost_From SearchExt_SOP_Cost_FromExtender SOP Cost FromInteger20
16Ext_SOP_Price_From SearchExt_SOP_Price_FromExtender SOP Price FromInteger20
17Ext_SOP_Freight_From SearchExt_SOP_Freight_FromExtender SOP Freight FromInteger20
18Ext_SOP_Misc_From SearchExt_SOP_Misc_FromExtender SOP Misc FromInteger20
19SOP_Field_Numbers_1 SearchSOP Field Numbers[1]INT5Integer24
20SOP_Field_Numbers_2 SearchSOP Field Numbers[2]INT5Integer24
21SOP_Field_Numbers_3 SearchSOP Field Numbers[3]INT5Integer24
22SOP_Field_Numbers_4 SearchSOP Field Numbers[4]INT5Integer24
23SOP_Field_Numbers_5 SearchSOP Field Numbers[5]INT5Integer24
24SOP_Field_Numbers_6 SearchSOP Field Numbers[6]INT5Integer24
25SOP_Field_Numbers_7 SearchSOP Field Numbers[7]INT5Integer24
26SOP_Field_Numbers_8 SearchSOP Field Numbers[8]INT5Integer24
27SOP_Field_Numbers_9 SearchSOP Field Numbers[9]INT5Integer24
28SOP_Field_Numbers_10 SearchSOP Field Numbers[10]INT5Integer24
29SOP_Field_Numbers_11 SearchSOP Field Numbers[11]INT5Integer24
30SOP_Field_Numbers_12 SearchSOP Field Numbers[12]INT5Integer24
31SOP_Field_Numbers_13 SearchSOP Field Numbers[13]INT5Integer24
32SOP_Field_Numbers_14 SearchSOP Field Numbers[14]INT5Integer24
33SOP_Field_Numbers_15 SearchSOP Field Numbers[15]INT5Integer24
34SOP_Field_Numbers_16 SearchSOP Field Numbers[16]INT5Integer24
35SOP_Field_Numbers_17 SearchSOP Field Numbers[17]INT5Integer24
36SOP_Field_Numbers_18 SearchSOP Field Numbers[18]INT5Integer24
37SOP_Field_Numbers_19 SearchSOP Field Numbers[19]INT5Integer24
38SOP_Field_Numbers_20 SearchSOP Field Numbers[20]INT5Integer24
39SOP_Field_Numbers_21 SearchSOP Field Numbers[21]INT5Integer24
40SOP_Field_Numbers_22 SearchSOP Field Numbers[22]INT5Integer24
41SOP_Field_Numbers_23 SearchSOP Field Numbers[23]INT5Integer24
42SOP_Field_Numbers_24 SearchSOP Field Numbers[24]INT5Integer24
43SOP_Field_Numbers_25 SearchSOP Field Numbers[25]INT5Integer24
44SOP_Field_Numbers_26 SearchSOP Field Numbers[26]INT5Integer24
45SOP_Field_Numbers_27 SearchSOP Field Numbers[27]INT5Integer24
46SOP_Field_Numbers_28 SearchSOP Field Numbers[28]INT5Integer24
47SOP_Field_Numbers_29 SearchSOP Field Numbers[29]INT5Integer24
48SOP_Field_Numbers_30 SearchSOP Field Numbers[30]INT5Integer24
49SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
50BACHNUMB SearchBatch NumberSTR15_LBAUString1615
51CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Extender SOP Setup'].CUSTNMBR AS 'Extender SOP Setup-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Extender SOP Setup'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
52LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Extender SOP Setup'].LOCNCODE AS 'Extender SOP Setup-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Extender SOP Setup'].LOCNCODE = ['Site Setup'].LOCNCODE
53PONUMBER SearchPO NumberSTR17_POP_NumberString1817
54ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Extender SOP Setup'].ITEMNMBR AS 'Extender SOP Setup-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Extender SOP Setup'].ITEMNMBR = ['Item Master'].ITEMNMBR
55QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
56UOFM SearchU Of MU_Of_MString108
57UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
58UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
59Sales_Percentage SearchSales PercentageINT5_%2Integer25
60FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
61MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
62Freight_Percentage SearchFreight PercentageINT5_%2Integer25
63Misc_Percentage SearchMisc PercentageINT5_%2Integer25
64Calculate_Commissions SearchCalculate CommissionsCalculate Commissions CBBoolean20
65Allow_Trade_Discounts SearchAllow Trade DiscountsAllow Trade Discounts CBBoolean20
66Ext_SOP_Reference_From SearchExt_SOP_Reference_FromExtender SOP Reference FromInteger20
67Ext_SOP_Comment_From SearchExt_SOP_Comment_FromExtender SOP Comment FromInteger20
68REFRENCE SearchReferenceSTR30String3230
69COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Extender SOP Setup'].COMMNTID AS 'Extender SOP Setup-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Extender SOP Setup'].COMMNTID = ['Comment Master'].COMMNTID
70Ext_SOP_Debtor_Name_From SearchExt_SOP_Debtor_Name_FromExtender SOP Debtor Name FromInteger20
71Ext_SOP_Salesperson_From SearchExt_SOP_Salesperson_FromExtender SOP Salesperson FromInteger20
72Ext_SOP_Sales_Territory_ SearchExt_SOP_Sales_Territory_FromExtender SOP Sales Territory FromInteger20
73Ext_SOPBillAddressFrom SearchExt_SOP_Bill_Address_FromExtender SOP Address FromInteger20
74Ext_SOPShipAddressFrom SearchExt_SOP_Ship_Address_FromExtender SOP Address FromInteger20
75CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
76SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Extender SOP Setup'].SLPRSNID AS 'Extender SOP Setup-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Extender SOP Setup'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
77SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Extender SOP Setup'].SALSTERR AS 'Extender SOP Setup-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Extender SOP Setup'].SALSTERR = ['Sales Territory Master File'].SALSTERR
78PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
79PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
80Ext_SOP_Item_Desc_From SearchExt_SOP_Item_Desc_FromExtender SOP Item Desc FromInteger20
81Ext_SOP_Markdown_From SearchExt_SOP_Markdown_FromExtender SOP Markdown FromInteger20
82Ext_SOP_Line_CommentFrom SearchExt_SOP_Line_Comment_FromExtender SOP Comment FromInteger20
83Ext_SOP_Line_Salesperson SearchExt_SOP_Line_Salesperson_FromExtender SOP Line Salesperson FromInteger20
84Ext_SOP_Line_Territory SearchExt_SOP_Line_Territory_FromExtender SOP Line Territory FromInteger20
85Ext_SOP_Line_Address SearchExt_SOP_Line_Address_FromExtender SOP Line Address FromInteger20
86Ext_SOP_Line_Site_From SearchExt_SOP_Line_Site_FromExtender SOP Line Site FromInteger20
87ITEMDESC SearchItem DescriptionSTR100String102100
88MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
89MRKDNPCT SearchMarkdown PercentINT5_%2Integer25
90Line_Comment_ID SearchLine Comment IDSTR15_Comment_IDString1615
91Line_Salesperson_ID SearchLine Salesperson IDSTR15_Salesperson_IDString1615
92Line_Sales_Territory SearchLine Sales TerritorySTR15_Sales_TerritoryString1615
93Line_Address_ID SearchLine Address IDSTR15_Address_CodeString1615
94Line_Site SearchLine SiteSTR10_Location_CodeString1210
95Minimum_Freight_Amount SearchMinimum Freight AmountDollar19Currency1019
96Maximum_Freight_Amount SearchMaximum Freight AmountDollar19Currency1019
97Minimum_Misc_Amount SearchMinimum Misc AmountDollar19Currency1019
98Maximum_Misc_Amount SearchMaximum Misc AmountDollar19Currency1019
99NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extender SOP Setup'].NOTEINDX AS 'Extender SOP Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extender SOP Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
100CREATDDT SearchCreated DateDTDate48
101CRUSRID SearchCreated User IDSTR15_User_IDString1615
102MODIFDT SearchModified DateDTDate48
103MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender SOP Setup'].MDFUSRID AS 'Extender SOP Setup-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT41800 AS ['Extender SOP Setup']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender SOP Setup'].MDFUSRID = ['Users Master'].USERID
104Ext_Date_From SearchExt_Date_FromExtender Date FromInteger20
azurecurveProductsExtender (3107)ProjectExtender SOP Setup (EXT41800)

Leave a Reply

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