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 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 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_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 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_%2Integer5
20DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
21DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
22DISCDATE SearchDiscount DateDTDate8
23DUEDATE SearchDue DateDTDate8
24REFRENCE SearchReferenceSTR30String30
25RCPTNOTE SearchReceipt Note ID ArrayDLR14Currency14
26RCPTNOTE_1 SearchReceipt Note ID Array[1]DLR14Currency14
27RCPTNOTE_2 SearchReceipt Note ID Array[2]DLR14Currency14
28RCPTNOTE_3 SearchReceipt Note ID Array[3]DLR14Currency14
29RCPTNOTE_4 SearchReceipt Note ID Array[4]DLR14Currency14
30RCPTNOTE_5 SearchReceipt Note ID Array[5]DLR14Currency14
31RCPTNOTE_6 SearchReceipt Note ID Array[6]DLR14Currency14
32RCPTNOTE_7 SearchReceipt Note ID Array[7]DLR14Currency14
33RCPTNOTE_8 SearchReceipt Note ID Array[8]DLR14Currency14
34POPHDR1 SearchPOP HDR Errors 1ML_POP_HDR_Errors_1Long Integer0
35POPHDR2 SearchPOP HDR Errors 2ML_POP_HDR_Errors_2Long Integer0
36POPLNERR SearchPOP LINE ErrorsML_POP_LINE_ErrorsLong Integer0
37POSTEDDT SearchPosted DateDATEDate6
38PTDUSRID SearchPosted User IDSTR15String15
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_IDString15
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 DateDTDate8
41MODIFDT SearchModified DateDTDate8
42TRXSORCE SearchTRX SourceSTR13String13
43VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
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 DateDTDate8
45CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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_IDString15
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_IDString15
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)14
50EXCHDATE SearchExchange DateDT_DateDate6
51TIME1 SearchTimeTM6Time6
52RATECALC 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
53DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
54MCTRXSTT 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.
55ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
56ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
57ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
58ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
59ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
60OR1099AM SearchOriginating 1099 AmountDLR17_RBS0_UTR$Currency17
61ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
62ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
63WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
64SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
65BNKRCAMT SearchBank Receipts AmountDLR17_RBS0_STR$Currency17
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 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 CalledYNBoolean0
70BSIVCTTL SearchBased On Invoice TotalYNBoolean0
71Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger0
72Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger0
73FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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_LBAUString15
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$Currency19
76ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
77MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency19
78ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
79BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
80OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
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
85TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean0
86TaxInvRecvd SearchTax Invoice ReceivedCB_Tax_Invoice_ReceivedBoolean0
87APLYWITH SearchApply WithholdingBooleanBoolean0
88PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
89SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_DocPrintedBoolean0

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$Currency17
92BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
93OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
94CBVAT SearchCash Based VATCB_CashBasedVATBoolean0
95VADCDTRO SearchVendor Address Code - Remit ToSTR15_Address_CodeString15
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_TypeInteger0
97TEN99BOXNUMBER Search1099 Box NumberDDL_1099_BoxInteger0
98REPLACEGOODS SearchReplace Returned GoodsCB_ReplaceReturnedGoodsBoolean0
99INVOICEEXPECTED SearchInvoice Expected ReturnsCB_InvoiceExpectedReturnsBoolean0
100PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency19
101OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency19
102POP_HDR_Errors_4 SearchPOP HDR Errors 4ML_POP_HDR_Errors_4Long Integer0
103DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
104ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
105DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
106ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
107InvoiceReceiptDate 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.
108Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
109DEX_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 Work (POP10300)

Leave a Reply

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