Item Journal Line

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Journal Line

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

Table Type: Company

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

Table Number: 83

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Journal Template Name]
   ,[Line No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Entry Type]
   ,[Source No_]
   ,[Document No_]
   ,[Description]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Source Posting Group]
   ,[Quantity]
   ,[Invoiced Quantity]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[Amount]
   ,[Discount Amount]
   ,[Salespers__Purch_ Code]
   ,[Source Code]
   ,[Applies-to Entry]
   ,[Item Shpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Indirect Cost _]
   ,[Source Type]
   ,[Shpt_ Method Code]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Recurring Method]
   ,[Expiration Date]
   ,[Recurring Frequency]
   ,[Drop Shipment]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Country_Region Code]
   ,[New Location Code]
   ,[New Shortcut Dimension 1 Code]
   ,[New Shortcut Dimension 2 Code]
   ,[Qty_ (Calculated)]
   ,[Qty_ (Phys_ Inventory)]
   ,[Last Item Ledger Entry No_]
   ,[Phys_ Inventory]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Entry_Exit Point]
   ,[Document Date]
   ,[External Document No_]
   ,[Area]
   ,[Transaction Specification]
   ,[Posting No_ Series]
   ,[Unit Cost (ACY)]
   ,[Source Currency Code]
   ,[Document Type]
   ,[Document Line No_]
   ,[VAT Reporting Date]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Dimension Set ID]
   ,[New Dimension Set ID]
   ,[Assemble to Order]
   ,[Job No_]
   ,[Job Task No_]
   ,[Job Purchase]
   ,[Job Contract Entry No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[New Bin Code]
   ,[Unit of Measure Code]
   ,[Derived from Blanket Order]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Quantity (Base)]
   ,[Invoiced Qty_ (Base)]
   ,[Level]
   ,[Flushing Method]
   ,[Changed by User]
   ,[Cross-Reference No_]
   ,[Originally Ordered No_]
   ,[Originally Ordered Var_ Code]
   ,[Out-of-Stock Substitution]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Planned Delivery Date]
   ,[Order Date]
   ,[Value Entry Type]
   ,[Item Charge No_]
   ,[Inventory Value (Calculated)]
   ,[Inventory Value (Revalued)]
   ,[Variance Type]
   ,[Inventory Value Per]
   ,[Partial Revaluation]
   ,[Applies-from Entry]
   ,[Invoice No_]
   ,[Unit Cost (Calculated)]
   ,[Unit Cost (Revalued)]
   ,[Applied Amount]
   ,[Update Standard Cost]
   ,[Amount (ACY)]
   ,[Correction]
   ,[Adjustment]
   ,[Applies-to Value Entry]
   ,[Invoice-to Source No_]
   ,[Type]
   ,[No_]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Setup Time]
   ,[Run Time]
   ,[Stop Time]
   ,[Output Quantity]
   ,[Scrap Quantity]
   ,[Concurrent Capacity]
   ,[Setup Time (Base)]
   ,[Run Time (Base)]
   ,[Stop Time (Base)]
   ,[Output Quantity (Base)]
   ,[Scrap Quantity (Base)]
   ,[Cap_ Unit of Measure Code]
   ,[Qty_ per Cap_ Unit of Measure]
   ,[Starting Time]
   ,[Ending Time]
   ,[Routing No_]
   ,[Routing Reference No_]
   ,[Prod_ Order Comp_ Line No_]
   ,[Finished]
   ,[Unit Cost Calculation]
   ,[Subcontracting]
   ,[Stop Code]
   ,[Scrap Code]
   ,[Work Center Group Code]
   ,[Work Shift Code]
   ,[Serial No_]
   ,[Lot No_]
   ,[Warranty Date]
   ,[New Serial No_]
   ,[New Lot No_]
   ,[New Item Expiration Date]
   ,[Item Expiration Date]
   ,[Package No_]
   ,[New Package No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Warehouse Adjustment]
   ,[Direct Transfer]
   ,[Phys Invt Counting Period Code]
   ,[Phys Invt Counting Period Type]
   ,[Overhead Rate]
   ,[Single-Level Material Cost]
   ,[Single-Level Capacity Cost]
   ,[Single-Level Subcontrd_ Cost]
   ,[Single-Level Cap_ Ovhd Cost]
   ,[Single-Level Mfg_ Ovhd Cost]
   ,[Rolled-up Material Cost]
   ,[Rolled-up Capacity Cost]
   ,[Rolled-up Subcontracted Cost]
   ,[Rolled-up Mfg_ Ovhd Cost]
   ,[Rolled-up Cap_ Overhead Cost]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Item 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_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Journal Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Item Journal Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Item Journal Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Journal Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Item Journal Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Item Journal Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Item Journal Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Journal Line].[New Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Item Journal Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Item Journal Line].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Item Journal Line].[Source Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Item Journal Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Item Journal Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Item Journal Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Item Journal Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Item Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Item Journal Line].[New Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Item Journal Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Item Journal Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Item Journal Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Item Journal Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Stop$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stop]
      ON
         [Item Journal Line].[Stop Code] = [Stop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Scrap$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Scrap]
      ON
         [Item Journal Line].[Scrap Code] = [Scrap].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
      ON
         [Item Journal Line].[Work Center Group Code] = [Work Center Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
      ON
         [Item Journal Line].[Work Shift Code] = [Work Shift].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Item Journal Line].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Item Journal Line].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Journal Line table

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

