Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1109
Table Type: Company
Table Name: Cost Budget Entry
Database Table Name: CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 1109Due 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 Cost Budget Entry can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Entry No_]
,[Budget Name]
,[Cost Type No_]
,[Date]
,[Cost Center Code]
,[Cost Object Code]
,[Amount]
,[Description]
,[Document No_]
,[Source Code]
,[Allocated]
,[Allocated with Journal No_]
,[Last Modified By User]
,[Last Date Modified]
,[Allocation Description]
,[Allocation ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
ON
[Cost Budget Entry].[Budget Name] = [G/L Budget Name].[Name]
LEFT JOIN
[CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
ON
[Cost Budget Entry].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
ON
[Cost Budget Entry].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Cost Budget Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
[User] AS [User]
ON
[Cost Budget Entry].[Last Modified By User] = [User].[User Name]
LEFT JOIN
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
ON
[Cost Budget Entry].[Allocation ID] = [Cost Allocation Source].[ID]
LEFT JOIN
[User] AS [User]
ON
[Cost Budget Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cost Budget Entry].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Entry No.  | Entry No. | Normal | Integer | 4 | Entry No_ | int |
| 2 | Budget Name  | Budget Name | Normal | Code | 10 | Budget Name | nvarchar(20) |
| Key to join to the G/L Budget Name table.SELECT
[Cost Budget Entry].[Budget Name]
,[G/L Budget Name].[Name]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
ON
[Cost Budget Entry].[Budget Name] = [G/L Budget Name].[Name] |
| 3 | Cost Type No. | Cost Type No. | Normal | Code | 20 | Cost Type No_ | nvarchar(40) |
| Key to join to the Cost Type table.SELECT
[Cost Budget Entry].[Cost Type No_]
,[Cost Type].[No_]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
ON
[Cost Budget Entry].[Cost Type No_] = [Cost Type].[No_] |
| 4 | Date | Date | Normal | Date | 4 | Date | datetime |
| 5 | Cost Center Code | Cost Center Code | Normal | Code | 20 | Cost Center Code | nvarchar(40) |
| Key to join to the Cost Center table.SELECT
[Cost Budget Entry].[Cost Center Code]
,[Cost Center].[Code]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
ON
[Cost Budget Entry].[Cost Center Code] = [Cost Center].[Code] |
| 6 | Cost Object Code | Cost Object Code | Normal | Code | 20 | Cost Object Code | nvarchar(40) |
| Key to join to the Cost Object table.SELECT
[Cost Budget Entry].[Cost Object Code]
,[Cost Object].[Code]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
ON
[Cost Budget Entry].[Cost Object Code] = [Cost Object].[Code] |
| 7 | Amount | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
| 9 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 20 | Document No. | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
| 30 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
| Key to join to the Source Code table.SELECT
[Cost Budget Entry].[Source Code]
,[Source Code].[Code]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
ON
[Cost Budget Entry].[Source Code] = [Source Code].[Code] |
| 31 | System-Created Entry | System-Created Entry | Normal | Boolean | 4 | | |
| 32 | Allocated | Allocated | Normal | Boolean | 4 | Allocated | tinyint |
| 33 | Allocated with Journal No. | Allocated with Journal No. | Normal | Integer | 4 | Allocated with Journal No_ | int |
| 40 | Last Modified By User | Last Modified By User | Normal | Code | 50 | Last Modified By User | nvarchar(100) |
| Key to join to the User table.SELECT
[Cost Budget Entry].[Last Modified By User]
,[User].[User Name]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[User] AS [User]
ON
[Cost Budget Entry].[Last Modified By User] = [User].[User Name] |
| 42 | Last Date Modified | Last Date Modified | Normal | Date | 4 | Last Date Modified | datetime |
| 50 | Allocation Description | Allocation Description | Normal | Text | 80 | Allocation Description | nvarchar(160) |
| 51 | Allocation ID | Allocation ID | Normal | Code | 10 | Allocation ID | nvarchar(20) |
| Key to join to the Cost Allocation Source table.SELECT
[Cost Budget Entry].[Allocation ID]
,[Cost Allocation Source].[ID]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
ON
[Cost Budget Entry].[Allocation ID] = [Cost Allocation Source].[ID] |
| 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
[Cost Budget Entry].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cost Budget Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Budget Entry]
LEFT JOIN
[User] AS [User]
ON
[Cost Budget Entry].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
