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 TypeLength
1POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString17
2POPTYPE SearchPOP TypeDDL_POP_TypeInteger0
3VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString20
4receiptdate SearchReceipt DateDTDate8
5GLPOSTDT SearchGL Posting DateDTDate8
6ACTLSHIP SearchActual Ship DateDTDate8
7BCHSOURC SearchBatch SourceSTR15String15
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_LBAUString15
9VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_NameString64
11SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
12TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
13TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)23
14FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
15MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
16TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
17TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency17
18PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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_%2Integer5
20DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
21DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
22DISCDATE SearchDiscount DateDTDate8
23DUEDATE SearchDue DateDTDate8
24REFRENCE SearchReferenceSTR30String30
25VOIDSTTS SearchVoid StatusINTInteger0
26RCPTNOTE SearchReceipt Note ID ArrayDLR14Currency14
27RCPTNOTE_1 SearchReceipt Note ID Array[1]DLR14Currency14
28RCPTNOTE_2 SearchReceipt Note ID Array[2]DLR14Currency14
29RCPTNOTE_3 SearchReceipt Note ID Array[3]DLR14Currency14
30RCPTNOTE_4 SearchReceipt Note ID Array[4]DLR14Currency14
31RCPTNOTE_5 SearchReceipt Note ID Array[5]DLR14Currency14
32RCPTNOTE_6 SearchReceipt Note ID Array[6]DLR14Currency14
33RCPTNOTE_7 SearchReceipt Note ID Array[7]DLR14Currency14
34RCPTNOTE_8 SearchReceipt Note ID Array[8]DLR14Currency14
35POPHDR1 SearchPOP HDR Errors 1ML_POP_HDR_Errors_1Long Integer0
36POPHDR2 SearchPOP HDR Errors 2ML_POP_HDR_Errors_2Long Integer0
37POPLNERR SearchPOP LINE ErrorsML_POP_LINE_ErrorsLong Integer0
38POSTEDDT SearchPosted DateDATEDate6
39PTDUSRID SearchPosted User IDSTR15String15
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_IDString15
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 DateDTDate8
42MODIFDT SearchModified DateDTDate8
43TRXSORCE SearchTRX SourceSTR13String13
44VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
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 DateDTDate8
46CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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_IDString15
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_IDString15
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)14
51EXCHDATE SearchExchange DateDT_DateDate6
52TIME1 SearchTimeTM6Time6
53RATECALC SearchRate Calc MethodINTInteger0
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)14
55MCTRXSTT SearchMC Transaction StateINT1Integer1
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$Currency17
57ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
58ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
59ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
60ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
61OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency17
62ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
63ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
64SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
65WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
66ECTRX SearchEC TransactionCB_EC_TransactionBoolean0
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 NumberSTR25String25
68TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 TotalYNBoolean0
70Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger0
71Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger0
72FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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_LBAUString15
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$Currency19
75ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
76MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency19
77ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
78BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
79OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
80TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean0
81BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency17
82OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency17
83BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency17
84OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency17
85TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
86APLYWITH SearchApply WithholdingBooleanBoolean0
87PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
88SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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$Currency17
90CBVAT SearchCash Based VATCB_CashBasedVATBoolean0
91VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString15
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 Integer8
93REVALTRXSOURCE SearchRevaluation TRX SourceSTR13String13
94TEN99TYPE Search1099 Type1099_TypeInteger0
95TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger0
96REPLACEGOODS SearchReplace Returned GoodsCB_ReplaceReturnedGoodsBoolean0
97INVOICEEXPECTED SearchInvoice Expected ReturnsCB_InvoiceExpectedReturnsBoolean0
98PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency19
99OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency19
100POP_HDR_Errors_4 SearchPOP HDR Errors 4ML_POP_HDR_Errors_4Long Integer0
101DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
102ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
103DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
104ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
105InvoiceReceiptDate SearchInvoice Receipt DateDTDate8
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 StatusInteger0
107DEX_ROW_ID Searchintint10

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 *