Other table in Microsoft Dynamics 365 Business Central. 55 fields, 0 records in Cronus demo.
The Standard Item Journal Line table (ID 753) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 55 fields, with a primary key of Journal Template Name, Line No., Standard Journal Code. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Line No., Standard Journal Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Standard Item Journal Line table through TableRelation properties.