Cost 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Starting Date for G/L Transfer SearchStarting Date for G/L TransferNormalDate4Starting Date for G_L Transferdatetime
3Align G/L Account SearchAlign G/L AccountNormalOption4Align G_L Accountint
Available options are:
  • “No Alignment”
  • “Automatic”
  • “Prompt”
4Align Cost Center Dimension SearchAlign Cost Center DimensionNormalOption4Align Cost Center Dimensionint
Available options are:
  • “No Alignment”
  • “Automatic”
  • “Prompt”
5Align Cost Object Dimension SearchAlign Cost Object DimensionNormalOption4Align Cost Object Dimensionint
Available options are:
  • “No Alignment”
  • “Automatic”
  • “Prompt”
20Last Allocation ID SearchLast Allocation IDNormalCode10Last Allocation IDnvarchar(20)
30Last Allocation Doc. No. SearchLast Allocation Doc. No.NormalCode20Last Allocation Doc_ No_nvarchar(40)
100Auto Transfer from G/L SearchAuto Transfer from G/LNormalBoolean4Auto Transfer from G_Ltinyint
120Check G/L Postings SearchCheck G/L PostingsNormalBoolean4Check G_L Postingstinyint
205Cost Center Dimension SearchCost Center DimensionNormalCode20Cost Center Dimensionnvarchar(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]
206Cost Object Dimension SearchCost Object DimensionNormalCode20Cost Object Dimensionnvarchar(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 SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Cost Accounting Setup].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

Your email address will not be published. Required fields are marked *