QTYUNIT
Each row of this table represents a QuantityUnit. A QuantityUnit is a unit of measurement, such as kilogram, meter, liter, pound, foot, quart, and so on. Note: Do not remove the row for the default QTYUNIT_ID C62 (the unitless unit).
Column Descriptions:
| Name | Type | Description |
|---|---|---|
| QTYUNIT_ID | CHAR (16) NOT NULL | A uniquely assigned identifier. Several
identifiers are defined. They are specified in the
UN/
CEFACT Working Party. Which is on Facilitation of
International Trade Procedures (WP.4), Recommendation No. 20, Codes
for Units of Measure Used in International Trade. |
| FIELD1 | VARCHAR (254) | Customizable. |
| OPTCOUNTER | SMALLINT | 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> | QTYUNIT_ID | Primary Key |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
|---|---|---|---|---|
| F_1017 | QTYUNIT_ID | ATTRVALUE | QTYUNIT_ID | Cascade |
| F_1018 | QTYUNIT_ID | ATTRIBUTE | QTYUNIT_ID | Cascade |
| F_107 | QTYUNIT_ID | BASEITEM | QUANTITYMEASURE | Cascade |
| F_1183 | QTYUNIT_ID | DKPDCCOMPLIST | QTYUNIT_ID | Cascade |
| F_178 | QTYUNIT_ID | CALSCALE | QTYUNIT_ID | Cascade |
| F_206 | QTYUNIT_ID | CATENTSHIP | QUANTITYMEASURE | Cascade |
| F_207 | QTYUNIT_ID | CATENTSHIP | SIZEMEASURE | Cascade |
| F_208 | QTYUNIT_ID | CATENTSHIP | WEIGHTMEASURE | Cascade |
| F_3559 | QTYUNIT_ID | ATTRDESC | QTYUNIT_ID | Cascade |
| F_3563 | QTYUNIT_ID | ATTRVALDESC | QTYUNIT_ID | Cascade |
| F_3584 | QTYUNIT_ID | INVAVL | QUANTITYMEASURE | Cascade |
| F_3585 | QTYUNIT_ID | INVCNF | QUANTITYMEASURE | Cascade |
| F_3690 | QTYUNIT_ID | SUBSCRIPTION | FFMFREQ_UOM | Cascade |
| F_3691 | QTYUNIT_ID | SUBSCRIPTION | PAYMENTFREQ_UOM | Cascade |
| F_3692 | QTYUNIT_ID | SUBSCRIPTION | TIMEPERIOD_UOM | Cascade |
| F_394 | QTYUNIT_ID | INVENTORY | QUANTITYMEASURE | Cascade |
| F_425 | QTYUNIT_ID | MANIFEST | WEIGHTMEASURE | Cascade |
| F_469 | QTYUNIT_ID | OFFER | QTYUNIT_ID | Cascade |
| F_572 | QTYUNIT_ID | PATTRVALUE | QTYUNIT_ID | Cascade |
| F_640 | QTYUNIT_ID | QTYCONVERT | QTYUNIT_ID_FROM | Cascade |
| F_641 | QTYUNIT_ID | QTYCONVERT | QTYUNIT_ID_TO | Cascade |
| F_646 | QTYUNIT_ID | QTYFORMAT | QTYUNIT_ID | Cascade |
| F_648 | QTYUNIT_ID | QTYUNITDSC | QTYUNIT_ID | Cascade |
| F_649 | QTYUNIT_ID | QTYUNITMAP | QTYUNIT_ID | Cascade |
| F_679 | QTYUNIT_ID | RFQPROD | QTYUNIT_ID | Cascade |
| F_688 | QTYUNIT_ID | RFQRSPPROD | QTYUNIT_ID | Cascade |