Reference > Database > WebSphere Commerce database tables > Q
WebSphere Commerce database table: 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 Name Column 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...
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.
Indexes Index Name Indexed Column Names Index Type I0000198 QTYUNIT_ID_TO+QTYUNIT_ID_FROM Unique Index SQL100520030419140 QTYCONVERT_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_640 QTYUNIT_ID_FROM QTYUNIT QTYUNIT_ID Cascade F_641 QTYUNIT_ID_TO QTYUNIT QTYUNIT_ID Cascade
Related reference
_vcc_freeselect_bottom_