Tax 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
   [timestamp]
   ,[Tax Jurisdiction Code]
   ,[Tax Group Code]
   ,[Tax Type]
   ,[Effective Date]
   ,[Maximum Amount_Qty_]
   ,[Tax Below Maximum]
   ,[Tax Above Maximum]
   ,[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 Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Tax Detail].[Tax Group Code] = [Tax Group].[Code]

Show/hide columns in Tax Detail table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Tax Jurisdiction Code Primary Key Searchnvarchar(20)
3Tax Group Code Primary Key Searchnvarchar(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]
4Tax Type Primary Key Searchint
5Effective Date Primary Key Searchdatetime
6Maximum Amount_Qty_ Searchdecimal(38,38)
7Tax Below Maximum Searchdecimal(38,38)
8Tax Above Maximum Searchdecimal(38,38)
9Calculate Tax on Tax Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Tax Detail table

Leave a Reply

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