PA Report Purchasing Receipt History (POP30300)

azurecurveProductsProject Accounting (258)PurchasingPA Report Purchasing 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: PA_POP_Report_ReceiptHist

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
2POPTYPE SearchPOP TypeDDL_POP_TypeInteger20
3VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString2220
4receiptdate SearchReceipt DateDTDate48
5GLPOSTDT SearchGL Posting DateDTDate48
6ACTLSHIP SearchActual Ship DateDTDate48
7BCHSOURC SearchBatch SourceSTR15String1615
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 NumberSTR15_LBAUString1615
9VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 NameSTR64_Vendor_NameString6664
11SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
12TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
13TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)1223
14FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
15MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
16TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
17TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
18PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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 AmountINT5_%2Integer25
20DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
21DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency1017
22DISCDATE SearchDiscount DateDTDate48
23DUEDATE SearchDue DateDTDate48
24REFRENCE SearchReferenceSTR30String3230
25VOIDSTTS SearchVoid StatusINTInteger20
26RCPTNOTE SearchReceipt Note ID ArrayDLR14Currency1014
27RCPTNOTE_1 SearchReceipt Note ID Array[1]DLR14Currency1014
28RCPTNOTE_2 SearchReceipt Note ID Array[2]DLR14Currency1014
29RCPTNOTE_3 SearchReceipt Note ID Array[3]DLR14Currency1014
30RCPTNOTE_4 SearchReceipt Note ID Array[4]DLR14Currency1014
31RCPTNOTE_5 SearchReceipt Note ID Array[5]DLR14Currency1014
32RCPTNOTE_6 SearchReceipt Note ID Array[6]DLR14Currency1014
33RCPTNOTE_7 SearchReceipt Note ID Array[7]DLR14Currency1014
34RCPTNOTE_8 SearchReceipt Note ID Array[8]DLR14Currency1014
35POPHDR1 SearchPOP HDR Errors 1ML_POP_HDR_Errors_1Long Integer40
36POPHDR2 SearchPOP HDR Errors 2ML_POP_HDR_Errors_2Long Integer40
37POPLNERR SearchPOP LINE ErrorsML_POP_LINE_ErrorsLong Integer40
38POSTEDDT SearchPosted DateDATEDate46
39PTDUSRID SearchPosted User IDSTR15String1615
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 EnterSTR15_User_IDString1615
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 DateDTDate48
42MODIFDT SearchModified DateDTDate48
43TRXSORCE SearchTRX SourceSTR13String1413
44VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
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 DateDTDate48
46CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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 IDSTR15_Rate_Type_IDString1615
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 IDSTR15_Exchange_Table_IDString1615
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 RateDLR14_Exchange_RateCurrency (Variable)1014
51EXCHDATE SearchExchange DateDT_DateDate46
52TIME1 SearchTimeTM6Time46
53RATECALC SearchRate Calc MethodINTInteger20
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 RateDLR14_Exchange_RateCurrency (Variable)1014
55MCTRXSTT SearchMC Transaction StateINT1Integer21
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 SubtotalDLR17_RBS0_STR$Currency1017
57ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
58ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
59ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency1019
60ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
61OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency1017
62ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
63ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency1017
64SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
65WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency1019
66ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
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 NumberSTR25String2625
68TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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 TotalYNBoolean20
70Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger20
71Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger20
72FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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 IDSTR15_LBAUString1615
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 AmountDLR19_RBSO_UTR$Currency1019
75ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
76MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
77ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
78BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
79OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
80TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
81BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
82OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
83BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
84OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
85TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
86APLYWITH SearchApply WithholdingBooleanBoolean20
87PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
88SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 AmountDLR17_RBS0_UTR$Currency1017
90CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
91VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
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 EntryLI8_U0Long Integer48
93REVALTRXSOURCE SearchRevaluation TRX SourceSTR13String1413
94TEN99TYPE Search1099 Type1099_TypeInteger20
95TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger20
96REPLACEGOODS SearchReplace Returned GoodsCB_ReplaceReturnedGoodsBoolean20
97INVOICEEXPECTED SearchInvoice Expected ReturnsCB_InvoiceExpectedReturnsBoolean20
98PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency1019
99OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency1019
100POP_HDR_Errors_4 SearchPOP HDR Errors 4ML_POP_HDR_Errors_4Long Integer40
101DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
102ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
103DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
104ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
105InvoiceReceiptDate SearchInvoice Receipt DateDTDate48
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 StatusWorkflow StatusInteger20
107DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsProject Accounting (258)PurchasingPA Report Purchasing Receipt History (POP30300)

Leave a Reply

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