PA Report Purchasing Receipt Work (POP10300)

azurecurveProductsProject Accounting (258)PurchasingPA Report Purchasing Receipt Work (POP10300)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt Work
Physical Name: POP10300
Technical Name: PA_POP_Report_Receipt

Group Display Name: Purchasing Transactions
Group Technical Name: Purchasing Transactions

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 Work'].VENDORID AS 'Purchasing Receipt Work-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Purchasing Receipt Work'].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 Work'].PYMTRMID AS 'Purchasing Receipt Work-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Purchasing Receipt Work'].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
25RCPTNOTE SearchReceipt Note ID ArrayDLR14Currency1014
26RCPTNOTE_1 SearchReceipt Note ID Array[1]DLR14Currency1014
27RCPTNOTE_2 SearchReceipt Note ID Array[2]DLR14Currency1014
28RCPTNOTE_3 SearchReceipt Note ID Array[3]DLR14Currency1014
29RCPTNOTE_4 SearchReceipt Note ID Array[4]DLR14Currency1014
30RCPTNOTE_5 SearchReceipt Note ID Array[5]DLR14Currency1014
31RCPTNOTE_6 SearchReceipt Note ID Array[6]DLR14Currency1014
32RCPTNOTE_7 SearchReceipt Note ID Array[7]DLR14Currency1014
33RCPTNOTE_8 SearchReceipt Note ID Array[8]DLR14Currency1014
34POPHDR1 SearchPOP HDR Errors 1ML_POP_HDR_Errors_1Long Integer40
35POPHDR2 SearchPOP HDR Errors 2ML_POP_HDR_Errors_2Long Integer40
36POPLNERR SearchPOP LINE ErrorsML_POP_LINE_ErrorsLong Integer40
37POSTEDDT SearchPosted DateDATEDate46
38PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].USER2ENT AS 'Purchasing Receipt Work-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Receipt Work'].USER2ENT = ['Users Master'].USERID
40CREATDDT SearchCreated DateDTDate48
41MODIFDT SearchModified DateDTDate48
42TRXSORCE SearchTRX SourceSTR13String1413
43VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].VCHRNMBR AS 'Purchasing Receipt Work-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['Purchasing Receipt Work'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['Purchasing Receipt Work'].DOCTYPE = ['PM Key Master File'].DOCTYPE
44Tax_Date SearchTax DateDTDate48
45CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].CURNCYID AS 'Purchasing Receipt Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchasing Receipt Work'].CURNCYID = ['Currency Setup'].CURNCYID
46CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].EXGTBLID AS 'Purchasing Receipt Work-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Purchasing Receipt Work'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
49XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
50EXCHDATE SearchExchange DateDT_DateDate46
51TIME1 SearchTimeTM6Time46
52RATECALC 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
53DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
54MCTRXSTT 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.
55ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
56ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
57ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
58ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency1019
59ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
60OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency1017
61ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
62ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency1017
63WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency1019
64SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
65BNKRCAMT SearchBank Receipts AmountDLR17_RBS0_STR$Currency1017
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 Work'].TAXSCHID AS 'Purchasing Receipt Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchasing Receipt Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
69TXENGCLD SearchTax Engine CalledYNBoolean20
70BSIVCTTL SearchBased On Invoice TotalYNBoolean20
71Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger20
72Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger20
73FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

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

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].MSCSCHID AS 'Purchasing Receipt Work-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchasing Receipt Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
75FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency1019
76ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
77MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
78ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
79BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
80OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
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
85TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
86TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean20
87APLYWITH SearchApply WithholdingBooleanBoolean20
88PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
89SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].SHIPMTHD AS 'Purchasing Receipt Work-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Purchasing Receipt Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
90DocPrinted SearchDocPrintedCB_DocPrintedBoolean20

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
91Total_Landed_Cost_Amount SearchTotal Landed Cost AmountDLR17_RBS0_UTR$Currency1017
92BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
93OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
94CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
95VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Purchasing Receipt Work'].VADCDTRO AS 'Purchasing Receipt Work-Vendor Address Code - Remit To'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       POP10300 AS ['Purchasing Receipt Work']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Purchasing Receipt Work'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Purchasing Receipt Work'].VENDORID = ['PM Address MSTR'].VENDORID
96TEN99TYPE Search1099 Type1099_TypeInteger20
97TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger20
98REPLACEGOODS SearchReplace Returned GoodsCB_ReplaceReturnedGoodsBoolean20
99INVOICEEXPECTED SearchInvoice Expected ReturnsCB_InvoiceExpectedReturnsBoolean20
100PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency1019
101OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency1019
102POP_HDR_Errors_4 SearchPOP HDR Errors 4ML_POP_HDR_Errors_4Long Integer40
103DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
104ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
105DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
106ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
107InvoiceReceiptDate 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.
108Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
109DEX_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 Work (POP10300)

Leave a Reply

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