GPSOPTaxesWorkHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPSOPTaxesWorkHist

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/4075

Table Type: Company

Table Name: GPSOPTaxesWorkHist
Database Table Name:

Table Number: 4075

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how GPSOPTaxesWorkHist can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GPSOPTaxesWorkHist]
LEFT JOIN
   [User] AS [User]
      ON
         [GPSOPTaxesWorkHist].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GPSOPTaxesWorkHist].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GPSOPTaxesWorkHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	SOPTYPE	SOP Type	Normal	Option	4
2	SOPNUMBE	SOP Number	Normal	Text	22
3	LNITMSEQ	Line Item Sequence	Normal	Integer	4
4	TAXDTLID	Tax Detail ID	Normal	Text	16
5	ACTINDX	Account Index	Normal	Integer	4
6	BKOUTTAX	Backout Tax	Normal	Boolean	4
7	TXABLETX	Taxable Tax	Normal	Boolean	4
8	STAXAMNT	Sales Tax Amount	Normal	Decimal	12
9	ORSLSTAX	Originating Sales Tax Amount	Normal	Decimal	12
10	FRTTXAMT	Freight Tax Amount	Normal	Decimal	12
11	ORFRTTAX	Originating Freight Tax Amount	Normal	Decimal	12
12	MSCTXAMT	Misc Tax Amount	Normal	Decimal	12
13	ORMSCTAX	Originating Misc Tax Amount	Normal	Decimal	12
14	TAXDTSLS	Tax Detail Total Sales	Normal	Decimal	12
15	ORTOTSLS	Originating Total Sales	Normal	Decimal	12
16	TDTTXSLS	Tax Detail Total Taxable Sales	Normal	Decimal	12
17	ORTXSLS	Originating Total Taxable Sales	Normal	Decimal	12
18	TXDTOTTX	Tax Detail Total Tax Potential	Normal	Decimal	12
19	OTTAXPON	Originating Total Tax Potential	Normal	Decimal	12
20	DELETE1	Delete	Normal	Boolean	4
21	CURRNIDX	Currency Index	Normal	Integer	4
22	TRXSORCE	TRX Source	Normal	Text	14
23	TXDTLPCTAMT	Tax Detail Percent or Amount	Normal	Decimal	12
24	DEX_ROW_ID	DEX_ROW_ID	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [GPSOPTaxesWorkHist].[] ,[User].[User Security ID] FROM [] AS [GPSOPTaxesWorkHist] LEFT JOIN [User] AS [User] ON [GPSOPTaxesWorkHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables Company Tables GGPSOPTaxesWorkHist

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in GPSOPTaxesWorkHist table

Show/hide example query

Leave a Reply Cancel reply