Cost Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesCCost Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1104

Table Type: Company

Table Name: Cost Entry
Database Table Name: CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1104

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 Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Cost Type No_]
   ,[Posting Date]
   ,[Document No_]
   ,[Description]
   ,[Amount]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Cost Center Code]
   ,[Cost Object Code]
   ,[Reason Code]
   ,[G_L Account]
   ,[G_L Entry No_]
   ,[Source Code]
   ,[Allocated]
   ,[Allocated with Journal No_]
   ,[User ID]
   ,[Batch Name]
   ,[Allocation Description]
   ,[Allocation ID]
   ,[Additional-Currency Amount]
   ,[Add_-Currency Debit Amount]
   ,[Add_-Currency Credit Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Cost Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Entry].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Entry].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Cost Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Cost Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
      ON
         [Cost Entry].[Batch Name] = [Gen. Journal Batch].[Journal Template Name]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
      ON
         [Cost Entry].[Allocation ID] = [Cost Allocation Source].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
4Cost Type No. Primary Key SearchCost Type No.NormalCode20Cost Type No_nvarchar(40)
Key to join to the Cost Type table.

Show/hide example query

SELECT
	       [Cost Entry].[Cost Type No_]
	       ,[Cost Type].[No_]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
	              ON
	                     [Cost Entry].[Cost Type No_] = [Cost Type].[No_]
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
16Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
17Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
18Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
20Cost Center Code SearchCost Center CodeNormalCode20Cost Center Codenvarchar(40)
Key to join to the Cost Center table.

Show/hide example query

SELECT
	       [Cost Entry].[Cost Center Code]
	       ,[Cost Center].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
	              ON
	                     [Cost Entry].[Cost Center Code] = [Cost Center].[Code]
21Cost Object Code SearchCost Object CodeNormalCode20Cost Object Codenvarchar(40)
Key to join to the Cost Object table.

Show/hide example query

SELECT
	       [Cost Entry].[Cost Object Code]
	       ,[Cost Object].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
	              ON
	                     [Cost Entry].[Cost Object Code] = [Cost Object].[Code]
27Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [Cost Entry].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Cost Entry].[Reason Code] = [Reason Code].[Code]
28G/L Account SearchG/L AccountNormalCode20G_L Accountnvarchar(40)
29G/L Entry No. SearchG/L Entry No.NormalInteger4G_L Entry No_int
30Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Cost Entry].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Cost Entry].[Source Code] = [Source Code].[Code]
31System-Created Entry SearchSystem-Created EntryNormalBoolean4
32Allocated SearchAllocatedNormalBoolean4Allocatedtinyint
33Allocated with Journal No. SearchAllocated with Register No.NormalInteger4Allocated with Journal No_int
40User ID SearchUser IDNormalCode50User IDnvarchar(100)
41Batch Name SearchBatch NameNormalCode10Batch Namenvarchar(20)
Key to join to the Gen. Journal Batch table.

Show/hide example query

SELECT
	       [Cost Entry].[Batch Name]
	       ,[Gen. Journal Batch].[Journal Template Name]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
	              ON
	                     [Cost Entry].[Batch Name] = [Gen. Journal Batch].[Journal Template Name]
50Allocation Description SearchAllocation DescriptionNormalText80Allocation Descriptionnvarchar(160)
51Allocation ID SearchAllocation IDNormalCode10Allocation IDnvarchar(20)
Key to join to the Cost Allocation Source table.

Show/hide example query

SELECT
	       [Cost Entry].[Allocation ID]
	       ,[Cost Allocation Source].[ID]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
	              ON
	                     [Cost Entry].[Allocation ID] = [Cost Allocation Source].[ID]
68Additional-Currency Amount SearchAdditional-Currency AmountNormalDecimal12Additional-Currency Amountdecimal(38,38)
69Add.-Currency Debit Amount SearchAdd.-Currency Debit AmountNormalDecimal12Add_-Currency Debit Amountdecimal(38,38)
70Add.-Currency Credit Amount SearchAdd.-Currency Credit AmountNormalDecimal12Add_-Currency Credit Amountdecimal(38,38)
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 Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Cost Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Cost Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesCCost Entry

Leave a Reply

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