Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1106
Table Type: Company
Table Name: Cost Allocation Source
Database Table Name: CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 1106Due 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 Allocation Source can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[ID]
,[Level]
,[Valid From]
,[Valid To]
,[Cost Type Range]
,[Cost Center Code]
,[Cost Object Code]
,[Variant]
,[Credit to Cost Type]
,[Comment]
,[Blocked]
,[Last Date Modified]
,[User ID]
,[Allocation Source Type]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
LEFT JOIN
[CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
ON
[Cost Allocation Source].[Cost Type Range] = [Cost Type].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
ON
[Cost Allocation Source].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
ON
[Cost Allocation Source].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
ON
[Cost Allocation Source].[Credit to Cost Type] = [Cost Type].[No_]
LEFT JOIN
[User] AS [User]
ON
[Cost Allocation Source].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Cost Allocation Source].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | ID  | ID | Normal | Code | 10 | ID | nvarchar(20) |
| 2 | Level  | Level | Normal | Integer | 4 | Level | int |
| 3 | Valid From | Valid From | Normal | Date | 4 | Valid From | datetime |
| 4 | Valid To | Valid To | Normal | Date | 4 | Valid To | datetime |
| 5 | Cost Type Range | Cost Type Range | Normal | Code | 30 | Cost Type Range | nvarchar(60) |
| Key to join to the Cost Type table.SELECT
[Cost Allocation Source].[Cost Type Range]
,[Cost Type].[No_]
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
LEFT JOIN
[CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
ON
[Cost Allocation Source].[Cost Type Range] = [Cost Type].[No_] |
| 6 | Cost Center Code | Cost Center Code | Normal | Code | 20 | Cost Center Code | nvarchar(40) |
| Key to join to the Cost Center table.SELECT
[Cost Allocation Source].[Cost Center Code]
,[Cost Center].[Code]
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
LEFT JOIN
[CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
ON
[Cost Allocation Source].[Cost Center Code] = [Cost Center].[Code] |
| 7 | Cost Object Code | Cost Object Code | Normal | Code | 20 | Cost Object Code | nvarchar(40) |
| Key to join to the Cost Object table.SELECT
[Cost Allocation Source].[Cost Object Code]
,[Cost Object].[Code]
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
LEFT JOIN
[CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
ON
[Cost Allocation Source].[Cost Object Code] = [Cost Object].[Code] |
| 8 | Variant | Variant | Normal | Code | 10 | Variant | nvarchar(20) |
| 10 | Credit to Cost Type | Credit to Cost Type | Normal | Code | 20 | Credit to Cost Type | nvarchar(40) |
| Key to join to the Cost Type table.SELECT
[Cost Allocation Source].[Credit to Cost Type]
,[Cost Type].[No_]
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
LEFT JOIN
[CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
ON
[Cost Allocation Source].[Credit to Cost Type] = [Cost Type].[No_] |
| 20 | Comment | Comment | Normal | Text | 50 | Comment | nvarchar(100) |
| 22 | Total Share | Total Share | FlowField | Decimal | 12 | | |
| 30 | Blocked | Blocked | Normal | Boolean | 4 | Blocked | tinyint |
| 60 | Last Date Modified | Last Date Modified | Normal | Date | 4 | Last Date Modified | datetime |
| 61 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 100 | Allocation Source Type | Allocation Source Type | Normal | Option | 4 | Allocation Source Type | int |
| Available options are:
|
| 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 Allocation Source].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
LEFT JOIN
[User] AS [User]
ON
[Cost Allocation Source].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
