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 Name | Column Type | Column Description |
---|---|---|
FACTOR | DECIMAL (31,20) NOT NULL |
The conversion factor. Implicit conversion rules are derived from explicit rules by combining conversion factors. |
MULTIPLYORDIVIDE | CHARACTER (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. |
QTYCONVERT_ID | INTEGER NOT NULL |
Generated unique key. |
QTYUNIT_ID_FROM | CHARACTER (16) NOT NULL |
The QuantityUnit converted from. |
QTYUNIT_ID_TO | CHARACTER (16) NOT NULL |
The QuantityUnit converted to. |
UPDATABLE | CHARACTER (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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000198 | QTYUNIT_ID_TO, QTYUNIT_ID_FROM | Unique Index |
SQL030416035044230 | QTYCONVERT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|