MSC_ITEMS

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_ITEMS_PK	INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
INVENTORY_ITEM_ID	NUMBER			Yes	Identifies the inventory item id	Active
ITEM_NAME	VARCHAR2	300		Yes	Identifies the inventory item name	Active
DESCRIPTION	VARCHAR2	240			Description of the inventory item	Active
REFRESH_NUMBER	NUMBER		18	Yes	Refresh identifier populated by the collection program.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
PROGRAM_APPLICATION_ID	NUMBER				This value indicates the Program application identifier.	Active
PROGRAM_ID	NUMBER				This value indicates the Program identifier.	Active
PROGRAM_UPDATE_DATE	DATE				This value indicates the update date of the program.	Active
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.	Active
ATTRIBUTE1	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE2	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE3	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE4	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE5	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE6	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE7	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE8	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE9	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE10	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE11	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE12	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE13	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE14	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
ATTRIBUTE15	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
msc_item_suppliers	msc_items	INVENTORY_ITEM_ID
msc_safety_stock_txns	msc_items	INVENTORY_ITEM_ID
msc_safety_stocks	msc_items	INVENTORY_ITEM_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MSC_ITEMS_N1	Non Unique	Default	UPPER("ITEM_NAME")
MSC_ITEMS_U1	Unique	FUSION_TS_TX_IDX	INVENTORY_ITEM_ID	Active
MSC_ITEMS_U2	Unique	FUSION_TS_TX_IDX	ITEM_NAME	Active