DW_ITEM_CAT_ASSIGNMENTS_D

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

Details

Module:

Key Columns

ITEM_CATEGORY_ASSIGNMENT_ID, ORGANIZATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ITEM_CATEGORY_ASSIGNMENT_ID NUMBER 38 0 True This column acts as primary key for Category Assigments.    
ORGANIZATION_ID NUMBER 38 0 True A organizing unit in the internal or external structure of your enterprise.    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier formed by item identifier, organization identifier, category set identifier and category identifier.    
CATEGORY_SET_ID NUMBER 38 0   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   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   Unique identifier for an item. This represents the ItemId for which this assignment is created. DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID

Copyright © 2019, 2023, Oracle and/or its affiliates.