Table 5065 "Interaction Log Entry"

Base Application · Microsoft.CRM.Interaction · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5076 “Interaction Log Entries” (1 Learn page).

Properties

Property	Value
Caption	Interaction Log Entry
DataClassification	CustomerContent
Permissions	tabledata “Interaction Log Entry” = rimd, tabledata “Inter. Log Entry Comment Line” = rd

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Entry No. Δ BC28	Integer	Specifies the number of the entry, as assigned from the specified number series when the entry was created.
2	Contact No. Δ BC28	Code[20]	Specifies the number of the contact involved in this interaction. This field is not editable.	TableRelation Table 5050 “Contact”
3	Contact Company No. Δ BC28	Code[20]	Specifies the number of the contact company.	TableRelation Table 5050 “Contact” (Contact where(Type = const(Company)))
4	Date Δ BC28	Date	Specifies the date that you have entered in the Date field in the Create Interaction wizard or the Segment window when you created the interaction. The field is not editable.
5	Description Δ BC28	Text[100]	Specifies the description of the interaction.
6	Information Flow Δ BC28	Option	Specifies the direction of information flow recorded by the interaction. There are two options: Outbound (the information was received by your contact) and Inbound (the information was received by your company).	OptionCaption: ,Outbound,Inbound
7	Initiated By Δ BC28	Option	Specifies who initiated the interaction. There are two options: Us (the interaction was initiated by your company) and Them (the interaction was initiated by your contact).	OptionCaption: ,Us,Them
8	Attachment No.	Integer	—	TableRelation Table 5062 “Attachment”
9	Cost (LCY) Δ BC27	Decimal	Specifies the cost of the interaction. via Page 5076 “Interaction Log Entries”	not editable
10	Duration (Min.) Δ BC27	Decimal	Specifies the duration of the interaction. via Page 5076 “Interaction Log Entries”	not editable
11	User ID Δ BC28	Code[50]	Specifies the ID of the user who logged this entry. This field is not editable.	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
12	Interaction Group Code Δ BC28	Code[10]	Specifies the code of the interaction group used to create this interaction. This field is not editable.	TableRelation Table 5063 “Interaction Group” (Interaction Group)
13	Interaction Template Code Δ BC28	Code[10]	Specifies the code for the interaction template used to create the interaction. This field is not editable.	TableRelation Table 5064 “Interaction Template” (Interaction Template)
14	Campaign No. Δ BC28	Code[20]	Specifies the number of the campaign (if any) to which the interaction is linked. This field is not editable.	TableRelation Table 5071 “Campaign”
15	Campaign Entry No. Δ BC28	Integer	Specifies the number of the campaign entry to which the interaction log entry is linked.	TableRelation Table 5072 “Campaign Entry” (“Campaign Entry” where(“Campaign No.” = field(“Campaign No.”)))
16	Campaign Response Δ BC28	Boolean	Specifies whether the interaction records a response to a campaign.
17	Campaign Target Δ BC28	Boolean	Specifies whether the interaction is applied to contacts that are part of the campaign target. This field is not editable.
18	Segment No. Δ BC28	Code[20]	Specifies the number of the segment. This field is valid only for interactions created for segments, and is not editable.
19	Evaluation Δ BC28	Enum “Interaction Evaluation”	Specifies the evaluation of the interaction. There are five options: Very Positive, Positive, Neutral, Negative, and Very Negative.	enum Enum 5078 “Interaction Evaluation”; not editable
20	Time of Interaction Δ BC28	Time	Specifies the time when the interaction was created. This field is not editable.
21	Attempt Failed Δ BC28	Boolean	Specifies whether the interaction records an failed attempt to reach the contact. This field is not editable.
23	To-do No. Δ BC28	Code[20]	Specifies the number of the task if the interaction has been created to complete a task. This field is not editable.	TableRelation Table 5080 “To-do” (To-do)
24	Salesperson Code Δ BC28	Code[20]	Specifies the code for the salesperson who carried out the interaction. This field is not editable.	TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
25	Delivery Status Δ BC28	Enum “Interaction Delivery Status”	Specifies the status of the delivery of the attachment. There are three options:	enum Enum 5083 “Interaction Delivery Status”
26	Canceled Δ BC28	Boolean	Specifies whether the interaction has been canceled. The field is not editable.
27	Correspondence Type Δ BC28	Enum “Correspondence Type”	Specifies the type of correspondence of the attachment in the interaction template. This field is not editable.	enum Enum 5076 “Correspondence Type”
28	Contact Alt. Address Code	Code[10]	—	TableRelation Table 5051 “Contact Alt. Address” (“Contact Alt. Address”.Code where(“Contact No.” = field(“Contact No.”)))
29	Logged Segment Entry No.	Integer	—	TableRelation Table 5075 “Logged Segment” (Logged Segment)
30	Document Type Δ BC28	Enum “Interaction Log Entry Document Type”	Specifies the type of document if there is one that the interaction log entry records. You cannot change the contents of this field.	enum Enum 5099 “Interaction Log Entry Document Type”
31	Document No. Δ BC28	Code[20]	Specifies the number of the document (if any) that the interaction log entry records.
32	Version No.	Integer	—
33	Doc. No. Occurrence	Integer	—
34	Contact Via Δ BC28	Text[80]	Specifies the telephone number that you used when calling the contact.
35	Send Word Docs. as Attmt.	Boolean	—
36	Interaction Language Code Δ BC28	Code[10]	Specifies the language code for the interaction for the interaction log. The code is copied from the language code of the interaction template, if one is specified.	TableRelation Table 8 “Language”
37	E-Mail Logged	Boolean	Email Logged caption
38	Subject Δ BC28	Text[100]	Specifies the subject text that will be used for this interaction.
39	Contact Name Δ BC24 Δ BC28	Text[100]	Specifies the name of the contact for which an interaction has been logged.	FlowField: lookup(Contact.Name where(“No.” = field(“Contact No.”))); not editable
40	Contact Company Name Δ BC24 Δ BC28	Text[100]	Specifies the name of the contact company for which an interaction has been logged.	FlowField: lookup(Contact.Name where(“No.” = field(“Contact Company No.”), Type = const(Company))); not editable
43	Comment Δ BC28	Boolean	Specifies that a comment exists for this interaction log entry.	FlowField: exist(“Inter. Log Entry Comment Line” where(“Entry No.” = field(“Entry No.”))); not editable
44	Opportunity No. Δ BC28	Code[20]	Specifies the number of the opportunity to which the interaction is linked.	TableRelation Table 5092 “Opportunity”
45	Postponed	Boolean	—
46	Word Template Code	Code[30]	—
47	Merged	Boolean	—	DataClassification SystemMetadata
48	Modified Word Template	Integer	—	DataClassification SystemMetadata

