Item 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: 0

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

Show/hide columns in Item Journal Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name 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
       [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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Journal Line].[Item No_] = [Item].[No_]
6Posting Date Searchdatetime
7Entry Type Searchint
8Source No_ Searchnvarchar(40)
9Document No_ Searchnvarchar(40)
10Description Searchnvarchar(200)
11Location Code Searchnvarchar(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]
12Inventory Posting Group Searchnvarchar(40)
13Source Posting Group Searchnvarchar(40)
14Quantity Searchdecimal(38,38)
15Invoiced Quantity Searchdecimal(38,38)
16Unit Amount Searchdecimal(38,38)
17Unit Cost Searchdecimal(38,38)
18Amount Searchdecimal(38,38)
19Discount Amount Searchdecimal(38,38)
20Salespers__Purch_ Code Searchnvarchar(40)
21Source Code Searchnvarchar(20)
22Applies-to Entry Searchint
23Item Shpt_ Entry No_ Searchint
24Shortcut Dimension 1 Code Searchnvarchar(40)
25Shortcut Dimension 2 Code Searchnvarchar(40)
26Indirect Cost _ Searchdecimal(38,38)
27Source Type Searchint
28Shpt_ Method Code Searchnvarchar(20)
29Reason Code Searchnvarchar(20)
30Recurring Method Searchint
31Expiration Date Searchdatetime
32Recurring Frequency Searchvarchar(32)
33Drop Shipment Searchtinyint
34Transaction Type Searchnvarchar(20)
35Transport Method Searchnvarchar(20)
36Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Item Journal Line].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Item Journal Line].[Country_Region Code] = [Country_Region].[Code]
37New Location Code Searchnvarchar(20)
38New Shortcut Dimension 1 Code Searchnvarchar(40)
39New Shortcut Dimension 2 Code Searchnvarchar(40)
40Qty_ (Calculated) Searchdecimal(38,38)
41Qty_ (Phys_ Inventory) Searchdecimal(38,38)
42Last Item Ledger Entry No_ Searchint
43Phys_ Inventory Searchtinyint
44Gen_ Bus_ Posting Group Searchnvarchar(40)
45Gen_ Prod_ Posting Group Searchnvarchar(40)
46Entry_Exit Point Searchnvarchar(20)
47Document Date Searchdatetime
48External Document No_ Searchnvarchar(70)
49Area Searchnvarchar(20)
50Transaction Specification Searchnvarchar(20)
51Posting No_ Series Searchnvarchar(40)
52Unit Cost (ACY) Searchdecimal(38,38)
53Source Currency Code Searchnvarchar(20)
54Document Type Searchint
55Document Line No_ Searchint
56Order Type Searchint
57Order No_ Searchnvarchar(40)
58Order Line No_ Searchint
59Dimension Set ID Searchint
60New Dimension Set ID Searchint
61Assemble to Order Searchtinyint
62Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Item Journal Line].[Job No_]
       ,[Job].[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].[Job No_]
63Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Item Journal Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Item Journal Line].[Job Task No_] = [Job Task].[Job Task No_]
64Job Purchase Searchtinyint
65Job Contract Entry No_ Searchint
66Variant Code Searchnvarchar(20)
67Bin Code Searchnvarchar(40)
68Qty_ per Unit of Measure Searchdecimal(38,38)
69New Bin Code Searchnvarchar(40)
70Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Item Journal Line].[Unit of Measure Code]
       ,[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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Item Journal Line].[Unit of Measure Code] = [Unit of Measure].[Code]
