# DW_ITEM_CATEGORIES_DH

This table holds the information about Item category Hierarchy.

## Details

Module:

## Key Columns

CATEGORY_ID, CATEGORY_SET_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CATEGORY_SET_ID | NUMBER | 38 | 0 | True | Collection of items grouped into categories. | DW_ITEM_CATEGORY_SETS_D | CATEGORY_SET_ID
CATEGORY_ID | NUMBER | 38 | 0 | True | Category belonging to the Item Catalog. | DW_ITEM_CATEGORIES_D | CATEGORY_ID
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Identifier |  |
CATALOG_CODE | VARCHAR2 | 32 |  |  | Unique indentifier of the catalogs. |  |
CATEGORY_CODE | VARCHAR2 | 999 |  |  | A unique identification assigned to an item class which can be easily associated with the UNSPC category. |  |
PARENT_CATEGORY_ID1 | VARCHAR2 | 999 |  |  | Parent Category ID1 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE1 | VARCHAR2 | 999 |  |  | Parent Category Code1 |  |
PARENT_CATEGORY_ID2 | VARCHAR2 | 999 |  |  | Parent Category ID2 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE2 | VARCHAR2 | 999 |  |  | Parent Category Code2 |  |
PARENT_CATEGORY_ID3 | VARCHAR2 | 999 |  |  | Parent Category ID3 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE3 | VARCHAR2 | 999 |  |  | Parent Category Code3 |  |
PARENT_CATEGORY_ID4 | VARCHAR2 | 999 |  |  | Parent Category ID4 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE4 | VARCHAR2 | 999 |  |  | Parent Category Code4 |  |
PARENT_CATEGORY_ID5 | VARCHAR2 | 999 |  |  | Parent Category ID5 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE5 | VARCHAR2 | 999 |  |  | Parent Category Code5 |  |
PARENT_CATEGORY_ID6 | VARCHAR2 | 999 |  |  | Parent Category ID6 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE6 | VARCHAR2 | 999 |  |  | Parent Category Code6 |  |
PARENT_CATEGORY_ID7 | VARCHAR2 | 999 |  |  | Parent Category ID7 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE7 | VARCHAR2 | 999 |  |  | Parent Category Code7 |  |
PARENT_CATEGORY_ID8 | VARCHAR2 | 999 |  |  | Parent Category ID8 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE8 | VARCHAR2 | 999 |  |  | Parent Category Code8 |  |
PARENT_CATEGORY_ID9 | VARCHAR2 | 999 |  |  | Parent Category ID9 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE9 | VARCHAR2 | 999 |  |  | Parent Category Code9 |  |
PARENT_CATEGORY_ID10 | VARCHAR2 | 999 |  |  | Parent Category ID10 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE10 | VARCHAR2 | 999 |  |  | Parent Category Code10 |  |
PARENT_CATEGORY_ID11 | VARCHAR2 | 999 |  |  | Parent Category ID11 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE11 | VARCHAR2 | 999 |  |  | Parent Category Code11 |  |
PARENT_CATEGORY_ID12 | VARCHAR2 | 999 |  |  | Parent Category ID12 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE12 | VARCHAR2 | 999 |  |  | Parent Category Code12 |  |
PARENT_CATEGORY_ID13 | VARCHAR2 | 999 |  |  | Parent Category ID13 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE13 | VARCHAR2 | 999 |  |  | Parent Category Code13 |  |
PARENT_CATEGORY_ID14 | VARCHAR2 | 999 |  |  | Parent Category ID14 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE14 | VARCHAR2 | 999 |  |  | Parent Category Code14 |  |
PARENT_CATEGORY_ID15 | VARCHAR2 | 999 |  |  | Parent Category ID15 | DW_ITEM_CATEGORIES_D | CATEGORY_ID
PARENT_CATEGORY_CODE15 | VARCHAR2 | 999 |  |  | Parent Category Code15 |  |

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