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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
      ON
         [Cost Allocation Target].[Target Cost Type] = [Cost Type].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Allocation Target].[Target Cost Center] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Allocation Target].[Target Cost Object] = [Cost Object].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Allocation Target].[Cost Center Filter] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Allocation Target].[Cost Object Filter] = [Cost Object].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Allocation Target].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Allocation Target].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Allocation Target table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalCode10IDnvarchar(20)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Target Cost Type SearchTarget Cost TypeNormalCode20Target Cost Typenvarchar(40)
Key to join to the Cost Type table.

Show/hide example query

SELECT
       [Cost Allocation Target].[Target Cost Type]
       ,[Cost Type].[No_]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
              ON
                     [Cost Allocation Target].[Target Cost Type] = [Cost Type].[No_]
6Target Cost Center SearchTarget Cost CenterNormalCode20Target Cost Centernvarchar(40)
Key to join to the Cost Center table.

Show/hide example query

SELECT
       [Cost Allocation Target].[Target Cost Center]
       ,[Cost Center].[Code]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
              ON
                     [Cost Allocation Target].[Target Cost Center] = [Cost Center].[Code]
7Target Cost Object SearchTarget Cost ObjectNormalCode20Target Cost Objectnvarchar(40)
Key to join to the Cost Object table.

Show/hide example query

SELECT
       [Cost Allocation Target].[Target Cost Object]
       ,[Cost Object].[Code]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
              ON
                     [Cost Allocation Target].[Target Cost Object] = [Cost Object].[Code]
8Static Base SearchStatic BaseNormalDecimal12Static Basedecimal(38,38)
9Static Weighting SearchStatic WeightingNormalDecimal12Static Weightingdecimal(38,38)
10Share SearchShareNormalDecimal12Sharedecimal(38,38)
11Percent SearchPercentNormalDecimal12Percentdecimal(38,38)
20Comment SearchCommentNormalText50Commentnvarchar(100)
30Base SearchBaseNormalOption4Baseint
Available options are:
  • “Static”
  • “G/L Entries”
  • “G/L Budget Entries”
  • “Cost Type Entries”
  • “Cost Budget Entries”
  • “No of Employees”
  • “Items Sold (Qty.)”
  • “Items Purchased (Qty.)”
  • “Items Sold (Amount)”
  • “Items Purchased (Amount)”
31No. Filter SearchNo. FilterNormalText250No_ Filternvarchar(500)
32Cost Center Filter SearchCost Center FilterNormalText250Cost Center Filternvarchar(500)
Key to join to the Cost Center table.

Show/hide example query

SELECT
       [Cost Allocation Target].[Cost Center Filter]
       ,[Cost Center].[Code]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
              ON
                     [Cost Allocation Target].[Cost Center Filter] = [Cost Center].[Code]
33Cost Object Filter SearchCost Object FilterNormalText250Cost Object Filternvarchar(500)
Key to join to the Cost Object table.

Show/hide example query

SELECT
       [Cost Allocation Target].[Cost Object Filter]
       ,[Cost Object].[Code]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
              ON
                     [Cost Allocation Target].[Cost Object Filter] = [Cost Object].[Code]
34Date Filter Code SearchDate Filter CodeNormalOption4Date Filter Codeint
Available options are:
  • ” “
  • “Week”
  • “Last Week”
  • “Month”
  • “Last Month”
  • “Month of Last Year”
  • “Year”
  • “Last Year”
  • “Period”
  • “Last Period”
  • “Period of Last Year”
  • “Fiscal Year”
  • “Last Fiscal Year”
35Group Filter SearchGroup FilterNormalText250Group Filternvarchar(500)
38Allocation Target Type SearchAllocation Target TypeNormalOption4Allocation Target Typeint
Available options are:
  • “All Costs”
  • “Percent per Share”
  • “Amount per Share”
40Percent per Share SearchPercent per ShareNormalDecimal12Percent per Sharedecimal(38,38)
41Amount per Share SearchAmount per ShareNormalDecimal12Amount per Sharedecimal(38,38)
50Share Updated on SearchShare Updated onNormalDate4Share Updated ondatetime
60Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
61User ID SearchUser IDNormalCode50User IDnvarchar(100)
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 Allocation Target].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cost Allocation Target].[$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 Allocation Target].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cost Allocation Target$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Target]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cost Allocation Target].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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