Warehouse Pick Summary #5774

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

39
Fields
0
Records
1
Primary key
1
FlowFields
7
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (39)

Warehouse Pick Summary — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Source Type Integer Normal
3 Source Subtype Option Normal
4 Source No. Code Normal
5 Source Line No. Integer Normal
6 Source Subline No. Integer Normal
7 Source Document Option Normal
11 Location Code Code Normal → Location #14
12 Bin Code Code Normal → Bin #7354
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
18 Description Text Normal
19 Description 2 Text 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
40 Qty. in Inventory ⚡ FLOW Decimal FlowField
41 Qty. Available to Pick Decimal Normal
42 Potential Qty. Available to Pick Decimal Normal
43 Available Quantity Excluding Ship Bin Decimal Normal
44 Qty. Assigned Decimal Normal
50 Qty. Reserved in Warehouse Decimal Normal
51 Qty. Reserved in Pick/Ship Bins Decimal Normal
52 Qty. Reserved for this Line Decimal Normal
60 Qty. in Blocked Item Tracking Decimal Normal
61 Qty. in Active Pick Lines Decimal Normal
62 Qty. in Pickable Bins Decimal Normal
63 Qty. in Warehouse Decimal Normal
70 Qty. in Blocked Item Tracking for Checking Reservation Decimal Normal
71 Qty. in Active Pick Lines for Checking Reservation Decimal Normal
72 Qty. Not in Ship Bins for Checking Reservation Decimal Normal
80 Active Worksheet Line GUID 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

Related tables (6)

Tables referenced by fields on the Warehouse Pick Summary table through TableRelation properties.

Location
#14 · General Ledger · via Location Code
Bin
#7354 · Warehouse · via Bin Code
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code