Show/hide example query

SELECT
	       [Item Journal Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Item Journal Line].[Item No_] = [Item].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Purchase”
  • “Sale”
  • “Positive Adjmt.”
  • “Negative Adjmt.”
  • “Transfer”
  • “Consumption”
  • “Output”
  • ” “
  • “Assembly Consumption”
  • “Assembly Output”
6Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Item Journal Line].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Item Journal Line].[Location Code] = [Location].[Code]
10Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
	       [Item Journal Line].[Inventory Posting Group]
	       ,[Inventory Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
	              ON
	                     [Item Journal Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
11Source Posting Group SearchSource Posting GroupNormalCode20Source Posting Groupnvarchar(40)
13Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
15Invoiced Quantity SearchInvoiced QuantityNormalDecimal12Invoiced Quantitydecimal(38,38)
16Unit Amount SearchUnit AmountNormalDecimal12Unit Amountdecimal(38,38)
17Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
18Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
22Discount Amount SearchDiscount AmountNormalDecimal12Discount Amountdecimal(38,38)
23Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Item Journal Line].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Item Journal Line].[Source Code] = [Source Code].[Code]
29Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
32Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
34Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Item Journal Line].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Item Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
37Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
39Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Item”
40Shpt. Method Code SearchShpt. Method CodeNormalCode10Shpt_ Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Item Journal Line].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Item Journal Line].[Reason Code] = [Reason Code].[Code]
43Recurring Method SearchRecurring MethodNormalOption4Recurring Methodint
Available options are:
  • “”
  • “Fixed”
  • “Variable”
44Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
45Recurring Frequency SearchRecurring FrequencyNormalDateFormula32Recurring Frequencyvarchar(32)
46Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
47Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Item Journal Line].[Transport Method]
	       ,[Transport Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
	              ON
	                     [Item Journal Line].[Transport Method] = [Transport Method].[Code]
49Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
50New Location Code SearchNew Location CodeNormalCode10New Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Item Journal Line].[New Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Item Journal Line].[New Location Code] = [Location].[Code]
51New Shortcut Dimension 1 Code SearchNew Shortcut Dimension 1 CodeNormalCode20New Shortcut Dimension 1 Codenvarchar(40)
52New Shortcut Dimension 2 Code SearchNew Shortcut Dimension 2 CodeNormalCode20New Shortcut Dimension 2 Codenvarchar(40)
53Qty. (Calculated) SearchQty. (Calculated)NormalDecimal12Qty_ (Calculated)decimal(38,38)
54Qty. (Phys. Inventory) SearchQty. (Phys. Inventory)NormalDecimal12Qty_ (Phys_ Inventory)decimal(38,38)
55Last Item Ledger Entry No. SearchLast Item Ledger Entry No.NormalInteger4Last Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
	       [Item Journal Line].[Last Item Ledger Entry No_]
	       ,[Item Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
	              ON
	                     [Item Journal Line].[Last Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
56Phys. Inventory SearchPhys. InventoryNormalBoolean4Phys_ Inventorytinyint
57Gen. 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
	       [Item Journal Line].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Item Journal Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
58Gen. 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
	       [Item Journal Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [Item Journal Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
59Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
60Document Date SearchDocument DateNormalDate4Document Datedatetime
62External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
63Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
	       [Item Journal Line].[Posting No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Item Journal Line].[Posting No_ Series] = [No. Series].[Code]
68Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
72Unit Cost (ACY) SearchUnit Cost (ACY)NormalDecimal12Unit Cost (ACY)decimal(38,38)
73Source Currency Code SearchSource Currency CodeNormalCode10Source Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Item Journal Line].[Source Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Item Journal Line].[Source Currency Code] = [Currency].[Code]
79Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Sales Shipment”
  • “Sales Invoice”
  • “Sales Return Receipt”
  • “Sales Credit Memo”
  • “Purchase Receipt”
  • “Purchase Invoice”
  • “Purchase Return Shipment”
  • “Purchase Credit Memo”
  • “Transfer Shipment”
  • “Transfer Receipt”
  • “Service Shipment”
  • “Service Invoice”
  • “Service Credit Memo”
  • “Posted Assembly”
  • “Inventory Receipt”
  • “Inventory Shipment”
  • “Direct Transfer”
80Document Line No. SearchDocument Line No.NormalInteger4Document Line No_int
86VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
90Order Type SearchOrder TypeNormalOption4Order Typeint
Available options are:
  • ” “
  • “Production”
  • “Transfer”
  • “Service”
  • “Assembly”
91Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
92Order Line No. SearchOrder Line No.NormalInteger4Order Line No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Item Journal Line].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Item Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481New Dimension Set ID SearchNew Dimension Set IDNormalInteger4New Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Item Journal Line].[New Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Item Journal Line].[New Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
904Assemble to Order SearchAssemble to OrderNormalBoolean4Assemble to Ordertinyint
1000Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
	       [Item Journal Line].[Job No_]
	       ,[Job].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	              ON
	                     [Item Journal Line].[Job No_] = [Job].[No_]
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Purchase SearchJob PurchaseNormalBoolean4Job Purchasetinyint
1030Job Contract Entry No. SearchJob Contract Entry No.NormalInteger4Job Contract Entry No_int
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Item Journal Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Item 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
	       [Item Journal Line].[Bin Code]
	       ,[Bin].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Item Journal Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5406New Bin Code SearchNew Bin CodeNormalCode20New Bin Codenvarchar(40)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5408Derived from Blanket Order SearchDerived from Blanket OrderNormalBoolean4Derived from Blanket Ordertinyint
5410Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5411Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
5413Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5415Invoiced Qty. (Base) SearchInvoiced Qty. (Base)NormalDecimal12Invoiced Qty_ (Base)decimal(38,38)
5468Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
5560Level SearchLevelNormalInteger4Levelint
5561Flushing Method SearchFlushing MethodNormalOption4Flushing Methodint
Available options are:
  • “Manual”
  • “Forward”
  • “Backward”
  • “Pick + Forward”
  • “Pick + Backward”
5562Changed by User SearchChanged by UserNormalBoolean4Changed by Usertinyint
5700Cross-Reference No. SearchCross-Reference No.NormalCode20Cross-Reference No_nvarchar(40)
5701Originally Ordered No. SearchOriginally Ordered No.NormalCode20Originally Ordered No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Item Journal Line].[Originally Ordered No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Item Journal Line].[Originally Ordered No_] = [Item].[No_]
5702Originally Ordered Var. Code SearchOriginally Ordered Var. CodeNormalCode10Originally Ordered Var_ Codenvarchar(20)
5703Out-of-Stock Substitution SearchOut-of-Stock SubstitutionNormalBoolean4Out-of-Stock Substitutiontinyint
5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
	       [Item Journal Line].[Item Category Code]
	       ,[Item Category].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
	              ON
	                     [Item Journal Line].[Item Category Code] = [Item Category].[Code]
5705Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5706Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
	       [Item Journal Line].[Purchasing Code]
	       ,[Purchasing].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
	              ON
	                     [Item Journal Line].[Purchasing Code] = [Purchasing].[Code]
5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchItem Reference Unit of MeasureNormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
5791Planned Delivery Date SearchPlanned Delivery DateNormalDate4Planned Delivery Datedatetime
5793Order Date SearchOrder DateNormalDate4Order Datedatetime
5800Value Entry Type SearchValue Entry TypeNormalOption4Value Entry Typeint
Available options are:
  • “Direct Cost”
  • “Revaluation”
  • “Rounding”
  • “Indirect Cost”
  • “Variance”
  • “Total”
5801Item Charge No. SearchItem Charge No.NormalCode20Item Charge No_nvarchar(40)
Key to join to the Item Charge table.

Show/hide example query

SELECT
	       [Item Journal Line].[Item Charge No_]
	       ,[Item Charge].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Charge$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge]
	              ON
	                     [Item Journal Line].[Item Charge No_] = [Item Charge].[No_]
