RM Matrix Management – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RRM Matrix Management

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5102

Table Type: Company

Table Name: RM Matrix Management
Database Table Name: CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5102

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how RM Matrix Management can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Company Name]
   ,[No_]
   ,[Name]
   ,[Type]
   ,[Company No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
LEFT JOIN
   [Company] AS [Company]
      ON
         [RM Matrix Management].[Company Name] = [Company].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [RM Matrix Management].[Salesperson Filter] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
      ON
         [RM Matrix Management].[Campaign Filter] = [Campaign].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
      ON
         [RM Matrix Management].[Contact Filter] = [Contact].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [RM Matrix Management].[Sales Cycle Filter] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
      ON
         [RM Matrix Management].[Team Filter] = [Team].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Close Opportunity Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Close Opportunity Code]
      ON
         [RM Matrix Management].[Close Opportunity Filter] = [Close Opportunity Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [RM Matrix Management].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [RM Matrix Management].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in RM Matrix Management table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Company Name	Company Name	Normal	Text	50	Company Name	nvarchar(100)
	Key to join to the Company table. Show/hide example query SELECT [RM Matrix Management].[Company Name] ,[Company].[Name] FROM [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management] LEFT JOIN [Company] AS [Company] ON [RM Matrix Management].[Company Name] = [Company].[Name]
2	No.	No.	Normal	Code	20	No_	nvarchar(40)
3	Name	Name	Normal	Text	50	Name	nvarchar(100)
4	Type	Type	Normal	Option	4	Type	int
	Available options are: “Company” “Person”
5	No. of Opportunities	No. of Opportunities	FlowField	Integer	4
6	Estimated Value (LCY)	Estimated Value ($)	FlowField	Decimal	12
7	Calcd. Current Value (LCY)	Calcd. Current Value ($)	FlowField	Decimal	12
8	Avg. Estimated Value (LCY)	Avg. Estimated Value ($)	FlowField	Decimal	12
9	Avg.Calcd. Current Value (LCY)	Avg.Calcd. Current Value ($)	FlowField	Decimal	12
10	Salesperson Filter	Salesperson Filter	FlowFilter	Code	20
11	Campaign Filter	Campaign Filter	FlowFilter	Code	20
12	Contact Filter	Contact Filter	FlowFilter	Code	20
13	Date Filter	Date Filter	FlowFilter	Date	4
14	Action Taken Filter	Action Taken Filter	FlowFilter	Option	4
15	Sales Cycle Filter	Sales Cycle Filter	FlowFilter	Code	10
16	Sales Cycle Stage Filter	Sales Cycle Stage Filter	FlowFilter	Integer	4
17	Probability % Filter	Probability % Filter	FlowFilter	Decimal	12
18	Completed % Filter	Completed % Filter	FlowFilter	Decimal	12
19	Company No.	Company No.	Normal	Code	20	Company No_	nvarchar(40)
20	Contact Company Filter	Contact Company Filter	FlowFilter	Code	20
21	Task Status Filter	Task Status Filter	FlowFilter	Option	4
22	Task Closed Filter	Task Closed Filter	FlowFilter	Boolean	4
23	Priority Filter	Priority Filter	FlowFilter	Option	4
24	Team Filter	Team Filter	FlowFilter	Code	10
25	No. of Tasks	No. of Tasks	FlowField	Integer	4
26	Estimated Value Filter	Estimated Value Filter	FlowFilter	Decimal	12
27	Calcd. Current Value Filter	Calcd. Current Value Filter	FlowFilter	Decimal	12
28	Chances of Success % Filter	Chances of Success % Filter	FlowFilter	Decimal	12
29	Close Opportunity Filter	Close Opportunity Filter	FlowFilter	Code	10
30	System Task Type Filter	System Task Type Filter	FlowFilter	Option	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [RM Matrix Management].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management] LEFT JOIN [User] AS [User] ON [RM Matrix Management].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [RM Matrix Management].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management] LEFT JOIN [User] AS [User] ON [RM Matrix Management].[$systemModifiedBy] = [User].[User Security ID]