DW_SUPPLIER_REG_PS_CATEGORY_MAP_G
This table stores information about supplier requests for adding new products and services.
Details
Module: Supplier Model
Key Columns
PS_REQUEST_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PS_REQUEST_ID | NUMBER | 38 | 0 | True | Products&Services 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 | |||
| ITEM_CATEGORY_ID | NUMBER | 38 | 0 | Category identifier for Item categories. | DW_ITEM_CATEGORIES_D_TL | CATEGORY_ID | |
| PURCHASING_CATEGORY_ID | NUMBER | 38 | 0 | Category identifier for Purchasing categories. | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID | |
| ITEM_CATEGORY_FLAG | VARCHAR2 | 16 | Identifies whether the category is Item Type | DW_YN_LKP_TL | YN_LKP_CODE | ||
| 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. |