This table contains information of items assigned to a Catalog and its category.
Module:
ITEM_CATEGORY_ASSIGNMENT_ID, ORGANIZATION_ID
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.