Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO30302
Product: WennSoft Products (131)
Series: Purchasing
Display Name: Receivings_HIST_LINE_File
Physical Name: PO30302
Technical Name: Receivings_HIST_LINE_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PURORDTYP 
Purchase_Order_Type_DDL DDL_Purchase_Order_Type Integer 0 2 RECNUM Receivings_Number_STR STR17_LBAU String 17 3 RECLINSEQ Receivings_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 4 RLT Receivings_Line_Total_DOL DLR17_RBS0_UTR$ Currency 17 5 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['Receivings_HIST_LINE_File'].PYMTRMID AS 'Receivings_HIST_LINE_File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PO30302 AS ['Receivings_HIST_LINE_File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['Receivings_HIST_LINE_File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID6 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 7 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 8 DOCNUMBR Document Number STR20_Document_Number String 20 9 VCHRNMBR Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['Receivings_HIST_LINE_File'].VCHRNMBR AS 'Receivings_HIST_LINE_File-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
PO30302 AS ['Receivings_HIST_LINE_File']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['Receivings_HIST_LINE_File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['Receivings_HIST_LINE_File'].DOCTYPE = ['PM Key Master File'].DOCTYPE10 PURORDNUM Purchase_Order_Number_STR STR17_LBAU String 17 11 PURORDLINSEQ Purchase_Order_Line_Sequence_DOL DLR17_RBS0_STR Currency 17 12 ITMNUM Item_Number_STR STR30_Item_Number String 30 13 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Receivings_HIST_LINE_File'].LOCNCODE AS 'Receivings_HIST_LINE_File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PO30302 AS ['Receivings_HIST_LINE_File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Receivings_HIST_LINE_File'].LOCNCODE = ['Site Setup'].LOCNCODE14 QTYREC Quantity_Received_DOL DLR17_RBS0_STR Currency 17 15 QTYREJ0 Quantity_Rejected_DOL DLR17_RBS0_STR Currency 17 16 QTYWO Quantity_Write_Off_DOL DLR17_RBS0_STR Currency 17 17 QTYINV Quantity_Invoiced_DOL DLR17_RBS0_STR Currency 17 18 REFNUM Reference_Number_STR STR20 String 20 19 REJID Rejection_ID_STR STR10_LBU String 10 20 REJDESC Rejection_Description_STR STR40 String 40 21 COMMID Comment_ID_STR STR10_LBU String 10 22 PURACCACCT Purchase_Accruals_Account_Index_LI LI_14 Long Integer 14 23 ACCTPAYACCACCT Accounts_Payable_Accrual_Account_Index_LI LI_14 Long Integer 14 24 PURACCT Purchases_Account_Index_LI LI_14 Long Integer 14 25 Cost_Element Cost Element INT3_RB0_U Integer 3 26 MISC1 Misc_1_CB CB Boolean 0 27 COMMNTID Comment ID STR15_Comment_ID String 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['Receivings_HIST_LINE_File'].COMMNTID AS 'Receivings_HIST_LINE_File-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
PO30302 AS ['Receivings_HIST_LINE_File']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Receivings_HIST_LINE_File'].COMMNTID = ['Comment Master'].COMMNTID28 NONINVEN Non IV INT1 Integer 1 29 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Receivings_HIST_LINE_File'].CUSTNMBR AS 'Receivings_HIST_LINE_File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PO30302 AS ['Receivings_HIST_LINE_File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Receivings_HIST_LINE_File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR30 PCBJOBNUMBER PCB_Job_Number_STR STR10 String 10 31 PCBTASKNUM PCB_Task_Number_STR STR10_Job String 10 32 PCBPNUM PCB_Phase_Number_STR STR10_Job String 10 33 PCB_Cost_ClassDDL PCB_Cost_Classification_DDL PCB_Cost_Classification_DDL Integer 0 34 SOPNUMBE SOP Number STR20_SOP_Number String 17 35 POFCAMOUNT PO_FC_Amount_DOL DLR19_RBS0_STR$ Currency 19 36 POEXCHANERATE PO_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 37 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Receivings_HIST_LINE_File'].CURNCYID AS 'Receivings_HIST_LINE_File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PO30302 AS ['Receivings_HIST_LINE_File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Receivings_HIST_LINE_File'].CURNCYID = ['Currency Setup'].CURNCYID38 LCSCHEDULE LC_Schedule_ID_STR LC_STR15_LBU String 15 39 LCACTVALUE LC_Actual_Value_DOL DLR17_RBS0_STR$ Currency 17 40 LCLNSEQNBR LC_Line_SEQ_Number Sequence_Number Currency 19 41 RETNAGAM Retainage Amount DLR17_RBS0_UTR$ Currency 17 42 WS_Job_Number WS Job Number STR17_LBAU String 17 43 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 44 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 45 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 46 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 47 PO_FC_Actual_Unit_Cost_D PO_FC_Actual_Unit_Cost_DOL PO_Unit_Cost_VC Currency (Variable) 23 48 FCFreight PO_FC_Freight_Amount_DOL DLR19_RBS0_STR$ Currency 19 49 fctax PO_FC_Tax_Amount_DOL DLR19_RBS0_STR$ Currency 19 50 PO_FC_Retainage_Amount PO_FC_Retainage_Amount_DOL DLR19_RBS0_STR$ Currency 19 51 PCB_Job_Line_Sequence PCB_Job_Line_Sequence_DOL Sequence_Number Currency 19 52 INTLRSVBOOL1 INTL_RSV_BOOL_1 Boolean Boolean 0 53 INTLRSVBOOL2 INTL_RSV_BOOL_2 Boolean Boolean 0 54 INTLRSVDATE1 INTL_RSV_DATE_1 DATE Date 6 55 INTLRSVDATE2 INTL_RSV_DATE_2 DATE Date 6 56 INTLRSVDOL141 INTL_RSV_DOL14_1 DLR14 Currency 14 57 INTLRSVDOL142 INTL_RSV_DOL14_2 DLR14 Currency 14 58 INTLRSVINT61 INTL_RSV_INT6_1 LI6_S2 Long Integer 6 59 INTLRSVINT62 INTL_RSV_INT6_2 LI6_S2 Long Integer 6 60 INTLRSVSTR301 INTL_RSV_STR30_1 STR30 String 30 61 INTLRSVSTR302 INTL_RSV_STR30_2 STR30 String 30