Purchasing Receipt History (POP30300)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Receipt History (POP30300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP30300

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt History
Physical Name: POP30300
Technical Name: POP_ReceiptHist

Group Display Name: Purchasing History
Group Technical Name: Purchasing History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
2POPTYPE SearchPOP TypeIntegerDDL_POP_Type0
3VNDDOCNM SearchVendor Document NumberStringSTR20_Document_Number20
4receiptdate SearchReceipt DateDateDT8
5GLPOSTDT SearchGL Posting DateDateDT8
6ACTLSHIP SearchActual Ship DateDateDT8
7BCHSOURC SearchBatch SourceStringSTR1515
Records whether the transaction was entered in a batch or not.

Click to show/hide the Batch Sources

PM_Trxent	Batch
XXPM_Trxent	No batch (real-time)
8BACHNUMB SearchBatch NumberStringSTR15_LBAU15
9VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].VENDORID AS 'Purchasing Receipt History-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Purchasing Receipt History'].VENDORID = ['PM Vendor Master File'].VENDORID
10VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
11SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
12TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
13TRDPCTPR SearchTrade Discount Percent (Precise)Currency (Variable)Trade Discount Percent (Precise)23
14FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
15MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
16TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
17TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
18PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].PYMTRMID AS 'Purchasing Receipt History-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Purchasing Receipt History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
19DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
20DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
21DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
22DISCDATE SearchDiscount DateDateDT8
23DUEDATE SearchDue DateDateDT8
24REFRENCE SearchReferenceStringSTR3030
25VOIDSTTS SearchVoid StatusIntegerINT0
26RCPTNOTE_1 SearchReceipt Note ID Array[1]CurrencyDLR1414
27RCPTNOTE SearchReceipt Note ID ArrayDLR14Currency14
28RCPTNOTE_2 SearchReceipt Note ID Array[2]CurrencyDLR1414
29RCPTNOTE_3 SearchReceipt Note ID Array[3]CurrencyDLR1414
30RCPTNOTE_4 SearchReceipt Note ID Array[4]CurrencyDLR1414
31RCPTNOTE_5 SearchReceipt Note ID Array[5]CurrencyDLR1414
32RCPTNOTE_6 SearchReceipt Note ID Array[6]CurrencyDLR1414
33RCPTNOTE_7 SearchReceipt Note ID Array[7]CurrencyDLR1414
34RCPTNOTE_8 SearchReceipt Note ID Array[8]CurrencyDLR1414
35POPHDR1 SearchPOP HDR Errors 1Long IntegerML_POP_HDR_Errors_10
36POPHDR2 SearchPOP HDR Errors 2Long IntegerML_POP_HDR_Errors_20
37POPLNERR SearchPOP LINE ErrorsLong IntegerML_POP_LINE_Errors0
38POSTEDDT SearchPosted DateDateDATE6
39PTDUSRID SearchPosted User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].PTDUSRID AS 'Purchasing Receipt History-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Receipt History'].PTDUSRID = ['Users Master'].USERID
40USER2ENT SearchUser To EnterStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].USER2ENT AS 'Purchasing Receipt History-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Receipt History'].USER2ENT = ['Users Master'].USERID
41CREATDDT SearchCreated DateDateDT8
42MODIFDT SearchModified DateDateDT8
43TRXSORCE SearchTRX SourceStringSTR1313
44VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].VCHRNMBR AS 'Purchasing Receipt History-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['Purchasing Receipt History'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['Purchasing Receipt History'].DOCTYPE = ['PM Key Master File'].DOCTYPE
45Tax_Date SearchTax DateDateDT8
46CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].CURNCYID AS 'Purchasing Receipt History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Receipt History'].CURNCYID = ['Currency Setup'].CURNCYID
47CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].CURRNIDX AS 'Purchasing Receipt History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Receipt History'].CURRNIDX = ['Currency Setup'].CURRNIDX
48RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].RATETPID AS 'Purchasing Receipt History-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Purchasing Receipt History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
49EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].EXGTBLID AS 'Purchasing Receipt History-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Purchasing Receipt History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
50XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
51EXCHDATE SearchExchange DateDateDT_Date6
52TIME1 SearchTimeTimeTM66
53RATECALC SearchRate Calc MethodIntegerINT0
Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank.

Click to show/hide Rate Calc Methods

0	Multiply
1	Divide
54DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
55MCTRXSTT SearchMC Transaction StateIntegerINT11
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.
56ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
57ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
58ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
59ORMISCAMT SearchOriginating Misc AmountCurrencyDLR19_RBSO_UTR$19
60ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
61OR1099AM SearchOriginating 1099 AmountCurrencyDLR17_RBS0_UTR$17
62ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
63ORDAVAMT SearchOriginating Discount Available AmountCurrencyDLR17_RBS0_UTR$17
64SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
65WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
66ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
67TXRGNNUM SearchTax Registration NumberStringSTR2525
68TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].TAXSCHID AS 'Purchasing Receipt History-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchasing Receipt History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
69BSIVCTTL SearchBased On Invoice TotalBooleanYN0
70Purchase_Freight_Taxable SearchPurchase Freight TaxableIntegerDDL_Purchase_Tax_Options0
71Purchase_Misc_Taxable SearchPurchase Misc TaxableIntegerDDL_Purchase_Tax_Options0
72FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].FRTSCHID AS 'Purchasing Receipt History-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchasing Receipt History'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].MSCSCHID AS 'Purchasing Receipt History-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchasing Receipt History'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
74FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
75ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
76MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
77ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
78BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
79OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
80TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
81BackoutFreightTaxAmt SearchBackout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
82OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
83BackoutMiscTaxAmt SearchBackout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
84OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
85TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
86APLYWITH SearchApply WithholdingBooleanBoolean0
87PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
88SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].SHIPMTHD AS 'Purchasing Receipt History-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Purchasing Receipt History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
89Total_Landed_Cost_Amount SearchTotal Landed Cost AmountCurrencyDLR17_RBS0_UTR$17
90CBVAT SearchCash Based VATBooleanCB_CashBasedVAT0
91VADCDTRO SearchVendor Address Code - Remit ToStringSTR15_Address_Code15
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Purchasing Receipt History'].VADCDTRO AS 'Purchasing Receipt History-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       POP30300 AS ['Purchasing Receipt History']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Purchasing Receipt History'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Purchasing Receipt History'].VENDORID = ['PM Address MSTR'].VENDORID
92REVALJRNENTRY SearchRevaluation Journal EntryLong IntegerLI8_U08
93REVALTRXSOURCE SearchRevaluation TRX SourceStringSTR1313
94TEN99TYPE Search1099 TypeInteger1099_Type0
95TEN99BOXNUMBER Search1099 Box NumberIntegerDDL_1099_Box0
96REPLACEGOODS SearchReplace Returned GoodsBooleanCB_ReplaceReturnedGoods0
97INVOICEEXPECTED SearchInvoice Expected ReturnsBooleanCB_InvoiceExpectedReturns0
98PrepaymentAmount SearchPrepayment AmountCurrencyDLR19_RBS0_UTR$19
99OriginatingPrepaymentAmt SearchOriginating Prepayment AmountCurrencyDLR19_RBS0_UTR$19
100POP_HDR_Errors_4 SearchPOP HDR Errors 4Long IntegerML_POP_HDR_Errors_40
101DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
102ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
103DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
104ORDATKN SearchOriginating Discount Available TakenCurrencyDLR17_RBS0_UTR$17
105InvoiceReceiptDate SearchInvoice Receipt DateDateDT8
Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
106Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Receipt History (POP30300)

Leave a Reply

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