Keys

Key1: Entry No. (clustered)
Key2: Contact Company No., Contact No., Date, Postponed
Key3: Contact Company No., Date, Contact No., Canceled, Initiated By, Attempt Failed, Postponed
Key4: Interaction Group Code, Date
Key5: Interaction Group Code, Canceled, Date, Postponed
Key6: Interaction Template Code, Date
Key7: Interaction Template Code, Canceled, Date, Postponed
Key8: Canceled, Campaign No., Campaign Entry No., Date, Postponed
Key9: Campaign No., Campaign Entry No., Date, Postponed
Key10: Salesperson Code, Date, Postponed
Key11: Canceled, Salesperson Code, Date, Postponed
Key12: Logged Segment Entry No., Postponed
Key13: Attachment No.
Key14: To-do No., Date
Key15: Contact No., Correspondence Type, E-Mail Logged, Subject, Postponed
Key16: Campaign No., Campaign Target
Key17: Campaign No., Contact Company No., Campaign Target, Postponed
Key18: Opportunity No., Date

Events published

OnAfterCopyFromSegment(var InteractionLogEntry: Record "Interaction Log Entry"; SegmentLine: Record "Segment Line") (integration)
OnAfterShowDocument(var InteractionLogEntry: Record "Interaction Log Entry") (integration)
OnBeforeOpenAttachment(var InteractionLogEntry: Record "Interaction Log Entry"; var IsHandled: Boolean; var Attachment: Record Attachment) (integration)
OnBeforeShowDocument(var InteractionLogEntry: Record "Interaction Log Entry"; var IsHandled: Boolean) (integration)
- subscribers: Codeunit 6467 “Serv. Interaction Log Mgt.” OnBeforeShowDocument
OnBeforeSetCanceledCheckmark(var InteractionLogEntry: Record "Interaction Log Entry"; CanceledCheckmark: Boolean; RemoveUniqueAttachment: Boolean; var IsHandled: Boolean) (integration)
OnAfterOpenAttachment(var InteractionLogEntry: Record "Interaction Log Entry"; Attachment: Record Attachment; var SegmentLine: Record "Segment Line") (integration)
OnOpenAttachmentOnBeforeShowAttachment(var InteractionLogEntry: Record "Interaction Log Entry"; var SegmentLine: Record "Segment Line"; var Attachment: Record Attachment) (integration)
OnResumeInteractionOnBeforeStartWizard(InteractionLogEntry: Record "Interaction Log Entry"; var SegmentLine: Record "Segment Line"; var IsHandled: Boolean) (integration)
OnResumeInteractionOnAfterDateValidation(var TempSegmentLine: Record "Segment Line" temporary) (integration)

