interact_objid | interact | objid | objid from interact table | 3 (UNIQUE) |
interact_id | interact | interact_id | Unique, system-managed, interaction identifier | |
create_date | interact | create_date | The create date and time of the interact object | |
inserted_by | interact | inserted_by | Process which created the interact object | |
external_id | interact | external_id | Tracking ID from an external system | |
direction | interact | direction | The direction of the interaction; e.g., inbound, outbound, etc. From user-defined popup list with default name Interaction Direction | |
type | interact | type | The type of interaction; e.g., call, email, letter, fax, etc. From user-defined popup list with default name Interaction Type | |
origin | interact | origin | Actual source of interaction. This is from a user-defined popup with default name Interaction Origin | |
product | interact | product | Informal product identification. This is from a user-defined popup with default name Interaction Product | |
reason_1 | interact | reason_1 | Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_1 | |
reason_2 | interact | reason_2 | Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_2 | |
reason_3 | interact | reason_3 | Categorization of the reason for the interaction. From user-defined popup list with default name Interaction Reason_3 | |
result | interact | result | Standard result code. From user-defined popup list with default name Interaction Result Code | |
done_in_one | interact | done_in_one | Completed during the interaction; i.e., 0=no, 1=yes, default=0 | |
fee_based | interact | fee_based | Indicates whether the interaction has a fee; i.e., 0=no 1=yes, default=0 | |
wait_time | interact | wait_time | Length of time in seconds the customer spent waiting for service | |
system_time | interact | system_time | Computed length of the interaction. End_date minus start_date in seconds | |
entered_time | interact | entered_time | Manually entered length of the interaction in seconds. Allows agent to override computed time. Defaults to system_time | |
pay_option | interact | pay_option | Type of payment for the interaction; e.g., contract, incident, pay-per-call, etc. From user defined pop up list with default name Interaction Pay Option | |
title | interact | title | Summary of what took place | |
start_date | interact | start_date | The start date and time of the interaction | |
end_date | interact | end_date | The finish date and time of the interaction | |
last_name | interact | last_name | Respondent last name | |
first_name | interact | first_name | Respondent first name | |
phone | interact | phone | Respondent primary phone number which includes area code, number, and extension. Defaulted from contact phone | |
fax_number | interact | fax_number | Respondent fax number which includes area code, number, and extension. Defaulted from contact.fax_number | |
email | interact | email | Respondent e-mail address. Defaults from contact.e_mail | |
zipcode | interact | zipcode | Respondent zipcode defaulted from contact/site/address zipcode | |
arch_ind | interact | arch_ind | When set to 1, indicates the object is ready for purge/archive | |
agent | interact | agent | Clarify user login name or external agent name | 2 |
dev | interact | dev | Row version number for mobile distribution purposes | 151 |
serial_no | interact | serial_no | Installed part's serial number | |
mobile_phone | interact | mobile_phone | Contact's mobile phone number which includes area code, number, and extension | |
notes | interact_txt | notes | Notes describing additional information about an interaction | 23 |
interact2user | user | objid | User who administered the interaction | |
interact2contact | contact | objid | Related contact if respondent was a contact | |
interact2case | case | objid | Case that was covered in the interaction | |
interact2opportunity | opportunity | objid | Opportunity that was covered in the interaction | |