Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO20201
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_OPEN_HDR_File
Physical Name: PO20201
Technical Name: PO_OPEN_HDR_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PURORDNUM 
Purchase_Order_Number_STR STR17_LBAU String 17 2 PONUMWRK Purchase_Order_Number_WORK_STR STR20_LBAU String 20 3 BACHNUMB Batch Number STR15_LBAU String 15 4 BCHSOURC Batch Source STR15 String 15 5 PURORDLINSEQ Purchase_Order_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 6 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 7 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 8 DTECHG Date_Changed DATE Date 6 9 POTMP PO_Temp STR1 String 1 10 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 11 VNDID Vendor_ID_STR STR15_Vendor_ID String 15 12 PAYMNTTRMID Payment_Terms_ID_STR STR20_Payment_Terms_ID String 20 13 SHPTOID Shipment_To_ID_STR STR20_LBAU String 20 14 SHIPMTHID Shipping_Method_ID_STR STR20_LBAU String 20 15 DELTOID Delivery_To_ID_STR STR20_LBAU String 20 16 ORDBY Ordered_By_STR STR15_LBU String 15 17 PURORDDAT Purchase_Order_Date_DATE DATE Date 6 18 PURORDTYP Purchase_Order_Type_DDL DDL_Purchase_Order_Type Integer 0 19 SLSTAXEXEMPSTAT Sales_Tax_Exemption_Status_CB CB_Sales_Tax_Exemption_Status Boolean 0 20 COMMID Comment_ID_STR STR10_LBU String 10 21 CONFIRMSTAT Confirmation_Status_CB CB_Confirmation_Status Boolean 0 22 ACKNOWSTAT Acknowledgement_Status_CB CB_Acknowledgement_Status Boolean 0 23 SUPPRICSTAT Suppress_Prices_Status_CB CB_Suppress_Price_Print Boolean 0 24 USRDEFFLD1 User_Defined_Field_1_STR STR15 String 15 25 USRDEFFLD2 User_Defined_Field_2_STR STR15 String 15 26 USRDEFFLD3 User_Defined_Field_3_STR STR15 String 15 27 USRDEFFLD4 User_Defined_Field_4_STR STR15 String 15 28 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PO_OPEN_HDR_File'].NOTEINDX AS 'PO_OPEN_HDR_File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PO_OPEN_HDR_File'].NOTEINDX = ['Record Notes Master'].NOTEINDX29 VADCDTRO Vendor Address Code - Remit To STR15_Address_Code String 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['PO_OPEN_HDR_File'].VADCDTRO AS 'PO_OPEN_HDR_File-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['PO_OPEN_HDR_File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['PO_OPEN_HDR_File'].VENDORID = ['PM Address MSTR'].VENDORID30 REQNUMWRK Requisition_Number_WORK_STR STR20_LBAU_REQ String 20 31 POFCAMOUNT PO_FC_Amount_DOL DLR19_RBS0_STR$ Currency 19 32 POEXCHANERATE PO_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 33 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PO_OPEN_HDR_File'].CURNCYID AS 'PO_OPEN_HDR_File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PO_OPEN_HDR_File'].CURNCYID = ['Currency Setup'].CURNCYID34 POREVISEDFREIGHT PO_Revised_Freight_Amount_DOL DLR19_RBSO_STR$ Currency 19 35 POREVTAX PO_Revised_Tax_Amount_DOL DLR19_RBSO_STR$ Currency 19 36 POREVEXPTOTAL PO_Revised_Expected_Total DLR19_RBSO_STR$ Currency 19 37 LCEXPTOTAL LC_Expected_Total_DOL DLR17_RBS0_STR$ Currency 17 38 APPROVL Approval CB_Approval Boolean 0 39 APRVLUSERID Approval User ID STR15_User_ID String 15 40 APPRVLDT Approval Date DATE Date 6 41 Approval_Time Approval Time TM6 Time 6 42 FCFreight PO_FC_Freight_Amount_DOL DLR19_RBS0_STR$ Currency 19 43 fctax PO_FC_Tax_Amount_DOL DLR19_RBS0_STR$ Currency 19 44 PO_FC_Revised_Amount_DOL PO_FC_Revised_Amount_DOL DLR19_RBSO_STR$ Currency 19 45 PO_FC_Revised_Expected PO_FC_Revised_Expected_Unit_Cost_DOL PO_Unit_Cost_VC Currency (Variable) 23 46 PO_FC_Revised_Freight_Am PO_FC_Revised_Freight_Amount_DOL DLR19_RBSO_STR$ Currency 19 47 PO_FC_Revised_Tax_Amount PO_FC_Revised_Tax_Amount_DOL DLR19_RBSO_STR$ Currency 19 48 EXCHDATE Exchange Date DT_Date Date 6 49 TIME1 Time TM6 Time 6 50 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['PO_OPEN_HDR_File'].RATETPID AS 'PO_OPEN_HDR_File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PO_OPEN_HDR_File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID51 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['PO_OPEN_HDR_File'].EXGTBLID AS 'PO_OPEN_HDR_File-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PO20201 AS ['PO_OPEN_HDR_File']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PO_OPEN_HDR_File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID