Table 5102 "RM Matrix Management"

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

Properties

Property	Value
Caption	RM Matrix Management
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	Company Name	Text[50]	—
2	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.	NotBlank
3	Name Δ BC28	Text[50]	Specifies the name of the opportunity.
4	Type	Enum “Contact Type”	—	enum Enum 5050 “Contact Type”
5	No. of Opportunities	Integer	—	FlowField: count(“Opportunity Entry” where(Active = const(true), “Salesperson Code” = field(“Salesperson Filter”), “Campaign No.” = field(“Campaign Filter”), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), “Estimated Close Date” = field(“Date Filter”), “Action …; not editable
6	Estimated Value (LCY) Δ BC27	Decimal	—	FlowField: sum(“Opportunity Entry”.“Estimated Value (LCY)” where(Active = const(true), “Salesperson Code” = field(“Salesperson Filter”), “Campaign No.” = field(“Campaign Filter”), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), “Estimated Close Date” = field(“D…; not editable
7	Calcd. Current Value (LCY) Δ BC27	Decimal	—	FlowField: sum(“Opportunity Entry”.“Calcd. Current Value (LCY)” where(Active = const(true), “Salesperson Code” = field(“Salesperson Filter”), “Campaign No.” = field(“Campaign Filter”), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), “Estimated Close Date” = fie…; not editable
8	Avg. Estimated Value (LCY) Δ BC24 Δ BC27	Decimal	—	FlowField: average(“Opportunity Entry”.“Estimated Value (LCY)” where(Active = const(true), “Salesperson Code” = field(“Salesperson Filter”), “Campaign No.” = field(“Campaign Filter”), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), “Estimated Close Date” = fiel…; not editable
9	Avg.Calcd. Current Value (LCY) Δ BC24 Δ BC27	Decimal	—	FlowField: average(“Opportunity Entry”.“Calcd. Current Value (LCY)” where(Active = const(true), “Salesperson Code” = field(“Salesperson Filter”), “Campaign No.” = field(“Campaign Filter”), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), “Estimated Close Date” =…; not editable
10	Salesperson Filter	Code[20]	—	TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser); FlowFilter
11	Campaign Filter	Code[20]	—	TableRelation Table 5071 “Campaign”; FlowFilter
12	Contact Filter	Code[20]	—	TableRelation Table 5050 “Contact”; FlowFilter
13	Date Filter	Date	—	FlowFilter
14	Action Taken Filter Δ BC28	Enum “Opportunity Action Taken”	—	FlowFilter; enum Enum 5091 “Opportunity Action Taken”
15	Sales Cycle Filter	Code[10]	—	TableRelation Table 5090 “Sales Cycle” (Sales Cycle); FlowFilter
16	Sales Cycle Stage Filter	Integer	—	TableRelation Table 5091 “Sales Cycle Stage” (“Sales Cycle Stage”.Stage where(“Sales Cycle Code” = field(“Sales Cycle Filter”))); FlowFilter
17	Probability % Filter Δ BC27	Decimal	—	FlowFilter
18	Completed % Filter Δ BC27	Decimal	—	FlowFilter
19	Company No.	Code[20]	—	TableRelation Table 5050 “Contact” (Contact where(Type = const(Company)))
20	Contact Company Filter	Code[20]	—	TableRelation Table 5050 “Contact” (Contact where(Type = const(Company))); FlowFilter
21	Task Status Filter	Enum “Task Status”	—	FlowFilter; enum Enum 5081 “Task Status”
22	Task Closed Filter	Boolean	—	FlowFilter
23	Priority Filter	Option	—	FlowFilter; OptionCaption: Low,Normal,High
24	Team Filter	Code[10]	—	TableRelation Table 5083 “Team”; FlowFilter
25	No. of Tasks	Integer	—	FlowField: count(“To-do” where(Date = field(“Date Filter”), “Salesperson Code” = field(“Salesperson Filter”), “Team Code” = field(“Team Filter”), “Campaign No.” = field(“Campaign Filter”), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), Status = field(“Task Sta…; not editable
26	Estimated Value Filter Δ BC27	Decimal	—	FlowFilter
27	Calcd. Current Value Filter Δ BC27	Decimal	—	FlowFilter
28	Chances of Success % Filter Δ BC27	Decimal	—	FlowFilter
29	Close Opportunity Filter	Code[10]	—	TableRelation Table 5094 “Close Opportunity Code” (Close Opportunity Code); FlowFilter
30	System Task Type Filter	Option	—	FlowFilter; OptionCaption: Organizer,Salesperson Attendee,Contact Attendee,Team

Keys

Key1: Company Name, Type, Name, No. (clustered)

Relations

Salesperson Filter: TableRelation Table 13 “Salesperson/Purchaser”
Company No.: TableRelation Table 5050 “Contact”
Contact Company Filter: TableRelation Table 5050 “Contact”
Contact Filter: TableRelation Table 5050 “Contact”
Campaign Filter: TableRelation Table 5071 “Campaign”
No. of Tasks: CalcFormula Table 5080 “To-do”
Team Filter: TableRelation Table 5083 “Team”
Sales Cycle Filter: TableRelation Table 5090 “Sales Cycle”
Sales Cycle Stage Filter: TableRelation Table 5091 “Sales Cycle Stage”
Avg. Estimated Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
Avg.Calcd. Current Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
Calcd. Current Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
Estimated Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
No. of Opportunities: CalcFormula Table 5093 “Opportunity Entry”
Close Opportunity Filter: TableRelation Table 5094 “Close Opportunity Code”

Pages and codeunits on this table

Page 5099 “Tasks” (source table)
Page 5131 “Opportunities” (source table)
Page 9255 “Tasks Matrix” (source table)
Page 9257 “Opportunities Matrix” (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: "RM Matrix Management"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.