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 TypeLength
1Extender_SOP_ID SearchExtender SOP IDSTR15_LBAUString15
2Extender_SOP_Description SearchExtender SOP DescriptionSTR64String64
3Extender_Type SearchExtender TypeINT5Integer4
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString15
5SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
6DOCID SearchDocument IDSTR15_LBAUString15
7Ext_SOP_Document_From SearchExt_SOP_Document_FromExtender SOP Document FromInteger0
8Ext_SOP_Batch_From SearchExt_SOP_Batch_FromExtender SOP Batch FromInteger0
9Ext_SOP_Debtor_From SearchExt_SOP_Debtor_FromExtender SOP Debtor FromInteger0
10Ext_SOP_Site_From SearchExt_SOP_Site_FromExtender SOP Site FromInteger0
11Ext_SOP_PO_From SearchExt_SOP_PO_FromExtender SOP PO FromInteger0
12Ext_SOP_Item_From SearchExt_SOP_Item_FromExtender SOP Item FromInteger0
13Ext_SOP_QTY_From SearchExt_SOP_QTY_FromExtender SOP QTY FromInteger0
14Ext_SOP_UofM_From SearchExt_SOP_UofM_FromExtender SOP UofM FromInteger0
15Ext_SOP_Cost_From SearchExt_SOP_Cost_FromExtender SOP Cost FromInteger0
16Ext_SOP_Price_From SearchExt_SOP_Price_FromExtender SOP Price FromInteger0
17Ext_SOP_Freight_From SearchExt_SOP_Freight_FromExtender SOP Freight FromInteger0
18Ext_SOP_Misc_From SearchExt_SOP_Misc_FromExtender SOP Misc FromInteger0
19SOP_Field_Numbers_1 SearchSOP Field Numbers[1]INT5Integer4
20SOP_Field_Numbers_2 SearchSOP Field Numbers[2]INT5Integer4
21SOP_Field_Numbers_3 SearchSOP Field Numbers[3]INT5Integer4
22SOP_Field_Numbers_4 SearchSOP Field Numbers[4]INT5Integer4
23SOP_Field_Numbers_5 SearchSOP Field Numbers[5]INT5Integer4
24SOP_Field_Numbers_6 SearchSOP Field Numbers[6]INT5Integer4
25SOP_Field_Numbers_7 SearchSOP Field Numbers[7]INT5Integer4
26SOP_Field_Numbers_8 SearchSOP Field Numbers[8]INT5Integer4
27SOP_Field_Numbers_9 SearchSOP Field Numbers[9]INT5Integer4
28SOP_Field_Numbers_10 SearchSOP Field Numbers[10]INT5Integer4
29SOP_Field_Numbers_11 SearchSOP Field Numbers[11]INT5Integer4
30SOP_Field_Numbers_12 SearchSOP Field Numbers[12]INT5Integer4
31SOP_Field_Numbers_13 SearchSOP Field Numbers[13]INT5Integer4
32SOP_Field_Numbers_14 SearchSOP Field Numbers[14]INT5Integer4
33SOP_Field_Numbers_15 SearchSOP Field Numbers[15]INT5Integer4
34SOP_Field_Numbers_16 SearchSOP Field Numbers[16]INT5Integer4
35SOP_Field_Numbers_17 SearchSOP Field Numbers[17]INT5Integer4
36SOP_Field_Numbers_18 SearchSOP Field Numbers[18]INT5Integer4
37SOP_Field_Numbers_19 SearchSOP Field Numbers[19]INT5Integer4
38SOP_Field_Numbers_20 SearchSOP Field Numbers[20]INT5Integer4
39SOP_Field_Numbers_21 SearchSOP Field Numbers[21]INT5Integer4
40SOP_Field_Numbers_22 SearchSOP Field Numbers[22]INT5Integer4
41SOP_Field_Numbers_23 SearchSOP Field Numbers[23]INT5Integer4
42SOP_Field_Numbers_24 SearchSOP Field Numbers[24]INT5Integer4
43SOP_Field_Numbers_25 SearchSOP Field Numbers[25]INT5Integer4
44SOP_Field_Numbers_26 SearchSOP Field Numbers[26]INT5Integer4
45SOP_Field_Numbers_27 SearchSOP Field Numbers[27]INT5Integer4
46SOP_Field_Numbers_28 SearchSOP Field Numbers[28]INT5Integer4
47SOP_Field_Numbers_29 SearchSOP Field Numbers[29]INT5Integer4
48SOP_Field_Numbers_30 SearchSOP Field Numbers[30]INT5Integer4
49SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
50BACHNUMB SearchBatch NumberSTR15_LBAUString15
51CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_CodeString10
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_NumberString17
54ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_STRCurrency17
56UOFM SearchU Of MU_Of_MString8
57UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
58UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
59Sales_Percentage SearchSales PercentageINT5_%2Integer5
60FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
61MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
62Freight_Percentage SearchFreight PercentageINT5_%2Integer5
63Misc_Percentage SearchMisc PercentageINT5_%2Integer5
64Calculate_Commissions SearchCalculate CommissionsCalculate Commissions CBBoolean0
65Allow_Trade_Discounts SearchAllow Trade DiscountsAllow Trade Discounts CBBoolean0
66Ext_SOP_Reference_From SearchExt_SOP_Reference_FromExtender SOP Reference FromInteger0
67Ext_SOP_Comment_From SearchExt_SOP_Comment_FromExtender SOP Comment FromInteger0
68REFRENCE SearchReferenceSTR30String30
69COMMNTID SearchComment IDSTR15_Comment_IDString15
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 FromInteger0
71Ext_SOP_Salesperson_From SearchExt_SOP_Salesperson_FromExtender SOP Salesperson FromInteger0
72Ext_SOP_Sales_Territory_ SearchExt_SOP_Sales_Territory_FromExtender SOP Sales Territory FromInteger0
73Ext_SOPBillAddressFrom SearchExt_SOP_Bill_Address_FromExtender SOP Address FromInteger0
74Ext_SOPShipAddressFrom SearchExt_SOP_Ship_Address_FromExtender SOP Address FromInteger0
75CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
76SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_TerritoryString15
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_LBAUString15
79PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
80Ext_SOP_Item_Desc_From SearchExt_SOP_Item_Desc_FromExtender SOP Item Desc FromInteger0
81Ext_SOP_Markdown_From SearchExt_SOP_Markdown_FromExtender SOP Markdown FromInteger0
82Ext_SOP_Line_CommentFrom SearchExt_SOP_Line_Comment_FromExtender SOP Comment FromInteger0
83Ext_SOP_Line_Salesperson SearchExt_SOP_Line_Salesperson_FromExtender SOP Line Salesperson FromInteger0
84Ext_SOP_Line_Territory SearchExt_SOP_Line_Territory_FromExtender SOP Line Territory FromInteger0
85Ext_SOP_Line_Address SearchExt_SOP_Line_Address_FromExtender SOP Line Address FromInteger0
86Ext_SOP_Line_Site_From SearchExt_SOP_Line_Site_FromExtender SOP Line Site FromInteger0
87ITEMDESC SearchItem DescriptionSTR100String100
88MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
89MRKDNPCT SearchMarkdown PercentINT5_%2Integer5
90Line_Comment_ID SearchLine Comment IDSTR15_Comment_IDString15
91Line_Salesperson_ID SearchLine Salesperson IDSTR15_Salesperson_IDString15
92Line_Sales_Territory SearchLine Sales TerritorySTR15_Sales_TerritoryString15
93Line_Address_ID SearchLine Address IDSTR15_Address_CodeString15
94Line_Site SearchLine SiteSTR10_Location_CodeString10
95Minimum_Freight_Amount SearchMinimum Freight AmountDollar19Currency19
96Maximum_Freight_Amount SearchMaximum Freight AmountDollar19Currency19
97Minimum_Misc_Amount SearchMinimum Misc AmountDollar19Currency19
98Maximum_Misc_Amount SearchMaximum Misc AmountDollar19Currency19
99NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
101CRUSRID SearchCreated User IDSTR15_User_IDString15
102MODIFDT SearchModified DateDTDate8
103MDFUSRID SearchModified User IDSTR15String15
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 FromInteger0
azurecurveProductsExtender (3107)ProjectExtender SOP Setup (EXT41800)

Leave a Reply

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