Standard Item Journal Line

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

Table Type: Company

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

Table Number: 753

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Standard 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_]
   ,[Entry Type]
   ,[Description]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Quantity]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[Amount]
   ,[Salespers__Purch_ Code]
   ,[Source Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Indirect Cost _]
   ,[Standard Journal Code]
   ,[Reason Code]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Country_Region Code]
   ,[Qty_ (Calculated)]
   ,[Qty_ (Phys_ Inventory)]
   ,[Phys_ Inventory]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Entry_Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Posting No_ Series]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Quantity (Base)]
   ,[Originally Ordered No_]
   ,[Originally Ordered Var_ Code]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Value Entry Type]
   ,[Item Charge No_]
   ,[Correction]
   ,[Work Center No_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Overhead Rate]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Standard 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_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Standard 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
         [Standard 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
         [Standard Item Journal Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Standard Item Journal Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Standard 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
         [Standard Item Journal Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Standard Item Journal Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Standard Item Journal Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Standard Item Journal Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Standard Item Journal Line].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Standard Item Journal Line].[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
         [Standard Item Journal Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Standard Item Journal Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Standard Item Journal Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Standard Item Journal Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Standard Item Journal Line].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Standard Item Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Standard Item Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Standard Item 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
3Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Standard Item Journal Line].[Item No_] = [Item].[No_]
5Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Purchase”
  • “Sale”
  • “Positive Adjmt.”
  • “Negative Adjmt.”
  • “Transfer”
  • “Consumption”
  • “Output”
  • ” “
  • “Assembly Consumption”
  • “Assembly Output”
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Standard Item Journal Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
13Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Unit Amount SearchUnit AmountNormalDecimal12Unit Amountdecimal(38,38)
17Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
18Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
23Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Standard Item Journal Line].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

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

Show/hide example query

SELECT
       [Standard Item Journal Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Standard Item Journal Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
37Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
41Standard Journal Code Primary Key SearchStandard Journal CodeNormalCode10Standard Journal Codenvarchar(20)
42Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

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

Show/hide example query

SELECT
       [Standard Item Journal Line].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Standard Item Journal Line].[Transport Method] = [Transport Method].[Code]
49Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Standard Item Journal Line].[Country_Region Code] = [Country/Region].[Code]
53Qty. (Calculated) SearchQty. (Calculated)NormalDecimal12Qty_ (Calculated)decimal(38,38)
54Qty. (Phys. Inventory) SearchQty. (Phys. Inventory)NormalDecimal12Qty_ (Phys_ Inventory)decimal(38,38)
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
       [Standard Item Journal Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Standard Item Journal Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
59Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Entry_Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Standard Item Journal Line].[Entry_Exit Point] = [Entry/Exit Point].[Code]
63Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Standard Item Journal Line].[Posting No_ Series] = [No. Series].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Standard Item Journal Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Standard Item Journal Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
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)
5701Originally Ordered No. SearchOriginally Ordered No.NormalCode20Originally Ordered No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

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

Show/hide example query

SELECT
       [Standard Item Journal Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Standard 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
       [Standard Item Journal Line].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Standard Item Journal Line].[Purchasing Code] = [Purchasing].[Code]
5707Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
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
       [Standard Item Journal Line].[Item Charge No_]
       ,[Item Charge].[No_]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Charge$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge]
              ON
                     [Standard Item Journal Line].[Item Charge No_] = [Item Charge].[No_]
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
5839Work Center No. SearchWork Center No.NormalCode20Work Center No_nvarchar(40)
Key to join to the Work Center table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Work Center No_]
       ,[Work Center].[No_]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
              ON
                     [Standard Item Journal Line].[Work Center No_] = [Work Center].[No_]
6600Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Return Reason Code]
       ,[Return Reason].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
              ON
                     [Standard Item Journal Line].[Return Reason Code] = [Return Reason].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
99000755Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(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
       [Standard Item Journal Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Standard Item 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
       [Standard Item Journal Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Standard Item Journal Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Standard Item Journal Line table

Leave a Reply

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