Cost Journal Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost 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

   [timestamp]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[Line No_]
   ,[Cost Type No_]
   ,[Posting Date]
   ,[Document No_]
   ,[Description]
   ,[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]
   ,[System-Created Entry]
   ,[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_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
      ON
         [Cost Journal Line].[Budget Name] = [G_L Budget Name].[Budget Name]

Show/hide columns in Cost Journal Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Journal Template Name	nvarchar(20)
3	Journal Batch Name	nvarchar(20)
4	Line No_	int
5	Cost Type No_	nvarchar(40)
6	Posting Date	datetime
7	Document No_	nvarchar(40)
8	Description	nvarchar(200)
9	Bal_ Cost Type No_	nvarchar(40)
10	Amount	decimal(38,38)
11	Balance	decimal(38,38)
12	Debit Amount	decimal(38,38)
13	Credit Amount	decimal(38,38)
14	Cost Center Code	nvarchar(40)
15	Cost Object Code	nvarchar(40)
16	Bal_ Cost Center Code	nvarchar(40)
17	Bal_ Cost Object Code	nvarchar(40)
18	Reason Code	nvarchar(20)
19	G_L Entry No_	int
20	Source Code	nvarchar(20)
21	System-Created Entry	tinyint
22	Cost Entry No_	int
23	Allocated	tinyint
24	Allocation Description	nvarchar(160)
25	Allocation ID	nvarchar(20)
26	Additional-Currency Amount	decimal(38,38)
27	Add_-Currency Debit Amount	decimal(38,38)
28	Add_-Currency Credit Amount	decimal(38,38)
29	Budget Name	nvarchar(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].[Budget 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].[Budget Name]
30	$systemId	uniqueidentifier
31	$systemCreatedAt	datetime
32	$systemCreatedBy	uniqueidentifier
33	$systemModifiedAt	datetime
34	$systemModifiedBy	uniqueidentifier