Warehouse table in Microsoft Dynamics 365 Business Central. 62 fields, 0 records in Cronus demo.
The Warehouse Journal Line table (ID 7311) is part of the Warehouse area in Microsoft Dynamics 365 Business Central. It contains 62 fields, with a primary key of Journal Template Name, Journal Batch Name, Line No., Location 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, Journal Batch Name, Line No., Location Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Journal Template Name PK | Code | Normal | → Warehouse Journal Template #7309 |
| 2 | Journal Batch Name PK | Code | Normal | → Warehouse Journal Batch #7310 |
| 3 | Line No. PK | Integer | Normal | |
| 4 | Registering Date | Date | Normal | |
| 5 | Location Code PK | Code | Normal | → Location #14 |
| 6 | From Zone Code | Code | Normal | → Zone #7300 |
| 7 | From Bin Code | Code | Normal | |
| 8 | Description | Text | Normal | |
| 9 | Item No. | Code | Normal | → Item #27 |
| 10 | Quantity | Decimal | Normal | |
| 11 | Qty. (Base) | Decimal | Normal | |
| 12 | Qty. (Absolute) | Decimal | Normal | |
| 13 | Qty. (Absolute, Base) | Decimal | Normal | |
| 14 | Zone Code | Code | Normal | → Zone #7300 |
| 15 | Bin Code | Code | Normal | |
| 20 | Source Type | Integer | Normal | |
| 21 | Source Subtype | Option | Normal | |
| 22 | Source No. | Code | Normal | |
| 23 | Source Line No. | Integer | Normal | |
| 24 | Source Subline No. | Integer | Normal | |
| 25 | Source Document | Option | Normal | |
| 26 | Source Code | Code | Normal | → Source Code #230 |
| 27 | To Zone Code | Code | Normal | → Zone #7300 |
| 28 | To Bin Code | Code | Normal | |
| 29 | Reason Code | Code | Normal | → Reason Code #231 |
| 33 | Registering No. Series | Code | Normal | → No. Series #308 |
| 35 | From Bin Type Code | Code | Normal | → Bin Type #7303 |
| 40 | Cubage | Decimal | Normal | |
| 41 | Weight | Decimal | Normal | |
| 50 | Whse. Document No. | Code | Normal | |
| 51 | Whse. Document Type | Option | Normal | |
| 52 | Whse. Document Line No. | Integer | Normal | |
| 53 | Qty. (Calculated) | Decimal | Normal | |
| 54 | Qty. (Phys. Inventory) | Decimal | Normal | |
| 55 | Entry Type | Option | Normal | |
| 56 | Phys. Inventory | Boolean | Normal | |
| 60 | Reference Document | Option | Normal | |
| 61 | Reference No. | Code | Normal | |
| 67 | User ID | Code | Normal | |
| 68 | Qty. (Calculated) (Base) | Decimal | Normal | |
| 69 | Qty. (Phys. Inventory) (Base) | Decimal | Normal | |
| 5402 | Variant Code | Code | Normal | → Item Variant #5401 |
| 5404 | Qty. per Unit of Measure | Decimal | Normal | |
| 5407 | Unit of Measure Code | Code | Normal | → Item Unit of Measure #5404 |
| 5408 | Qty. Rounding Precision | Decimal | Normal | |
| 5409 | Qty. Rounding Precision (Base) | Decimal | Normal | |
| 6500 | Serial No. | Code | Normal | |
| 6501 | Lot No. | Code | Normal | |
| 6502 | Warranty Date | Date | Normal | |
| 6503 | Expiration Date | Date | Normal | |
| 6504 | New Serial No. | Code | Normal | |
| 6505 | New Lot No. | Code | Normal | |
| 6506 | New Expiration Date | Date | Normal | |
| 6515 | Package No. | Code | Normal | |
| 6516 | New Package No. | Code | Normal | |
| 7380 | Phys Invt Counting Period Code | Code | Normal | → Phys. Invt. Counting Period #7381 |
| 7381 | Phys Invt Counting Period Type | Option | 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 Warehouse Journal Line table through TableRelation properties.