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
   [timestamp]
   ,[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 columns in Cost Accounting Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Starting Date for G_L Transfer Searchdatetime
4Align G_L Account Searchint
5Align Cost Center Dimension Searchint
6Align Cost Object Dimension Searchint
7Last Allocation ID Searchnvarchar(20)
8Last Allocation Doc_ No_ Searchnvarchar(40)
9Auto Transfer from G_L Searchtinyint
10Check G_L Postings Searchtinyint
11Cost Center Dimension Searchnvarchar(40)
12Cost Object Dimension Searchnvarchar(40)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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