Table 5774 "Warehouse Pick Summary"
Base Application · Microsoft.Warehouse.Activity
Across versions
- BC23present
- BC242 procedures added
- BC25-27unchanged
- BC2828 fields changed
- BC29-30unchanged
Neighbourhood 8 connected objects and pages
Base Application · Microsoft.Warehouse.Activity · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Warehouse Pick Summary |
| Access | Internal |
| TableType | Temporary |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | — | not editable |
| 2 | Source Type Δ BC28 | Integer | Specifies the type of source document to which the warehouse activity line relates, such as sales, purchase, and production. | not editable |
| 3 | Source Subtype | Option | — | OptionCaption: 0,1,2,3,4,5,6,7,8,9,10; not editable |
| 4 | Source No. Δ BC28 | Code[20] | Specifies the number of the source document that the entry originates from. | not editable |
| 5 | Source Line No. Δ BC28 | Integer | Specifies the line number of the source document | not editable |
| 6 | Source Subline No. Δ BC28 | Integer | Specifies the subline number of the source document | not editable |
| 7 | Source Document Δ BC28 | Enum “Warehouse Activity Source Document” | Specifies the type of document that the line relates to. | enum Enum 5768 “Warehouse Activity Source Document”; not editable |
| 11 | Location Code Δ BC28 | Code[10] | Specifies the code for the location where the pick activity occurs. | TableRelation Table 14 “Location”; not editable |
| 12 | Bin Code | Code[20] | — | TableRelation Bin.Code; not editable |
| 14 | Item No. Δ BC28 | Code[20] | Specifies the item number of the item to be picked. | TableRelation Item.“No.”; not editable |
| 15 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 16 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 18 | Description | Text[100] | — | not editable |
| 19 | Description 2 | Text[50] | — | not editable |
| 26 | Qty. to Handle Δ BC28 | Decimal | Specifies how many units to handle in this warehouse activity. | |
| 27 | Qty. to Handle (Base) Δ BC28 | Decimal | Specifies how many units to handle (base unit of measure) in this warehouse activity. via Page 5772 “Warehouse Pick Summary” | |
| 28 | Qty. Handled Δ BC28 | Decimal | Specifies the number of items on the line that have been handled in this warehouse activity. | not editable |
| 29 | Qty. Handled (Base) Δ BC28 | Decimal | Specifies the number of items on the line that have been handled in this warehouse activity. via Page 5772 “Warehouse Pick Summary” | not editable |
| 40 | Qty. in Inventory Δ BC28 | Decimal | Specifies the quantity in the inventory. | FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Unit of Measure Code” = field(“Unit of Measure Code”))); not editable |
| 41 | Qty. Available to Pick Δ BC28 | Decimal | Specifies the quantity that is actually available to pick. | not editable |
| 42 | Potential Pickable Qty. Δ BC28 | Decimal | Specifies the maximum quantity that can be considered for picking. This quantity consists of items in pickable bins excluding bins that are blocked, dedicated, blocked by item tracking or items that are being picked. This quantity cannot be more than the total quantity in the warehouse including adj… | not editable |
| 43 | Available Qty. Not in Ship Bin Δ BC28 | Decimal | Specifies the quantity available to pick in the warehouse excluding the shipment bins, bins that are blocked, dedicated, blocked by item tracking or items that are being picked. | not editable |
| 44 | Qty. Assigned Δ BC28 | Decimal | Specifies the quantity that has been handled for other source lines. If tracking is enabled, then the same source line is also included. The quantity consists of the current execution of create warehouse pick action. | not editable |
| 50 | Qty. Reserved in Warehouse Δ BC28 | Decimal | Specifies the quantity reserved in warehouse. This quantity consists of inventory from reservation including inventory that is picked or being picked but not yet shipped or consumed. It excludes the quantity blocked by bins, item tracking or reserved against dedicated bins. | not editable |
| 51 | Qty. Res. in Pick/Ship Bins Δ BC28 | Decimal | Specifies the quantity reserved in pick/ship bins. | not editable |
| 52 | Qty. Reserved for this Line Δ BC28 | Decimal | Specifies the quantity reserved for the selected line. | not editable |
| 60 | Qty. in Blocked Item Tracking Δ BC28 | Decimal | Specifies the quantity in blocked item tracking for the pickable/takeable bins. | not editable |
| 61 | Qty. in Active Pick Lines Δ BC28 | Decimal | Specifies the quantity assigned in active warehouse pick documents. | not editable |
| 62 | Qty. in Pickable Bins Δ BC28 | Decimal | Specifies the quantity in takeable bins. The quantity is not reduced by item tracking. | not editable |
| 63 | Qty. in Warehouse Δ BC28 | Decimal | Specifies the quantity in warehouse. | not editable |
| 70 | Qty. Block. Item Tracking Res. Δ BC28 | Decimal | Specifies the quantity in blocked item tracking for the quantity reserved in warehouse. | not editable |
| 71 | Qty. in Active Pick Lines Res. Δ BC28 | Decimal | Specifies the quantity assigned in active warehouse pick documents. | not editable |
| 72 | Qty. Not in Ship Bin Δ BC28 | Decimal | Qty. Not in Ship Bins for Checking Reservation caption | not editable |
| 80 | ActiveWhseWorksheetLine | Guid | Active Worksheet Line caption | not editable |
Keys
- Key1: Entry No. (clustered)
Procedures
IncrementEntryNumber()ShowBinContents(BinTypeFilter: Option ExcludeReceive,ExcludeShip,OnlyPickBins)(internal)SetQtyToHandleStyle(): Text(internal)ShowPickWorksheet(WhseWorksheetLine: Record "Whse. Worksheet Line"; FilterToLine: Boolean)(internal)ShowReservationEntries()+ BC24 (internal)
Plus 1 local procedures.
Relations
- Location Code: TableRelation Table 14 “Location”
- Qty. in Inventory: CalcFormula Table 32 “Item Ledger Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Pages and codeunits on this table
- Page 5772 “Warehouse Pick Summary” (source table)
- Page 5773 “Warehouse Pick Summary Part” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 7312 “Create Pick” (1 call:
ShowBinContents → GetBinTypeFilter) - Page 497 “Reservation Entries” (1 call:
ShowReservationEntries → (object))
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Warehouse Pick Summary"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.