Table 9063 "Relationship Mgmt. Cue"

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

Properties

Property	Value
Caption	Relationship Mgmt. 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	Contacts	Integer	—	FlowField: count(Contact)
3	Segments	Integer	—	FlowField: count(“Segment Header”)
4	Logged Segments	Integer	—	FlowField: count(“Logged Segment”)
5	Open Opportunities Δ BC28	Integer	Specifies open opportunities.	FlowField: count(Opportunity where(Closed = filter(false)))
6	Closed Opportunities Δ BC28	Integer	Specifies opportunities that have been closed.	FlowField: count(Opportunity where(Closed = filter(true)))
7	Opportunities Due in 7 Days Δ BC28	Integer	Specifies opportunities with a due date in seven days or more.	FlowField: count(“Opportunity Entry” where(Active = filter(true), “Date Closed” = filter(0D), “Estimated Close Date” = field(“Due Date Filter”)))
8	Overdue Opportunities Δ BC28	Integer	Specifies opportunities that have exceeded the due date.	FlowField: count(“Opportunity Entry” where(Active = filter(true), “Date Closed” = filter(0D), “Estimated Close Date” = field(“Overdue Date Filter”)))
9	Sales Cycles	Integer	—	FlowField: count(“Sales Cycle”)
10	Sales Persons	Integer	—	FlowField: count(“Salesperson/Purchaser”)
11	Contacts - Open Opportunities	Integer	—	FlowField: count(Contact where(“No. of Opportunities” = filter(<> 0)))
12	Contacts - Companies Δ BC28	Integer	Specifies contacts assigned to a company.	FlowField: count(Contact where(Type = const(Company)))
13	Contacts - Persons Δ BC28	Integer	Specifies contact persons.	FlowField: count(Contact where(Type = const(Person)))
14	Contacts - Duplicates Δ BC28	Integer	Specifies contacts that have duplicates.	FlowField: count(“Contact Duplicate”)
18	Due Date Filter	Date	—	FlowFilter
19	Overdue Date Filter	Date	—	FlowFilter
20	Open Sales Quotes Δ BC28	Integer	Specifies the number of sales quotes that are not yet converted to invoices or orders.	FlowField: count(“Sales Header” where(“Document Type” = filter(Quote), Status = filter(Open)))
21	Open Sales Orders Δ BC28	Integer	Specifies the number of sales orders that are not fully posted.	FlowField: count(“Sales Header” where(“Document Type” = filter(Order), Status = filter(Open)))
22	Active Campaigns Δ BC28	Integer	Specifies marketing campaigns that are active.	FlowField: count(Campaign where(Activated = filter(true)))
23	Uninvoiced Bookings	Integer	—	not editable
24	Coupled Data Synch Errors Δ BC28	Integer	Specifies the number of errors that occurred in the latest synchronization of coupled data between Business Central and Dynamics 365 Sales.	FlowField: count(“CRM Integration Record” where(Skipped = const(true)))
25	CDS Integration Errors Δ BC28	Integer	Specifies the number of errors related to data integration.	FlowField: count(“Integration Synch. Job Errors”)

Keys

Key1: Primary Key (clustered)

Relations

Sales Persons: CalcFormula Table 13 “Salesperson/Purchaser”
Open Sales Orders: CalcFormula Table 36 “Sales Header”
Open Sales Quotes: CalcFormula Table 36 “Sales Header”
Contacts - Companies: CalcFormula Table 5050 “Contact”
Contacts - Open Opportunities: CalcFormula Table 5050 “Contact”
Contacts - Persons: CalcFormula Table 5050 “Contact”
Active Campaigns: CalcFormula Table 5071 “Campaign”
Logged Segments: CalcFormula Table 5075 “Logged Segment”
Segments: CalcFormula Table 5076 “Segment Header”
Contacts - Duplicates: CalcFormula Table 5085 “Contact Duplicate”
Sales Cycles: CalcFormula Table 5090 “Sales Cycle”
Closed Opportunities: CalcFormula Table 5092 “Opportunity”
Open Opportunities: CalcFormula Table 5092 “Opportunity”
Opportunities Due in 7 Days: CalcFormula Table 5093 “Opportunity Entry”
Overdue Opportunities: CalcFormula Table 5093 “Opportunity Entry”
Coupled Data Synch Errors: CalcFormula Table 5331 “CRM Integration Record”
CDS Integration Errors: CalcFormula Table 5339 “Integration Synch. Job Errors”

Pages and codeunits on this table

Page 9076 “Sales & Relationship Mgr. Act.” (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: "Relationship Mgmt. Cue"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.