5802Inventory Value (Calculated) SearchInventory Value (Calculated)NormalDecimal12Inventory Value (Calculated)decimal(38,38)
5803Inventory Value (Revalued) SearchInventory Value (Revalued)NormalDecimal12Inventory Value (Revalued)decimal(38,38)
5804Variance Type SearchVariance TypeNormalOption4Variance Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Material”
  • “Capacity”
  • “Capacity Overhead”
  • “Manufacturing Overhead”
  • “Subcontracted”
5805Inventory Value Per SearchInventory Value PerNormalOption4Inventory Value Perint
Available options are:
  • ” “
  • “Item”
  • “Location”
  • “Variant”
  • “Location and Variant”
5806Partial Revaluation SearchPartial RevaluationNormalBoolean4Partial Revaluationtinyint
5807Applies-from Entry SearchApplies-from EntryNormalInteger4Applies-from Entryint
5808Invoice No. SearchInvoice No.NormalCode20Invoice No_nvarchar(40)
5809Unit Cost (Calculated) SearchUnit Cost (Calculated)NormalDecimal12Unit Cost (Calculated)decimal(38,38)
5810Unit Cost (Revalued) SearchUnit Cost (Revalued)NormalDecimal12Unit Cost (Revalued)decimal(38,38)
5811Applied Amount SearchApplied AmountNormalDecimal12Applied Amountdecimal(38,38)
5812Update Standard Cost SearchUpdate Standard CostNormalBoolean4Update Standard Costtinyint
5813Amount (ACY) SearchAmount (ACY)NormalDecimal12Amount (ACY)decimal(38,38)
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
5818Adjustment SearchAdjustmentNormalBoolean4Adjustmenttinyint
5819Applies-to Value Entry SearchApplies-to Value EntryNormalInteger4Applies-to Value Entryint
5820Invoice-to Source No. SearchInvoice-to Source No.NormalCode20Invoice-to Source No_nvarchar(40)
5830Type SearchTypeNormalOption4Typeint
Available options are:
  • “Work Center”
  • “Machine Center”
  • ” “
  • “Resource”
5831No. SearchNo.NormalCode20No_nvarchar(40)
5838Operation No. SearchOperation No.NormalCode10Operation No_nvarchar(20)
5839Work Center No. SearchWork Center No.NormalCode20Work Center No_nvarchar(40)
Key to join to the Work Center table.

