MSS_ASSETS

This table stores operational asset definitions.

Details

• Schema: FUSION

• Object owner: MSS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSS_ASSETS_PK	PLAN_ID, ASSET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
ASSET_ID	NUMBER		18	Yes	Unique identifier of the asset.
ASSET_NUMBER	VARCHAR2	80		Yes	An user identifier for the asset object. This is the user primary key for the asset. If user does not enter a value then it is system generated using the Asset Document Number Sequence.
DESCRIPTION	VARCHAR2	240			The detailed description of the asset.
ITEM_ID	NUMBER		18	Yes	Product/Item reference as defined in the Fusion Item Master.
ITEM_ORGANIZATION_ID	NUMBER		18		Reference to the organization ID where the asset product instance is instantiated.
WORK_CENTER_ID	NUMBER		18		Reference to work center ID of the maintenance resource; foreign key reference to MSS_RESOURCES.
RESOURCE_ID	NUMBER		18		Reference to maintenance resource ID; foreign key reference to MSS_RESOURCES.
SERIAL_NUMBER	VARCHAR2	80			The Serial Number of the product. Which uniquely identifies the product instance that is either manufactured as an end assembly product or as components bought from the supplier.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSS_ASSETS	mss_items	PLAN_ID, ITEM_ID
MSS_ASSETS	mss_resources	PLAN_ID, WORK_CENTER_ID, RESOURCE_ID
mss_wo_assets	mss_assets	PLAN_ID, ASSET_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSS_ASSETS_N1	Non Unique	Default	PLAN_ID, WORK_CENTER_ID, RESOURCE_ID
MSS_ASSETS_U1	Unique	Default	PLAN_ID, ASSET_ID
MSS_ASSETS_U2	Unique	Default	PLAN_ID, ASSET_NUMBER