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

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchnvarchar(20)
3Level Searchint
4Valid From Searchdatetime
5Valid To Searchdatetime
6Cost Type Range Searchnvarchar(60)
7Cost Center Code Searchnvarchar(40)
8Cost Object Code Searchnvarchar(40)
9Variant Searchnvarchar(20)
10Credit to Cost Type Searchnvarchar(40)
11Comment Searchnvarchar(100)
12Blocked Searchtinyint
13Last Date Modified Searchdatetime
14User ID Searchnvarchar(100)
15Allocation Source Type Searchint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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