CONTACTMETHOD
The CONTACTMETHOD table stores the ways that a CONTACT can be reached. For example, this can include e-mail address, phone number, fax number, web sites, or others.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| CONTACT_METHOD_ID | A unique, system-generated key that identifies a contact method in the system. | BIGINT | Not Null | Yes |
| ADDRESS_ID | A unique, system-generated key that identifies an address in the system. There is no implementation for this attribute in the object model. You have the option to create your own implementation. | BIGINT | Null | No |
| CONT_METH_CAT_CD | Identifies the main category of contact method. For example: telephone, e-mail, PDA, and so forth. | BIGINT | Not Null | No |
| REF_NUM | The actual text provided for the contact method. For example, if the contact method category type is telephone, then this column contains the actual 10 digits for the phone number. | VARCHAR(255) | Not Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
| LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
| CONT_METH_STD_IND | Indicates if this contact method has been standardized. | CHAR(1) | Null | No |