Tax Jurisdiction

Dynamics 365 BC Table ReferenceTablesCompany TablesTTax Jurisdiction

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

Table Type: Company

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

Table Number: 320

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[Tax Account (Sales)]
   ,[Tax Account (Purchases)]
   ,[Report-to Jurisdiction]
   ,[Unreal_ Tax Acc_ (Sales)]
   ,[Unreal_ Tax Acc_ (Purchases)]
   ,[Reverse Charge (Purchases)]
   ,[Unreal_ Rev_ Charge (Purch_)]
   ,[Unrealized VAT Type]
   ,[Calculate Tax on Tax]
   ,[Adjust for Payment Discount]
   ,[Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Tax Jurisdiction table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
3Tax 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 Jurisdiction].[Tax Account (Sales)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Tax Jurisdiction].[Tax Account (Sales)] = [G/L Account].[No_]
4Tax 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 Jurisdiction].[Tax Account (Purchases)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Tax Jurisdiction].[Tax Account (Purchases)] = [G/L Account].[No_]
5Report-to Jurisdiction SearchReport-to JurisdictionNormalCode10Report-to Jurisdictionnvarchar(20)
6Date Filter SearchDate FilterFlowFilterDate4
7Tax Group Filter SearchTax Group FilterFlowFilterCode20
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 Jurisdiction].[Unreal_ Tax Acc_ (Sales)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Tax Jurisdiction].[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 Jurisdiction].[Unreal_ Tax Acc_ (Purchases)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Tax Jurisdiction].[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 Jurisdiction].[Reverse Charge (Purchases)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Tax Jurisdiction].[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 Jurisdiction].[Unreal_ Rev_ Charge (Purch_)]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Tax Jurisdiction].[Unreal_ Rev_ Charge (Purch_)] = [G/L Account].[No_]
12Unrealized VAT Type SearchUnrealized Tax TypeNormalOption4Unrealized VAT Typeint
Available options are:
  • ” “
  • “Percentage”
  • “First”
  • “Last”
  • “First (Fully Paid)”
  • “Last (Fully Paid)”
13Calculate Tax on Tax SearchCalculate Tax on TaxNormalBoolean4Calculate Tax on Taxtinyint
14Adjust for Payment Discount SearchAdjust for Payment DiscountNormalBoolean4Adjust for Payment Discounttinyint
15Name SearchNameNormalText30Namenvarchar(60)
10010Country/Region SearchCountry/RegionNormalOption4
10020Print Order SearchPrint OrderNormalInteger4
10030Print Description SearchPrint DescriptionNormalText30
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 Jurisdiction].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [User] AS [User]
              ON
                     [Tax Jurisdiction].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Tax Jurisdiction].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
       [User] AS [User]
              ON
                     [Tax Jurisdiction].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesTTax Jurisdiction

Leave a Reply

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