# 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

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. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.