Warehouse Journal Line #7311

Warehouse table in Microsoft Dynamics 365 Business Central. 62 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (62)

Warehouse Journal Line — FIELDS

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