Res_ Journal Line

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

Table Type: Company

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

Table Number: 207

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Res_ 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_]
   ,[Entry Type]
   ,[Document No_]
   ,[Posting Date]
   ,[Resource No_]
   ,[Resource Group No_]
   ,[Description]
   ,[Work Type Code]
   ,[Job No_]
   ,[Unit of Measure Code]
   ,[Quantity]
   ,[Direct Unit Cost]
   ,[Unit Cost]
   ,[Total Cost]
   ,[Unit Price]
   ,[Total Price]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Source Code]
   ,[Reason Code]
   ,[Recurring Method]
   ,[Expiration Date]
   ,[Recurring Frequency]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Document Date]
   ,[External Document No_]
   ,[Posting No_ Series]
   ,[Source Type]
   ,[Source No_]
   ,[Qty_ per Unit of Measure]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Dimension Set ID]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Time Sheet Date]
   ,[System-Created Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Res_ 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_$Res_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Res_ Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Res_ Journal Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Res_ Journal Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Res_ 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
5Entry Type Searchint
6Document No_ Searchnvarchar(40)
7Posting Date Searchdatetime
8Resource No_ Searchnvarchar(40)
9Resource Group No_ Searchnvarchar(40)
10Description Searchnvarchar(200)
11Work Type Code Searchnvarchar(20)
12Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Res_ Journal Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Res_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Res_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Res_ Journal Line].[Job No_] = [Job].[Job No_]
13Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Res_ Journal Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Res_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Res_ Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Res_ Journal Line].[Unit of Measure Code] = [Unit of Measure].[Code]
14Quantity Searchdecimal(38,38)
15Direct Unit Cost Searchdecimal(38,38)
16Unit Cost Searchdecimal(38,38)
17Total Cost Searchdecimal(38,38)
18Unit Price Searchdecimal(38,38)
19Total Price Searchdecimal(38,38)
20Shortcut Dimension 1 Code Searchnvarchar(40)
21Shortcut Dimension 2 Code Searchnvarchar(40)
22Source Code Searchnvarchar(20)
23Reason Code Searchnvarchar(20)
24Recurring Method Searchint
25Expiration Date Searchdatetime
26Recurring Frequency Searchvarchar(32)
27Gen_ Bus_ Posting Group Searchnvarchar(40)
28Gen_ Prod_ Posting Group Searchnvarchar(40)
29Document Date Searchdatetime
30External Document No_ Searchnvarchar(70)
31Posting No_ Series Searchnvarchar(40)
32Source Type Searchint
33Source No_ Searchnvarchar(40)
34Qty_ per Unit of Measure Searchdecimal(38,38)
35Order Type Searchint
36Order No_ Searchnvarchar(40)
37Order Line No_ Searchint
38Dimension Set ID Searchint
39Time Sheet No_ Searchnvarchar(40)
40Time Sheet Line No_ Searchint
41Time Sheet Date Searchdatetime
42System-Created Entry Searchtinyint
43$systemId Searchuniqueidentifier
44$systemCreatedAt Searchdatetime
45$systemCreatedBy Searchuniqueidentifier
46$systemModifiedAt Searchdatetime
47$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Res_ Journal Line table

Leave a Reply

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