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
   [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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Tax Jurisdiction Code SearchTax Jurisdiction CodeNormalCode10Tax Jurisdiction Codenvarchar(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]
2Tax Group Code Primary Key SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
3Tax Type Primary Key SearchTax TypeNormalOption4Tax Typeint
Available options are:
  • “Sales and Use Tax”
  • “Excise Tax”
  • “Sales Tax Only”
  • “Use Tax Only”
4Maximum Amount/Qty. Primary Key SearchMaximum Amount/Qty.NormalDecimal12Maximum Amount_Qty_decimal(38,38)
5Tax Below Maximum SearchTax Below MaximumNormalDecimal12Tax Below Maximumdecimal(38,38)
6Tax Above Maximum SearchTax Above MaximumNormalDecimal12Tax Above Maximumdecimal(38,38)
7Effective Date SearchEffective DateNormalDate4Effective Datedatetime
8Calculate Tax on Tax Primary Key SearchCalculate Tax on TaxNormalBoolean4Calculate Tax on Taxtinyint
10010Expense/Capitalize SearchExpense/CapitalizeNormalBoolean4
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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Tax Detail table

Leave a Reply

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