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     Unique Identifier    
CATALOG_CODE VARCHAR2 32     Unique indentifier of the catalogs.    
CATEGORY_CODE VARCHAR2 1024     A unique identification assigned to an item class which can be easily associated with the UNSPC category.    
LVL NUMBER       Will not be available in 12.x as the columns is being deprecated    
PATH VARCHAR2 4000     Will not be available in 12.x as the columns is being deprecated    
PARENT_CATEGORY_ID1 VARCHAR2 4000     Parent Category ID1 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE1 VARCHAR2 1024     Parent Category Code1    
PARENT_CATEGORY_ID2 VARCHAR2 4000     Parent Category ID2 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE2 VARCHAR2 1024     Parent Category Code2    
PARENT_CATEGORY_ID3 VARCHAR2 4000     Parent Category ID3 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE3 VARCHAR2 1024     Parent Category Code3    
PARENT_CATEGORY_ID4 VARCHAR2 4000     Parent Category ID4 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE4 VARCHAR2 1024     Parent Category Code4    
PARENT_CATEGORY_ID5 VARCHAR2 4000     Parent Category ID5 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE5 VARCHAR2 1024     Parent Category Code5    
PARENT_CATEGORY_ID6 VARCHAR2 4000     Parent Category ID6 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE6 VARCHAR2 1024     Parent Category Code6    
PARENT_CATEGORY_ID7 VARCHAR2 4000     Parent Category ID7 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE7 VARCHAR2 1024     Parent Category Code7    
PARENT_CATEGORY_ID8 VARCHAR2 4000     Parent Category ID8 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE8 VARCHAR2 1024     Parent Category Code8    
PARENT_CATEGORY_ID9 VARCHAR2 4000     Parent Category ID9 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE9 VARCHAR2 1024     Parent Category Code9    
PARENT_CATEGORY_ID10 VARCHAR2 4000     Parent Category ID10 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE10 VARCHAR2 1024     Parent Category Code10    
PARENT_CATEGORY_ID11 VARCHAR2 4000     Parent Category ID11 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE11 VARCHAR2 1024     Parent Category Code11    
PARENT_CATEGORY_ID12 VARCHAR2 4000     Parent Category ID12 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE12 VARCHAR2 1024     Parent Category Code12    
PARENT_CATEGORY_ID13 VARCHAR2 4000     Parent Category ID13 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE13 VARCHAR2 1024     Parent Category Code13    
PARENT_CATEGORY_ID14 VARCHAR2 4000     Parent Category ID14 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE14 VARCHAR2 1024     Parent Category Code14    
PARENT_CATEGORY_ID15 VARCHAR2 4000     Parent Category ID15 DW_ITEM_CATEGORIES_D CATEGORY_ID
PARENT_CATEGORY_CODE15 VARCHAR2 1024     Parent Category Code15