Interaction Merge Data

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

Table Type: Company

Table Name: Interaction Merge Data
Database Table Name: CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5106

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 Interaction Merge Data can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [ID]
   ,[Contact No_]
   ,[Salesperson Code]
   ,[Log Entry Number]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Merge Data]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Interaction Merge Data].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry]
      ON
         [Interaction Merge Data].[Log Entry Number] = [Interaction Log Entry].[Entry No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Merge Data].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Merge Data].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Interaction Merge Data table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalGUID16IDuniqueidentifier
2Contact No. SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Interaction Merge Data].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Merge Data]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Interaction Merge Data].[Contact No_] = [Contact].[No_]
3Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Interaction Merge Data].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Merge Data]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Interaction Merge Data].[Salesperson Code] = [Salesperson/Purchaser].[Code]
4Log Entry Number SearchLog Entry NumberNormalInteger4Log Entry Numberint
Key to join to the Interaction Log Entry table.

Show/hide example query

SELECT
       [Interaction Merge Data].[Log Entry Number]
       ,[Interaction Log Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Merge Data]
LEFT JOIN
       [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry]
              ON
                     [Interaction Merge Data].[Log Entry Number] = [Interaction Log Entry].[Entry No_]
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
       [Interaction Merge Data].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Merge Data]
LEFT JOIN
       [User] AS [User]
              ON
                     [Interaction Merge Data].[$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
       [Interaction Merge Data].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Interaction Merge Data$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Merge Data]
LEFT JOIN
       [User] AS [User]
              ON
                     [Interaction Merge Data].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Interaction Merge Data table

Leave a Reply

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