XPT / Schema / GPPOPPOHist

GPPOPPOHist #4057

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

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

143
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: PO Number.

All fields (143)

GPPOPPOHist — FIELDS
NO.FIELDTYPECLASSRELATION
1 PO Number PK Text Normal
2 PO Status Option Normal
3 Status Group Option Normal
4 PO Type Option Normal
5 User To Enter Text Normal
6 Confirm With Text Normal
7 Document Date Date Normal
8 Last Edit Date Date Normal
9 Last Printed Date Date Normal
10 Promised Date Date Normal
11 Promised Ship Date Date Normal
12 Required Date Date Normal
13 Requisition Date Date Normal
14 Shipping Method Text Normal
15 Tax Registration Number Text Normal
16 Remaining Subtotal Decimal Normal
17 Subtotal Decimal Normal
18 Trade Discount Amount Decimal Normal
20 Freight Amount Decimal Normal
21 Misc Charges Amount Decimal Normal
22 Tax Amount Decimal Normal
23 Vendor ID Text Normal
24 Vendor Name Text Normal
25 Minimum Order Decimal Normal
26 Vendor Address Code - Purchase Address Text Normal
27 Company ID Integer Normal
28 Primary Billto Address Code Text Normal
29 Primary Shipto Address Code Text Normal
30 Company Name Text Normal
31 Contact Text Normal
32 Address 1 Text Normal
33 Address 2 Text Normal
34 Address 3 Text Normal
35 City Text Normal
36 State Text Normal
37 Zip Code Text Normal
38 Country Code Text Normal
39 Country Text Normal
40 Phone 1 Text Normal
41 Phone 2 Text Normal
42 Phone 3 Text Normal
43 Fax Text Normal
44 Payment Terms ID Text Normal
45 Discount Dollar Amount Decimal Normal
46 Discount Percent Amount Integer Normal
47 Discount Amount Available Decimal Normal
48 Discount Date Date Normal
49 Due Date Date Normal
50 Customer Number Text Normal
51 Times Printed Integer Normal
52 Created Date Date Normal
53 Modified Date Date Normal
54 PO Note ID Array Decimal Normal
55 PO Note ID Array Decimal Normal
56 PO Note ID Array Decimal Normal
57 PO Note ID Array Decimal Normal
58 PO Note ID Array Decimal Normal
59 PO Note ID Array Decimal Normal
60 PO Note ID Array Decimal Normal
61 PO Note ID Array Decimal Normal
62 PO Note ID Array Decimal Normal
63 PO Note ID Array Decimal Normal
64 PO Note ID Array Decimal Normal
65 PO Note ID Array Decimal Normal
66 PO Note ID Array Decimal Normal
67 PO Note ID Array Decimal Normal
68 PO Note ID Array Decimal Normal
69 TRX Source Text Normal
70 Comment ID Text Normal
71 Canceled Subtotal Decimal Normal
72 Currency ID Text Normal
73 Currency Index Integer Normal
74 Rate Type ID Text Normal
75 Exchange Table ID Text Normal
76 Exchange Rate Decimal Normal
77 Exchange Date Date Normal
78 Time DateTime Normal
79 Rate Calc Method Option Normal
80 Denomination Exchange Rate Decimal Normal
81 MC Transaction State Option Normal
82 Originating Remaining Subtotal Decimal Normal
83 Originating Subtotal Decimal Normal
84 Originating Canceled Subtotal Decimal Normal
85 Originating Trade Discount Amount Decimal Normal
86 Originating Freight Amount Decimal Normal
87 Originating Misc Charges Amount Decimal Normal
88 Originating Tax Amount Decimal Normal
89 Originating Discount Dollar Amount Decimal Normal
90 Originating Discount Amount Available Decimal Normal
91 Buyer ID Text Normal
92 Allow SO Commitments Boolean Normal
93 Discount Grace Period Integer Normal
94 Due Date Grace Period Integer Normal
95 Revision Number Integer Normal
96 Tax Schedule ID Text Normal
97 Tax Schedule Source Option Normal
98 Based On Invoice Total Boolean Normal
99 Purchase Freight Taxable Option Normal
100 Purchase Misc Taxable Option Normal
101 Freight Schedule ID Text Normal
102 Misc Schedule ID Text Normal
103 Freight Tax Amount Decimal Normal
104 Originating Freight Tax Amount Decimal Normal
105 Misc Tax Amount Decimal Normal
106 Originating Misc Tax Amount Decimal Normal
107 Backout Tax Amount Decimal Normal
108 Originating Backout Tax Amount Decimal Normal
109 Backout Freight Tax Amount Decimal Normal
110 Originating Backout Freight Tax Amount Decimal Normal
111 Backout Misc Tax Amount Decimal Normal
112 Originating Backout Misc Tax Amount Decimal Normal
113 Flags Integer Normal
114 POP Contract Number Text Normal
115 Contract End Date Date Normal
116 Control Blanket By Option Normal
117 Purchase Company Name Text Normal
118 Purchase Contact Text Normal
119 Purchase Address 1 Text Normal
120 Purchase Address 2 Text Normal
121 Purchase Address 3 Text Normal
122 Purchase City Text Normal
123 Purchase State Text Normal
124 Purchase Zip Code Text Normal
125 Purchase Country Code Text Normal
126 Purchase Country Text Normal
127 Purchase Phone 1 Text Normal
128 Purchase Phone 2 Text Normal
129 Purchase Phone 3 Text Normal
130 Purchase Fax Text Normal
131 Total Blanket Line Ext Qty Decimal Normal
132 Workflow Approval Status Option Normal
133 Workflow Priority Option Normal
134 Workflow Status Option Normal
135 Print Phone Number GB Option Normal
136 Prepayment Amount Decimal Normal
137 Originating Prepayment Amount Decimal Normal
138 DEX_ROW_TS DateTime Normal
139 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