Warehouse Activity Line #5767

Warehouse table in Microsoft Dynamics 365 Business Central. 69 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: Activity Type, No., Line No..

All fields (69)

Warehouse Activity Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Activity Type PK	Option	Normal
2	No. PK	Code	Normal
3	Line No. PK	Integer	Normal
4	Source Type	Integer	Normal
5	Source Subtype	Option	Normal
6	Source No.	Code	Normal
7	Source Line No.	Integer	Normal
8	Source Subline No.	Integer	Normal
9	Source Document	Option	Normal
11	Location Code	Code	Normal	→ Location #14
12	Shelf No.	Code	Normal
13	Sorting Sequence No.	Integer	Normal
14	Item No.	Code	Normal	→ Item #27
15	Variant Code	Code	Normal	→ Item Variant #5401
16	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
17	Qty. per Unit of Measure	Decimal	Normal
18	Description	Text	Normal
19	Description 2	Text	Normal
20	Quantity	Decimal	Normal
21	Qty. (Base)	Decimal	Normal
24	Qty. Outstanding	Decimal	Normal
25	Qty. Outstanding (Base)	Decimal	Normal
26	Qty. to Handle	Decimal	Normal
27	Qty. to Handle (Base)	Decimal	Normal
28	Qty. Handled	Decimal	Normal
29	Qty. Handled (Base)	Decimal	Normal
31	Shipping Advice	Option	Normal
34	Due Date	Date	Normal
39	Destination Type	Option	Normal
40	Destination No.	Code	Normal
42	Shipping Agent Code	Code	Normal	→ Shipping Agent #291
43	Shipping Agent Service Code	Code	Normal	→ Shipping Agent Services #5790
44	Shipment Method Code	Code	Normal	→ Shipment Method #10
47	Starting Date	Date	Normal
50	Qty. Rounding Precision	Decimal	Normal
51	Qty. Rounding Precision (Base)	Decimal	Normal
900	Assemble to Order	Boolean	Normal
901	ATO Component	Boolean	Normal
6500	Serial No.	Code	Normal
6501	Lot No.	Code	Normal
6502	Warranty Date	Date	Normal
6503	Expiration Date	Date	Normal
6504	Serial No. Blocked ⚡ FLOW	Boolean	FlowField
6505	Lot No. Blocked ⚡ FLOW	Boolean	FlowField
6515	Package No.	Code	Normal
7300	Bin Code	Code	Normal
7301	Zone Code	Code	Normal	→ Zone #7300
7305	Action Type	Option	Normal
7306	Whse. Document Type	Option	Normal
7307	Whse. Document No.	Code	Normal
7308	Whse. Document Line No.	Integer	Normal
7309	Bin Ranking	Integer	Normal
7310	Cubage	Decimal	Normal
7311	Weight	Decimal	Normal
7312	Special Equipment Code	Code	Normal	→ Special Equipment #7305
7313	Bin Type Code	Code	Normal	→ Bin Type #7303
7314	Breakbulk No.	Integer	Normal
7315	Original Breakbulk	Boolean	Normal
7316	Breakbulk	Boolean	Normal
7317	Cross-Dock Information	Option	Normal
7318	Dedicated	Boolean	Normal
7319	Over-Receipt Quantity	Decimal	Normal
7320	Over-Receipt Code	Code	Normal	→ Over-Receipt Code #8510
7321	Warehouse Reason Code	Code	Normal	→ Warehouse Reason Code #7389
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