Table 7325 "Whse. Pick Request"

Base Application · Microsoft.Warehouse.Request · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Whse. Pick Request
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	Document Type Δ BC28	Enum “Warehouse Pick Request Document Type”	Specifies the type of document from which the pick originated.	enum Enum 7325 “Warehouse Pick Request Document Type”
2	Document Subtype Δ BC28	Option	Specifies the type of document that the component pick request is related to, such as Released and Assembly.	OptionCaption: 0,1,2,3,4,5,6,7,8,9,10
3	Document No. Δ BC26 Δ BC28	Code[20]	Specifies the number of the warehouse document for which the program has received a pick request.	TableRelation Table 7320 “Warehouse Shipment Header”, Table 7333 “Whse. Internal Pick Header” (if (“Document Type” = const(Shipment)) “Warehouse Shipment Header”.“No.” else if (“Document Type” = const(“Internal Pick”)) “Whse. Internal Pick Header”.“No.” else if (“Document Type” = const(Job)) Job.“No.” where(Status = const(Open))); NotBlank
4	Location Code Δ BC28	Code[10]	Specifies the code of the location in which the request is occurring.	TableRelation Table 14 “Location”
5	Zone Code	Code[10]	—	TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
6	Bin Code	Code[20]	—	TableRelation Table 7354 “Bin” (if (“Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”)))
7	Status	Option	—	OptionCaption: Open,Released; not editable
8	Completely Picked	Boolean	—
9	Shipment Method Code Δ BC24 Δ BC28	Code[10]	Specifies the delivery conditions of the related shipment, such as free on board (FOB).	TableRelation Table 10 “Shipment Method” (Shipment Method); FlowField: lookup(“Warehouse Shipment Header”.“Shipment Method Code” where(“No.” = field(“Document No.”))); not editable
10	Shipping Agent Code Δ BC24 Δ BC28	Code[10]	Specifies the code for the shipping agent who is transporting the items.	TableRelation Table 291 “Shipping Agent” (Shipping Agent); FlowField: lookup(“Warehouse Shipment Header”.“Shipping Agent Code” where(“No.” = field(“Document No.”))); not editable
11	Shipping Agent Service Code Δ BC24 Δ BC28	Code[10]	Specifies the code for the service, such as a one-day delivery, that is offered by the shipping agent.	TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”))); FlowField: lookup(“Warehouse Shipment Header”.“Shipping Agent Service Code” where(“No.” = field(“Document No.”))); not editable

Keys

Key1: Document Type, Document Subtype, Document No., Location Code (clustered)
Key2: Document No., Document Type, Status

Events published

OnBeforeLookupDocumentNo(var WhsePickRequest: Record "Whse. Pick Request"; var IsHandled: Boolean) (integration)
OnLookupDocumentNo(var WhsePickRequest: Record "Whse. Pick Request") + BC26 (integration)
- subscribers: Codeunit 5996 “Prod. Order Warehouse Mgt.” OnLookupDocumentNo, Codeunit 5997 “Assembly Warehouse Mgt.” OnLookupDocumentNo

Procedures

1 local procedures, no public ones.

Relations

Shipment Method Code: TableRelation Table 10 “Shipment Method”
Location Code: TableRelation Table 14 “Location”
Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
Zone Code: TableRelation Table 7300 “Zone”
Shipment Method Code: CalcFormula Table 7320 “Warehouse Shipment Header”
Shipping Agent Code: CalcFormula Table 7320 “Warehouse Shipment Header”
Shipping Agent Service Code: CalcFormula Table 7320 “Warehouse Shipment Header”
Document No.: TableRelation Table 7320 “Warehouse Shipment Header” (conditional)
Document No.: TableRelation Table 7333 “Whse. Internal Pick Header” (conditional)
Bin Code: TableRelation Table 7354 “Bin” (conditional)

Pages and codeunits on this table

Page 7343 “Pick Selection” (source table)

Extended by

Ask your agent

Procedure bodies are not stored here (D10). 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: "Whse. Pick Request"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.