Job Journal Line

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job 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_]
   ,[Job No_]
   ,[Posting Date]
   ,[Document No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Quantity]
   ,[Direct Unit Cost (LCY)]
   ,[Unit Cost (LCY)]
   ,[Total Cost (LCY)]
   ,[Unit Price (LCY)]
   ,[Total Price (LCY)]
   ,[Resource Group No_]
   ,[Unit of Measure Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Location Code]
   ,[Chargeable]
   ,[Posting Group]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Work Type Code]
   ,[Customer Price Group]
   ,[Applies-to Entry]
   ,[Shpt_ Method Code]
   ,[Entry Type]
   ,[Source Code]
   ,[Reason Code]
   ,[Recurring Method]
   ,[Expiration Date]
   ,[Recurring Frequency]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Country_Region Code]
   ,[Entry_Exit Point]
   ,[Document Date]
   ,[External Document No_]
   ,[Area]
   ,[Transaction Specification]
   ,[Serial No_]
   ,[Posting No_ Series]
   ,[Source Currency Code]
   ,[Source Currency Total Cost]
   ,[Source Currency Total Price]
   ,[Source Currency Line Amount]
   ,[Dimension Set ID]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Time Sheet Date]
   ,[Job Task No_]
   ,[Total Cost]
   ,[Unit Price]
   ,[Line Type]
   ,[Applies-from Entry]
   ,[Job Posting Only]
   ,[Line Discount _]
   ,[Line Discount Amount]
   ,[Currency Code]
   ,[Line Amount]
   ,[Currency Factor]
   ,[Unit Cost]
   ,[Line Amount (LCY)]
   ,[Line Discount Amount (LCY)]
   ,[Total Price]
   ,[Cost Factor]
   ,[Description 2]
   ,[Ledger Entry Type]
   ,[Ledger Entry No_]
   ,[Job Planning Line No_]
   ,[Remaining Qty_]
   ,[Remaining Qty_ (Base)]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Quantity (Base)]
   ,[Service Order No_]
   ,[Posted Service Shipment No_]
   ,[Lot No_]
   ,[Package No_]
   ,[Price Calculation Method]
   ,[Cost Calculation Method]
   ,[Shipment Method Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job 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_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Job 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
         [Job Journal Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Job Journal Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Job Journal Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Job Journal Line].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Job Journal Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Journal Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Job Journal Line].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Job 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
5Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Job Journal Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job Journal Line].[Job No_] = [Job].[Job No_]
6Posting Date Searchdatetime
7Document No_ Searchnvarchar(40)
8Type Searchint
9No_ Searchnvarchar(40)
10Description Searchnvarchar(200)
11Quantity Searchdecimal(38,38)
12Direct Unit Cost (LCY) Searchdecimal(38,38)
13Unit Cost (LCY) Searchdecimal(38,38)
14Total Cost (LCY) Searchdecimal(38,38)
15Unit Price (LCY) Searchdecimal(38,38)
16Total Price (LCY) Searchdecimal(38,38)
17Resource Group No_ Searchnvarchar(40)
18Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Job Journal Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Job Journal Line].[Unit of Measure Code] = [Unit of Measure].[Code]
19Qty_ Rounding Precision Searchdecimal(38,38)
20Qty_ Rounding Precision (Base) Searchdecimal(38,38)
21Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Job Journal Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Job Journal Line].[Location Code] = [Location].[Code]
22Chargeable Searchtinyint
23Posting Group Searchnvarchar(40)
24Shortcut Dimension 1 Code Searchnvarchar(40)
25Shortcut Dimension 2 Code Searchnvarchar(40)
26Work Type Code Searchnvarchar(20)
27Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Job Journal Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Job Journal Line].[Customer Price Group] = [Customer Price Group].[Code]
28Applies-to Entry Searchint
29Shpt_ Method Code Searchnvarchar(20)
30Entry Type Searchint
31Source Code Searchnvarchar(20)
32Reason Code Searchnvarchar(20)
33Recurring Method Searchint
34Expiration Date Searchdatetime
35Recurring Frequency Searchvarchar(32)
36Gen_ Bus_ Posting Group Searchnvarchar(40)
37Gen_ Prod_ Posting Group Searchnvarchar(40)
38Transaction Type Searchnvarchar(20)
39Transport Method Searchnvarchar(20)
40Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Job Journal Line].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Job Journal Line].[Country_Region Code] = [Country_Region].[Code]
41Entry_Exit Point Searchnvarchar(20)
42Document Date Searchdatetime
43External Document No_ Searchnvarchar(70)
44Area Searchnvarchar(20)
45Transaction Specification Searchnvarchar(20)
46Serial No_ Searchnvarchar(100)
47Posting No_ Series Searchnvarchar(40)
48Source Currency Code Searchnvarchar(20)
49Source Currency Total Cost Searchdecimal(38,38)
50Source Currency Total Price Searchdecimal(38,38)
51Source Currency Line Amount Searchdecimal(38,38)
52Dimension Set ID Searchint
53Time Sheet No_ Searchnvarchar(40)
54Time Sheet Line No_ Searchint
55Time Sheet Date Searchdatetime
56Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Job Journal Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Job Journal Line].[Job Task No_] = [Job Task].[Job Task No_]
57Total Cost Searchdecimal(38,38)
58Unit Price Searchdecimal(38,38)
59Line Type Searchint
60Applies-from Entry Searchint
61Job Posting Only Searchtinyint
62Line Discount _ Searchdecimal(38,38)
63Line Discount Amount Searchdecimal(38,38)
64Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Job Journal Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Job Journal Line].[Currency Code] = [Currency].[Code]
65Line Amount Searchdecimal(38,38)
66Currency Factor Searchdecimal(38,38)
67Unit Cost Searchdecimal(38,38)
68Line Amount (LCY) Searchdecimal(38,38)
69Line Discount Amount (LCY) Searchdecimal(38,38)
70Total Price Searchdecimal(38,38)
71Cost Factor Searchdecimal(38,38)
72Description 2 Searchnvarchar(100)
73Ledger Entry Type Searchint
74Ledger Entry No_ Searchint
75Job Planning Line No_ Searchint
76Remaining Qty_ Searchdecimal(38,38)
77Remaining Qty_ (Base) Searchdecimal(38,38)
78Variant Code Searchnvarchar(20)
79Bin Code Searchnvarchar(40)
80Qty_ per Unit of Measure Searchdecimal(38,38)
81Quantity (Base) Searchdecimal(38,38)
82Service Order No_ Searchnvarchar(40)
83Posted Service Shipment No_ Searchnvarchar(40)
84Lot No_ Searchnvarchar(100)
85Package No_ Searchnvarchar(100)
86Price Calculation Method Searchint
87Cost Calculation Method Searchint
88Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Job Journal Line].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Job Journal Line].[Shipment Method Code] = [Shipment Method].[Code]
89$systemId Searchuniqueidentifier
90$systemCreatedAt Searchdatetime
91$systemCreatedBy Searchuniqueidentifier
92$systemModifiedAt Searchdatetime
93$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job Journal Line table

Leave a Reply

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