Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/551
Table Type: Company
Table Name: VAT Rate Change Conversion
Database Table Name: CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972
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 VAT Rate Change Conversion can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Type]
,[From Code]
,[To Code]
,[Converted Date]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Rate Change Conversion]
LEFT JOIN
[User] AS [User]
ON
[VAT Rate Change Conversion].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[VAT Rate Change Conversion].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in VAT Rate Change Conversion table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Type  | Type | Normal | Option | 4 | Type | int |
Available options are:
| |||||||
| 2 | From Code  | From Code | Normal | Code | 20 | From Code | nvarchar(40) |
| 3 | To Code | To Code | Normal | Code | 20 | To Code | nvarchar(40) |
| 10 | Converted Date | Converted Date | Normal | Date | 4 | Converted Date | datetime |
| 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 [VAT Rate Change Conversion].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$VAT Rate Change Conversion$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Rate Change Conversion] LEFT JOIN [User] AS [User] ON [VAT Rate Change Conversion].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |