Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO20301
Product: WennSoft Products (131)
Series: Purchasing
Display Name: Receivings_OPEN_HDR_File
Physical Name: PO20301
Technical Name: Receivings_OPEN_HDR_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCAMNT 
Document Amount DLR19_RBSO_UTR$ Currency 19 2 Receivings_Type_DDL Receivings_Type_DDL Receivings_Type_DDL Integer 0 3 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 4 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 5 RECNUM Receivings_Number_STR STR17_LBAU String 17 6 BACHNUMB Batch Number STR15_LBAU String 15 7 BCHSOURC Batch Source STR15 String 15 8 RECLINSEQ Receivings_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 9 VNDID Vendor_ID_STR STR15_Vendor_ID String 15 10 RECBY Received_By_STR STR15_LBU String 15 11 AMTMATCH Amount_Matched_DOL DLR17_RBS0_STR$ Currency 17 12 GRNDATE Receivings_Date_DATE DATE Date 6 13 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Receivings_OPEN_HDR_File'].NOTEINDX AS 'Receivings_OPEN_HDR_File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PO20301 AS ['Receivings_OPEN_HDR_File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Receivings_OPEN_HDR_File'].NOTEINDX = ['Record Notes Master'].NOTEINDX14 LCACTTOTAL LC_Actual_Total_DOL DLR17_RBS0_STR$ Currency 17 15 Expense_Claim_CB Expense_Claim_CB CB Boolean 0 16 Approved_By_STR Approved_By_STR STR15_User_ID String 15 17 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Receivings_OPEN_HDR_File'].CURNCYID AS 'Receivings_OPEN_HDR_File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PO20301 AS ['Receivings_OPEN_HDR_File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Receivings_OPEN_HDR_File'].CURNCYID = ['Currency Setup'].CURNCYID18 POEXCHANERATE PO_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 19 POFCAMOUNT PO_FC_Amount_DOL DLR19_RBS0_STR$ Currency 19 20 FCFreight PO_FC_Freight_Amount_DOL DLR19_RBS0_STR$ Currency 19 21 fctax PO_FC_Tax_Amount_DOL DLR19_RBS0_STR$ Currency 19 22 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['Receivings_OPEN_HDR_File'].EXGTBLID AS 'Receivings_OPEN_HDR_File-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PO20301 AS ['Receivings_OPEN_HDR_File']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Receivings_OPEN_HDR_File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID23 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['Receivings_OPEN_HDR_File'].RATETPID AS 'Receivings_OPEN_HDR_File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PO20301 AS ['Receivings_OPEN_HDR_File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Receivings_OPEN_HDR_File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID24 EXCHDATE Exchange Date DT_Date Date 6 25 TIME1 Time TM6 Time 6