MSC_ITEM_CATEGORIES

This table stores the item assignment to a category.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_ITEM_CATEGORIES_PK	ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ORGANIZATION_ID	NUMBER		18	Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		18	Yes	Identifies the inventory item id
CATEGORY_ID	NUMBER		18	Yes	Unique identifier for the category
REFRESH_NUMBER	NUMBER				Refresh number populated by the collection program
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
SR_CATEGORY_ID	NUMBER				Source side value of the category identifier.	Obsolete
CATEGORY_NAME	VARCHAR2	250			Name assigned to the item category	Obsolete
SUMMARY_FLAG	VARCHAR2	1			Summary flag of the item categories.	Obsolete
ENABLED_FLAG	VARCHAR2	1			Determine whether this record is enabled	Obsolete
SR_INSTANCE_ID	NUMBER				Identifier of the source system from where the data is collected.	Obsolete
BOR_FLAG	NUMBER				Identifies whether It's a Aggregate Category Item created during BOR Collections.'1' -Aggregate Item, '2' -Regular Item

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_ITEM_CATEGORIES	msc_catalog_categories	CATEGORY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_ITEM_CATEGORIES_N1	Non Unique	Default	INVENTORY_ITEM_ID, CATEGORY_ID
MSC_ITEM_CATEGORIES_U1	Unique	Default	ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_ID