GPPMHist #4053

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

The GPPMHist table (ID 4053) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 84 fields, with a primary key of Voucher Number, Document Type. Use the reference below to explore every field, data type, and table relation.

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: Voucher Number, Document Type.

All fields (84)

GPPMHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	Voucher Number PK	Text	Normal
2	Vendor ID	Text	Normal
3	Document Type PK	Option	Normal
4	Document Date	Date	Normal
5	Document Number	Text	Normal
6	Document Amount	Decimal	Normal
7	Current Trx Amount	Decimal	Normal
8	Discount Taken Amount	Decimal	Normal
9	Discount Amount	Decimal	Normal
10	Discount Dollar Amount	Decimal	Normal
11	Batch Number	Text	Normal
12	TRX Source	Text	Normal
13	Batch Source	Text	Normal
14	Discount Date	Date	Normal
15	Due Date	Date	Normal
16	Purchase Order Number	Text	Normal
17	1099 Amount	Decimal	Normal
18	Write Off Amount	Decimal	Normal
19	Discount Amount Available	Decimal	Normal
20	Transaction Description	Text	Normal
21	Unapplied 1099 Amount	Decimal	Normal
22	Backout Purchases Amount	Decimal	Normal
23	Backout Freight Amount	Decimal	Normal
24	Backout Misc Amount	Decimal	Normal
25	Voided	Boolean	Normal
26	Hold	Boolean	Normal
27	Checkbook ID	Text	Normal
28	Date Invoice Paid Off	Date	Normal
29	PPS Amount Deducted	Decimal	Normal
30	PPS Tax Rate	Integer	Normal
31	Percent Of Gross Amount Subject	Integer	Normal
32	GST Discount Amount	Decimal	Normal
33	Posted Date	Date	Normal
34	Posted User ID	Text	Normal
35	Modified Date	Date	Normal
36	Modified User ID	Text	Normal
37	Payment Entry Type	Option	Normal
38	Card Name	Text	Normal
39	Purchases Amount	Decimal	Normal
40	Trade Discount Amount	Decimal	Normal
41	Misc Charges Amount	Decimal	Normal
42	Freight Amount	Decimal	Normal
43	Tax Amount	Decimal	Normal
44	Total Payments	Decimal	Normal
45	Currency ID	Text	Normal
46	Payment Terms ID	Text	Normal
47	Shipping Method	Text	Normal
48	Tax Schedule ID	Text	Normal
49	Purchase Schedule ID	Text	Normal
50	Freight Schedule ID	Text	Normal
51	Misc Schedule ID	Text	Normal
52	Posting Date	Date	Normal
53	Discount Available Taken	Decimal	Normal
54	Control Type	Integer	Normal
55	Note Index	Decimal	Normal
56	Percent Discount	Integer	Normal
57	Retainage Amount	Decimal	Normal
58	Void GL Posting Date	Date	Normal
59	IC TRX	Boolean	Normal
60	Tax Date	Date	Normal
61	Purchase Date	Date	Normal
62	Correction	Boolean	Normal
63	Simplified	Boolean	Normal
64	Apply Withholding	Boolean	Normal
65	Electronic	Boolean	Normal
66	EC Transaction	Boolean	Normal
67	DocPrinted	Boolean	Normal
68	Tax Invoice Required	Boolean	Normal
69	Vendor Check Name	Text	Normal
70	Backout Trade Discount Amount	Decimal	Normal
71	Cash Based Tax	Boolean	Normal
72	Vendor Address Code - Remit To	Text	Normal
73	1099 Type	Option	Normal
74	1099 Box Number	Integer	Normal
75	PO Number	Text	Normal
76	Workflow Status	Option	Normal
77	Invoice Receipt Date	Date	Normal
78	DEX_ROW_TS	DateTime	Normal
79	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