DW_SUPPLIER_REG_APPROVAL_MAP_G
This table contains information about the approval and control history of supplier registration requests.
Details
Module: Supplier Model
Key Columns
APPROVAL_HISTORY_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| APPROVAL_HISTORY_ID | NUMBER | 38 | 0 | True | Approval history record unique 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 | |||
| ACTION_CODE | VARCHAR2 | 32 | Approval or control action type. | DW_SUPPLIER_APPROVAL_ACTION_LKP_TL | APPROVAL_ACTION_CODE | ||
| ACTION_DATE | TIMESTAMP | Approval or control action date | |||||
| PERFORMER_TYPE | VARCHAR2 | 32 | Type of the action performer | ||||
| PERFORMER_NAME | VARCHAR2 | 512 | Name of Person who took the action. | ||||
| 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. |