Whse. Worksheet Line #7326

Warehouse table in Microsoft Dynamics 365 Business Central. 50 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: Worksheet Template Name, Name, Line No., Location Code.

All fields (50)

Whse. Worksheet Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Worksheet Template Name PK	Code	Normal	→ Whse. Worksheet Template #7328
2	Name 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
10	Location Code PK	Code	Normal	→ Location #14
11	Shelf No.	Code	Normal
12	From Zone Code	Code	Normal	→ Zone #7300
13	From Bin Code	Code	Normal
14	To Bin Code	Code	Normal
15	To Zone Code	Code	Normal	→ Zone #7300
16	Item No.	Code	Normal	→ Item #27
17	Quantity	Decimal	Normal
18	Qty. (Base)	Decimal	Normal
19	Qty. Outstanding	Decimal	Normal
20	Qty. Outstanding (Base)	Decimal	Normal
21	Qty. to Handle	Decimal	Normal
22	Qty. to Handle (Base)	Decimal	Normal
23	Qty. Handled	Decimal	Normal
24	Qty. Handled (Base)	Decimal	Normal
27	From Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
28	Qty. per From Unit of Measure	Decimal	Normal
29	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
30	Qty. per Unit of Measure	Decimal	Normal
31	Variant Code	Code	Normal	→ Item Variant #5401
32	Description	Text	Normal
33	Description 2	Text	Normal
35	Sorting Sequence No.	Integer	Normal
36	Due Date	Date	Normal
39	Destination Type	Option	Normal
40	Destination No.	Code	Normal
41	Shipping Agent Code	Code	Normal	→ Shipping Agent #291
42	Shipping Agent Service Code	Code	Normal	→ Shipping Agent Services #5790
43	Shipment Method Code	Code	Normal	→ Shipment Method #10
44	Shipping Advice	Option	Normal
45	Shipment Date	Date	Normal
46	Whse. Document Type	Option	Normal
47	Whse. Document No.	Code	Normal
48	Whse. Document Line No.	Integer	Normal
50	Qty. Rounding Precision	Decimal	Normal
51	Qty. Rounding Precision (Base)	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