Tax Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesTTax Setup

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

Table Type: Company

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

Table Number: 326

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Auto_ Create Tax Details]
   ,[Non-Taxable Tax Group Code]
   ,[Tax Account (Sales)]
   ,[Tax Account (Purchases)]
   ,[Unreal_ Tax Acc_ (Sales)]
   ,[Unreal_ Tax Acc_ (Purchases)]
   ,[Reverse Charge (Purchases)]
   ,[Unreal_ Rev_ Charge (Purch_)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Tax Setup$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 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Tax Setup].[Non-Taxable Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Tax Setup].[Tax Account (Sales)] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Tax Setup].[Tax Account (Purchases)] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Tax Setup].[Reverse Charge (Purchases)] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Tax Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Tax Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Tax Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Auto. Create Tax Details Primary Key SearchAuto. Create Tax DetailsNormalBoolean4Auto_ Create Tax Detailstinyint
3Non-Taxable Tax Group Code SearchNon-Taxable Tax Group CodeNormalCode20Non-Taxable Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
	       [Tax Setup].[Non-Taxable Tax Group Code]
	       ,[Tax Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
	              ON
	                     [Tax Setup].[Non-Taxable Tax Group Code] = [Tax Group].[Code]
6Tax Account (Sales) SearchTax Account (Sales)NormalCode20Tax Account (Sales)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Tax Setup].[Tax Account (Sales)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Tax Setup].[Tax Account (Sales)] = [G/L Account].[No_]
7Tax Account (Purchases) SearchTax Account (Purchases)NormalCode20Tax Account (Purchases)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Tax Setup].[Tax Account (Purchases)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Tax Setup].[Tax Account (Purchases)] = [G/L Account].[No_]
8Unreal. Tax Acc. (Sales) SearchUnreal. Tax Acc. (Sales)NormalCode20Unreal_ Tax Acc_ (Sales)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Tax Setup].[Unreal_ Tax Acc_ (Sales)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Tax Setup].[Unreal_ Tax Acc_ (Sales)] = [G/L Account].[No_]
9Unreal. Tax Acc. (Purchases) SearchUnreal. Tax Acc. (Purchases)NormalCode20Unreal_ Tax Acc_ (Purchases)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Tax Setup].[Unreal_ Tax Acc_ (Purchases)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Tax Setup].[Unreal_ Tax Acc_ (Purchases)] = [G/L Account].[No_]
10Reverse Charge (Purchases) SearchReverse Charge (Purchases)NormalCode20Reverse Charge (Purchases)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Tax Setup].[Reverse Charge (Purchases)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Tax Setup].[Reverse Charge (Purchases)] = [G/L Account].[No_]
11Unreal. Rev. Charge (Purch.) SearchUnreal. Rev. Charge (Purch.)NormalCode20Unreal_ Rev_ Charge (Purch_)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Tax Setup].[Unreal_ Rev_ Charge (Purch_)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Tax Setup].[Unreal_ Rev_ Charge (Purch_)] = [G/L Account].[No_]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Tax Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Tax Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesTTax Setup

Leave a Reply

Your email address will not be published. Required fields are marked *