GPPOPReceiptHist #4061

Other table in Microsoft Dynamics 365 Business Central. 106 fields, 0 records in Cronus demo.

106
Fields
0
Records
1
Primary key
0
FlowFields
2
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: POP Receipt Number.

All fields (106)

GPPOPReceiptHist — FIELDS
NO.FIELDTYPECLASSRELATION
1 POP Receipt Number PK Text Normal
2 POP Type Option Normal
3 Vendor Document Number Text Normal
4 Receipt Date Date Normal
5 GL Posting Date Date Normal
6 Actual Ship Date Date Normal
7 Batch Source Text Normal
8 Batch Number Text Normal
9 Vendor ID Text Normal
10 Vendor Name Text Normal
11 Subtotal Decimal Normal
12 Trade Discount Amount Decimal Normal
14 Freight Amount Decimal Normal
15 Misc Amount Decimal Normal
16 Tax Amount Decimal Normal
17 1099 Amount Decimal Normal
18 Payment Terms ID Text Normal
19 Discount Percent Amount Integer Normal
20 Discount Dollar Amount Decimal Normal
21 Discount Available Amount Decimal Normal
22 Discount Date Date Normal
23 Due Date Date Normal
24 Reference Text Normal
25 Void Status Option Normal
26 Receipt Note ID Array 1 Decimal Normal
27 Receipt Note ID Array 2 Decimal Normal
28 Receipt Note ID Array 3 Decimal Normal
29 Receipt Note ID Array 4 Decimal Normal
30 Receipt Note ID Array 5 Decimal Normal
31 Receipt Note ID Array 6 Decimal Normal
32 Receipt Note ID Array 7 Decimal Normal
33 Receipt Note ID Array 8 Decimal Normal
34 Posted Date Date Normal
35 Posted User ID Text Normal
36 User To Enter Text Normal
37 Created Date Date Normal
38 Modified Date Date Normal
39 TRX Source Text Normal
40 Voucher Number Text Normal
41 Tax Date Date Normal
42 Currency ID Text Normal
43 Currency Index Integer Normal
44 Rate Type ID Text Normal
45 Exchange Table ID Text Normal
46 Exchange Rate Decimal Normal
47 Exchange Date Date Normal
48 Time DateTime Normal
49 Rate Calc Method Option Normal
50 Denomination Exchange Rate Decimal Normal
51 MC Transaction State Option Normal
52 Originating Subtotal Decimal Normal
53 Originating Trade Discount Amount Decimal Normal
54 Originating Freight Amount Decimal Normal
55 Originating Misc Amount Decimal Normal
56 Originating Tax Amount Decimal Normal
57 Originating 1099 Amount Decimal Normal
58 Originating Discount Dollar Amount Decimal Normal
59 Originating Discount Available Amount Decimal Normal
60 Simplified Boolean Normal
61 Withholding Amount Decimal Normal
62 EC Transaction Boolean Normal
63 Tax Registration Number Text Normal
64 Tax Schedule ID Text Normal
65 Based On Invoice Total Boolean Normal
66 Purchase Freight Taxable Option Normal
67 Purchase Misc Taxable Option Normal
68 Freight Schedule ID Text Normal
69 Misc Schedule ID Text Normal
70 Freight Tax Amount Decimal Normal
71 Originating Freight Tax Amount Decimal Normal
72 Misc Tax Amount Decimal Normal
73 Originating Misc Tax Amount Decimal Normal
74 Backout Tax Amount Decimal Normal
75 Originating Backout Tax Amount Decimal Normal
76 Tax Invoice Required Boolean Normal
77 Backout Freight Tax Amount Decimal Normal
78 Originating Backout Freight Tax Amount Decimal Normal
79 Backout Misc Tax Amount Decimal Normal
80 Originating Backout Misc Tax Amount Decimal Normal
81 Tax Invoice Received Boolean Normal
82 Apply Withholding Boolean Normal
83 PPS Tax Rate Integer Normal
84 Shipping Method Text Normal
85 Total Landed Cost Amount Decimal Normal
86 Cash Based Tax Boolean Normal
87 Vendor Address Code - Remit To Text Normal
88 Revaluation Journal Entry Integer Normal
89 Revaluation TRX Source Text Normal
90 1099 Type Option Normal
91 1099 Box Number Integer Normal
92 Replace Returned Goods Boolean Normal
93 Invoice Expected Returns Boolean Normal
94 Prepayment Amount Decimal Normal
95 Originating Prepayment Amount Decimal Normal
96 Discount Taken Amount Decimal Normal
97 Originating Discount Taken Amount Decimal Normal
98 Discount Available Taken Decimal Normal
99 Originating Discount Available Taken Decimal Normal
100 Invoice Receipt Date Date Normal
101 Workflow Status Option Normal
102 DEX_ROW_ID Integer Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal