DW_SUPPLIER_REG_CONTACT_MAP_G
This table stores information about supplier contact requests.
Details
Module: Supplier Model
Key Columns
CONTACT_REQUEST_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CONTACT_REQUEST_ID | NUMBER | 38 | 0 | True | Contact request identifier | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. System generated Unique Identifier. | |||
| SUPPLIER_REG_ID | NUMBER | 38 | 0 | Supplier registration identifier | |||
| CONTACT_TITLE | VARCHAR2 | 32 | Contact title | ||||
| FIRST_NAME | VARCHAR2 | 256 | First name | ||||
| LAST_NAME | VARCHAR2 | 256 | Last name | ||||
| MIDDLE_NAME | VARCHAR2 | 128 | Middle name | ||||
| JOB_TITLE | VARCHAR2 | 128 | Job title | ||||
| REQUEST_STATUS | VARCHAR2 | 32 | Status of the request | DW_SUPPLIER_PROFILE_REQ_STATUS_LKP_TL | REQUEST_STATUS_CODE | ||
| CREATION_DATE | TIMESTAMP | The date and time of the creation of the row | |||||
| LAST_UPDATE_DATE | TIMESTAMP | The date and time of the last update of the row. |