This table contains item category set information.
Module:
CATEGORY_SET_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CATEGORY_SET_ID | NUMBER | 38 | 0 | True | CATEGORY_SET_ID | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source record identifier. | |||
CATALOG_CODE | VARCHAR2 | 32 | CATALOG_CODE | ||||
MULT_ITEM_CAT_ASSIGN_FLAG | VARCHAR2 | 16 | MULT_ITEM_CAT_ASSIGN_FLAG | ||||
CONTROL_LEVEL | NUMBER | CONTROL_LEVEL | DW_CATALOG_CONTROL_LVL_LKP_TL | CATALOG_CONTROL_LEVEL_CODE | |||
DEFAULT_CATEGORY_CODE | VARCHAR2 | 1024 | Category an item is assigned to when during new item creation | ||||
START_DATE | DATE | Date the catalog will become active | |||||
END_DATE | DATE | Date the catalog will become inactive |