Show/hide example query

SELECT
	       [Item Journal Line].[Work Center No_]
	       ,[Work Center].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
	              ON
	                     [Item Journal Line].[Work Center No_] = [Work Center].[No_]
5841Setup Time SearchSetup TimeNormalDecimal12Setup Timedecimal(38,38)
5842Run Time SearchRun TimeNormalDecimal12Run Timedecimal(38,38)
5843Stop Time SearchStop TimeNormalDecimal12Stop Timedecimal(38,38)
5846Output Quantity SearchOutput QuantityNormalDecimal12Output Quantitydecimal(38,38)
5847Scrap Quantity SearchScrap QuantityNormalDecimal12Scrap Quantitydecimal(38,38)
5849Concurrent Capacity SearchConcurrent CapacityNormalDecimal12Concurrent Capacitydecimal(38,38)
5851Setup Time (Base) SearchSetup Time (Base)NormalDecimal12Setup Time (Base)decimal(38,38)
5852Run Time (Base) SearchRun Time (Base)NormalDecimal12Run Time (Base)decimal(38,38)
5853Stop Time (Base) SearchStop Time (Base)NormalDecimal12Stop Time (Base)decimal(38,38)
5856Output Quantity (Base) SearchOutput Quantity (Base)NormalDecimal12Output Quantity (Base)decimal(38,38)
5857Scrap Quantity (Base) SearchScrap Quantity (Base)NormalDecimal12Scrap Quantity (Base)decimal(38,38)
5858Cap. Unit of Measure Code SearchCap. Unit of Measure CodeNormalCode10Cap_ Unit of Measure Codenvarchar(20)
Key to join to the Capacity Unit of Measure table.

Show/hide example query

SELECT
	       [Item Journal Line].[Cap_ Unit of Measure Code]
	       ,[Capacity Unit of Measure].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
	              ON
	                     [Item Journal Line].[Cap_ Unit of Measure Code] = [Capacity Unit of Measure].[Code]
5859Qty. per Cap. Unit of Measure SearchQty. per Cap. Unit of MeasureNormalDecimal12Qty_ per Cap_ Unit of Measuredecimal(38,38)
5873Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
5874Ending Time SearchEnding TimeNormalTime4Ending Timedatetime
5882Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
	       [Item Journal Line].[Routing No_]
	       ,[Routing Header].[No_]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
	              ON
	                     [Item Journal Line].[Routing No_] = [Routing Header].[No_]
5883Routing Reference No. SearchRouting Reference No.NormalInteger4Routing Reference No_int
5884Prod. Order Comp. Line No. SearchProd. Order Comp. Line No.NormalInteger4Prod_ Order Comp_ Line No_int
5885Finished SearchFinishedNormalBoolean4Finishedtinyint
5887Unit Cost Calculation SearchUnit Cost CalculationNormalOption4Unit Cost Calculationint
Available options are:
  • “Time”
  • “Units”
5888Subcontracting SearchSubcontractingNormalBoolean4Subcontractingtinyint
5895Stop Code SearchStop CodeNormalCode10Stop Codenvarchar(20)
Key to join to the Stop table.

Show/hide example query

SELECT
	       [Item Journal Line].[Stop Code]
	       ,[Stop].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Stop$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stop]
	              ON
	                     [Item Journal Line].[Stop Code] = [Stop].[Code]
5896Scrap Code SearchScrap CodeNormalCode10Scrap Codenvarchar(20)
Key to join to the Scrap table.

Show/hide example query

SELECT
	       [Item Journal Line].[Scrap Code]
	       ,[Scrap].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Scrap$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Scrap]
	              ON
	                     [Item Journal Line].[Scrap Code] = [Scrap].[Code]
5898Work Center Group Code SearchWork Center Group CodeNormalCode10Work Center Group Codenvarchar(20)
Key to join to the Work Center Group table.

