GPPOPReceiptHist #4061

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

The GPPOPReceiptHist table (ID 4061) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 106 fields, with a primary key of POP Receipt Number. Use the reference below to explore every field, data type, and table relation.

106

Fields

Records

Primary key

FlowFields

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.	FIELD	TYPE	CLASS
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