INV_UOM_CONVERSIONS

This table contains conversion rates between non-base units of measure and their base unit in the unit of measure class. The non-base units of measure are contained in the table. Conversion rates may either be standard, or an intraclass conversion unique defined for an item.

Details

Schema: FUSION
Object owner: RCS
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
INV_UOM_CONVERSIONS_PK	CONVERSION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CONVERSION_ID	NUMBER		18	Yes	Unit of Measure (UOM) conversion identifier.
UOM_CODE	VARCHAR2	3		Yes	Unit of Measure (UOM) code.
CONTAINED_UOM_CODE	VARCHAR2	3			Contained UOM Code (used in Standard Packs setup)
UOM_CLASS	VARCHAR2	10		Yes	Class to which the Unit of Measure (UOM) belongs.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item identifier (stores 0 for Item independent standard conversions)
CONVERSION_RATE	NUMBER			Yes	Conversion factor by which the UOM is equivalent to the Base UOM of its Class
DEFAULT_CONVERSION_FLAG	VARCHAR2	1		Yes	'Y' if Item specific conversion is same as standard conversion
DISABLE_DATE	DATE				Date when the conversion is no longer valid to be used in the system (transactions, etc)
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.
UOM_LENGTH	NUMBER		18		Length of Item-UOM
UOM_WIDTH	NUMBER		18		Width of item-UOM
UOM_HEIGHT	NUMBER		18		Height of item-UOM
DIMENSION_UOM	VARCHAR2	3			UOM for Item-UOM dimensions
INTERIOR_UNIT_CODE	VARCHAR2	3			Unit of Measure (UOM) code for the interior packaging UOM which this unit is packaging	Obsolete
INTERIOR_UNIT_QTY	NUMBER				Integer conversion factor by which the UOM is equivalent to the packaging UOM in its Class for a specific Item	Obsolete
INVERSE_FLAG	VARCHAR2	1			Contains one of the following values: true or false. If true, then the conversion rate between the secondary unit of the class and the base UOM of the class is modeled as an inverse quantity. In this case, the conversion factor represents "conversion factor" x secondary unit = 1 of the base unit. If false, the conversion factor represents 1 x secondary unit = conversion factor of base unit. The default value is false.
INVERSE_CONVERSION_RATE	NUMBER				Value entered by the user which is multiplicatively inversed to generate the conversion rate for the pair of units.

Foreign Keys

Table	Foreign Table	Foreign Key Column
INV_UOM_CONVERSIONS	inv_units_of_measure_b	UOM_CODE
INV_UOM_CONVERSIONS	inv_units_of_measure_b	CONTAINED_UOM_CODE
INV_UOM_CONVERSIONS	inv_uom_classes_b	UOM_CLASS

Indexes

Index	Uniqueness	Tablespace	Columns
INV_UOM_CONVERSIONS_N1	Non Unique	Default	LAST_UPDATE_DATE
INV_UOM_CONVERSIONS_N2	Non Unique	Default	INVENTORY_ITEM_ID
INV_UOM_CONVERSIONS_PK	Unique	Default	CONVERSION_ID
INV_UOM_CONVERSIONS_U1	Unique	Default	UOM_CODE, INVENTORY_ITEM_ID