Job Ledger Entry

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

Table Type: Company

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

Table Number: 169

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 Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry 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]
   ,[Location Code]
   ,[Job Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Work Type Code]
   ,[Customer Price Group]
   ,[User ID]
   ,[Source Code]
   ,[Shpt_ Method Code]
   ,[Amt_ to Post to G_L]
   ,[Amt_ Posted to G_L]
   ,[Entry Type]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Country_Region Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Entry_Exit Point]
   ,[Document Date]
   ,[External Document No_]
   ,[Area]
   ,[Transaction Specification]
   ,[No_ Series]
   ,[Additional-Currency Total Cost]
   ,[Add_-Currency Total Price]
   ,[Add_-Currency Line Amount]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Line Amount (LCY)]
   ,[Unit Cost]
   ,[Total Cost]
   ,[Unit Price]
   ,[Total Price]
   ,[Line Amount]
   ,[Line Discount Amount]
   ,[Line Discount Amount (LCY)]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Description 2]
   ,[Ledger Entry Type]
   ,[Ledger Entry No_]
   ,[Serial No_]
   ,[Lot No_]
   ,[Line Discount _]
   ,[Line Type]
   ,[Original Unit Cost (LCY)]
   ,[Original Total Cost (LCY)]
   ,[Original Unit Cost]
   ,[Original Total Cost]
   ,[Original Total Cost (ACY)]
   ,[Adjusted]
   ,[DateTime Adjusted]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Quantity (Base)]
   ,[Service Order No_]
   ,[Posted Service Shipment No_]
   ,[Package No_]
   ,[Shipment Method Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job Ledger Entry$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 Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Job Ledger Entry].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Job Ledger Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Job Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Job Ledger Entry].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Job Ledger Entry].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Job Ledger Entry].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Job Ledger Entry].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Job Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Job Ledger Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Job Ledger Entry].[Location Code] = [Location].[Code]
18Job Posting Group Searchnvarchar(40)
19Global Dimension 1 Code Searchnvarchar(40)
20Global Dimension 2 Code Searchnvarchar(40)
21Work Type Code Searchnvarchar(20)
22Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Job Ledger Entry].[Customer Price Group] = [Customer Price Group].[Code]
23User ID Searchnvarchar(100)
24Source Code Searchnvarchar(20)
25Shpt_ Method Code Searchnvarchar(20)
26Amt_ to Post to G_L Searchdecimal(38,38)
27Amt_ Posted to G_L Searchdecimal(38,38)
28Entry Type Searchint
29Journal Batch Name Searchnvarchar(20)
30Reason Code Searchnvarchar(20)
31Transaction Type Searchnvarchar(20)
32Transport Method Searchnvarchar(20)
33Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Job Ledger Entry].[Country_Region Code] = [Country_Region].[Code]
34Gen_ Bus_ Posting Group Searchnvarchar(40)
35Gen_ Prod_ Posting Group Searchnvarchar(40)
36Entry_Exit Point Searchnvarchar(20)
37Document Date Searchdatetime
38External Document No_ Searchnvarchar(70)
39Area Searchnvarchar(20)
40Transaction Specification Searchnvarchar(20)
41No_ Series Searchnvarchar(40)
42Additional-Currency Total Cost Searchdecimal(38,38)
43Add_-Currency Total Price Searchdecimal(38,38)
44Add_-Currency Line Amount Searchdecimal(38,38)
45Dimension Set ID Searchint
46Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Job Ledger Entry].[Job Task No_] = [Job Task].[Job Task No_]
47Line Amount (LCY) Searchdecimal(38,38)
48Unit Cost Searchdecimal(38,38)
49Total Cost Searchdecimal(38,38)
50Unit Price Searchdecimal(38,38)
51Total Price Searchdecimal(38,38)
52Line Amount Searchdecimal(38,38)
53Line Discount Amount Searchdecimal(38,38)
54Line Discount Amount (LCY) Searchdecimal(38,38)
55Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Job Ledger Entry].[Currency Code] = [Currency].[Code]
56Currency Factor Searchdecimal(38,38)
57Description 2 Searchnvarchar(100)
58Ledger Entry Type Searchint
59Ledger Entry No_ Searchint
60Serial No_ Searchnvarchar(100)
61Lot No_ Searchnvarchar(100)
62Line Discount _ Searchdecimal(38,38)
63Line Type Searchint
64Original Unit Cost (LCY) Searchdecimal(38,38)
65Original Total Cost (LCY) Searchdecimal(38,38)
66Original Unit Cost Searchdecimal(38,38)
67Original Total Cost Searchdecimal(38,38)
68Original Total Cost (ACY) Searchdecimal(38,38)
69Adjusted Searchtinyint
70DateTime Adjusted Searchdatetime
71Variant Code Searchnvarchar(20)
72Bin Code Searchnvarchar(40)
73Qty_ per Unit of Measure Searchdecimal(38,38)
74Quantity (Base) Searchdecimal(38,38)
75Service Order No_ Searchnvarchar(40)
76Posted Service Shipment No_ Searchnvarchar(40)
77Package No_ Searchnvarchar(100)
78Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Job Ledger Entry].[Shipment Method Code] = [Shipment Method].[Code]
79$systemId Searchuniqueidentifier
80$systemCreatedAt Searchdatetime
81$systemCreatedBy Searchuniqueidentifier
82$systemModifiedAt Searchdatetime
83$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job Ledger Entry table

Leave a Reply

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