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: 210

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
   [Journal Template 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]
   ,[Journal Batch Name]
   ,[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]
   ,[$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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Job Journal Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Job Journal Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Journal Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
      ON
         [Job Journal Line].[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 Journal Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Job Journal Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Job Journal Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Job Journal Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Job Journal Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Job Journal Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Job Journal Line].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Job Journal Line].[Source Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Job Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Job Journal Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Job Journal Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job Journal Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name Primary Key SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

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

Show/hide example query

SELECT
       [Job Journal Line].[Resource Group No_]
       ,[Resource Group].[No_]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
              ON
                     [Job Journal Line].[Resource Group No_] = [Resource Group].[No_]
18Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
19Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
20Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
21Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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 SearchChargeableNormalBoolean4Chargeabletinyint
30Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Job Journal Line].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Job Journal Line].[Posting Group] = [Customer Posting Group].[Code]
31Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Job Journal Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job Journal Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
32Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Job Journal Line].[Work Type Code]
       ,[Work Type].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
              ON
                     [Job Journal Line].[Work Type Code] = [Work Type].[Code]
34Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
37Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
40Shpt. Method Code SearchShpt. Method CodeNormalCode10Shpt_ Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Job Journal Line].[Shpt_ 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].[Shpt_ Method Code] = [Shipment Method].[Code]
61Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Usage”
  • “Sale”
62Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Job Journal Line].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Job Journal Line].[Source Code] = [Source Code].[Code]
73Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
74Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Job Journal Line].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Job Journal Line].[Reason Code] = [Reason Code].[Code]
75Recurring Method SearchRecurring MethodNormalOption4Recurring Methodint
Available options are:
  • “”
  • “Fixed”
  • “Variable”
76Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
77Recurring Frequency SearchRecurring FrequencyNormalDateFormula32Recurring Frequencyvarchar(32)
79Gen. 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 Journal Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Job Journal Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
80Gen. 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 Journal Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Job Journal Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
81Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

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

Show/hide example query

SELECT
       [Job Journal Line].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Job Journal Line].[Transport Method] = [Transport Method].[Code]
83Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
86Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Job Journal Line].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Job Journal Line].[Transaction Specification] = [Transaction Specification].[Code]
91Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
92Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Job Journal Line].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Job Journal Line].[Posting No_ Series] = [No. Series].[Code]
93Source Currency Code SearchSource Currency CodeNormalCode10Source Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Job Journal Line].[Source 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].[Source Currency Code] = [Currency].[Code]
94Source Currency Total Cost SearchSource Currency Total CostNormalDecimal12Source Currency Total Costdecimal(38,38)
95Source Currency Total Price SearchSource Currency Total PriceNormalDecimal12Source Currency Total Pricedecimal(38,38)
96Source Currency Line Amount SearchSource Currency Line AmountNormalDecimal12Source 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 Journal Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Job Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
950Time Sheet No. SearchTime Sheet No.NormalCode20Time Sheet No_nvarchar(40)
951Time Sheet Line No. SearchTime Sheet Line No.NormalInteger4Time Sheet Line No_int
952Time Sheet Date SearchTime Sheet DateNormalDate4Time Sheet Datedatetime
1000Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1001Total Cost SearchTotal CostNormalDecimal12Total Costdecimal(38,38)
1002Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
1003Line Type SearchLine TypeNormalOption4Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
1004Applies-from Entry SearchApplies-from EntryNormalInteger4Applies-from Entryint
1005Job Posting Only SearchJob Posting OnlyNormalBoolean4Job Posting Onlytinyint
1006Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
1007Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
1008Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
1009Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
1010Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
1011Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
1012Line Amount (LCY) SearchLine Amount ($)NormalDecimal12Line Amount (LCY)decimal(38,38)
1013Line Discount Amount (LCY) SearchLine Discount Amount ($)NormalDecimal12Line Discount Amount (LCY)decimal(38,38)
1014Total Price SearchTotal PriceNormalDecimal12Total Pricedecimal(38,38)
1015Cost Factor SearchCost FactorNormalDecimal12Cost 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 Journal Line].[Ledger Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [Job Journal Line].[Ledger Entry No_] = [G/L Entry].[Entry No_]
1019Job Planning Line No. SearchJob Planning Line No.NormalInteger4Job Planning Line No_int
1030Remaining Qty. SearchRemaining Qty.NormalDecimal12Remaining Qty_decimal(38,38)
1031Remaining Qty. (Base) SearchRemaining Qty. (Base)NormalDecimal12Remaining Qty_ (Base)decimal(38,38)
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

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

Show/hide example query

SELECT
       [Job Journal Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Job Journal Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5410Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5468Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
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)
6501Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Cost Calculation Method SearchCost Calculation MethodNormalOption4Cost Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
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 Journal Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job Journal Line].[$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 Journal Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job Journal Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Job Journal Line table

Leave a Reply

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