| Table Name: | exch_log |
| Table Number: | 5142 |
| Group: | Exchange Mgr |
| Description: | Records exchange events |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| comments | CHAR | text | ALLOW_NULL | Notes about the event | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| entry_time | CLK_TIME | datetime | Date and time of entry into exchange log | |||||
| event_time | CLK_TIME | datetime | Date and time the event took place | |||||
| exch_code | LONG | int | DIRECT | Event code for the exchange log entry; internally assigned with a unique code for each type of event | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| reason_code | CHAR | varchar | 80 | Reason for the event from user-defined popup lists which are context dependent | ||||
| repair_code | LONG | int | DIRECT | Identifies the X790 Repair Activity performed |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| exch_log2act_entry | OTOF | act_entry | act_entry2exch_log | The releated act_entry | |||
| exch_log2close_exch | MTO | close_exch | close2exch_log | Related close_exch | |||
| exch_log2contact_role | MTO | contact_role | doer2exch_log | Contact role who performed the activity | |||
| exch_log2exchange | MTO | exchange | exchange2exch_log | The releated exchange object | |||
| exch_log2user | MTO | user | user2exch_log | User who created the entry |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_exch_log2contact_role | exch_log2contact_role, objid | nonclustered, unique located on PRIMARY |
| ind_exch_log2exchange | exch_log2exchange, objid | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| exch_log | |||