Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT43500
Product: Extender (3107)
Series: Project
Display Name: Extender POP
Physical Name: EXT43500
Technical Name: PT_Extender_POPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_POP_ID 
Extender POP ID STR15_LBAU String 15 2 Extender_POP_Description Extender POP Description STR64 String 64 3 Extender_Type Extender Type INT5 Integer 4 4 Extender_Form_ID Extender Form ID STR15_LBAU String 15 5 Ext_POP_PO_Number_From Ext_POP_PO_Number_From Extender POP PO Number From Integer 0 6 Ext_POP_Creditor_From Ext_POP_Creditor_From Extender POP Creditor From Integer 0 7 Ext_POP_Buyer_From Ext_POP_Buyer_From Extender POP Buyer From Integer 0 8 Ext_POP_Item_From Ext_POP_Item_From Extender POP Item From Integer 0 9 Ext_POP_UofM_From Ext_POP_UofM_From Extender POP UofM From Integer 0 10 Ext_POP_Quantity_From Ext_POP_Quantity_From Extender POP Quantity From Integer 0 11 Ext_POP_Unit_Cost Ext_POP_Unit_Cost_From Extender POP Unit Cost From Integer 0 12 Ext_POP_Site_From Ext_POP_Site_From Extender POP Site From Integer 0 13 Ext_POP_Freight_From Ext_POP_Freight_From Extender POP Freight From Integer 0 14 Ext_POP_Misc_From Ext_POP_Misc_From Extender POP Misc From Integer 0 15 Ext_POP_Creditor_Name Ext_POP_Creditor_Name_From Extender POP Creditor Name From Integer 0 16 Ext_POP_Purchase_Address Ext_POP_Purchase_Address_From Extender POP Purchase Address From Integer 0 17 Ext_POP_Bill_Address Ext_POP_Bill_Address_From Extender POP Company Address From Integer 0 18 Ext_POP_Ship_Address Ext_POP_Ship_Address_From Extender POP Company Address From Integer 0 19 Ext_POP_Shipping_Method Ext_POP_Shipping_Method_From Extender POP Shipping Method From Integer 0 20 Ext_POP_Item_Description Ext_POP_Item_Description_From Extender POP Item Description From Integer 0 21 Ext_POP_Requested_From Ext_POP_Requested_From Extender POP Requested From Integer 0 22 Ext_POP_Comment_From Ext_POP_Comment_From Extender POP Comment From Integer 0 23 Minimum_Freight_Amount Minimum Freight Amount Dollar19 Currency 19 24 Minimum_Misc_Amount Minimum Misc Amount Dollar19 Currency 19 25 Maximum_Freight_Amount Maximum Freight Amount Dollar19 Currency 19 26 Maximum_Misc_Amount Maximum Misc Amount Dollar19 Currency 19 27 PONUMBER PO Number STR17_POP_Number String 17 28 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Extender POP'].VENDORID AS 'Extender POP-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Extender POP'].VENDORID = ['PM Vendor Master File'].VENDORID29 BUYERID Buyer ID STR15_User_ID String 15 30 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Extender POP'].ITEMNMBR AS 'Extender POP-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Extender POP'].ITEMNMBR = ['Item Master'].ITEMNMBR31 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 17 32 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 33 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Extender POP'].LOCNCODE AS 'Extender POP-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Extender POP'].LOCNCODE = ['Site Setup'].LOCNCODE34 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 35 Freight_Percentage Freight Percentage INT5_%2 Integer 5 36 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 37 Misc_Percentage Misc Percentage INT5_%2 Integer 5 38 VENDNAME Vendor Name STR64_Vendor_Name String 64 39 VADCDPAD Vendor Address Code - Purchase Address STR15_Address_Code String 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['Extender POP'].VADCDPAD AS 'Extender POP-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['Extender POP'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['Extender POP'].VENDORID = ['PM Address MSTR'].VENDORID40 Extender_POP_Bill_Addres Extender POP Bill Address STR15_Location_ID String 15 41 Extender_POP_Ship_Addres Extender POP Ship Address STR15_Location_ID String 15 42 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['Extender POP'].SHIPMTHD AS 'Extender POP-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Extender POP'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD43 ITEMDESC Item Description STR100 String 100 44 REQSTDBY Requested By STR20_LB String 20 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender POP'].REQSTDBY AS 'Extender POP-Requested By'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender POP'].REQSTDBY = ['Users Master'].USERID45 COMMNTID Comment ID STR15_Comment_ID String 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['Extender POP'].COMMNTID AS 'Extender POP-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Extender POP'].COMMNTID = ['Comment Master'].COMMNTID46 POP_Field_Numbers_1 POP Field Numbers[1] INT5 Integer 4 47 POP_Field_Numbers_2 POP Field Numbers[2] INT5 Integer 4 48 POP_Field_Numbers_3 POP Field Numbers[3] INT5 Integer 4 49 POP_Field_Numbers_4 POP Field Numbers[4] INT5 Integer 4 50 POP_Field_Numbers_5 POP Field Numbers[5] INT5 Integer 4 51 POP_Field_Numbers_6 POP Field Numbers[6] INT5 Integer 4 52 POP_Field_Numbers_7 POP Field Numbers[7] INT5 Integer 4 53 POP_Field_Numbers_8 POP Field Numbers[8] INT5 Integer 4 54 POP_Field_Numbers_9 POP Field Numbers[9] INT5 Integer 4 55 POP_Field_Numbers_10 POP Field Numbers[10] INT5 Integer 4 56 POP_Field_Numbers_11 POP Field Numbers[11] INT5 Integer 4 57 POP_Field_Numbers_12 POP Field Numbers[12] INT5 Integer 4 58 POP_Field_Numbers_13 POP Field Numbers[13] INT5 Integer 4 59 POP_Field_Numbers_14 POP Field Numbers[14] INT5 Integer 4 60 POP_Field_Numbers_15 POP Field Numbers[15] INT5 Integer 4 61 POP_Field_Numbers_16 POP Field Numbers[16] INT5 Integer 4 62 POP_Field_Numbers_17 POP Field Numbers[17] INT5 Integer 4 63 POP_Field_Numbers_18 POP Field Numbers[18] INT5 Integer 4 64 POP_Field_Numbers_19 POP Field Numbers[19] INT5 Integer 4 65 POP_Field_Numbers_20 POP Field Numbers[20] INT5 Integer 4 66 POP_Field_Numbers_21 POP Field Numbers[21] INT5 Integer 4 67 POP_Field_Numbers_22 POP Field Numbers[22] INT5 Integer 4 68 POP_Field_Numbers_23 POP Field Numbers[23] INT5 Integer 4 69 POP_Field_Numbers_24 POP Field Numbers[24] INT5 Integer 4 70 POP_Field_Numbers_25 POP Field Numbers[25] INT5 Integer 4 71 POP_Field_Numbers_26 POP Field Numbers[26] INT5 Integer 4 72 POP_Field_Numbers_27 POP Field Numbers[27] INT5 Integer 4 73 POP_Field_Numbers_28 POP Field Numbers[28] INT5 Integer 4 74 POP_Field_Numbers_29 POP Field Numbers[29] INT5 Integer 4 75 POP_Field_Numbers_30 POP Field Numbers[30] INT5 Integer 4 76 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Extender POP'].NOTEINDX AS 'Extender POP-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extender POP'].NOTEINDX = ['Record Notes Master'].NOTEINDX77 MODIFDT Modified Date DT Date 8 78 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender POP'].MDFUSRID AS 'Extender POP-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT43500 AS ['Extender POP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender POP'].MDFUSRID = ['Users Master'].USERID79 CREATDDT Created Date DT Date 8 80 CRUSRID Created User ID STR15_User_ID String 15 81 Ext_Date_From Ext_Date_From Extender Date From Integer 0