Standard Item Journal Line #753

Other table in Microsoft Dynamics 365 Business Central. 55 fields, 0 records in Cronus demo.

55
Fields
0
Records
3
Primary key
0
FlowFields
31
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., Standard Journal Code.

All fields (55)

Standard 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
5 Entry Type Option Normal
8 Description Text Normal
9 Location Code Code Normal → Location #14
10 Inventory Posting Group Code Normal → Inventory Posting Group #94
13 Quantity Decimal Normal
16 Unit Amount Decimal Normal
17 Unit Cost Decimal Normal
18 Amount Decimal Normal
23 Salespers./Purch. Code Code Normal → Salesperson/Purchaser #13
26 Source Code Code Normal → Source Code #230
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
41 Standard Journal Code PK Code Normal → Standard Item Journal #752
42 Reason Code Code Normal → Reason Code #231
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
53 Qty. (Calculated) Decimal Normal
54 Qty. (Phys. Inventory) Decimal Normal
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
63 Area Code Normal → Area #284
64 Transaction Specification Code Normal → Transaction Specification #285
65 Posting No. Series Code Normal → No. Series #308
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5402 Variant Code Code Normal → Item Variant #5401
5403 Bin Code Code Normal
5404 Qty. per Unit of Measure Decimal Normal
5407 Unit of Measure Code Code Normal → Item Unit of Measure #5404
5410 Qty. Rounding Precision Decimal Normal
5411 Qty. Rounding Precision (Base) Decimal Normal
5413 Quantity (Base) Decimal Normal
5701 Originally Ordered No. Code Normal → Item #27
5702 Originally Ordered Var. Code Code Normal → Item Variant #5401
5704 Item Category Code Code Normal → Item Category #5722
5705 Catalog Boolean Normal
5706 Purchasing Code Code Normal → Purchasing #5721
5800 Value Entry Type Option Normal
5801 Item Charge No. Code Normal → Item Charge #5800
5817 Correction Boolean Normal
5839 Work Center No. Code Normal → Work Center #99000754
6600 Return Reason Code Code Normal → Return Reason #6635
7000 Price Calculation Method Option Normal
99000755 Overhead Rate 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 (27)

Tables referenced by fields on the Standard 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
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
Standard Item Journal
#752 · Other · via Standard Journal Code
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
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
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Item Variant
#5401 · Other · via Variant Code, Originally Ordered Var. Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code
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.
Return Reason
#6635 · Other · via Return Reason Code