DW_ITEM_CATEGORIES_DH

This table holds the information about Item category Hierarchy.

Details

Module:

Key Columns

CATEGORY_SET_ID, CATEGORY_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