Procedures

InsertRecord() Δ BC26
AssignNewOpportunity()
CanCreateOpportunity(): Boolean
CopyFromSegment(SegLine: Record "Segment Line")
CreateInteraction()
CreateTask()
OpenAttachment()
ToggleCanceledCheckmark()
SetCanceledCheckmark(CanceledCheckmark: Boolean; RemoveUniqueAttachment: Boolean)
UniqueAttachment(): Boolean
ShowDocument()
EvaluateInteraction()
ResumeInteraction()
GetEntryTitle(): Text

Plus 2 local procedures.

Triggers

OnDelete

Relations

drill-down page Page 5076 “Interaction Log Entries”
lookup page Page 5076 “Interaction Log Entries”
Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
Contact Company Name: CalcFormula Table 5050 “Contact”
Contact Name: CalcFormula Table 5050 “Contact”
Contact Company No.: TableRelation Table 5050 “Contact”
Contact No.: TableRelation Table 5050 “Contact”
Contact Alt. Address Code: TableRelation Table 5051 “Contact Alt. Address”
Attachment No.: TableRelation Table 5062 “Attachment”
Interaction Group Code: TableRelation Table 5063 “Interaction Group”
Interaction Template Code: TableRelation Table 5064 “Interaction Template”
Campaign No.: TableRelation Table 5071 “Campaign”
Campaign Entry No.: TableRelation Table 5072 “Campaign Entry”
Logged Segment Entry No.: TableRelation Table 5075 “Logged Segment”
To-do No.: TableRelation Table 5080 “To-do”
Opportunity No.: TableRelation Table 5092 “Opportunity”
Comment: CalcFormula Table 5123 “Inter. Log Entry Comment Line”
Interaction Language Code: TableRelation Table 8 “Language”

Referenced by

25 fields in 10 objects relate to this table (TableRelation or CalcFormula).

Table 5050 “Contact”: Cost (LCY), Date of Last Interaction, Duration (Min.), Last Date Attempted, No. of Interactions
Table 5071 “Campaign”: Contacts Responded, Cost (LCY), Duration (Min.), Target Contacts Contacted
Table 13 “Salesperson/Purchaser”: Cost (LCY), Duration (Min.), No. of Interactions
Table 5063 “Interaction Group”: Cost (LCY), Duration (Min.), No. of Interactions
Table 5064 “Interaction Template”: Cost (LCY), Duration (Min.), No. of Interactions
Table 5072 “Campaign Entry”: Cost (LCY), Duration (Min.), No. of Interactions
Table 5075 “Logged Segment”: No. of Interactions
Table 5092 “Opportunity”: No. of Interactions
Table 5106 “Interaction Merge Data”: Log Entry Number
Table 5123 “Inter. Log Entry Comment Line”: Entry No.

Pages and codeunits on this table

Page 5073 “Contact Int. Entries Subform” (source table)
Page 5076 “Interaction Log Entries” (source table)
Page 5082 “Postponed Interactions” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 700 “Page Management” (2 calls: ShowDocument → PageRun, ShowDocument → PageRunList)
Codeunit 9500 “Sequence No. Mgt.” (2 calls: InsertRecord → GetNextSeqNo, InsertRecord → RebaseSeqNo)
Codeunit 1299 “Web Request Helper” (1 call: OpenAttachment → IsHttpUrl)
Codeunit 7030 “Campaign Target Group Mgt” (1 call: OnDelete → DeleteContfromTargetGr)
Page 438 “Issued Reminder” (1 call: ShowDocument → (object))
Page 450 “Issued Finance Charge Memo” (1 call: ShowDocument → (object))
Page 5159 “Sales Order Archive” (1 call: ShowDocument → (object))
Page 5162 “Sales Quote Archive” (1 call: ShowDocument → (object))
Page 5164 “Purchase Quote Archive” (1 call: ShowDocument → (object))
Page 5167 “Purchase Order Archive” (1 call: ShowDocument → (object))
Page 6620 “Blanket Sales Order Archive” (1 call: ShowDocument → (object))
Page 6623 “Blanket Purchase Order Archive” (1 call: ShowDocument → (object))

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Interaction Log Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.