| Table Name: | user_touch |
| Table Number: | 5464 |
| Group: | Sales Mgr |
| Description: | Records the user's last access to instances of selected object types as defined by the members of the 'touched by' Exclusive Set |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| last_touch_time | CLK_TIME | datetime | 46 | Time stamp of the last time the user touched the object | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| source_lowid | LONG | int | DIRECT, ALLOW_NULL | Internal record number of the touched object | ||||
| source_type | LONG | smallint | DIRECT, ALLOW_NULL | Object type ID of touched object | ||||
| touch_type | LONG | smallint | 0 | DIRECT | Type of user touch; i.e., 0=view |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| user_touch2bus_org | MTO | bus_org | bus_org2user_touch | For a last user_touch that involved a bus_org, the bus_org | touched_by | source_type | source_lowid | |||
| user_touch2contact | MTO | contact | contact2user_touch | For a last user_touch that involved a contact, the contact | touched_by | source_type | source_lowid | |||
| user_touch2lead | MTO | lead | lead2user_touch | For a last user_touch that involved a lead, the lead | touched_by | source_type | source_lowid | |||
| user_touch2notes_log | MTO | notes_log | notes_log2user_touch | For a last user_touch that involved a notes_log, the notes_log | touched_by | source_type | source_lowid | |||
| user_touch2opportunity | MTO | opportunity | opp2user_touch | For a last user_touch that involved an opportunity, the opportunity | touched_by | source_type | source_lowid | |||
| user_touch2task | MTO | task | task2user_touch | For a last user_touch that involved a task, the task | touched_by | source_type | source_lowid | |||
| touched_by2user | MTO | user | user2user_touch | User for whom the touch is recorded | ||||||
| Index Name | Fields | Flags |
|---|---|---|
| I5464 | touched_by2user:source_type:source_lowid | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5464 | touched_by2user, source_type, source_lowid | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| st5464 | source_type, source_lowid | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|
| user_touch | |||