QTYUNITDSC

Each row in this table describes a QuantityUnit in a particular language.


Column Descriptions:

Name Type Description
QTYUNIT_ID CHAR (16) NOT NULL The QuantityUnit.
LANGUAGE_ID INTEGER NOT NULL The language of the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR (254) The description of the QuantityUnit.
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> LANGUAGE_ID+QTYUNIT_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_647 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_648 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade


Related reference
Quantity unit data model