Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/7132
Table Type: Company
Table Name: Item Budget Name
Database Table Name: CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 7132Due 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 Item Budget Name can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Analysis Area]
,[Name]
,[Description]
,[Blocked]
,[Budget Dimension 1 Code]
,[Budget Dimension 2 Code]
,[Budget Dimension 3 Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Item Budget Name].[Budget Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Item Budget Name].[Budget Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Item Budget Name].[Budget Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
[User] AS [User]
ON
[Item Budget Name].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Item Budget Name].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Analysis Area  | Analysis Area | Normal | Option | 4 | Analysis Area | int |
| Available options are:
- “Sales”
- “Purchase”
- “Inventory”
|
| 2 | Name  | Name | Normal | Code | 10 | Name | nvarchar(20) |
| 3 | Description | Description | Normal | Text | 80 | Description | nvarchar(160) |
| 4 | Blocked | Blocked | Normal | Boolean | 4 | Blocked | tinyint |
| 5 | 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
[Item Budget Name].[Budget Dimension 1 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Item Budget Name].[Budget Dimension 1 Code] = [Dimension].[Code] |
| 6 | 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
[Item Budget Name].[Budget Dimension 2 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Item Budget Name].[Budget Dimension 2 Code] = [Dimension].[Code] |
| 7 | 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
[Item Budget Name].[Budget Dimension 3 Code]
,[Dimension].[Code]
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
ON
[Item Budget Name].[Budget Dimension 3 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
[Item Budget Name].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Item Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Name]
LEFT JOIN
[User] AS [User]
ON
[Item 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 |
