Cost Journal Line

Dynamics 365 BC Table ReferenceTablesCompany TablesCCost Journal Line

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

Table Type: Company

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

Table Number: 1101

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

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

FROM

   [CRONUS UK Ltd_$Cost Journal Line$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 Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
      ON
         [Cost Journal Line].[Cost Center Code] = [Cost Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
      ON
         [Cost Journal Line].[Cost Object Code] = [Cost Object].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Cost Journal Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Cost Journal Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
      ON
         [Cost Journal Line].[Allocation ID] = [Cost Allocation Source].[ID]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
      ON
         [Cost Journal Line].[Budget Name] = [G/L Budget Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cost Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cost Journal Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name Primary Key SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Cost Type No. SearchCost Type No.NormalCode20Cost Type No_nvarchar(40)
Key to join to the Cost Type table.

Show/hide example query

SELECT
       [Cost Journal Line].[Cost Type No_]
       ,[Cost Type].[No_]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
              ON
                     [Cost Journal Line].[Cost Type No_] = [Cost Type].[No_]
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
11Bal. Cost Type No. SearchBal. Cost Type No.NormalCode20Bal_ Cost Type No_nvarchar(40)
Key to join to the Cost Type table.

Show/hide example query

SELECT
       [Cost Journal Line].[Bal_ Cost Type No_]
       ,[Cost Type].[No_]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Type]
              ON
                     [Cost Journal Line].[Bal_ Cost Type No_] = [Cost Type].[No_]
16Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
17Balance SearchBalanceNormalDecimal12Balancedecimal(38,38)
18Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
19Credit 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 Journal Line].[Cost Center Code]
       ,[Cost Center].[Code]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
              ON
                     [Cost Journal Line].[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 Journal Line].[Cost Object Code]
       ,[Cost Object].[Code]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
              ON
                     [Cost Journal Line].[Cost Object Code] = [Cost Object].[Code]
22Bal. Cost Center Code SearchBal. Cost Center CodeNormalCode20Bal_ Cost Center Codenvarchar(40)
Key to join to the Cost Center table.

Show/hide example query

SELECT
       [Cost Journal Line].[Bal_ Cost Center Code]
       ,[Cost Center].[Code]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Center]
              ON
                     [Cost Journal Line].[Bal_ Cost Center Code] = [Cost Center].[Code]
23Bal. Cost Object Code SearchBal. Cost Object CodeNormalCode20Bal_ Cost Object Codenvarchar(40)
Key to join to the Cost Object table.

Show/hide example query

SELECT
       [Cost Journal Line].[Bal_ Cost Object Code]
       ,[Cost Object].[Code]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Object$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Object]
              ON
                     [Cost Journal Line].[Bal_ 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 Journal Line].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Cost Journal Line].[Reason Code] = [Reason Code].[Code]
29G/L Entry No. SearchG/L Entry No.NormalInteger4G_L Entry No_int
Key to join to the G/L Entry table.

Show/hide example query

SELECT
       [Cost Journal Line].[G_L Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [Cost Journal Line].[G_L Entry No_] = [G/L Entry].[Entry No_]
30Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Cost Journal Line].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Cost Journal Line].[Source Code] = [Source Code].[Code]
31System-Created Entry SearchSystem-Created EntryNormalBoolean4
32Cost Entry No. SearchCost Entry No.NormalInteger4Cost Entry No_int
33Allocated SearchAllocatedNormalBoolean4Allocatedtinyint
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 Journal Line].[Allocation ID]
       ,[Cost Allocation Source].[ID]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Cost Allocation Source$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Allocation Source]
              ON
                     [Cost Journal Line].[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)
100Budget Name SearchBudget NameNormalCode10Budget Namenvarchar(20)
Key to join to the G/L Budget Name table.

Show/hide example query

SELECT
       [Cost Journal Line].[Budget Name]
       ,[G/L Budget Name].[Name]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
              ON
                     [Cost Journal Line].[Budget Name] = [G/L Budget Name].[Name]
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 Journal Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cost Journal Line].[$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 Journal Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cost Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cost Journal Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Cost Journal Line table

G/L Budget Name
Dynamics 365 BC Table ReferenceTablesCompany TablesCCost Journal Line

Leave a Reply

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