GPPOPPOTaxHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPPOTaxHist

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

Table Type: Company

Table Name: GPPOPPOTaxHist
Database Table Name:

Table Number: 4059

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 GPPOPPOTaxHist 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 [GPPOPPOTaxHist]
LEFT JOIN
   [User] AS [User]
      ON
         [GPPOPPOTaxHist].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GPPOPPOTaxHist].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GPPOPPOTaxHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	PONUMBER	PO Number	Normal	Text	18
2	ORD	Ord	Normal	Integer	4
3	TAXDTLID	Tax Detail ID	Normal	Text	16
4	BKOUTTAX	Backout Tax	Normal	Boolean	4
5	TAXAMNT	Tax Amount	Normal	Decimal	12
6	ORTAXAMT	Originating Tax Amount	Normal	Decimal	12
7	FRTTXAMT	Freight Tax Amount	Normal	Decimal	12
8	ORFRTTAX	Originating Freight Tax Amount	Normal	Decimal	12
9	MSCTXAMT	Misc Tax Amount	Normal	Decimal	12
10	ORMSCTAX	Originating Misc Tax Amount	Normal	Decimal	12
11	TAXPURCH	Taxable Purchases	Normal	Decimal	12
12	ORGTXPCH	Originating Taxable Purchases	Normal	Decimal	12
13	TOTPURCH	Total Purchases	Normal	Decimal	12
14	ORTOTPUR	Originating Total Purchases	Normal	Decimal	12
15	TXDTOTTX	Tax Detail Total Tax Potential	Normal	Decimal	12
16	OTTAXPON	Originating Total Tax Potential	Normal	Decimal	12
17	TRXSORCE	TRX Source	Normal	Text	14
18	POP_Tax_Note_ID_Array_1	POP Tax Note ID Array	Normal	Decimal	12
19	POP_Tax_Note_ID_Array_2	POP Tax Note ID Array	Normal	Decimal	12
20	CURRNIDX	Currency Index	Normal	Integer	4
21	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 [GPPOPPOTaxHist].[] ,[User].[User Security ID] FROM [] AS [GPPOPPOTaxHist] LEFT JOIN [User] AS [User] ON [GPPOPPOTaxHist].[] = [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 GGPPOPPOTaxHist

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 GPPOPPOTaxHist table

Show/hide example query

Leave a Reply Cancel reply