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 Group Display Name: Purchasing History
Physical Name: POP30300
Technical Name: POP_ReceiptHist
Group Technical Name: Purchasing History
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 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 | ||||||
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 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 | ||||||
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 | VOIDSTTS | Void Status | Integer | INT | 0 | |
26 | RCPTNOTE_1 | Receipt Note ID Array[1] | Currency | DLR14 | 14 | |
27 | RCPTNOTE | Receipt Note ID Array | DLR14 | Currency | 14 | |
28 | RCPTNOTE_2 | Receipt Note ID Array[2] | Currency | DLR14 | 14 | |
29 | RCPTNOTE_3 | Receipt Note ID Array[3] | Currency | DLR14 | 14 | |
30 | RCPTNOTE_4 | Receipt Note ID Array[4] | Currency | DLR14 | 14 | |
31 | RCPTNOTE_5 | Receipt Note ID Array[5] | Currency | DLR14 | 14 | |
32 | RCPTNOTE_6 | Receipt Note ID Array[6] | Currency | DLR14 | 14 | |
33 | RCPTNOTE_7 | Receipt Note ID Array[7] | Currency | DLR14 | 14 | |
34 | RCPTNOTE_8 | Receipt Note ID Array[8] | Currency | DLR14 | 14 | |
35 | POPHDR1 | POP HDR Errors 1 | Long Integer | ML_POP_HDR_Errors_1 | 0 | |
36 | POPHDR2 | POP HDR Errors 2 | Long Integer | ML_POP_HDR_Errors_2 | 0 | |
37 | POPLNERR | POP LINE Errors | Long Integer | ML_POP_LINE_Errors | 0 | |
38 | POSTEDDT | Posted Date | Date | DATE | 6 | |
39 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
40 | USER2ENT | User To Enter | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
41 | CREATDDT | Created Date | Date | DT | 8 | |
42 | MODIFDT | Modified Date | Date | DT | 8 | |
43 | TRXSORCE | TRX Source | String | STR13 | 13 | |
44 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
Partial key to the PM Key Master File (PM00400).
Click to show/hideSELECT
['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 | ||||||
45 | Tax_Date | Tax Date | Date | DT | 8 | |
46 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
47 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['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 | ||||||
48 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['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 | ||||||
49 | EXGTBLID | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['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 | ||||||
50 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
51 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
52 | TIME1 | Time | Time | TM6 | 6 | |
53 | 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 | ||||||
54 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
55 | 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.
| ||||||
56 | ORSUBTOT | Originating Subtotal | Currency | DLR17_RBS0_STR$ | 17 | |
57 | ORTDISAM | Originating Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
58 | ORFRTAMT | Originating Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
59 | ORMISCAMT | Originating Misc Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
60 | ORTAXAMT | Originating Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
61 | OR1099AM | Originating 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
62 | ORDDLRAT | Originating Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
63 | ORDAVAMT | Originating Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
64 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
65 | WITHHAMT | Withholding Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
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 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 | ||||||
69 | BSIVCTTL | Based On Invoice Total | Boolean | YN | 0 | |
70 | Purchase_Freight_Taxable | Purchase Freight Taxable | Integer | DDL_Purchase_Tax_Options | 0 | |
71 | Purchase_Misc_Taxable | Purchase Misc Taxable | Integer | DDL_Purchase_Tax_Options | 0 | |
72 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
73 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['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 | ||||||
74 | FRTTXAMT | Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
75 | ORFRTTAX | Originating Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
76 | MSCTXAMT | Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
77 | ORMSCTAX | Originating Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
78 | BCKTXAMT | Backout Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
79 | OBTAXAMT | Originating Backout Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
80 | TaxInvReqd | Tax Invoice Required | Boolean | CB_Tax_Invoice_Required | 0 | |
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 | TaxInvRecvd | Tax Invoice Received | Boolean | CB_Tax_Invoice_Received | 0 | |
86 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
87 | PPSTAXRT | PPS Tax Rate | Integer | INT5_%2 | 5 | |
88 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['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 | ||||||
89 | Total_Landed_Cost_Amount | Total Landed Cost Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
90 | CBVAT | Cash Based VAT | Boolean | CB_CashBasedVAT | 0 | |
91 | 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 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 | ||||||
92 | REVALJRNENTRY | Revaluation Journal Entry | Long Integer | LI8_U0 | 8 | |
93 | REVALTRXSOURCE | Revaluation TRX Source | String | STR13 | 13 | |
94 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 | |
95 | TEN99BOXNUMBER | 1099 Box Number | Integer | DDL_1099_Box | 0 | |
96 | REPLACEGOODS | Replace Returned Goods | Boolean | CB_ReplaceReturnedGoods | 0 | |
97 | INVOICEEXPECTED | Invoice Expected Returns | Boolean | CB_InvoiceExpectedReturns | 0 | |
98 | PrepaymentAmount | Prepayment Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
99 | OriginatingPrepaymentAmt | Originating Prepayment Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
100 | POP_HDR_Errors_4 | POP HDR Errors 4 | Long Integer | ML_POP_HDR_Errors_4 | 0 | |
101 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
102 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
103 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
104 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
105 | 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. | ||||||
106 | Workflow_Status | Workflow Status | Integer | Workflow Status | 0 |