Receivings_HIST_LINE_File (PO30302)

azurecurveProductsWennSoft Products (131)PurchasingReceivings_HIST_LINE_File (PO30302)

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_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PURORDTYP SearchPurchase_Order_Type_DDLDDL_Purchase_Order_TypeInteger20
2RECNUM SearchReceivings_Number_STRSTR17_LBAUString1817
3RECLINSEQ SearchReceivings_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
4RLT SearchReceivings_Line_Total_DOLDLR17_RBS0_UTR$Currency1017
5PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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'].PYMTRMID
6FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
7TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
8DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
9VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
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'].DOCTYPE
10PURORDNUM SearchPurchase_Order_Number_STRSTR17_LBAUString1817
11PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
12ITMNUM SearchItem_Number_STRSTR30_Item_NumberString3230
13LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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'].LOCNCODE
14QTYREC SearchQuantity_Received_DOLDLR17_RBS0_STRCurrency1017
15QTYREJ0 SearchQuantity_Rejected_DOLDLR17_RBS0_STRCurrency1017
16QTYWO SearchQuantity_Write_Off_DOLDLR17_RBS0_STRCurrency1017
17QTYINV SearchQuantity_Invoiced_DOLDLR17_RBS0_STRCurrency1017
18REFNUM SearchReference_Number_STRSTR20String2220
19REJID SearchRejection_ID_STRSTR10_LBUString1210
20REJDESC SearchRejection_Description_STRSTR40String4240
21COMMID SearchComment_ID_STRSTR10_LBUString1210
22PURACCACCT SearchPurchase_Accruals_Account_Index_LILI_14Long Integer414
23ACCTPAYACCACCT SearchAccounts_Payable_Accrual_Account_Index_LILI_14Long Integer414
24PURACCT SearchPurchases_Account_Index_LILI_14Long Integer414
25Cost_Element SearchCost ElementINT3_RB0_UInteger23
26MISC1 SearchMisc_1_CBCBBoolean20
27COMMNTID SearchComment IDSTR15_Comment_IDString1615
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'].COMMNTID
28NONINVEN SearchNon IVINT1Integer21
29CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
30PCBJOBNUMBER SearchPCB_Job_Number_STRSTR10String1210
31PCBTASKNUM SearchPCB_Task_Number_STRSTR10_JobString1210
32PCBPNUM SearchPCB_Phase_Number_STRSTR10_JobString1210
33PCB_Cost_ClassDDL SearchPCB_Cost_Classification_DDLPCB_Cost_Classification_DDLInteger20
34SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
35POFCAMOUNT SearchPO_FC_Amount_DOLDLR19_RBS0_STR$Currency1019
36POEXCHANERATE SearchPO_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
37CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
38LCSCHEDULE SearchLC_Schedule_ID_STRLC_STR15_LBUString1615
39LCACTVALUE SearchLC_Actual_Value_DOLDLR17_RBS0_STR$Currency1017
40LCLNSEQNBR SearchLC_Line_SEQ_NumberSequence_NumberCurrency1019
41RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
42WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
43Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
44Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
45Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
46Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
47PO_FC_Actual_Unit_Cost_D SearchPO_FC_Actual_Unit_Cost_DOLPO_Unit_Cost_VCCurrency (Variable)1223
48FCFreight SearchPO_FC_Freight_Amount_DOLDLR19_RBS0_STR$Currency1019
49fctax SearchPO_FC_Tax_Amount_DOLDLR19_RBS0_STR$Currency1019
50PO_FC_Retainage_Amount SearchPO_FC_Retainage_Amount_DOLDLR19_RBS0_STR$Currency1019
51PCB_Job_Line_Sequence SearchPCB_Job_Line_Sequence_DOLSequence_NumberCurrency1019
52INTLRSVBOOL1 SearchINTL_RSV_BOOL_1BooleanBoolean20
53INTLRSVBOOL2 SearchINTL_RSV_BOOL_2BooleanBoolean20
54INTLRSVDATE1 SearchINTL_RSV_DATE_1DATEDate46
55INTLRSVDATE2 SearchINTL_RSV_DATE_2DATEDate46
56INTLRSVDOL141 SearchINTL_RSV_DOL14_1DLR14Currency1014
57INTLRSVDOL142 SearchINTL_RSV_DOL14_2DLR14Currency1014
58INTLRSVINT61 SearchINTL_RSV_INT6_1LI6_S2Long Integer46
59INTLRSVINT62 SearchINTL_RSV_INT6_2LI6_S2Long Integer46
60INTLRSVSTR301 SearchINTL_RSV_STR30_1STR30String3230
61INTLRSVSTR302 SearchINTL_RSV_STR30_2STR30String3230
azurecurveProductsWennSoft Products (131)PurchasingReceivings_HIST_LINE_File (PO30302)

Leave a Reply

Your email address will not be published. Required fields are marked *