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: 326Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Tax Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]
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]
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]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Primary Key  | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
| 2 | Auto. Create Tax Details  | Auto. Create Tax Details | Normal | Boolean | 4 | Auto_ Create Tax Details | tinyint |
| 3 | Non-Taxable Tax Group Code | Non-Taxable Tax Group Code | Normal | Code | 20 | Non-Taxable Tax Group Code | nvarchar(40) |
| Key to join to the Tax Group table.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] |
| 6 | Tax Account (Sales) | Tax Account (Sales) | Normal | Code | 20 | Tax Account (Sales) | nvarchar(40) |
| Key to join to the G/L Account table.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_] |
| 7 | Tax Account (Purchases) | Tax Account (Purchases) | Normal | Code | 20 | Tax Account (Purchases) | nvarchar(40) |
| Key to join to the G/L Account table.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_] |
| 8 | Unreal. Tax Acc. (Sales) | Unreal. Tax Acc. (Sales) | Normal | Code | 20 | Unreal_ Tax Acc_ (Sales) | nvarchar(40) |
| Key to join to the G/L Account table.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_] |
| 9 | Unreal. Tax Acc. (Purchases) | Unreal. Tax Acc. (Purchases) | Normal | Code | 20 | Unreal_ Tax Acc_ (Purchases) | nvarchar(40) |
| Key to join to the G/L Account table.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_] |
| 10 | Reverse Charge (Purchases) | Reverse Charge (Purchases) | Normal | Code | 20 | Reverse Charge (Purchases) | nvarchar(40) |
| Key to join to the G/L Account table.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_] |
| 11 | Unreal. Rev. Charge (Purch.) | Unreal. Rev. Charge (Purch.) | Normal | Code | 20 | Unreal_ Rev_ Charge (Purch_) | nvarchar(40) |
| Key to join to the G/L Account table.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 | 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.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] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
