Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/95
Table Type: Company
Table Name: G/L Budget Name
Database Table Name: CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 95Due 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 G/L Budget Name can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Name]
,[Description]
,[Blocked]
,[Budget Dimension 1 Code]
,[Budget Dimension 2 Code]
,[Budget Dimension 3 Code]
,[Budget Dimension 4 Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
[User] AS [User]
ON
[G/L Budget Name].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[G/L Budget Name].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Name  | Name | Normal | Code | 10 | Name | nvarchar(20) |
| 2 | Description  | Description | Normal | Text | 80 | Description | nvarchar(160) |
| 3 | Blocked | Blocked | Normal | Boolean | 4 | Blocked | tinyint |
| 4 | Budget Dimension 1 Code | Budget Dimension 1 Code | Normal | Code | 20 | Budget Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[G/L Budget Name].[Budget Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 1 Code] = [Dimension].[Code] |
| 5 | Budget Dimension 2 Code | Budget Dimension 2 Code | Normal | Code | 20 | Budget Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[G/L Budget Name].[Budget Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 2 Code] = [Dimension].[Code] |
| 6 | Budget Dimension 3 Code | Budget Dimension 3 Code | Normal | Code | 20 | Budget Dimension 3 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[G/L Budget Name].[Budget Dimension 3 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 3 Code] = [Dimension].[Code] |
| 7 | Budget Dimension 4 Code | Budget Dimension 4 Code | Normal | Code | 20 | Budget Dimension 4 Code | nvarchar(40) |
| Key to join to the Dimension table.SELECT
[G/L Budget Name].[Budget Dimension 4 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[G/L Budget Name].[Budget Dimension 4 Code] = [Dimension].[Code] |
| 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
[G/L Budget Name].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
LEFT JOIN
[User] AS [User]
ON
[G/L Budget Name].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
