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 Group Display Name: Purchasing Transactions
Physical Name: POP10300
Technical Name: POP_Receipt
Group Technical Name: Purchasing Transactions
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | POPRCTNM  | POP Receipt Number | String | STR17_POP_Number | 17 | |
| 2 | POPTYPE | POP Type | Integer | DDL_POP_Type | 0 | |
| 3 | VNDDOCNM | Vendor Document Number | String | STR20_Document_Number | 20 | |
| 4 | receiptdate | Receipt Date | Date | DT | 8 | |
| 5 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 6 | ACTLSHIP | Actual Ship Date | Date | DT | 8 | |
| 7 | BCHSOURC | Batch Source | String | STR15 | 15 | |
Records whether the transaction was entered in a batch or not.Click to show/hide the Batch SourcesPM_Trxent Batch
XXPM_Trxent No batch (real-time)
| ||||||
| 8 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 9 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['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 | ||||||
| 10 | VENDNAME | Vendor Name | String | STR64_Vendor_Name | 64 | |
| 11 | SUBTOTAL | Subtotal | Currency | DLR17_RBS0_STR$ | 17 | |
| 12 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 13 | TRDPCTPR | Trade Discount Percent (Precise) | Currency (Variable) | Trade Discount Percent (Precise) | 23 | |
| 14 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | MISCAMNT | Misc Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 16 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 17 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['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 | ||||||
| 19 | DSCPCTAM | Discount Percent Amount | Integer | INT5_%2 | 5 | |
| 20 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 21 | DISAVAMT | Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 22 | DISCDATE | Discount Date | Date | DT | 8 | |
| 23 | DUEDATE | Due Date | Date | DT | 8 | |
| 24 | REFRENCE | Reference | String | STR30 | 30 | |
| 25 | RCPTNOTE_1 | Receipt Note ID Array[1] | Currency | DLR14 | 14 | |
| 26 | RCPTNOTE | Receipt Note ID Array | DLR14 | Currency | 14 | |
| 27 | RCPTNOTE_2 | Receipt Note ID Array[2] | Currency | DLR14 | 14 | |
| 28 | RCPTNOTE_3 | Receipt Note ID Array[3] | Currency | DLR14 | 14 | |
| 29 | RCPTNOTE_4 | Receipt Note ID Array[4] | Currency | DLR14 | 14 | |
| 30 | RCPTNOTE_5 | Receipt Note ID Array[5] | Currency | DLR14 | 14 | |
| 31 | RCPTNOTE_6 | Receipt Note ID Array[6] | Currency | DLR14 | 14 | |
| 32 | RCPTNOTE_7 | Receipt Note ID Array[7] | Currency | DLR14 | 14 | |
| 33 | RCPTNOTE_8 | Receipt Note ID Array[8] | Currency | DLR14 | 14 | |
| 34 | POPHDR1 | POP HDR Errors 1 | Long Integer | ML_POP_HDR_Errors_1 | 0 | |
| 35 | POPHDR2 | POP HDR Errors 2 | Long Integer | ML_POP_HDR_Errors_2 | 0 | |
| 36 | POPLNERR | POP LINE Errors | Long Integer | ML_POP_LINE_Errors | 0 | |
| 37 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 38 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 39 | USER2ENT | User To Enter | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 40 | CREATDDT | Created Date | Date | DT | 8 | |
| 41 | MODIFDT | Modified Date | Date | DT | 8 | |
| 42 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 43 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['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 | ||||||
| 44 | Tax_Date | Tax Date | Date | DT | 8 | |
| 45 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
| 46 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
| 47 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['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 | ||||||
| 48 | EXGTBLID | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['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 | ||||||
| 49 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 50 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
| 51 | TIME1 | Time | Time | TM6 | 6 | |
| 52 | RATECALC | Rate Calc Method | Integer | INT | 0 | |
Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank.
Click to show/hide Rate Calc Methods0 Multiply
1 Divide | ||||||
| 53 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 54 | MCTRXSTT | MC Transaction State | Integer | INT1 | 1 | |
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 States0 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.
| ||||||
| 55 | ORSUBTOT | Originating Subtotal | Currency | DLR17_RBS0_STR$ | 17 | |
| 56 | ORTDISAM | Originating Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 57 | ORFRTAMT | Originating Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 58 | ORMISCAMT | Originating Misc Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 59 | ORTAXAMT | Originating Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 60 | OR1099AM | Originating 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 61 | ORDDLRAT | Originating Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 62 | ORDAVAMT | Originating Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 63 | WITHHAMT | Withholding Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 64 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 65 | BNKRCAMT | Bank Receipts Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 66 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
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. | ||||||
| 67 | TXRGNNUM | Tax Registration Number | String | STR25 | 25 | |
| 68 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 69 | TXENGCLD | Tax Engine Called | Boolean | YN | 0 | |
| 70 | BSIVCTTL | Based On Invoice Total | Boolean | YN | 0 | |
| 71 | Purchase_Freight_Taxable | Purchase Freight Taxable | Integer | DDL_Purchase_Tax_Options | 0 | |
| 72 | Purchase_Misc_Taxable | Purchase Misc Taxable | Integer | DDL_Purchase_Tax_Options | 0 | |
| 73 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 74 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
| 75 | FRTTXAMT | Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 76 | ORFRTTAX | Originating Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 77 | MSCTXAMT | Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 78 | ORMSCTAX | Originating Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 79 | BCKTXAMT | Backout Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 80 | OBTAXAMT | Originating Backout Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 81 | BackoutFreightTaxAmt | Backout Freight Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 82 | OrigBackoutFreightTaxAmt | Originating Backout Freight Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 83 | BackoutMiscTaxAmt | Backout Misc Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 84 | OrigBackoutMiscTaxAmt | Originating Backout Misc Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 85 | TaxInvReqd | Tax Invoice Required | Boolean | CB_Tax_Invoice_Required | 0 | |
| 86 | TaxInvRecvd | Tax Invoice Received | Boolean | CB_Tax_Invoice_Received | 0 | |
| 87 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
| 88 | PPSTAXRT | PPS Tax Rate | Integer | INT5_%2 | 5 | |
| 89 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['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 | ||||||
| 90 | DocPrinted | DocPrinted | Boolean | CB_DocPrinted | 0 | |
Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
| 91 | Total_Landed_Cost_Amount | Total Landed Cost Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 92 | BackoutTradeDiscTax | Backout Trade Discount Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 93 | OrigBackoutTradeDiscTax | Originating Backout Trade Discount Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 94 | CBVAT | Cash Based VAT | Boolean | CB_CashBasedVAT | 0 | |
| 95 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['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 | ||||||
| 96 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 | |
| 97 | TEN99BOXNUMBER | 1099 Box Number | Integer | DDL_1099_Box | 0 | |
| 98 | REPLACEGOODS | Replace Returned Goods | Boolean | CB_ReplaceReturnedGoods | 0 | |
| 99 | INVOICEEXPECTED | Invoice Expected Returns | Boolean | CB_InvoiceExpectedReturns | 0 | |
| 100 | PrepaymentAmount | Prepayment Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 101 | OriginatingPrepaymentAmt | Originating Prepayment Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 102 | POP_HDR_Errors_4 | POP HDR Errors 4 | Long Integer | ML_POP_HDR_Errors_4 | 0 | |
| 103 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 104 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 105 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 106 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 107 | InvoiceReceiptDate | Invoice Receipt Date | Date | DT | 8 | |
| 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. | ||||||
| 108 | Workflow_Status | Workflow Status | Integer | Workflow Status | 0 | |