GPSOPTaxesWorkHist #4075

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

The GPSOPTaxesWorkHist table (ID 4075) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 29 fields, with a primary key of SOP Type, SOP Number, Line Item Sequence, Tax Detail ID. 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: SOP Type, SOP Number, Line Item Sequence, Tax Detail ID.

All fields (29)

GPSOPTaxesWorkHist — 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	Tax Detail ID PK	Text	Normal
5	Account Index	Integer	Normal
6	Backout Tax	Boolean	Normal
7	Taxable Tax	Boolean	Normal
8	Sales Tax Amount	Decimal	Normal
9	Originating Sales Tax Amount	Decimal	Normal
10	Freight Tax Amount	Decimal	Normal
11	Originating Freight Tax Amount	Decimal	Normal
12	Misc Tax Amount	Decimal	Normal
13	Originating Misc Tax Amount	Decimal	Normal
14	Tax Detail Total Sales	Decimal	Normal
15	Originating Total Sales	Decimal	Normal
16	Tax Detail Total Taxable Sales	Decimal	Normal
17	Originating Total Taxable Sales	Decimal	Normal
18	Tax Detail Total Tax Potential	Decimal	Normal
19	Originating Total Tax Potential	Decimal	Normal
20	Delete	Boolean	Normal
21	Currency Index	Integer	Normal
22	TRX Source	Text	Normal
23	Tax Detail Percent or Amount	Decimal	Normal
24	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