WebSphere Commerce database table: QTYCONVERT

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


Column Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000198 QTYUNIT_ID_TO+QTYUNIT_ID_FROM Unique Index
SQL050212031302050 QTYCONVERT_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_640 QTYUNIT_ID_FROM QTYUNIT QTYUNIT_ID Cascade
F_641 QTYUNIT_ID_TO QTYUNIT QTYUNIT_ID Cascade

Feedback