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
   [timestamp]
   ,[Journal Template Name]
   ,[Standard Journal Code]
   ,[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 _]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Standard Item Journal Line].[Item No_] = [Item].[No_]
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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Standard Item Journal Line].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Standard Item Journal Line].[Unit of Measure Code] = [Unit of Measure].[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_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Standard Item Journal Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Standard Item Journal Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Standard Journal Code Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Standard Item Journal Line].[Item No_] = [Item].[No_]
6Entry Type Searchint
7Description Searchnvarchar(200)
8Location Code Searchnvarchar(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]
9Inventory Posting Group Searchnvarchar(40)
10Quantity Searchdecimal(38,38)
11Unit Amount Searchdecimal(38,38)
12Unit Cost Searchdecimal(38,38)
13Amount Searchdecimal(38,38)
14Salespers__Purch_ Code Searchnvarchar(40)
15Source Code Searchnvarchar(20)
16Shortcut Dimension 1 Code Searchnvarchar(40)
17Shortcut Dimension 2 Code Searchnvarchar(40)
18Indirect Cost _ Searchdecimal(38,38)
19Reason Code Searchnvarchar(20)
20Transaction Type Searchnvarchar(20)
21Transport Method Searchnvarchar(20)
22Country_Region Code Searchnvarchar(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]
23Qty_ (Calculated) Searchdecimal(38,38)
24Qty_ (Phys_ Inventory) Searchdecimal(38,38)
25Phys_ Inventory Searchtinyint
26Gen_ Bus_ Posting Group Searchnvarchar(40)
27Gen_ Prod_ Posting Group Searchnvarchar(40)
28Entry_Exit Point Searchnvarchar(20)
29Area Searchnvarchar(20)
30Transaction Specification Searchnvarchar(20)
31Posting No_ Series Searchnvarchar(40)
32Dimension Set ID Searchint
33Variant Code Searchnvarchar(20)
34Bin Code Searchnvarchar(40)
35Qty_ per Unit of Measure Searchdecimal(38,38)
36Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Standard Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Standard Item Journal Line].[Unit of Measure Code] = [Unit of Measure].[Code]
37Qty_ Rounding Precision Searchdecimal(38,38)
38Qty_ Rounding Precision (Base) Searchdecimal(38,38)
39Quantity (Base) Searchdecimal(38,38)
40Originally Ordered No_ Searchnvarchar(40)
41Originally Ordered Var_ Code Searchnvarchar(20)
42Item Category Code Searchnvarchar(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]
43Nonstock Searchtinyint
44Purchasing Code Searchnvarchar(20)
45Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Standard Item Journal Line].[Product Group Code]
       ,[Product 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_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Standard Item Journal Line].[Product Group Code] = [Product Group].[Code]
46Value Entry Type Searchint
47Item Charge No_ Searchnvarchar(40)
48Correction Searchtinyint
49Work Center No_ Searchnvarchar(40)
50Return Reason Code Searchnvarchar(20)
51Price Calculation Method Searchint
52Overhead Rate Searchdecimal(38,38)
53$systemId Searchuniqueidentifier
54$systemCreatedAt Searchdatetime
55$systemCreatedBy Searchuniqueidentifier
56$systemModifiedAt Searchdatetime
57$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Standard Item Journal Line table

Leave a Reply

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