QTYCONVERT

Each row of this table represents a rule. It can be used to convert a quantity amount from one QuantityUnit (unit of measurement) to another QuantityUnit.

Column Descriptions:

Name	Type	Description
QTYUNIT_ID_TO	CHAR (16) NOT NULL	The QuantityUnit converted to.
QTYCONVERT_ID	INTEGER NOT NULL	Generated unique key.
QTYUNIT_ID_FROM	CHAR (16) NOT NULL	The QuantityUnit converted from.
FACTOR	DECIMAL (31,20) NOT NULL	The conversion factor. Implicit conversion rules are derived from explicit rules by combining conversion factors.
MULTIPLYORDIVIDE	CHAR (1) NOT NULL	Indicates how to convert from QTYUNIT_ID_FROM to QTYUNIT_ID_TO. Valid values are as follows: M = multiply by FACTOR D = divide by FACTOR Conversion from QTYUNIT_ID_TO to QTYUNIT_ID_FROM using the inverse operation is implicitly defined.
UPDATABLE	CHAR (1) NOT NULL	A flag intended to be used by a user interface that manages QuantityUnit conversion rules: N = the conversion factor is irrevocable. It should never be changed. Y = the conversion factor can be changed.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	QTYCONVERT_ID	Primary Key
I0000198	QTYUNIT_ID_TO+QTYUNIT_ID_FROM	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_640	QTYUNIT_ID_FROM	QTYUNIT	QTYUNIT_ID	Cascade
F_641	QTYUNIT_ID_TO	QTYUNIT	QTYUNIT_ID	Cascade