This table contains information of items assigned to a Catalog and its category.
Module:
ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID, CATEGORY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CATEGORY_SET_ID | NUMBER | 38 | 0 | True | Identifier for category set, Category set is collection of items grouped into categories. Value is derived from the table DW_ITEM_CATEGORIES_D_TL. | ||
CATEGORY_ID | NUMBER | 38 | 0 | True | Category identifier for category belonging to the Item Catalog. Value is derived from the table DW_ITEM_CATEGORY_SETS_D_TL. | ||
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Unique identifier for an item. This represents the ItemId for which this assignment is created. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID |
ORGANIZATION_ID | NUMBER | 38 | 0 | True | A organizing unit in the internal or external structure of your enterprise. | DW_INVENTORY_ITEM_D | ORGANIZATION_ID |
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source record identifier formed by item identifier, organization identifier, category set identifier and category identifier. |