XPT / Schema / GPPMHist

GPPMHist #4053

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

84
Fields
0
Records
2
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: Voucher Number, Document Type.

All fields (84)

GPPMHist — FIELDS
NO.FIELDTYPECLASSRELATION
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

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms