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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | ID  | nvarchar(20) |
| 3 | Line No_ | int |
| 4 | Target Cost Type | nvarchar(40) |
| 5 | Target Cost Center | nvarchar(40) |
| 6 | Target Cost Object | nvarchar(40) |
| 7 | Static Base | decimal(38,38) |
| 8 | Static Weighting | decimal(38,38) |
| 9 | Share | decimal(38,38) |
| 10 | Percent | decimal(38,38) |
| 11 | Comment | nvarchar(100) |
| 12 | Base | int |
| 13 | No_ Filter | nvarchar(500) |
| 14 | Cost Center Filter | nvarchar(500) |
| 15 | Cost Object Filter | nvarchar(500) |
| 16 | Date Filter Code | int |
| 17 | Group Filter | nvarchar(500) |
| 18 | Allocation Target Type | int |
| 19 | Percent per Share | decimal(38,38) |
| 20 | Amount per Share | decimal(38,38) |
| 21 | Share Updated on | datetime |
| 22 | Last Date Modified | datetime |
| 23 | User ID | nvarchar(100) |
| 24 | $systemId | uniqueidentifier |
| 25 | $systemCreatedAt | datetime |
| 26 | $systemCreatedBy | uniqueidentifier |
| 27 | $systemModifiedAt | datetime |
| 28 | $systemModifiedBy | uniqueidentifier |