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

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchnvarchar(20)
3Line No_ Primary Key Searchint
4Target Cost Type Searchnvarchar(40)
5Target Cost Center Searchnvarchar(40)
6Target Cost Object Searchnvarchar(40)
7Static Base Searchdecimal(38,38)
8Static Weighting Searchdecimal(38,38)
9Share Searchdecimal(38,38)
10Percent Searchdecimal(38,38)
11Comment Searchnvarchar(100)
12Base Searchint
13No_ Filter Searchnvarchar(500)
14Cost Center Filter Searchnvarchar(500)
15Cost Object Filter Searchnvarchar(500)
16Date Filter Code Searchint
17Group Filter Searchnvarchar(500)
18Allocation Target Type Searchint
19Percent per Share Searchdecimal(38,38)
20Amount per Share Searchdecimal(38,38)
21Share Updated on Searchdatetime
22Last Date Modified Searchdatetime
23User ID Searchnvarchar(100)
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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