Table 9053 "Sales Cue"

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

Properties

Property	Value
Caption	Sales 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	Sales Quotes - Open Δ BC26	Integer	Specifies the number of sales quotes that are not yet converted to invoices or orders.	FlowField: count(“Sales Header” where(“Document Type” = const(Quote), Status = const(Open), “Responsibility Center” = field(“Responsibility Center Filter”))); not editable
3	Sales Orders - Open Δ BC26	Integer	Specifies the number of sales orders that are not fully posted.	FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = const(Open), “Responsibility Center” = field(“Responsibility Center Filter”))); not editable
4	Ready to Ship	Integer	—	FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = const(Released), “Completely Shipped” = const(false), “Shipment Date” = field(“Date Filter2”), “Responsibility Center” = field(“Responsibility Center Filter”))); not editable
5	Delayed	Integer	—	FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = const(Released), “Completely Shipped” = const(false), “Shipment Date” = field(“Date Filter”), “Responsibility Center” = field(“Responsibility Center Filter”), “Late Order Shipping” = const(true))); not editable
6	Sales Return Orders - Open Δ BC26	Integer	Specifies the number of sales return orders documents that are displayed in the Sales Cue on the Role Center. The documents are filtered by today’s date.	FlowField: count(“Sales Header” where(“Document Type” = const(“Return Order”), Status = const(Open), “Responsibility Center” = field(“Responsibility Center Filter”))); not editable
7	Sales Credit Memos - Open Δ BC26	Integer	Specifies the number of sales credit memos that are not yet posted.	FlowField: count(“Sales Header” where(“Document Type” = const(“Credit Memo”), Status = const(Open), “Responsibility Center” = field(“Responsibility Center Filter”))); not editable
8	Partially Shipped	Integer	—	FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = const(Released), Shipped = const(true), “Completely Shipped” = const(false), “Shipment Date” = field(“Date Filter2”), “Responsibility Center” = field(“Responsibility Center Filter”))); not editable
9	Average Days Delayed Δ BC28	Decimal	—	not editable
10	Sales Inv. - Pending Doc.Exch. Δ BC26	Integer	Specifies sales invoices that await sending to the customer through the document exchange service.	FlowField: count(“Sales Invoice Header” where(“Document Exchange Status” = filter(“Sent to Document Exchange Service” \| “Delivery Failed”))); not editable
12	Sales CrM. - Pending Doc.Exch. Δ BC26	Integer	Specifies sales credit memos that await sending to the customer through the document exchange service.	FlowField: count(“Sales Cr.Memo Header” where(“Document Exchange Status” = filter(“Sent to Document Exchange Service” \| “Delivery Failed”))); not editable
13	Avg. Days Delayed Updated On	DateTime	Average Days Delayed Updated On caption	not editable
20	Date Filter	Date	—	FlowFilter; not editable
21	Date Filter2	Date	Date Filter 2 caption	FlowFilter; not editable
22	Responsibility Center Filter	Code[10]	—	FlowFilter; not editable
23	User ID Filter	Code[50]	—	FlowFilter
34	S. Ord. - Reserved From Stock	Integer	Sales Orders - Completely Reserved from Stock caption

Keys

Key1: Primary Key (clustered)

Events published

OnAfterSetRespCenterFilter(var SalesCue: Record "Sales Cue"; RespCenterCode: Code[10]) (integration): Raises an event after the responsibility center filter has been set on the sales cue.
OnBeforeCountOrders(var SalesCue: Record "Sales Cue"; FieldNumber: Integer; var Result: Integer; var IsHandled: Boolean) (integration): Raises an event before counting sales orders for the specified field.
OnCountOrdersOnAfterCountPurchOrdersSetFilters(var CountSalesOrders: Query "Count Sales Orders") (integration): Raises an event after setting filters on the Count Sales Orders query, allowing additional filter modifications.
OnFilterOrdersOnAfterSalesHeaderSetFilters(var SalesHeader: Record "Sales Header") (integration): Raises an event after setting filters on the sales header record for order filtering.
OnFilterOrdersOnCaseElseFieldNumber(var SalesHeader: Record "Sales Header"; var SalesCue: Record "Sales Cue"; FieldNumber: Integer) + BC27 (integration): Raises an event when filtering orders for a field number not handled by the default case statement.
OnBeforeSummarizeDelayedData(var SalesHeader: Record "Sales Header"; var SumDelayDays: Integer; var CountDelayedInvoices: Integer; var IsHandled: Boolean) (integration): Raises an event before summarizing delayed data for a sales header when calculating average days delayed.
OnBeforeDrillDownNoOfReservedFromStockSalesOrders(var SalesHeader: Record "Sales Header") + BC26 (integration): Raises an event before drilling down on the number of sales orders reserved from stock.
OnBeforeCalcNoOfReservedFromStockSalesOrders(var SalesHeader: Record "Sales Header"; var Number: Integer; var IsHandled: Boolean) + BC26 (integration): Raises an event before calculating the number of sales orders reserved from stock.

Procedures

SetRespCenterFilter(): Sets a responsibility center filter on the sales cue based on the current user’s assigned responsibility center.
CalculateAverageDaysDelayed(): Decimal: Calculates the average number of days that delayed sales orders are overdue for shipment.
CountOrders(FieldNumber: Integer): Integer: Counts the number of sales orders matching the criteria associated with the specified field.
ShowOrders(FieldNumber: Integer): Opens the Sales Order List page filtered to show orders matching the criteria associated with the specified field.
CalcNoOfReservedFromStockSalesOrders(): Integer: Calculates the number of sales orders that have all required quantities fully reserved from available inventory stock.
DrillDownNoOfReservedFromStockSalesOrders(): Opens the Sales Order List page showing only sales orders that are fully reserved from available inventory stock.

Plus 3 local procedures.

Relations

Sales Inv. - Pending Doc.Exch.: CalcFormula Table 112 “Sales Invoice Header”
Sales CrM. - Pending Doc.Exch.: CalcFormula Table 114 “Sales Cr.Memo Header”
Delayed: CalcFormula Table 36 “Sales Header”
Partially Shipped: CalcFormula Table 36 “Sales Header”
Ready to Ship: CalcFormula Table 36 “Sales Header”
Sales Credit Memos - Open: CalcFormula Table 36 “Sales Header”
Sales Orders - Open: CalcFormula Table 36 “Sales Header”
Sales Quotes - Open: CalcFormula Table 36 “Sales Header”
Sales Return Orders - Open: CalcFormula Table 36 “Sales Header”

Pages and codeunits on this table

Page 9060 “SO Processor Activities” (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.

Page 9305 “Sales Order List” (2 calls: DrillDownNoOfReservedFromStockSalesOrders → (object), ShowOrders → (object))
Codeunit 5700 “User Setup Management” (1 call: SetRespCenterFilter → GetSalesFilter)

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

Across versions

Neighbourhood 6 connected objects and pages