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: 320Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972]
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]
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]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Code  | Code | Normal | Code | 10 | Code | nvarchar(20) |
| 2 | Description  | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 3 | 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 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_] |
| 4 | 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 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_] |
| 5 | Report-to Jurisdiction | Report-to Jurisdiction | Normal | Code | 10 | Report-to Jurisdiction | nvarchar(20) |
| 6 | Date Filter | Date Filter | FlowFilter | Date | 4 | | |
| 7 | Tax Group Filter | Tax Group Filter | FlowFilter | Code | 20 | | |
| Key to join to the Tax Group table.SELECT
[Tax Jurisdiction].[]
,[Tax Group].[Code]
FROM
[CRONUS UK Ltd_$Tax Jurisdiction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Jurisdiction]
LEFT JOIN
[CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
ON
[Tax Jurisdiction].[] = [Tax Group].[Code] |
| 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 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_] |
| 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 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_] |
| 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 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_] |
| 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 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_] |
| 12 | Unrealized VAT Type | Unrealized Tax Type | Normal | Option | 4 | Unrealized VAT Type | int |
| Available options are:
- ” “
- “Percentage”
- “First”
- “Last”
- “First (Fully Paid)”
- “Last (Fully Paid)”
|
| 13 | Calculate Tax on Tax | Calculate Tax on Tax | Normal | Boolean | 4 | Calculate Tax on Tax | tinyint |
| 14 | Adjust for Payment Discount | Adjust for Payment Discount | Normal | Boolean | 4 | Adjust for Payment Discount | tinyint |
| 15 | Name | Name | Normal | Text | 30 | Name | nvarchar(60) |
| 10010 | Country/Region | Country/Region | Normal | Option | 4 | | |
| 10020 | Print Order | Print Order | Normal | Integer | 4 | | |
| 10030 | Print Description | Print Description | Normal | Text | 30 | | |
| 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 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] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
