Interaction Log Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInteraction 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: 5065

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

   [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]
   ,[Merged]
   ,[Modified Word Template]
   ,[$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_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group]
      ON
         [Interaction Log Entry].[Interaction Group Code] = [Interaction Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
      ON
         [Interaction Log Entry].[Interaction Template Code] = [Interaction Template].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Interaction Log Entry].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Interaction Log Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Interaction Log Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Interaction Log Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Interaction Log Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Interaction Log Entry].[Interaction Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template]
      ON
         [Interaction Log Entry].[Word Template Code] = [Word Template].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Log Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Interaction Log Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Interaction Log Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Contact No.	Contact No.	Normal	Code	20	Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Interaction Log Entry].[Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Interaction Log Entry].[Contact No_] = [Contact].[No_]
3	Contact Company No.	Contact Company No.	Normal	Code	20	Contact Company No_	nvarchar(40)
4	Date	Date	Normal	Date	4	Date	datetime
5	Description	Description	Normal	Text	100	Description	nvarchar(200)
6	Information Flow	Information Flow	Normal	Option	4	Information Flow	int
	Available options are: ” “ “Outbound” “Inbound”
7	Initiated By	Initiated By	Normal	Option	4	Initiated By	int
	Available options are: ” “ “Us” “Them”
8	Attachment No.	Attachment No.	Normal	Integer	4	Attachment No_	int
	Key to join to the Attachment table. Show/hide example query SELECT [Interaction Log Entry].[Attachment No_] ,[Attachment].[No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment] ON [Interaction Log Entry].[Attachment No_] = [Attachment].[No_]
9	Cost (LCY)	Cost ($)	Normal	Decimal	12	Cost (LCY)	decimal(38,38)
10	Duration (Min.)	Duration (Min.)	Normal	Decimal	12	Duration (Min_)	decimal(38,38)
11	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
12	Interaction Group Code	Interaction Group Code	Normal	Code	10	Interaction Group Code	nvarchar(20)
	Key to join to the Interaction Group table. Show/hide example query SELECT [Interaction Log Entry].[Interaction Group Code] ,[Interaction Group].[Code] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Interaction Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Group] ON [Interaction Log Entry].[Interaction Group Code] = [Interaction Group].[Code]
13	Interaction Template Code	Interaction Template Code	Normal	Code	10	Interaction Template Code	nvarchar(20)
	Key to join to the Interaction Template table. Show/hide example query SELECT [Interaction Log Entry].[Interaction Template Code] ,[Interaction Template].[Code] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template] ON [Interaction Log Entry].[Interaction Template Code] = [Interaction Template].[Code]
14	Campaign No.	Campaign No.	Normal	Code	20	Campaign No_	nvarchar(40)
	Key to join to the Campaign table. Show/hide example query SELECT [Interaction Log Entry].[Campaign No_] ,[Campaign].[No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign] ON [Interaction Log Entry].[Campaign No_] = [Campaign].[No_]
15	Campaign Entry No.	Campaign Entry No.	Normal	Integer	4	Campaign Entry No_	int
	Key to join to the Campaign Entry table. Show/hide example query SELECT [Interaction Log Entry].[Campaign Entry No_] ,[Campaign Entry].[Entry No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Campaign Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign Entry] ON [Interaction Log Entry].[Campaign Entry No_] = [Campaign Entry].[Entry No_]
16	Campaign Response	Campaign Response	Normal	Boolean	4	Campaign Response	tinyint
17	Campaign Target	Campaign Target	Normal	Boolean	4	Campaign Target	tinyint
18	Segment No.	Segment No.	Normal	Code	20	Segment No_	nvarchar(40)
	Key to join to the Segment Header table. Show/hide example query SELECT [Interaction Log Entry].[Segment No_] ,[Segment Header].[No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header] ON [Interaction Log Entry].[Segment No_] = [Segment Header].[No_]
19	Evaluation	Evaluation	Normal	Option	4	Evaluation	int
	Available options are: ” “ “Very Positive” “Positive” “Neutral” “Negative” “Very Negative”
