XPT / Schema / Item Journal Line

Item Journal Line #83

Other table in Microsoft Dynamics 365 Business Central. 185 fields, 1 records in Cronus demo.

The Item Journal Line table is the staging area for all item-related journal transactions in Business Central. Every time you post an inventory adjustment, positive or negative entry, reclassification, or physical inventory count, the data passes through this table before it hits the ledger. It is one of the most heavily referenced tables in manufacturing and warehouse scenarios.

COMMON USE CASES
185
Fields
1
Records
3
Primary key
3
FlowFields
50
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Line No., Journal Batch Name.

All fields (185)

Item Journal Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Journal Template Name PK Code Normal → Item Journal Template #82
2 Line No. PK Integer Normal
3 Item No. Code Normal → Item #27
4 Posting Date Date Normal
5 Entry Type Option Normal
6 Source No. Code Normal
7 Document No. Code Normal
8 Description Text Normal
9 Location Code Code Normal → Location #14
10 Inventory Posting Group Code Normal → Inventory Posting Group #94
11 Source Posting Group Code Normal
13 Quantity Decimal Normal
15 Invoiced Quantity Decimal Normal
16 Unit Amount Decimal Normal
17 Unit Cost Decimal Normal
18 Amount Decimal Normal
22 Discount Amount Decimal Normal
23 Salespers./Purch. Code Code Normal → Salesperson/Purchaser #13
26 Source Code Code Normal → Source Code #230
29 Applies-to Entry Integer Normal
32 Item Shpt. Entry No. Integer Normal
34 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
35 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
37 Indirect Cost % Decimal Normal
39 Source Type Option Normal
40 Shpt. Method Code Code Normal → Shipment Method #10
41 Journal Batch Name PK Code Normal → Item Journal Batch #233
42 Reason Code Code Normal → Reason Code #231
43 Recurring Method Option Normal
44 Expiration Date Date Normal
45 Recurring Frequency DateFormula Normal
46 Drop Shipment Boolean Normal
47 Transaction Type Code Normal → Transaction Type #258
48 Transport Method Code Normal → Transport Method #259
49 Country/Region Code Code Normal → Country/Region #9
50 New Location Code Code Normal → Location #14
51 New Shortcut Dimension 1 Code Code Normal → Dimension Value #349
52 New Shortcut Dimension 2 Code Code Normal → Dimension Value #349
53 Qty. (Calculated) Decimal Normal
54 Qty. (Phys. Inventory) Decimal Normal
55 Last Item Ledger Entry No. Integer Normal → Item Ledger Entry #32
56 Phys. Inventory Boolean Normal
57 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
58 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
59 Entry/Exit Point Code Normal → Entry/Exit Point #282
60 Document Date Date Normal
62 External Document No. Code Normal
63 Area Code Normal → Area #284
64 Transaction Specification Code Normal → Transaction Specification #285
65 Posting No. Series Code Normal → No. Series #308
68 Reserved Quantity ⚡ FLOW Decimal FlowField
72 Unit Cost (ACY) Decimal Normal
73 Source Currency Code Code Normal → Currency #4
79 Document Type Option Normal
80 Document Line No. Integer Normal
86 VAT Date Date Normal
90 Order Type Option Normal
91 Order No. Code Normal
92 Order Line No. Integer Normal
101 Applies-to Remaining Quantity ⚡ FLOW Decimal FlowField
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
481 New Dimension Set ID Integer Normal → Dimension Set Entry #480
904 Assemble to Order Boolean Normal
1000 Project No. Code Normal
1001 Project Task No. Code Normal
1002 Project Purchase Boolean Normal
1030 Project Contract Entry No. Integer Normal
5402 Variant Code Code Normal → Item Variant #5401
5403 Bin Code Code Normal
5404 Qty. per Unit of Measure Decimal Normal
5406 New Bin Code Code Normal → Bin #7354
5407 Unit of Measure Code Code Normal → Item Unit of Measure #5404
5408 Derived from Blanket Order Boolean Normal
5410 Qty. Rounding Precision Decimal Normal
5411 Qty. Rounding Precision (Base) Decimal Normal
5413 Quantity (Base) Decimal Normal
5415 Invoiced Qty. (Base) Decimal Normal
5468 Reserved Qty. (Base) ⚡ FLOW Decimal FlowField
5560 Level Integer Normal
5561 Flushing Method Option Normal
5562 Changed by User Boolean Normal
5701 Originally Ordered No. Code Normal → Item #27
5702 Originally Ordered Var. Code Code Normal → Item Variant #5401
5703 Out-of-Stock Substitution Boolean Normal
5704 Item Category Code Code Normal → Item Category #5722
5705 Catalog Boolean Normal
5706 Purchasing Code Code Normal → Purchasing #5721
5725 Item Reference No. Code Normal
5726 Item Reference Unit of Measure Code Normal → Item Unit of Measure #5404
5727 Item Reference Type Option Normal
5728 Item Reference Type No. Code Normal
5791 Planned Delivery Date Date Normal
5793 Order Date Date Normal
5800 Value Entry Type Option Normal
5801 Item Charge No. Code Normal → Item Charge #5800
5802 Inventory Value (Calculated) Decimal Normal
5803 Inventory Value (Revalued) Decimal Normal
5804 Variance Type Option Normal
5805 Inventory Value Per Option Normal
5806 Partial Revaluation Boolean Normal
5807 Applies-from Entry Integer Normal
5808 Invoice No. Code Normal
5809 Unit Cost (Calculated) Decimal Normal
5810 Unit Cost (Revalued) Decimal Normal
5811 Applied Amount Decimal Normal
5812 Update Standard Cost Boolean Normal
5813 Amount (ACY) Decimal Normal
5817 Correction Boolean Normal
5818 Adjustment Boolean Normal
5819 Applies-to Value Entry Integer Normal
5820 Invoice-to Source No. Code Normal
5830 Type Option Normal
5831 No. Code Normal
5838 Operation No. Code Normal
5839 Work Center No. Code Normal → Work Center #99000754
5841 Setup Time Decimal Normal
5842 Run Time Decimal Normal
5843 Stop Time Decimal Normal
5846 Output Quantity Decimal Normal
5847 Scrap Quantity Decimal Normal
5849 Concurrent Capacity Decimal Normal
5851 Setup Time (Base) Decimal Normal
5852 Run Time (Base) Decimal Normal
5853 Stop Time (Base) Decimal Normal
5856 Output Quantity (Base) Decimal Normal
5857 Scrap Quantity (Base) Decimal Normal
5858 Cap. Unit of Measure Code Code Normal
5859 Qty. per Cap. Unit of Measure Decimal Normal
5873 Starting Time Time Normal
5874 Ending Time Time Normal
5882 Routing No. Code Normal → Routing Header #99000763
5883 Routing Reference No. Integer Normal
5884 Prod. Order Comp. Line No. Integer Normal
5885 Finished Boolean Normal
5887 Unit Cost Calculation Option Normal
5888 Subcontracting Boolean Normal
5895 Stop Code Code Normal → Stop #99000761
5896 Scrap Code Code Normal → Scrap #99000762
5898 Work Center Group Code Code Normal → Work Center Group #99000756
5899 Work Shift Code Code Normal → Work Shift #99000750
5900 Reversed Capacity Ledger Entry No. Integer Normal → Capacity Ledger Entry #5832
6210 Sustainability Account No. Code Normal → Sustainability Account #6210
6211 Sustainability Account Name Text Normal
6212 Sustainability Account Category Code Normal → Sustain. Account Category #6211
6213 Sustainability Account Subcategory Code Normal → Sustain. Account Subcategory #6212
6214 Emission CO2 Decimal Normal
6215 Emission CH4 Decimal Normal
6216 Emission N2O Decimal Normal
6217 CO2e per Unit Decimal Normal
6218 Total CO2e Decimal Normal
6219 EPR Fee per Unit Decimal Normal
6220 Total EPR Fee Decimal Normal
6500 Serial No. Code Normal
6501 Lot No. Code Normal
6502 Warranty Date Date Normal
6503 New Serial No. Code Normal
6504 New Lot No. Code Normal
6505 New Item Expiration Date Date Normal
6506 Item Expiration Date Date Normal
6515 Package No. Code Normal
6516 New Package No. Code Normal
6600 Return Reason Code Code Normal → Return Reason #6635
7000 Price Calculation Method Option Normal
7315 Warehouse Adjustment Boolean Normal
7316 Direct Transfer Boolean Normal
7380 Phys Invt Counting Period Code Code Normal → Phys. Invt. Counting Period #7381
7381 Phys Invt Counting Period Type Option Normal
99000755 Overhead Rate Decimal Normal
99000756 Single-Level Material Cost Decimal Normal
99000757 Single-Level Capacity Cost Decimal Normal
99000758 Single-Level Subcontrd. Cost Decimal Normal
99000759 Single-Level Cap. Ovhd Cost Decimal Normal
99000760 Single-Level Mfg. Ovhd Cost Decimal Normal
99000761 Rolled-up Material Cost Decimal Normal
99000762 Rolled-up Capacity Cost Decimal Normal
99000763 Rolled-up Subcontracted Cost Decimal Normal
99000764 Rolled-up Mfg. Ovhd Cost Decimal Normal
99000765 Rolled-up Cap. Overhead Cost Decimal Normal
99000766 Single-Level Material Non-Inventory Cost Decimal Normal
99000767 Rolled-up Material Non-Inventory Cost Decimal Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (41)

