Whse. Internal Pick Line #7334

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

30
Fields
0
Records
2
Primary key
2
FlowFields
7
Relations
Open in Data Explorer →

Primary key

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

All fields (30)

Whse. Internal Pick Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Line No. PK Integer Normal
10 Location Code Code Normal → Location #14
11 Shelf No. Code Normal
12 To Bin Code Code Normal
13 To Zone Code Code Normal → Zone #7300
14 Item No. Code Normal → Item #27
15 Quantity Decimal Normal
16 Qty. (Base) Decimal Normal
19 Qty. Outstanding Decimal Normal
20 Qty. Outstanding (Base) Decimal Normal
23 Qty. Picked Decimal Normal
24 Qty. Picked (Base) Decimal Normal
27 Pick Qty. ⚡ FLOW Decimal FlowField
28 Pick Qty. (Base) ⚡ FLOW Decimal FlowField
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
34 Status Option Normal
35 Sorting Sequence No. Integer Normal
36 Due Date Date Normal
37 Cubage Decimal Normal
38 Weight 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

Related tables (6)

Tables referenced by fields on the Whse. Internal Pick Line table through TableRelation properties.

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