GPSOPTrxAmountsHist #4077

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

The GPSOPTrxAmountsHist table (ID 4077) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 125 fields, with a primary key of SOP Type, SOP Number, Line Item Sequence, Component Sequence. Use the reference below to explore every field, data type, and table relation.

125

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: SOP Type, SOP Number, Line Item Sequence, Component Sequence.

All fields (125)

GPSOPTrxAmountsHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	SOP Type PK	Option	Normal
2	SOP Number PK	Text	Normal
3	Line Item Sequence PK	Integer	Normal
4	Component Sequence PK	Integer	Normal
5	Item Number	Text	Normal
6	Item Description	Text	Normal
7	Non-Inventory Item	Option	Normal
8	Drop Ship	Integer	Normal
9	U Of M	Text	Normal
10	Location Code	Text	Normal
11	Unit Cost	Decimal	Normal
12	Originating Unit Cost	Decimal	Normal
13	Unit Price	Decimal	Normal
14	Originating Unit Price	Decimal	Normal
15	Extended Price	Decimal	Normal
16	Originating Extended Price	Decimal	Normal
17	Remaining Price	Decimal	Normal
18	Originating Remaining Price	Decimal	Normal
19	Extended Cost	Decimal	Normal
20	Originating Extended Cost	Decimal	Normal
21	Markdown Amount	Decimal	Normal
22	Originating Markdown Amount	Decimal	Normal
23	Markdown Percent	Integer	Normal
24	Markdown Type	Option	Normal
25	Inventory Index	Integer	Normal
26	Cost Of Sales Index	Integer	Normal
27	Sales Index	Integer	Normal
28	Markdown Index	Integer	Normal
29	Returns Index	Integer	Normal
30	In Use Index	Integer	Normal
31	In Service Index	Integer	Normal
32	Damaged Index	Integer	Normal
33	Item Tax Schedule ID	Text	Normal
34	IV Item Taxable	Option	Normal
35	Backout Sales Amount	Decimal	Normal
36	Originating Backout Sales Amount	Decimal	Normal
37	Tax Amount	Decimal	Normal
38	Originating Tax Amount	Decimal	Normal
39	Taxable Tax Amount	Decimal	Normal
40	Originating Taxable Tax Amount	Decimal	Normal
41	Based On Invoice Total	Boolean	Normal
42	Trade Discount Amount	Decimal	Normal
43	Originating Trade Discount Amount	Decimal	Normal
44	Discount Available Sales	Decimal	Normal
45	Originating Discount Available Sales	Decimal	Normal
46	QTY	Decimal	Normal
47	QTY Allocated	Decimal	Normal
48	QTY In Service	Decimal	Normal
49	QTY In Use	Decimal	Normal
50	QTY Damaged	Decimal	Normal
51	QTY Returned	Decimal	Normal
52	QTY On Hand	Decimal	Normal
53	QTY Canceled	Decimal	Normal
54	QTY Canceled Other	Decimal	Normal
55	QTY Ordered	Decimal	Normal
56	QTY Prev Back Ordered	Decimal	Normal
57	QTY Prev BO On Order	Decimal	Normal
58	QTY Prev Invoiced	Decimal	Normal
59	QTY Prev Ordered	Decimal	Normal
60	QTY Prev Received	Decimal	Normal
61	QTY Received	Decimal	Normal
62	QTY Remaining	Decimal	Normal
63	QTY Remaining On BO	Decimal	Normal
64	QTY To Back Order	Decimal	Normal
65	QTY To Invoice	Decimal	Normal
66	QTY To Order	Decimal	Normal
67	QTY Fulfilled	Decimal	Normal
68	QTY Selected	Decimal	Normal
69	QTY In Base U Of M	Decimal	Normal
70	Existing Qty Available	Decimal	Normal
71	Existing Qty Selected	Decimal	Normal
72	Requested Ship Date	Date	Normal
73	Fulfillment Date	Date	Normal
74	Actual Ship Date	Date	Normal
75	Shipping Method	Text	Normal
76	Sales Territory	Text	Normal
77	Salesperson ID	Text	Normal
78	PriceLevel	Text	Normal
79	Comment ID	Text	Normal
80	Break Field 1	Integer	Normal
81	Break Field 2	Integer	Normal
82	Break Field 3	Integer	Normal
83	Currency Index	Integer	Normal
84	TRX Source	Text	Normal
85	Document Number Corrected	Text	Normal
86	Original Sequence Number Corrected	Integer	Normal
87	Item Code	Text	Normal
88	Purchasing Status	Option	Normal
89	Decimal Places QTYS	Option	Normal
90	Decimal Places Currency	Option	Normal
91	Originating Decimal Places Currency	Option	Normal
92	Exceptional Demand	Boolean	Normal
93	Tax Schedule ID	Text	Normal
94	Tax Schedule Source	Option	Normal
95	Primary Shipto Address Code	Text	Normal
96	ShipToName	Text	Normal
97	Contact Person	Text	Normal
98	Address 1	Text	Normal
99	Address 2	Text	Normal
100	Address 3	Text	Normal
101	City	Text	Normal
102	State	Text	Normal
103	Zip Code	Text	Normal
104	Country Code	Text	Normal
105	Country	Text	Normal
106	Phone 1	Text	Normal
107	Phone 2	Text	Normal
108	Phone 3	Text	Normal
109	Fax Number	Text	Normal
110	Flags	Integer	Normal
111	Contract Number	Text	Normal
112	Contract Line SEQ Number	Decimal	Normal
113	Contract Start Date	Date	Normal
114	Contract End Date	Date	Normal
115	Contract Item Number	Text	Normal
116	Contract Serial Number	Text	Normal
117	IsLineIntrastat	Boolean	Normal
118	Print Phone Number GB	Option	Normal
119	DEX_ROW_TS	DateTime	Normal
120	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