Cost Allocation Target – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost Allocation Target

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1107

Table Type: Company

Table Name: Cost Allocation Target
Database Table Name: CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1107

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 Target can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[Line No_]
   ,[Target Cost Type]
   ,[Target Cost Center]
   ,[Target Cost Object]
   ,[Static Base]
   ,[Static Weighting]
   ,[Share]
   ,[Percent]
   ,[Comment]
   ,[Base]
   ,[No_ Filter]
   ,[Cost Center Filter]
   ,[Cost Object Filter]
   ,[Date Filter Code]
   ,[Group Filter]
   ,[Allocation Target Type]
   ,[Percent per Share]
   ,[Amount per Share]
   ,[Share Updated on]
   ,[Last Date Modified]
   ,[User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Cost Allocation Target$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 Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
      ON
         [Cost Allocation Target].[Target Cost Type] = [Cost Type].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Allocation Target].[Target Cost Center] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Allocation Target].[Target Cost Object] = [Cost Object].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Allocation Target].[Cost Center Filter] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Allocation Target].[Cost Object Filter] = [Cost Object].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Allocation Target].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Allocation Target].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Allocation Target 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	Line No.	Line No.	Normal	Integer	4	Line No_	int
5	Target Cost Type	Target Cost Type	Normal	Code	20	Target Cost Type	nvarchar(40)
	Key to join to the Cost Type table. Show/hide example query SELECT [Cost Allocation Target].[Target Cost Type] ,[Cost Type].[No_] FROM [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target] LEFT JOIN [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type] ON [Cost Allocation Target].[Target Cost Type] = [Cost Type].[No_]
6	Target Cost Center	Target Cost Center	Normal	Code	20	Target Cost Center	nvarchar(40)
	Key to join to the Cost Center table. Show/hide example query SELECT [Cost Allocation Target].[Target Cost Center] ,[Cost Center].[Code] FROM [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target] LEFT JOIN [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center] ON [Cost Allocation Target].[Target Cost Center] = [Cost Center].[Code]
7	Target Cost Object	Target Cost Object	Normal	Code	20	Target Cost Object	nvarchar(40)
	Key to join to the Cost Object table. Show/hide example query SELECT [Cost Allocation Target].[Target Cost Object] ,[Cost Object].[Code] FROM [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target] LEFT JOIN [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object] ON [Cost Allocation Target].[Target Cost Object] = [Cost Object].[Code]
8	Static Base	Static Base	Normal	Decimal	12	Static Base	decimal(38,38)
9	Static Weighting	Static Weighting	Normal	Decimal	12	Static Weighting	decimal(38,38)
10	Share	Share	Normal	Decimal	12	Share	decimal(38,38)
11	Percent	Percent	Normal	Decimal	12	Percent	decimal(38,38)
20	Comment	Comment	Normal	Text	50	Comment	nvarchar(100)
30	Base	Base	Normal	Option	4	Base	int
	Available options are: “Static” “G/L Entries” “G/L Budget Entries” “Cost Type Entries” “Cost Budget Entries” “No of Employees” “Items Sold (Qty.)” “Items Purchased (Qty.)” “Items Sold (Amount)” “Items Purchased (Amount)”
31	No. Filter	No. Filter	Normal	Text	250	No_ Filter	nvarchar(500)
32	Cost Center Filter	Cost Center Filter	Normal	Text	250	Cost Center Filter	nvarchar(500)
	Key to join to the Cost Center table. Show/hide example query SELECT [Cost Allocation Target].[Cost Center Filter] ,[Cost Center].[Code] FROM [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target] LEFT JOIN [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center] ON [Cost Allocation Target].[Cost Center Filter] = [Cost Center].[Code]
33	Cost Object Filter	Cost Object Filter	Normal	Text	250	Cost Object Filter	nvarchar(500)
	Key to join to the Cost Object table. Show/hide example query SELECT [Cost Allocation Target].[Cost Object Filter] ,[Cost Object].[Code] FROM [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target] LEFT JOIN [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object] ON [Cost Allocation Target].[Cost Object Filter] = [Cost Object].[Code]
34	Date Filter Code	Date Filter Code	Normal	Option	4	Date Filter Code	int
	Available options are: ” “ “Week” “Last Week” “Month” “Last Month” “Month of Last Year” “Year” “Last Year” “Period” “Last Period” “Period of Last Year” “Fiscal Year” “Last Fiscal Year”
35	Group Filter	Group Filter	Normal	Text	250	Group Filter	nvarchar(500)
38	Allocation Target Type	Allocation Target Type	Normal	Option	4	Allocation Target Type	int
	Available options are: “All Costs” “Percent per Share” “Amount per Share”
40	Percent per Share	Percent per Share	Normal	Decimal	12	Percent per Share	decimal(38,38)
41	Amount per Share	Amount per Share	Normal	Decimal	12	Amount per Share	decimal(38,38)
50	Share Updated on	Share Updated on	Normal	Date	4	Share Updated on	datetime
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)
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 Target].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target] LEFT JOIN [User] AS [User] ON [Cost Allocation Target].[$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 Target

Leave a Reply Cancel reply