Cost Accounting Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost Accounting Setup

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

Table Type: Company

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

Table Number: 1108

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Starting Date for G_L Transfer]
   ,[Align G_L Account]
   ,[Align Cost Center Dimension]
   ,[Align Cost Object Dimension]
   ,[Last Allocation ID]
   ,[Last Allocation Doc_ No_]
   ,[Auto Transfer from G_L]
   ,[Check G_L Postings]
   ,[Cost Center Dimension]
   ,[Cost Object Dimension]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Cost Accounting Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Starting Date for G/L Transfer	Starting Date for G/L Transfer	Normal	Date	4	Starting Date for G_L Transfer	datetime
3	Align G/L Account	Align G/L Account	Normal	Option	4	Align G_L Account	int
4	Align Cost Center Dimension	Align Cost Center Dimension	Normal	Option	4	Align Cost Center Dimension	int
	Available options are: “No Alignment” “Automatic” “Prompt”
5	Align Cost Object Dimension	Align Cost Object Dimension	Normal	Option	4	Align Cost Object Dimension	int
	Available options are: “No Alignment” “Automatic” “Prompt”
20	Last Allocation ID	Last Allocation ID	Normal	Code	10	Last Allocation ID	nvarchar(20)
30	Last Allocation Doc. No.	Last Allocation Doc. No.	Normal	Code	20	Last Allocation Doc_ No_	nvarchar(40)
100	Auto Transfer from G/L	Auto Transfer from G/L	Normal	Boolean	4	Auto Transfer from G_L	tinyint
120	Check G/L Postings	Check G/L Postings	Normal	Boolean	4	Check G_L Postings	tinyint
205	Cost Center Dimension	Cost Center Dimension	Normal	Code	20	Cost Center Dimension	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Cost Accounting Setup].[Cost Center Dimension] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cost Accounting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Accounting Setup] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cost Accounting Setup].[Cost Center Dimension] = [Dimension].[Code]
206	Cost Object Dimension	Cost Object Dimension	Normal	Code	20	Cost Object Dimension	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Cost Accounting Setup].[Cost Object Dimension] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Cost Accounting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Accounting Setup] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Cost Accounting Setup].[Cost Object Dimension] = [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. Show/hide example query SELECT [Cost Accounting Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Cost Accounting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Accounting Setup] LEFT JOIN [User] AS [User] ON [Cost Accounting Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier