Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/30109
Table Type: Company
Table Name: Shpfy Tax Area
Database Table Name: CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb
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 Shpfy Tax Area can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb]
Show/hide an example select of all columns by name
SELECT
[Country_Region Code]
,[County]
,[Tax Area Code]
,[Tax Liable]
,[VAT Bus_ Posting Group]
,[County Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Tax Area]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Shpfy Tax Area].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Tax Area].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Tax Area].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Shpfy Tax Area table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Country/Region Code | Country/Region Code | Normal | Code | 20 | Country_Region Code | nvarchar(40) |
Key to join to the Country/Region table.Show/hide example querySELECT
[Shpfy Tax Area].[Country_Region Code]
,[Country/Region].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Tax Area]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
ON
[Shpfy Tax Area].[Country_Region Code] = [Country/Region].[Code] | |||||||
2 | County | State | Normal | Text | 50 | County | nvarchar(100) |
3 | Tax Area Code | Tax Area Code | Normal | Code | 20 | Tax Area Code | nvarchar(40) |
Key to join to the Tax Area table.Show/hide example querySELECT
[Shpfy Tax Area].[Tax Area Code]
,[Tax Area].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Tax Area]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Shpfy Tax Area].[Tax Area Code] = [Tax Area].[Code] | |||||||
4 | Tax Liable | Tax Liable | Normal | Boolean | 4 | Tax Liable | tinyint |
5 | VAT Bus. Posting Group | Tax Bus. Posting Group | Normal | Code | 20 | VAT Bus_ Posting Group | nvarchar(40) |
Key to join to the VAT Business Posting Group table.Show/hide example querySELECT
[Shpfy Tax Area].[VAT Bus_ Posting Group]
,[VAT Business Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Tax Area]
LEFT JOIN
[CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
ON
[Shpfy Tax Area].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code] | |||||||
6 | County Code | State Code | Normal | Code | 2 | County Code | nvarchar(4) |
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.Show/hide example querySELECT
[Shpfy Tax Area].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Tax Area]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Tax Area].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Shpfy Tax Area].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Shpfy Tax Area$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Tax Area]
LEFT JOIN
[User] AS [User]
ON
[Shpfy Tax Area].[$systemModifiedBy] = [User].[User Security ID] |