# DW_PURCHASING_CAT_HIERARCHY_D

purchasing category hierarchy dimension table

## Details

Module: Purchasing

## Key Columns

PURCHASING_CAT_ID, PURCHASING_CAT_TYPE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PURCHASING_CAT_ID | NUMBER | 38 | 0 | True | Purchasing category ID | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PURCHASING_CAT_TYPE | VARCHAR2 | 32 |  | True | Purchasing category Type |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
LEVEL1_CAT_ID | NUMBER | 38 | 0 |  | Level1 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL2_CAT_ID | NUMBER | 38 | 0 |  | Level2 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL3_CAT_ID | NUMBER | 38 | 0 |  | Level3 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL4_CAT_ID | NUMBER | 38 | 0 |  | Level4 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL5_CAT_ID | NUMBER | 38 | 0 |  | Level5 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL6_CAT_ID | NUMBER | 38 | 0 |  | Level6 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL7_CAT_ID | NUMBER | 38 | 0 |  | Level7 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL8_CAT_ID | NUMBER | 38 | 0 |  | Level8 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL9_CAT_ID | NUMBER | 38 | 0 |  | Level9 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
LEVEL10_CAT_ID | NUMBER | 38 | 0 |  | Level10 Category ID | DW_PURCHASING_CATEGORY_D_TL | PURCHASING_CAT_ID
NODE_LEVEL | NUMBER | 38 | 0 |  | Node Level |  |

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