Table 36623 "Credit Manager Cue" (MX)

MX country layer · Microsoft.Sales.RoleCenters · BC29-30 · source at ea08af5e · facts from BC29

An object of the MX localization, not part of W1.

Properties

Property	Value
Caption	Credit Manager 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	Code[10]	—
2	Overdue Sales Invoices	Integer	—	FlowField: count(“Cust. Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Overdue Date Filter”), Open = const(true)))
5	SOs Pending Approval	Integer	—	FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = filter(“Pending Approval”)))
6	Approved Sales Orders	Integer	—	FlowField: count(“Sales Header” where(“Document Type” = const(Order), Status = filter(Released \| “Pending Prepayment”)))
7	Sales Orders On Hold	Integer	—	FlowField: count(“Sales Header” where(“Document Type” = const(Order), “On Hold” = filter(<> ‘’)))
11	Customers - Blocked	Integer	—	FlowField: count(Customer where(Blocked = filter(<> “ “)))
12	Customers - Overdue	Integer	—	FlowField: count(Customer where(“Date Filter” = field(“Overdue Date Filter”), “Balance Due (LCY)” = filter(> 0)))
15	Approvals - Sales Orders	Integer	—	FlowField: count(“Approval Entry” where(“Table ID” = const(36), “Document Type” = const(Order), “Approver ID” = field(“User Filter”), Status = const(Open)))
16	Approvals - Sales Invoices	Integer	—	FlowField: count(“Approval Entry” where(“Table ID” = const(36), “Document Type” = const(Invoice), “Approver ID” = field(“User Filter”), Status = const(Open)))
20	Due Date Filter	Date	—	FlowFilter; not editable
21	Overdue Date Filter	Date	—	FlowFilter
22	User Filter	Code[50]	—	TableRelation User Setup; FlowFilter; not editable

Keys

Key1: Primary Key (clustered)

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

A MX country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.