Table 9050 "Warehouse Basic Cue"

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

Properties

Property	Value
Caption	Warehouse Basic Cue
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	Primary Key Δ BC26	Code[10]	—
2	Rlsd. Sales Orders Until Today Δ BC24 Δ BC28	Integer	Specifies the number of released sales orders that are displayed in the Warehouse Basic Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Sales Header” where(“Document Type” = filter(Order), Status = filter(Released), “Shipment Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”))); not editable
3	Posted Sales Shipments - Today Δ BC24 Δ BC28	Integer	Specifies the number of posted sales shipments that are displayed in the Basic Warehouse Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Sales Shipment Header” where(“Posting Date” = field(“Date Filter2”), “Location Code” = field(“Location Filter”))); not editable
4	Exp. Purch. Orders Until Today Δ BC24 Δ BC28	Integer	Specifies the number of expected purchase orders that are displayed in the Basic Warehouse Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Purchase Header” where(“Document Type” = filter(Order), Status = filter(Released), “Expected Receipt Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”))); not editable
5	Posted Purch. Receipts - Today Δ BC24 Δ BC28	Integer	Specifies the number of posted purchase receipts that are displayed in the Warehouse Basic Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Purch. Rcpt. Header” where(“Posting Date” = field(“Date Filter2”), “Location Code” = field(“Location Filter”))); not editable
6	Invt. Picks Until Today Δ BC24 Δ BC28	Integer	Specifies the number of inventory picks that are displayed in the Warehouse Basic Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Warehouse Activity Header” where(Type = filter(“Invt. Pick”), “Shipment Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”))); not editable
7	Invt. Put-aways Until Today Δ BC24 Δ BC28	Integer	Specifies the number of inventory put-always that are displayed in the Warehouse Basic Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Warehouse Activity Header” where(Type = filter(“Invt. Put-away”), “Shipment Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”))); not editable
8	Open Phys. Invt. Orders Δ BC24 Δ BC28	Integer	Specifies the number of open physical inventory orders.	FlowField: count(“Phys. Invt. Order Header” where(Status = const(Open))); not editable
20	Date Filter	Date	—	FlowFilter; not editable
21	Date Filter2	Date	—	FlowFilter; not editable
22	Location Filter	Code[10]	—	FlowFilter
23	User ID Filter	Code[50]	—	FlowFilter

Keys

Key1: Primary Key (clustered)

Relations

Posted Sales Shipments - Today: CalcFormula Table 110 “Sales Shipment Header”
Posted Purch. Receipts - Today: CalcFormula Table 120 “Purch. Rcpt. Header”
Rlsd. Sales Orders Until Today: CalcFormula Table 36 “Sales Header”
Exp. Purch. Orders Until Today: CalcFormula Table 38 “Purchase Header”
Invt. Picks Until Today: CalcFormula Table 5766 “Warehouse Activity Header”
Invt. Put-aways Until Today: CalcFormula Table 5766 “Warehouse Activity Header”
Open Phys. Invt. Orders: CalcFormula Table 5875 “Phys. Invt. Order Header”

Pages and codeunits on this table

Page 9050 “Whse Ship & Receive Activities” (source table)

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: "Warehouse Basic Cue"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.