Cost 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Cost Type No_ Searchnvarchar(40)
6Posting Date Searchdatetime
7Document No_ Searchnvarchar(40)
8Description Searchnvarchar(200)
9Bal_ Cost Type No_ Searchnvarchar(40)
10Amount Searchdecimal(38,38)
11Balance Searchdecimal(38,38)
12Debit Amount Searchdecimal(38,38)
13Credit Amount Searchdecimal(38,38)
14Cost Center Code Searchnvarchar(40)
15Cost Object Code Searchnvarchar(40)
16Bal_ Cost Center Code Searchnvarchar(40)
17Bal_ Cost Object Code Searchnvarchar(40)
18Reason Code Searchnvarchar(20)
19G_L Entry No_ Searchint
20Source Code Searchnvarchar(20)
21System-Created Entry Searchtinyint
22Cost Entry No_ Searchint
23Allocated Searchtinyint
24Allocation Description Searchnvarchar(160)
25Allocation ID Searchnvarchar(20)
26Additional-Currency Amount Searchdecimal(38,38)
27Add_-Currency Debit Amount Searchdecimal(38,38)
28Add_-Currency Credit Amount Searchdecimal(38,38)
29Budget Name Searchnvarchar(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 Searchuniqueidentifier
31$systemCreatedAt Searchdatetime
32$systemCreatedBy Searchuniqueidentifier
33$systemModifiedAt Searchdatetime
34$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Cost Journal Line table

Leave a Reply

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