# 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

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

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