20	Time of Interaction	Time of Interaction	Normal	Time	4	Time of Interaction	datetime
21	Attempt Failed	Attempt Failed	Normal	Boolean	4	Attempt Failed	tinyint
23	To-do No.	Task No.	Normal	Code	20	To-do No_	nvarchar(40)
	Key to join to the To-do table. Show/hide example query SELECT [Interaction Log Entry].[To-do No_] ,[To-do].[No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do] ON [Interaction Log Entry].[To-do No_] = [To-do].[No_]
24	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Interaction Log Entry].[Salesperson Code] ,[Salesperson/Purchaser].[Code] 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].[Code]
25	Delivery Status	Delivery Status	Normal	Option	4	Delivery Status	int
	Available options are: ” “ “In Progress” “Error”
26	Canceled	Canceled	Normal	Boolean	4	Canceled	tinyint
27	Correspondence Type	Correspondence Type	Normal	Option	4	Correspondence Type	int
	Available options are: ” “ “Hard Copy” “Email” “Fax”
28	Contact Alt. Address Code	Contact Alt. Address Code	Normal	Code	10	Contact Alt_ Address Code	nvarchar(20)
29	Logged Segment Entry No.	Logged Segment Entry No.	Normal	Integer	4	Logged Segment Entry No_	int
	Key to join to the Logged Segment table. Show/hide example query SELECT [Interaction Log Entry].[Logged Segment Entry No_] ,[Logged Segment].[Entry No_] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Logged Segment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Logged Segment] ON [Interaction Log Entry].[Logged Segment Entry No_] = [Logged Segment].[Entry No_]
30	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Sales Qte.” “Sales Blnkt. Ord” “Sales Ord. Cnfrmn.” “Sales Inv.” “Sales Shpt. Note” “Sales Cr. Memo” “Sales Stmnt.” “Sales Rmdr.” “Serv. Ord. Create” “Serv. Ord. Post” “Purch.Qte.” “Purch. Blnkt. Ord.” “Purch. Ord.” “Purch. Inv.” “Purch. Rcpt.” “Purch. Cr. Memo” “Cover Sheet” “Sales Return Order” “Sales Finance Charge Memo” “Sales Return Receipt” “Purch. Return Shipment” “Purch. Return Ord. Cnfrmn.” “Service Contract” “Service Contract Quote” “Service Quote” “Sales Draft Invoice”
31	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
32	Version No.	Version No.	Normal	Integer	4	Version No_	int
33	Doc. No. Occurrence	Doc. No. Occurrence	Normal	Integer	4	Doc_ No_ Occurrence	int
34	Contact Via	Contact Via	Normal	Text	80	Contact Via	nvarchar(160)
35	Send Word Docs. as Attmt.	Send Word Docs. as Attmt.	Normal	Boolean	4	Send Word Docs_ as Attmt_	tinyint
36	Interaction Language Code	Interaction Language Code	Normal	Code	10	Interaction Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Interaction Log Entry].[Interaction Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Interaction Log Entry].[Interaction Language Code] = [Language].[Code]
37	E-Mail Logged	Email Logged	Normal	Boolean	4	E-Mail Logged	tinyint
38	Subject	Subject	Normal	Text	100	Subject	nvarchar(200)
39	Contact Name	Contact Name	FlowField	Text	100
40	Contact Company Name	Contact Company Name	FlowField	Text	100
43	Comment	Comment	FlowField	Boolean	4
44	Opportunity No.	Opportunity No.	Normal	Code	20	Opportunity No_	nvarchar(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_]
45	Postponed	Postponed	Normal	Boolean	4	Postponed	tinyint
46	Word Template Code	Word Template Code	Normal	Code	30	Word Template Code	nvarchar(60)
	Key to join to the Word Template table. Show/hide example query SELECT [Interaction Log Entry].[Word Template Code] ,[Word Template].[Code] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [CRONUS UK Ltd_$Word Template$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Word Template] ON [Interaction Log Entry].[Word Template Code] = [Word Template].[Code]
47	Merged	Merged	Normal	Boolean	4	Merged	tinyint
48	Modified Word Template	Modified Word Template	Normal	Integer	4	Modified Word Template	int
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Interaction Log Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Interaction Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Log Entry] LEFT JOIN [User] AS [User] ON [Interaction Log Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Interaction Log Entry table

Dynamics 365 BC Table Reference Tables Company Tables IInteraction Log Entry

Leave a Reply Cancel reply