Show/hide example query

SELECT
	       [Item Journal Line].[Work Center Group Code]
	       ,[Work Center Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
	              ON
	                     [Item Journal Line].[Work Center Group Code] = [Work Center Group].[Code]
5899Work Shift Code SearchWork Shift CodeNormalCode10Work Shift Codenvarchar(20)
Key to join to the Work Shift table.

Show/hide example query

SELECT
	       [Item Journal Line].[Work Shift Code]
	       ,[Work Shift].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
	              ON
	                     [Item Journal Line].[Work Shift Code] = [Work Shift].[Code]
6500Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
6501Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6502Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
6503New Serial No. SearchNew Serial No.NormalCode50New Serial No_nvarchar(100)
6504New Lot No. SearchNew Lot No.NormalCode50New Lot No_nvarchar(100)
6505New Item Expiration Date SearchNew Item Expiration DateNormalDate4New Item Expiration Datedatetime
6506Item Expiration Date SearchItem Expiration DateNormalDate4Item Expiration Datedatetime
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
6516New Package No. SearchNew Package No.NormalCode50New Package No_nvarchar(100)
6600Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
	       [Item Journal Line].[Return Reason Code]
	       ,[Return Reason].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
	              ON
	                     [Item Journal Line].[Return Reason Code] = [Return Reason].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7315Warehouse Adjustment SearchWarehouse AdjustmentNormalBoolean4Warehouse Adjustmenttinyint
7316Direct Transfer SearchDirect TransferNormalBoolean4Direct Transfertinyint
7380Phys Invt Counting Period Code SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(20)
Key to join to the Phys. Invt. Counting Period table.

Show/hide example query

SELECT
	       [Item Journal Line].[Phys Invt Counting Period Code]
	       ,[Phys. Invt. Counting Period].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
	              ON
	                     [Item Journal Line].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7381Phys Invt Counting Period Type SearchPhys Invt Counting Period TypeNormalOption4Phys Invt Counting Period Typeint
Available options are:
  • ” “
  • “Item”
  • “SKU”
99000755Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
99000756Single-Level Material Cost SearchSingle-Level Material CostNormalDecimal12Single-Level Material Costdecimal(38,38)
99000757Single-Level Capacity Cost SearchSingle-Level Capacity CostNormalDecimal12Single-Level Capacity Costdecimal(38,38)
99000758Single-Level Subcontrd. Cost SearchSingle-Level Subcontrd. CostNormalDecimal12Single-Level Subcontrd_ Costdecimal(38,38)
99000759Single-Level Cap. Ovhd Cost SearchSingle-Level Cap. Ovhd CostNormalDecimal12Single-Level Cap_ Ovhd Costdecimal(38,38)
99000760Single-Level Mfg. Ovhd Cost SearchSingle-Level Mfg. Ovhd CostNormalDecimal12Single-Level Mfg_ Ovhd Costdecimal(38,38)
99000761Rolled-up Material Cost SearchRolled-up Material CostNormalDecimal12Rolled-up Material Costdecimal(38,38)
99000762Rolled-up Capacity Cost SearchRolled-up Capacity CostNormalDecimal12Rolled-up Capacity Costdecimal(38,38)
99000763Rolled-up Subcontracted Cost SearchRolled-up Subcontracted CostNormalDecimal12Rolled-up Subcontracted Costdecimal(38,38)
99000764Rolled-up Mfg. Ovhd Cost SearchRolled-up Mfg. Ovhd CostNormalDecimal12Rolled-up Mfg_ Ovhd Costdecimal(38,38)
99000765Rolled-up Cap. Overhead Cost SearchRolled-up Cap. Overhead CostNormalDecimal12Rolled-up Cap_ Overhead Costdecimal(38,38)
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
	       [Item Journal Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Item Journal Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Item Journal Line table

Item CategoryLocationProduct GroupSales HeaderSales Header ArchiveUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Journal Line

Leave a Reply

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