DW_ITEM_CAT_ASSIGNMENTS_D

This table contains information of items assigned to a Catalog and its category.

Details

Module:

Key Columns

ORGANIZATION_ID, INVENTORY_ITEM_ID, 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 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.