| View Name: | account_interaction |
| View Number: | 5849 |
| Group: | CIM |
| Description: | View for interactions related to account. Used in interaction_home_html_2_account_tab.jsp JSP page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| channel_inst_objid | channel_inst | objid | Channel inst internal record number | 3 (UNIQUE) |
| account_objid | bus_org | objid | account internal record number | |
| interaction_objid | intrxn | objid | Interaction internal record number | |
| create_on | intrxn | start_time | Date and time the interaction was started | |
| title | intrxn | title | Summary of what took place | |
| type | medium | title | Common name of the medium | |
| direction | intrxn | direction | The direction of the interaction; i.e 0=unknown, 1=inbound, 2=outbound | |
| contact_first | contact | first_name | Contact's first name | |
| contact_last | contact | last_name | Contact's last name |
| Join From | Join To |
|---|---|
| (intrxn).intrxn2bus_org | (bus_org).bus_org2intrxn |
| (intrxn).intrxn2contact | (contact).contact2intrxn |
| (channel_inst).channel_inst2intrxn | (intrxn).intrxn2channel_inst |
| (channel_inst).channel_inst2channel | (channel).channel2channel_inst |
| (channel).channel2medium | (medium).medium2channel |
| account_interaction | |||