Cost Allocation Source – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost Allocation Source

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: 1106

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 Cost Allocation Source can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

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]

Show/hide an example select of all columns including those from all joined tables

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]

Show/hide columns in Cost Allocation Source table

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. Show/hide example query 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. Show/hide example query 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. Show/hide example query 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. Show/hide example query 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: “Both” “Actual” “Budget”
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 query 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

Dynamics 365 BC Table Reference Tables Company Tables CCost Allocation Source

Leave a Reply Cancel reply