71Derived from Blanket Order Searchtinyint
72Qty_ Rounding Precision Searchdecimal(38,38)
73Qty_ Rounding Precision (Base) Searchdecimal(38,38)
74Quantity (Base) Searchdecimal(38,38)
75Invoiced Qty_ (Base) Searchdecimal(38,38)
76Level Searchint
77Flushing Method Searchint
78Changed by User Searchtinyint
79Cross-Reference No_ Searchnvarchar(40)
80Originally Ordered No_ Searchnvarchar(40)
81Originally Ordered Var_ Code Searchnvarchar(20)
82Out-of-Stock Substitution Searchtinyint
83Item Category Code Searchnvarchar(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]
84Nonstock Searchtinyint
85Purchasing Code Searchnvarchar(20)
86Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Item Journal Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Item Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Item Journal Line].[Product Group Code] = [Product Group].[Code]
87Item Reference No_ Searchnvarchar(100)
88Planned Delivery Date Searchdatetime
89Order Date Searchdatetime
90Value Entry Type Searchint
91Item Charge No_ Searchnvarchar(40)
92Inventory Value (Calculated) Searchdecimal(38,38)
93Inventory Value (Revalued) Searchdecimal(38,38)
94Variance Type Searchint
95Inventory Value Per Searchint
96Partial Revaluation Searchtinyint
97Applies-from Entry Searchint
98Invoice No_ Searchnvarchar(40)
99Unit Cost (Calculated) Searchdecimal(38,38)
100Unit Cost (Revalued) Searchdecimal(38,38)
101Applied Amount Searchdecimal(38,38)
102Update Standard Cost Searchtinyint
103Amount (ACY) Searchdecimal(38,38)
104Correction Searchtinyint
105Adjustment Searchtinyint
106Applies-to Value Entry Searchint
107Invoice-to Source No_ Searchnvarchar(40)
108Type Searchint
109No_ Searchnvarchar(40)
110Operation No_ Searchnvarchar(20)
111Work Center No_ Searchnvarchar(40)
112Setup Time Searchdecimal(38,38)
113Run Time Searchdecimal(38,38)
114Stop Time Searchdecimal(38,38)
115Output Quantity Searchdecimal(38,38)
116Scrap Quantity Searchdecimal(38,38)
117Concurrent Capacity Searchdecimal(38,38)
118Setup Time (Base) Searchdecimal(38,38)
119Run Time (Base) Searchdecimal(38,38)
120Stop Time (Base) Searchdecimal(38,38)
121Output Quantity (Base) Searchdecimal(38,38)
122Scrap Quantity (Base) Searchdecimal(38,38)
123Cap_ Unit of Measure Code Searchnvarchar(20)
124Qty_ per Cap_ Unit of Measure Searchdecimal(38,38)
125Starting Time Searchdatetime
126Ending Time Searchdatetime
127Routing No_ Searchnvarchar(40)
128Routing Reference No_ Searchint
129Prod_ Order Comp_ Line No_ Searchint
130Finished Searchtinyint
131Unit Cost Calculation Searchint
132Subcontracting Searchtinyint
133Stop Code Searchnvarchar(20)
134Scrap Code Searchnvarchar(20)
135Work Center Group Code Searchnvarchar(20)
136Work Shift Code Searchnvarchar(20)
137Serial No_ Searchnvarchar(100)
138Lot No_ Searchnvarchar(100)
139Warranty Date Searchdatetime
140New Serial No_ Searchnvarchar(100)
141New Lot No_ Searchnvarchar(100)
142New Item Expiration Date Searchdatetime
143Item Expiration Date Searchdatetime
144Package No_ Searchnvarchar(100)
145New Package No_ Searchnvarchar(100)
146Return Reason Code Searchnvarchar(20)
147Price Calculation Method Searchint
148Warehouse Adjustment Searchtinyint
149Direct Transfer Searchtinyint
150Phys Invt Counting Period Code Searchnvarchar(20)
151Phys Invt Counting Period Type Searchint
152Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Item Journal Line].[Shipment 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].[Shipment Method Code] = [Shipment Method].[Code]
153Overhead Rate Searchdecimal(38,38)
154Single-Level Material Cost Searchdecimal(38,38)
155Single-Level Capacity Cost Searchdecimal(38,38)
156Single-Level Subcontrd_ Cost Searchdecimal(38,38)
157Single-Level Cap_ Ovhd Cost Searchdecimal(38,38)
158Single-Level Mfg_ Ovhd Cost Searchdecimal(38,38)
159Rolled-up Material Cost Searchdecimal(38,38)
160Rolled-up Capacity Cost Searchdecimal(38,38)
161Rolled-up Subcontracted Cost Searchdecimal(38,38)
162Rolled-up Mfg_ Ovhd Cost Searchdecimal(38,38)
163Rolled-up Cap_ Overhead Cost Searchdecimal(38,38)
164$systemId Searchuniqueidentifier
165$systemCreatedAt Searchdatetime
166$systemCreatedBy Searchuniqueidentifier
167$systemModifiedAt Searchdatetime
168$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Journal Line table

Leave a Reply

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