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: 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Contact No. Primary Key SearchContact No.NormalCode20Contact 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_]
3Contact Company No. SearchContact Company No.NormalCode20Contact Company No_nvarchar(40)
4Date SearchDateNormalDate4Datedatetime
5Description SearchDescriptionNormalText100Descriptionnvarchar(200)
6Information Flow SearchInformation FlowNormalOption4Information Flowint
Available options are:
  • ” “
  • “Outbound”
  • “Inbound”
7Initiated By SearchInitiated ByNormalOption4Initiated Byint
Available options are:
  • ” “
  • “Us”
  • “Them”
8Attachment No. SearchAttachment No.NormalInteger4Attachment 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_]
9Cost (LCY) SearchCost ($)NormalDecimal12Cost (LCY)decimal(38,38)
10Duration (Min.) SearchDuration (Min.)NormalDecimal12Duration (Min_)decimal(38,38)
11User ID SearchUser IDNormalCode50User IDnvarchar(100)
12Interaction Group Code SearchInteraction Group CodeNormalCode10Interaction Group Codenvarchar(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]
13Interaction Template Code SearchInteraction Template CodeNormalCode10Interaction Template Codenvarchar(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]
14Campaign No. SearchCampaign No.NormalCode20Campaign 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_]
15Campaign Entry No. SearchCampaign Entry No.NormalInteger4Campaign 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_]
16Campaign Response SearchCampaign ResponseNormalBoolean4Campaign Responsetinyint
17Campaign Target SearchCampaign TargetNormalBoolean4Campaign Targettinyint
18Segment No. SearchSegment No.NormalCode20Segment 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_]
19Evaluation SearchEvaluationNormalOption4Evaluationint
Available options are:
  • ” “
  • “Very Positive”
  • “Positive”
  • “Neutral”
  • “Negative”
  • “Very Negative”
20Time of Interaction SearchTime of InteractionNormalTime4Time of Interactiondatetime
21Attempt Failed SearchAttempt FailedNormalBoolean4Attempt Failedtinyint
23To-do No. SearchTask No.NormalCode20To-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_]
24Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(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]
25Delivery Status SearchDelivery StatusNormalOption4Delivery Statusint
Available options are:
  • ” “
  • “In Progress”
  • “Error”
26Canceled SearchCanceledNormalBoolean4Canceledtinyint
27Correspondence Type SearchCorrespondence TypeNormalOption4Correspondence Typeint
Available options are:
  • ” “
  • “Hard Copy”
  • “Email”
  • “Fax”
28Contact Alt. Address Code SearchContact Alt. Address CodeNormalCode10Contact Alt_ Address Codenvarchar(20)
29Logged Segment Entry No. SearchLogged Segment Entry No.NormalInteger4Logged 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_]
30Document Type SearchDocument TypeNormalOption4Document Typeint
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”
31Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
32Version No. SearchVersion No.NormalInteger4Version No_int
33Doc. No. Occurrence SearchDoc. No. OccurrenceNormalInteger4Doc_ No_ Occurrenceint
34Contact Via SearchContact ViaNormalText80Contact Vianvarchar(160)
35Send Word Docs. as Attmt. SearchSend Word Docs. as Attmt.NormalBoolean4Send Word Docs_ as Attmt_tinyint
36Interaction Language Code SearchInteraction Language CodeNormalCode10Interaction Language Codenvarchar(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]
37E-Mail Logged SearchEmail LoggedNormalBoolean4E-Mail Loggedtinyint
38Subject SearchSubjectNormalText100Subjectnvarchar(200)
39Contact Name SearchContact NameFlowFieldText100
40Contact Company Name SearchContact Company NameFlowFieldText100
43Comment SearchCommentFlowFieldBoolean4
44Opportunity No. SearchOpportunity No.NormalCode20Opportunity 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_]
45Postponed SearchPostponedNormalBoolean4Postponedtinyint
46Word Template Code SearchWord Template CodeNormalCode30Word Template Codenvarchar(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]
47Merged SearchMergedNormalBoolean4Mergedtinyint
48Modified Word Template SearchModified Word TemplateNormalInteger4Modified Word Templateint
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 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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Interaction Log Entry table

Leave a Reply

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