Tax Detail – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables TTax Detail

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

Table Type: Company

Table Name: Tax Detail
Database Table Name: CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 322

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 Tax Detail can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Tax Jurisdiction Code]
   ,[Tax Group Code]
   ,[Tax Type]
   ,[Maximum Amount_Qty_]
   ,[Tax Below Maximum]
   ,[Tax Above Maximum]
   ,[Effective Date]
   ,[Calculate Tax on Tax]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Detail]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
      ON
         [Tax Detail].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Tax Detail].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Tax Detail].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Tax Detail].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Tax Detail table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Tax Jurisdiction Code	Tax Jurisdiction Code	Normal	Code	10	Tax Jurisdiction Code	nvarchar(20)
	Key to join to the Tax Jurisdiction table. Show/hide example query SELECT [Tax Detail].[Tax Jurisdiction Code] ,[Tax Jurisdiction].[Code] FROM [CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Detail] LEFT JOIN [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction] ON [Tax Detail].[Tax Jurisdiction Code] = [Tax Jurisdiction].[Code]
2	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Tax Detail].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Detail] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Tax Detail].[Tax Group Code] = [Tax Group].[Code]
3	Tax Type	Tax Type	Normal	Option	4	Tax Type	int
	Available options are: “Sales and Use Tax” “Excise Tax” “Sales Tax Only” “Use Tax Only”
4	Maximum Amount/Qty.	Maximum Amount/Qty.	Normal	Decimal	12	Maximum Amount_Qty_	decimal(38,38)
5	Tax Below Maximum	Tax Below Maximum	Normal	Decimal	12	Tax Below Maximum	decimal(38,38)
6	Tax Above Maximum	Tax Above Maximum	Normal	Decimal	12	Tax Above Maximum	decimal(38,38)
7	Effective Date	Effective Date	Normal	Date	4	Effective Date	datetime
8	Calculate Tax on Tax	Calculate Tax on Tax	Normal	Boolean	4	Calculate Tax on Tax	tinyint
10010	Expense/Capitalize	Expense/Capitalize	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Tax Detail].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Tax Detail$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Detail] LEFT JOIN [User] AS [User] ON [Tax Detail].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Tax Detail table

Tax Group

Dynamics 365 BC Table Reference Tables Company Tables TTax Detail

Leave a Reply Cancel reply