RM Matrix Management

Dynamics 365 BC Table ReferenceTablesCompany TablesRRM 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Company Name SearchCompany NameNormalText50Company Namenvarchar(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]
2No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
3Name Primary Key SearchNameNormalText50Namenvarchar(100)
4Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Company”
  • “Person”
5No. of Opportunities Primary Key SearchNo. of OpportunitiesFlowFieldInteger4
6Estimated Value (LCY) SearchEstimated Value ($)FlowFieldDecimal12
7Calcd. Current Value (LCY) SearchCalcd. Current Value ($)FlowFieldDecimal12
8Avg. Estimated Value (LCY) SearchAvg. Estimated Value ($)FlowFieldDecimal12
9Avg.Calcd. Current Value (LCY) SearchAvg.Calcd. Current Value ($)FlowFieldDecimal12
10Salesperson Filter SearchSalesperson FilterFlowFilterCode20
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
	       [RM Matrix Management].[]
	       ,[Salesperson/Purchaser].[Code]
	FROM
	       [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
	              ON
	                     [RM Matrix Management].[] = [Salesperson/Purchaser].[Code]
11Campaign Filter SearchCampaign FilterFlowFilterCode20
Key to join to the Campaign table.

Show/hide example query

SELECT
	       [RM Matrix Management].[]
	       ,[Campaign].[No_]
	FROM
	       [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
	LEFT JOIN
	       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
	              ON
	                     [RM Matrix Management].[] = [Campaign].[No_]
12Contact Filter SearchContact FilterFlowFilterCode20
Key to join to the Contact table.

Show/hide example query

SELECT
	       [RM Matrix Management].[]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [RM Matrix Management].[] = [Contact].[No_]
13Date Filter SearchDate FilterFlowFilterDate4
14Action Taken Filter SearchAction Taken FilterFlowFilterOption4
15Sales Cycle Filter SearchSales Cycle FilterFlowFilterCode10
Key to join to the Sales Cycle table.

Show/hide example query

SELECT
	       [RM Matrix Management].[]
	       ,[Sales Cycle].[Code]
	FROM
	       [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
	LEFT JOIN
	       [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
	              ON
	                     [RM Matrix Management].[] = [Sales Cycle].[Code]
16Sales Cycle Stage Filter SearchSales Cycle Stage FilterFlowFilterInteger4
17Probability % Filter SearchProbability % FilterFlowFilterDecimal12
18Completed % Filter SearchCompleted % FilterFlowFilterDecimal12
19Company No. SearchCompany No.NormalCode20Company No_nvarchar(40)
20Contact Company Filter SearchContact Company FilterFlowFilterCode20
21Task Status Filter SearchTask Status FilterFlowFilterOption4
22Task Closed Filter SearchTask Closed FilterFlowFilterBoolean4
23Priority Filter SearchPriority FilterFlowFilterOption4
24Team Filter SearchTeam FilterFlowFilterCode10
Key to join to the Team table.

Show/hide example query

SELECT
	       [RM Matrix Management].[]
	       ,[Team].[Code]
	FROM
	       [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
	LEFT JOIN
	       [CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
	              ON
	                     [RM Matrix Management].[] = [Team].[Code]
25No. of Tasks SearchNo. of TasksFlowFieldInteger4
26Estimated Value Filter SearchEstimated Value FilterFlowFilterDecimal12
27Calcd. Current Value Filter SearchCalcd. Current Value FilterFlowFilterDecimal12
28Chances of Success % Filter SearchChances of Success % FilterFlowFilterDecimal12
29Close Opportunity Filter SearchClose Opportunity FilterFlowFilterCode10
Key to join to the Close Opportunity Code table.

Show/hide example query

SELECT
	       [RM Matrix Management].[]
	       ,[Close Opportunity Code].[Code]
	FROM
	       [CRONUS UK Ltd_$RM Matrix Management$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [RM Matrix Management]
	LEFT JOIN
	       [CRONUS UK Ltd_$Close Opportunity Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Close Opportunity Code]
	              ON
	                     [RM Matrix Management].[] = [Close Opportunity Code].[Code]
30System Task Type Filter SearchSystem Task Type FilterFlowFilterOption4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesRRM Matrix Management

Leave a Reply

Your email address will not be published. Required fields are marked *