This table holds the information about Item category Hierarchy.
Module:
CATEGORY_SET_ID, CATEGORY_ID
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 | 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 |