DW_SUPPLIER_PS_CATEGORY_D
This table stores information about product and services that suppliers can provide.
Details
Module: Supplier Model
Key Columns
CLASSIFICATION_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CLASSIFICATION_ID | NUMBER | 38 | 0 | True | Classification Identifier | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. System generated Unique Identifier. | |||
| SUPPLIER_ID | NUMBER | 38 | 0 | Supplier identifier | DW_SUPPLIER_D | SUPPLIER_ID | |
| 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 | ||
| STATUS | VARCHAR2 | 32 | Status of the classification | ||||
| 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. |