MSC_UOM_CLASS_CONVERSIONS

Details

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

Primary Key

Name	Columns
MSC_UOM_CLASS_CONVERSIONS_PK	INVENTORY_ITEM_ID, FROM_UNIT_OF_MEASURE, TO_UNIT_OF_MEASURE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
INVENTORY_ITEM_ID	NUMBER		18	Yes	The inventory item for which the conversion factors between base unitsof measures, is defined.
FROM_UNIT_OF_MEASURE	VARCHAR2	25		Yes	Base unit of measure of the item's base class
FROM_UOM_CODE	VARCHAR2	3		Yes	Base unit of measure short name for the item's base class
FROM_UOM_CLASS	VARCHAR2	10		Yes	UOM class from which the conversion is to be done
TO_UNIT_OF_MEASURE	VARCHAR2	25		Yes	Base unit of the class to which the conversion is defined
TO_UOM_CODE	VARCHAR2	3		Yes	Base unit short name of the class to which the conversion is defined
TO_UOM_CLASS	VARCHAR2	10		Yes	Class to which the conversion is defined
CONVERSION_RATE	NUMBER			Yes	Conversion rate from the item's class base unit to the "to" class base unit
DISABLE_DATE	DATE				Date when the defined inter-class conversion can no longer be used
SR_INSTANCE_ID	NUMBER		18	Yes	Source application instance identifier	Obsolete
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.
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
REFRESH_NUMBER	NUMBER				Refresh identifier populated by the collection program.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_UOM_CLASS_CONVERSIONS	msc_units_of_measure	FROM_UNIT_OF_MEASURE
MSC_UOM_CLASS_CONVERSIONS	msc_units_of_measure	TO_UNIT_OF_MEASURE

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MSC_UOM_CLASS_CONVERSIONS_N1	Non Unique	Default	INVENTORY_ITEM_ID	Obsolete
MSC_UOM_CLASS_CONVERSIONS_U1	Unique	Default	INVENTORY_ITEM_ID, FROM_UNIT_OF_MEASURE, TO_UNIT_OF_MEASURE
MSC_UOM_CLASS_CONVERSIONS_U2	Unique	Default	INVENTORY_ITEM_ID, FROM_UOM_CODE, TO_UOM_CODE