# 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 |  |  | This column is for Oracle Internal use only. 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
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Item Category Assignment Creation Timestamp |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Item Category Assignment Last Update Timestamp |  |

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