XPT / Schema / GPSOPTrxHist

GPSOPTrxHist #4078

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

184
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: SOP Type, SOP Number.

All fields (184)

GPSOPTrxHist — FIELDS
NO.FIELDTYPECLASSRELATION
1 SOP Type PK Option Normal
2 SOP Number PK Text Normal
3 Original Type Option Normal
4 Original Number Text Normal
5 Document ID Text Normal
6 Document Date Date Normal
7 GL Posting Date Date Normal
8 Quote Date Date Normal
9 Quote Expiration Date Date Normal
10 Order Date Date Normal
11 Invoice Date Date Normal
12 Back Order Date Date Normal
13 Return Date Date Normal
14 Requested Ship Date Date Normal
15 Fulfillment Date Date Normal
16 Actual Ship Date Date Normal
17 Discount Date Date Normal
18 Due Date Date Normal
19 Repeating Boolean Normal
20 TRX Frequency Option Normal
21 Times Repeated Integer Normal
22 Times To Repeat Integer Normal
23 Days to Increment Integer Normal
24 Date Last Repeated Date Normal
25 Dest Batch 1 Text Normal
26 Dest Batch 2 Text Normal
27 Use Document ID 1 Text Normal
28 Use Document ID 2 Text Normal
29 Discount Available Freight Decimal Normal
30 Originating Discount Available Freight Decimal Normal
31 Discount Available Misc Decimal Normal
32 Originating Discount Available Misc Decimal Normal
33 Discount Available Amount Decimal Normal
34 Originating Discount Available Amount Decimal Normal
35 Discount Returned Decimal Normal
36 Originating Discount Returned Decimal Normal
37 Discount Taken Amount Decimal Normal
38 Originating Discount Taken Amount Decimal Normal
39 Discount Percent Amount Integer Normal
40 Discount Dollar Amount Decimal Normal
41 Originating Discount Dollar Amount Decimal Normal
42 Discount Available Taken Decimal Normal
43 Originating Discount Available Taken Decimal Normal
44 Payment Terms ID Text Normal
45 PriceLevel Text Normal
46 Location Code Text Normal
47 Batch Source Text Normal
48 Batch Number Text Normal
49 Customer Number Text Normal
50 Customer Name Text Normal
51 Customer PO Number Text Normal
52 Prospect Integer Normal
53 Master Number Integer Normal
54 Packing Slip Number Text Normal
55 Picking Ticket Number Text Normal
56 Markdown Amount Decimal Normal
57 Originating Markdown Amount Decimal Normal
58 Primary Billto Address Code Text Normal
59 Primary Shipto Address Code Text Normal
60 Contact Person Text Normal
61 ShipToName Text Normal
62 Address 1 Text Normal
63 Address 2 Text Normal
64 Address 3 Text Normal
65 City Text Normal
66 State Text Normal
67 Zip Code Text Normal
68 Country Code Text Normal
69 Country Text Normal
70 Phone Number 1 Text Normal
71 Phone Number 2 Text Normal
72 Phone 3 Text Normal
73 Fax Number Text Normal
74 Commission Applied To Option Normal
75 Commission Amount Decimal Normal
76 Originating Commission Amount Decimal Normal
77 Commission Sale Amount Decimal Normal
78 Originating Commission Sales Amount Decimal Normal
79 Non-Commissioned Amount Decimal Normal
80 Originating Non-Commissioned Amount Decimal Normal
81 Shipping Method Text Normal
82 Trade Discount Amount Decimal Normal
83 Originating Trade Discount Amount Decimal Normal
84 Trade Discount Percent Integer Normal
85 Subtotal Decimal Normal
86 Originating Subtotal Decimal Normal
87 Remaining Subtotal Decimal Normal
88 Originating Remaining Subtotal Decimal Normal
89 Extended Cost Decimal Normal
90 Originating Extended Cost Decimal Normal
91 Freight Amount Decimal Normal
92 Originating Freight Amount Decimal Normal
93 Misc Amount Decimal Normal
94 Originating Misc Amount Decimal Normal
95 Tax Engine Called Boolean Normal
96 Tax Exempt 1 Text Normal
97 Tax Exempt 2 Text Normal
98 Tax Registration Number Text Normal
99 Tax Schedule ID Text Normal
100 Tax Schedule Source Option Normal
101 Based On Invoice Total Boolean Normal
102 Freight Schedule ID Text Normal
103 Freight Tax Amount Decimal Normal
104 Originating Freight Tax Amount Decimal Normal
105 Freight Taxable Option Normal
106 Misc Schedule ID Text Normal
107 Misc Tax Amount Decimal Normal
108 Originating Misc Tax Amount Decimal Normal
109 Misc Taxable Option Normal
110 Backout Freight Amount Decimal Normal
111 Originating Backout Freight Amount Decimal Normal
112 Backout Misc Amount Decimal Normal
113 Originating Backout Misc Amount Decimal Normal
114 Backout Tax Amount Decimal Normal
115 Originating Backout Tax Amount Decimal Normal
116 Taxable Tax Amount Decimal Normal
117 Originating Taxable Tax Amount Decimal Normal
118 Tax Amount Decimal Normal
119 Originating Tax Amount Decimal Normal
120 EC Transaction Boolean Normal
121 Document Amount Decimal Normal
122 Originating Document Amount Decimal Normal
123 Payment Received Decimal Normal
124 Originating Payment Received Decimal Normal
125 Deposit Received Decimal Normal
126 Originating Deposit Received Decimal Normal
127 COD Amount Decimal Normal
128 Originating COD Amount Decimal Normal
129 Account Amount Decimal Normal
130 Originating Account Amount Decimal Normal
131 Sales Territory Text Normal
132 Salesperson ID Text Normal
133 UPS Zone Text Normal
134 Times Printed Integer Normal
135 Posting Status Integer Normal
136 Void Status Option Normal
137 Allocate By Option Normal
138 Note Index Decimal Normal
139 Currency ID Text Normal
140 Currency Index Integer Normal
141 Rate Type ID Text Normal
142 Exchange Table ID Text Normal
143 Exchange Rate Decimal Normal
144 Denomination Exchange Rate Decimal Normal
145 Exchange Date Date Normal
146 Time DateTime Normal
147 Rate Calculation Method Option Normal
148 MC Transaction State Option Normal
149 TRX Source Text Normal
150 Comment ID Text Normal
151 Reference Text Normal
152 Posted Date Date Normal
153 Posted User ID Text Normal
154 User To Enter Text Normal
155 Created Date Date Normal
156 Modified Date Date Normal
157 Tax Date Date Normal
158 Apply Withholding Boolean Normal
159 Withholding Amount Decimal Normal
160 Shipping Document Boolean Normal
161 Correction Boolean Normal
162 Simplified Boolean Normal
163 Document Number Corrected Text Normal
164 Sequence Number Corrected Integer Normal
165 Sale Date Date Normal
166 Exceptional Demand Boolean Normal
167 Flags Integer Normal
168 SOP Status Option Normal
169 Ship Complete Document Boolean Normal
170 Direct Debit Boolean Normal
171 Workflow Approval Status Credit Limit Option Normal
172 Workflow Priority Credit Limit Option Normal
173 Workflow Approval Status Quote Option Normal
174 Workflow Priority Quote Option Normal
175 Workflow Status Option Normal
176 Contract Exchange Rate Status Integer Normal
177 Print Phone Number GB Option Normal
178 DEX_ROW_TS DateTime Normal
179 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