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
   [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_]
   ,[$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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Job Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
      ON
         [Job Ledger Entry].[Work Type Code] = [Work Type].[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_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Job Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Job Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Job Ledger Entry].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Job Ledger Entry].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Job Ledger Entry].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Job Ledger Entry].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Job Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
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_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Job Ledger Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Job Ledger Entry].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Job No_]
       ,[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].[No_]
3Posting Date SearchPosting DateNormalDate4Posting Datedatetime
4Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
5Type SearchTypeNormalOption4Typeint
Available options are:
  • “Resource”
  • “Item”
  • “G/L Account”
7No. SearchNo.NormalCode20No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
11Direct Unit Cost (LCY) SearchDirect Unit Cost ($)NormalDecimal12Direct Unit Cost (LCY)decimal(38,38)
12Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
13Total Cost (LCY) SearchTotal Cost ($)NormalDecimal12Total Cost (LCY)decimal(38,38)
14Unit Price (LCY) SearchUnit Price ($)NormalDecimal12Unit Price (LCY)decimal(38,38)
15Total Price (LCY) SearchTotal Price ($)NormalDecimal12Total Price (LCY)decimal(38,38)
16Resource Group No. SearchResource Group No.NormalCode20Resource Group No_nvarchar(40)
Key to join to the Resource Group table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Resource Group No_]
       ,[Resource Group].[No_]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
              ON
                     [Job Ledger Entry].[Resource Group No_] = [Resource Group].[No_]
17Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
29Job Posting Group SearchPosting GroupNormalCode20Job Posting Groupnvarchar(40)
30Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
31Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
32Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Work Type Code]
       ,[Work Type].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
              ON
                     [Job Ledger Entry].[Work Type Code] = [Work Type].[Code]
33Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
37User ID SearchUser IDNormalCode50User IDnvarchar(100)
38Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Job Ledger Entry].[Source Code] = [Source Code].[Code]
40Shpt. Method Code SearchShpt. Method CodeNormalCode10Shpt_ Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Shpt_ 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].[Shpt_ Method Code] = [Shipment Method].[Code]
60Amt. to Post to G/L SearchAmt. to Post to G/LNormalDecimal12Amt_ to Post to G_Ldecimal(38,38)
61Amt. Posted to G/L SearchAmt. Posted to G/LNormalDecimal12Amt_ Posted to G_Ldecimal(38,38)
64Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Usage”
  • “Sale”
75Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
76Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Job Ledger Entry].[Reason Code] = [Reason Code].[Code]
77Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Job Ledger Entry].[Transaction Type] = [Transaction Type].[Code]
78Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Job Ledger Entry].[Transport Method] = [Transport Method].[Code]
79Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
80Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Job Ledger Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
81Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Job Ledger Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
82Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Entry_Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Job Ledger Entry].[Entry_Exit Point] = [Entry/Exit Point].[Code]
83Document Date SearchDocument DateNormalDate4Document Datedatetime
84External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
85Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Job Ledger Entry].[Area] = [Area].[Code]
86Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Job Ledger Entry].[Transaction Specification] = [Transaction Specification].[Code]
87No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Job Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Job Ledger Entry].[No_ Series] = [No. Series].[Code]
88Additional-Currency Total Cost SearchAdditional-Currency Total CostNormalDecimal12Additional-Currency Total Costdecimal(38,38)
89Add.-Currency Total Price SearchAdd.-Currency Total PriceNormalDecimal12Add_-Currency Total Pricedecimal(38,38)
94Add.-Currency Line Amount SearchAdd.-Currency Line AmountNormalDecimal12Add_-Currency Line Amountdecimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Job Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
1000Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1001Line Amount (LCY) SearchLine Amount ($)NormalDecimal12Line Amount (LCY)decimal(38,38)
1002Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
1003Total Cost SearchTotal CostNormalDecimal12Total Costdecimal(38,38)
1004Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
1005Total Price SearchTotal PriceNormalDecimal12Total Pricedecimal(38,38)
1006Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
1007Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
1008Line Discount Amount (LCY) SearchLine Discount Amount ($)NormalDecimal12Line Discount Amount (LCY)decimal(38,38)
1009Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
1010Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
1016Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
1017Ledger Entry Type SearchLedger Entry TypeNormalOption4Ledger Entry Typeint
Available options are:
  • ” “
  • “Resource”
  • “Item”
  • “G/L Account”
1018Ledger Entry No. SearchLedger Entry No.NormalInteger4Ledger Entry No_int
Key to join to the G/L Entry table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Ledger Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [Job Ledger Entry].[Ledger Entry No_] = [G/L Entry].[Entry No_]
1019Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
1020Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
1021Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
1022Line Type SearchLine TypeNormalOption4Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
1023Original Unit Cost (LCY) SearchOriginal Unit Cost ($)NormalDecimal12Original Unit Cost (LCY)decimal(38,38)
1024Original Total Cost (LCY) SearchOriginal Total Cost ($)NormalDecimal12Original Total Cost (LCY)decimal(38,38)
1025Original Unit Cost SearchOriginal Unit CostNormalDecimal12Original Unit Costdecimal(38,38)
1026Original Total Cost SearchOriginal Total CostNormalDecimal12Original Total Costdecimal(38,38)
1027Original Total Cost (ACY) SearchOriginal Total Cost (ACY)NormalDecimal12Original Total Cost (ACY)decimal(38,38)
1028Adjusted SearchAdjustedNormalBoolean4Adjustedtinyint
1029DateTime Adjusted SearchDateTime AdjustedNormalDateTime8DateTime Adjusteddatetime
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Job Ledger Entry].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Job Ledger Entry].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Job Ledger Entry].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5405Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5900Service Order No. SearchService Order No.NormalCode20Service Order No_nvarchar(40)
5901Posted Service Shipment No. SearchPosted Service Shipment No.NormalCode20Posted Service Shipment No_nvarchar(40)
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Job Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Job Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Job Ledger Entry table

Leave a Reply

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