Warehouse table in Microsoft Dynamics 365 Business Central. 39 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Warehouse Pick Summary table through TableRelation properties.