tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 9060 "SB Owner Cue"

Base Application · Microsoft.RoleCenters

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25unchanged
  4. BC261 fields changed, 1 fields removed
  5. BC27-30unchanged

Neighbourhood 10 connected objects and pages

Table 36 "Sales Header" (relates to, 5 links)Sales HeaderTable 112 "Sales Invoice Header" (relates to, 2 links)Sales Invoice HeaderTable 122 "Purch. Inv. Header" (relates to, 2 links)Purch. Inv. HeaderTable 38 "Purchase Header" (relates to, 2 links)Purchase HeaderTable 18 "Customer" (relates to)CustomerTable 21 "Cust. Ledger Entry" (relates to)Cust. Ledger EntryTable 23 "Vendor" (relates to)VendorTable 25 "Vendor Ledger Entry" (relates to)Vendor Ledger EntryPage 9073 "Small Business Owner Act." (pages and codeunits on it)Small Business Owner Act.Page 9305 "Sales Order List" (calls)Sales Order List

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Properties

Property Value
Caption SB Owner 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 Released Sales Quotes Integer Specifies the number of released sales quotes that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(“Sales Header” where(“Document Type” = const(Quote), Status = filter(Released)))
3 Open Sales Orders Integer Specifies the number of open sales orders that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = filter(Open)))
4 Released Sales Orders Integer Specifies the number of released sales orders that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = filter(Released)))
5 Released Purchase Orders Integer Specifies the number of released purchase orders that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(“Purchase Header” where(“Document Type” = const(Order), Status = filter(Released)))
6 Overdue Sales Documents Integer Specifies the number of overdue sales invoices that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(“Cust. Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Due Date” = field(“Overdue Date Filter”), Open = const(true)))
8 Customers - Blocked Integer Specifies the number of blocked customers that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(Customer where(Blocked = filter(<> “ “)))
9 Purchase Documents Due Today Integer Specifies the number of purchase invoices that are displayed in the Order Cue in the Business Manager Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice | “Credit Memo”), “Due Date” = field(“Due Date Filter”), Open = const(true)))
10 Vendors - Payment on Hold Integer Specifies the number of vendors with payments on hold that are displayed in the Small Business Owner Cue on the Role Center. The documents are filtered by today’s date. via Page 9073 “Small Business Owner Act.” FlowField: count(Vendor where(Blocked = filter(Payment)))
11 Sales Invoices Integer — FlowField: count(“Sales Header” where(“Document Type” = filter(Invoice)))
12 Unpaid Sales Invoices Integer — FlowField: count(“Sales Invoice Header” where(Closed = filter(false)))
13 Overdue Sales Invoices Integer — FlowField: count(“Sales Invoice Header” where(“Due Date” = field(“Overdue Date Filter”), Closed = filter(false)))
14 Sales Quotes Integer — FlowField: count(“Sales Header” where(“Document Type” = filter(Quote)))
20 Due Date Filter Date — FlowFilter; not editable
21 Overdue Date Filter Date — FlowFilter
30 Purchase Invoices Integer — FlowField: count(“Purchase Header” where(“Document Type” = filter(Invoice)))
31 Unpaid Purchase Invoices Integer — FlowField: count(“Purch. Inv. Header” where(Closed = filter(false)))
32 Overdue Purchase Invoices Integer — FlowField: count(“Purch. Inv. Header” where(“Due Date” = field(“Overdue Date Filter”), Closed = filter(false)))
33 User ID Filter Code[50] — FlowFilter

Keys

  • Key1: Primary Key (clustered)

Procedures

  • CountSalesOrdersShippedNotInvoiced(): Integer
  • ShowSalesOrdersShippedNotInvoiced()

Relations

Pages and codeunits on this 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.

Countries that replace it

ES

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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

Evidence 1 sources