Relationship Mgmt. Cue

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

Table Type: Company

Table Name: Relationship Mgmt. Cue
Database Table Name: CRONUS UK Ltd_$Relationship Mgmt_ Cue$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 9063

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 Relationship Mgmt. Cue can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Relationship Mgmt_ Cue$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Uninvoiced Bookings]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Relationship Mgmt_ Cue$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Relationship Mgmt_ Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Relationship Mgmt. Cue]
LEFT JOIN
   [User] AS [User]
      ON
         [Relationship Mgmt. Cue].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Relationship Mgmt. Cue].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Relationship Mgmt. Cue table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Contacts SearchContactsFlowFieldInteger4
3Segments SearchSegmentsFlowFieldInteger4
4Logged Segments SearchLogged SegmentsFlowFieldInteger4
5Open Opportunities SearchOpen OpportunitiesFlowFieldInteger4
6Closed Opportunities SearchClosed OpportunitiesFlowFieldInteger4
7Opportunities Due in 7 Days SearchOpportunities Due in 7 DaysFlowFieldInteger4
8Overdue Opportunities SearchOverdue OpportunitiesFlowFieldInteger4
9Sales Cycles SearchSales CyclesFlowFieldInteger4
10Sales Persons SearchSales PersonsFlowFieldInteger4
11Contacts – Open Opportunities SearchContacts – Open OpportunitiesFlowFieldInteger4
12Contacts – Companies SearchContacts – CompaniesFlowFieldInteger4
13Contacts – Persons SearchContacts – PersonsFlowFieldInteger4
14Contacts – Duplicates SearchContacts – DuplicatesFlowFieldInteger4
18Due Date Filter SearchDue Date FilterFlowFilterDate4
19Overdue Date Filter SearchOverdue Date FilterFlowFilterDate4
20Open Sales Quotes SearchOpen Sales QuotesFlowFieldInteger4
21Open Sales Orders SearchOpen Sales OrdersFlowFieldInteger4
22Active Campaigns SearchActive CampaignsFlowFieldInteger4
23Uninvoiced Bookings SearchUninvoiced BookingsNormalInteger4Uninvoiced Bookingsint
24Coupled Data Synch Errors SearchCoupled Data Synch ErrorsFlowFieldInteger4
25CDS Integration Errors SearchDataverse Integration ErrorsFlowFieldInteger4
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
       [Relationship Mgmt. Cue].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Relationship Mgmt_ Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Relationship Mgmt. Cue]
LEFT JOIN
       [User] AS [User]
              ON
                     [Relationship Mgmt. Cue].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Relationship Mgmt. Cue].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Relationship Mgmt_ Cue$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Relationship Mgmt. Cue]
LEFT JOIN
       [User] AS [User]
              ON
                     [Relationship Mgmt. Cue].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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