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_SOPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_SOP_ID 
Extender SOP ID STR15_LBAU String 15 2 Extender_SOP_Description Extender SOP Description STR64 String 64 3 Extender_Type Extender Type INT5 Integer 4 4 Extender_Form_ID Extender Form ID STR15_LBAU String 15 5 SOPTYPE SOP Type DDL_SOP_Type Integer 0 6 DOCID Document ID STR15_LBAU String 15 7 Ext_SOP_Document_From Ext_SOP_Document_From Extender SOP Document From Integer 0 8 Ext_SOP_Batch_From Ext_SOP_Batch_From Extender SOP Batch From Integer 0 9 Ext_SOP_Debtor_From Ext_SOP_Debtor_From Extender SOP Debtor From Integer 0 10 Ext_SOP_Site_From Ext_SOP_Site_From Extender SOP Site From Integer 0 11 Ext_SOP_PO_From Ext_SOP_PO_From Extender SOP PO From Integer 0 12 Ext_SOP_Item_From Ext_SOP_Item_From Extender SOP Item From Integer 0 13 Ext_SOP_QTY_From Ext_SOP_QTY_From Extender SOP QTY From Integer 0 14 Ext_SOP_UofM_From Ext_SOP_UofM_From Extender SOP UofM From Integer 0 15 Ext_SOP_Cost_From Ext_SOP_Cost_From Extender SOP Cost From Integer 0 16 Ext_SOP_Price_From Ext_SOP_Price_From Extender SOP Price From Integer 0 17 Ext_SOP_Freight_From Ext_SOP_Freight_From Extender SOP Freight From Integer 0 18 Ext_SOP_Misc_From Ext_SOP_Misc_From Extender SOP Misc From Integer 0 19 SOP_Field_Numbers_1 SOP Field Numbers[1] INT5 Integer 4 20 SOP_Field_Numbers_2 SOP Field Numbers[2] INT5 Integer 4 21 SOP_Field_Numbers_3 SOP Field Numbers[3] INT5 Integer 4 22 SOP_Field_Numbers_4 SOP Field Numbers[4] INT5 Integer 4 23 SOP_Field_Numbers_5 SOP Field Numbers[5] INT5 Integer 4 24 SOP_Field_Numbers_6 SOP Field Numbers[6] INT5 Integer 4 25 SOP_Field_Numbers_7 SOP Field Numbers[7] INT5 Integer 4 26 SOP_Field_Numbers_8 SOP Field Numbers[8] INT5 Integer 4 27 SOP_Field_Numbers_9 SOP Field Numbers[9] INT5 Integer 4 28 SOP_Field_Numbers_10 SOP Field Numbers[10] INT5 Integer 4 29 SOP_Field_Numbers_11 SOP Field Numbers[11] INT5 Integer 4 30 SOP_Field_Numbers_12 SOP Field Numbers[12] INT5 Integer 4 31 SOP_Field_Numbers_13 SOP Field Numbers[13] INT5 Integer 4 32 SOP_Field_Numbers_14 SOP Field Numbers[14] INT5 Integer 4 33 SOP_Field_Numbers_15 SOP Field Numbers[15] INT5 Integer 4 34 SOP_Field_Numbers_16 SOP Field Numbers[16] INT5 Integer 4 35 SOP_Field_Numbers_17 SOP Field Numbers[17] INT5 Integer 4 36 SOP_Field_Numbers_18 SOP Field Numbers[18] INT5 Integer 4 37 SOP_Field_Numbers_19 SOP Field Numbers[19] INT5 Integer 4 38 SOP_Field_Numbers_20 SOP Field Numbers[20] INT5 Integer 4 39 SOP_Field_Numbers_21 SOP Field Numbers[21] INT5 Integer 4 40 SOP_Field_Numbers_22 SOP Field Numbers[22] INT5 Integer 4 41 SOP_Field_Numbers_23 SOP Field Numbers[23] INT5 Integer 4 42 SOP_Field_Numbers_24 SOP Field Numbers[24] INT5 Integer 4 43 SOP_Field_Numbers_25 SOP Field Numbers[25] INT5 Integer 4 44 SOP_Field_Numbers_26 SOP Field Numbers[26] INT5 Integer 4 45 SOP_Field_Numbers_27 SOP Field Numbers[27] INT5 Integer 4 46 SOP_Field_Numbers_28 SOP Field Numbers[28] INT5 Integer 4 47 SOP_Field_Numbers_29 SOP Field Numbers[29] INT5 Integer 4 48 SOP_Field_Numbers_30 SOP Field Numbers[30] INT5 Integer 4 49 SOPNUMBE SOP Number STR20_SOP_Number String 17 50 BACHNUMB Batch Number STR15_LBAU String 15 51 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 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'].CUSTNMBR52 LOCNCODE Location Code STR10_Location_Code String 10 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'].LOCNCODE53 PONUMBER PO Number STR17_POP_Number String 17 54 ITEMNMBR Item Number STR30_Item_Number String 30 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'].ITEMNMBR55 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 17 56 UOFM U Of M U_Of_M String 8 57 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 58 UNITPRCE Unit Price DLR17_RBS0_STR$ Currency 17 59 Sales_Percentage Sales Percentage INT5_%2 Integer 5 60 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 61 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 62 Freight_Percentage Freight Percentage INT5_%2 Integer 5 63 Misc_Percentage Misc Percentage INT5_%2 Integer 5 64 Calculate_Commissions Calculate Commissions Calculate Commissions CB Boolean 0 65 Allow_Trade_Discounts Allow Trade Discounts Allow Trade Discounts CB Boolean 0 66 Ext_SOP_Reference_From Ext_SOP_Reference_From Extender SOP Reference From Integer 0 67 Ext_SOP_Comment_From Ext_SOP_Comment_From Extender SOP Comment From Integer 0 68 REFRENCE Reference STR30 String 30 69 COMMNTID Comment ID STR15_Comment_ID String 15 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'].COMMNTID70 Ext_SOP_Debtor_Name_From Ext_SOP_Debtor_Name_From Extender SOP Debtor Name From Integer 0 71 Ext_SOP_Salesperson_From Ext_SOP_Salesperson_From Extender SOP Salesperson From Integer 0 72 Ext_SOP_Sales_Territory_ Ext_SOP_Sales_Territory_From Extender SOP Sales Territory From Integer 0 73 Ext_SOPBillAddressFrom Ext_SOP_Bill_Address_From Extender SOP Address From Integer 0 74 Ext_SOPShipAddressFrom Ext_SOP_Ship_Address_From Extender SOP Address From Integer 0 75 CUSTNAME Customer Name STR64_Customer_Name String 64 76 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 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'].SLPRSNID77 SALSTERR Sales Territory STR15_Sales_Territory String 15 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'].SALSTERR78 PRBTADCD Primary Billto Address Code STR15_LBAU String 15 79 PRSTADCD Primary Shipto Address Code STR15_LBAU String 15 80 Ext_SOP_Item_Desc_From Ext_SOP_Item_Desc_From Extender SOP Item Desc From Integer 0 81 Ext_SOP_Markdown_From Ext_SOP_Markdown_From Extender SOP Markdown From Integer 0 82 Ext_SOP_Line_CommentFrom Ext_SOP_Line_Comment_From Extender SOP Comment From Integer 0 83 Ext_SOP_Line_Salesperson Ext_SOP_Line_Salesperson_From Extender SOP Line Salesperson From Integer 0 84 Ext_SOP_Line_Territory Ext_SOP_Line_Territory_From Extender SOP Line Territory From Integer 0 85 Ext_SOP_Line_Address Ext_SOP_Line_Address_From Extender SOP Line Address From Integer 0 86 Ext_SOP_Line_Site_From Ext_SOP_Line_Site_From Extender SOP Line Site From Integer 0 87 ITEMDESC Item Description STR100 String 100 88 MRKDNAMT Markdown Amount DLR17_RBS0_UTR$ Currency 17 89 MRKDNPCT Markdown Percent INT5_%2 Integer 5 90 Line_Comment_ID Line Comment ID STR15_Comment_ID String 15 91 Line_Salesperson_ID Line Salesperson ID STR15_Salesperson_ID String 15 92 Line_Sales_Territory Line Sales Territory STR15_Sales_Territory String 15 93 Line_Address_ID Line Address ID STR15_Address_Code String 15 94 Line_Site Line Site STR10_Location_Code String 10 95 Minimum_Freight_Amount Minimum Freight Amount Dollar19 Currency 19 96 Maximum_Freight_Amount Maximum Freight Amount Dollar19 Currency 19 97 Minimum_Misc_Amount Minimum Misc Amount Dollar19 Currency 19 98 Maximum_Misc_Amount Maximum Misc Amount Dollar19 Currency 19 99 NOTEINDX Note Index DLR14 Currency 14 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'].NOTEINDX100 CREATDDT Created Date DT Date 8 101 CRUSRID Created User ID STR15_User_ID String 15 102 MODIFDT Modified Date DT Date 8 103 MDFUSRID Modified User ID STR15 String 15 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'].USERID104 Ext_Date_From Ext_Date_From Extender Date From Integer 0