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
   [timestamp]
   ,[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].[No_]

Show/hide columns in Interaction Merge Data table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Contact No_ Searchnvarchar(40)
4Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Interaction Merge Data].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
5Log Entry Number Searchint
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Interaction Merge Data table

Leave a Reply

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