GPPOPTaxHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPTaxHist

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

Table Type: Company

Table Name: GPPOPTaxHist
Database Table Name:

Table Number: 4064

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

Show/hide columns in GPPOPTaxHist table

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

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

Show/hide example query

Leave a Reply Cancel reply