Tables referenced by fields on the Item Journal Line table through TableRelation properties.

Item Journal Template
#82 · Other · via Journal Template Name
Item
#27 · Inventory · via Item No., Originally Ordered No.
Location
#14 · General Ledger · via Location Code, New Location Code
Inventory Posting Group
#94 · Other · via Inventory Posting Group
Salesperson/Purchaser
#13 · General Ledger · via Salespers./Purch. Code
Source Code
#230 · Other · via Source Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, New Shortcut Dimension 1 Code, New Shortcut Dimension 2 Code
Shipment Method
#10 · General Ledger · via Shpt. Method Code
Item Journal Batch
#233 · Other · via Journal Batch Name
Reason Code
#231 · Other · via Reason Code
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Country/Region
#9 · General Ledger · via Country/Region Code
Item Ledger Entry
#32 · Inventory · via Last Item Ledger Entry No.
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Entry/Exit Point
#282 · Other · via Entry/Exit Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
No. Series
#308 · Other · via Posting No. Series
Currency
#4 · General Ledger · via Source Currency Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID, New Dimension Set ID
Item Variant
#5401 · Other · via Variant Code, Originally Ordered Var. Code
Bin
#7354 · Warehouse · via New Bin Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code, Item Reference Unit of Measure
Item Category
#5722 · Other · via Item Category Code
Purchasing
#5721 · Other · via Purchasing Code
Item Charge
#5800 · Other · via Item Charge No.
Work Center
#99000754 · Manufacturing · via Work Center No.
Routing Header
#99000763 · Manufacturing · via Routing No.
Stop
#99000761 · Manufacturing · via Stop Code
Scrap
#99000762 · Manufacturing · via Scrap Code
Work Center Group
#99000756 · Manufacturing · via Work Center Group Code
Work Shift
#99000750 · Manufacturing · via Work Shift Code
Capacity Ledger Entry
#5832 · Other · via Reversed Capacity Ledger Entry No.
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory
Return Reason
#6635 · Other · via Return Reason Code
Phys. Invt. Counting Period
#7381 · Warehouse · via Phys Invt Counting Period Code

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms