Interaction Log Entry

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

Table Type: Company

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

Table Number: 0

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 Log Entry can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Contact No_]
   ,[Contact Company No_]
   ,[Date]
   ,[Description]
   ,[Information Flow]
   ,[Initiated By]
   ,[Attachment No_]
   ,[Cost (LCY)]
   ,[Duration (Min_)]
   ,[User ID]
   ,[Interaction Group Code]
   ,[Interaction Template Code]
   ,[Campaign No_]
   ,[Campaign Entry No_]
   ,[Campaign Response]
   ,[Campaign Target]
   ,[Segment No_]
   ,[Evaluation]
   ,[Time of Interaction]
   ,[Attempt Failed]
   ,[To-do No_]
   ,[Salesperson Code]
   ,[Delivery Status]
   ,[Canceled]
   ,[Correspondence Type]
   ,[Contact Alt_ Address Code]
   ,[Logged Segment Entry No_]
   ,[Document Type]
   ,[Document No_]
   ,[Version No_]
   ,[Doc_ No_ Occurrence]
   ,[Contact Via]
   ,[Send Word Docs_ as Attmt_]
   ,[Interaction Language Code]
   ,[E-Mail Logged]
   ,[Subject]
   ,[Opportunity No_]
   ,[Postponed]
   ,[Word Template Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Interaction Log Entry$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 Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Interaction Log Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Interaction Log Entry].[Opportunity No_] = [Opportunity].[No_]

Show/hide columns in Interaction Log Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Contact No_ Searchnvarchar(40)
4Contact Company No_ Searchnvarchar(40)
5Date Searchdatetime
6Description Searchnvarchar(200)
7Information Flow Searchint
8Initiated By Searchint
9Attachment No_ Searchint
10Cost (LCY) Searchdecimal(38,38)
11Duration (Min_) Searchdecimal(38,38)
12User ID Searchnvarchar(100)
13Interaction Group Code Searchnvarchar(20)
14Interaction Template Code Searchnvarchar(20)
15Campaign No_ Searchnvarchar(40)
16Campaign Entry No_ Searchint
17Campaign Response Searchtinyint
18Campaign Target Searchtinyint
19Segment No_ Searchnvarchar(40)
20Evaluation Searchint
21Time of Interaction Searchdatetime
22Attempt Failed Searchtinyint
23To-do No_ Searchnvarchar(40)
24Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Interaction Log Entry].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Interaction Log Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]
25Delivery Status Searchint
26Canceled Searchtinyint
27Correspondence Type Searchint
28Contact Alt_ Address Code Searchnvarchar(20)
29Logged Segment Entry No_ Searchint
30Document Type Searchint
31Document No_ Searchnvarchar(40)
32Version No_ Searchint
33Doc_ No_ Occurrence Searchint
34Contact Via Searchnvarchar(160)
35Send Word Docs_ as Attmt_ Searchtinyint
36Interaction Language Code Searchnvarchar(20)
37E-Mail Logged Searchtinyint
38Subject Searchnvarchar(200)
39Opportunity No_ Searchnvarchar(40)
Key to join to the Opportunity table.

Show/hide example query

SELECT
       [Interaction Log Entry].[Opportunity No_]
       ,[Opportunity].[No_]
FROM
       [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
              ON
                     [Interaction Log Entry].[Opportunity No_] = [Opportunity].[No_]
40Postponed Searchtinyint
41Word Template Code Searchnvarchar(60)
42$systemId Searchuniqueidentifier
43$systemCreatedAt Searchdatetime
44$systemCreatedBy Searchuniqueidentifier
45$systemModifiedAt Searchdatetime
46$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Interaction Log Entry table

Leave a Reply

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