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:

NameTypeDescription
QTYUNIT_IDCHAR (16) NOT NULLA 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.
FIELD1VARCHAR (254)Customizable.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>QTYUNIT_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1017QTYUNIT_IDATTRVALUEQTYUNIT_IDCascade
F_1018QTYUNIT_IDATTRIBUTEQTYUNIT_IDCascade
F_107QTYUNIT_IDBASEITEMQUANTITYMEASURECascade
F_1183QTYUNIT_IDDKPDCCOMPLISTQTYUNIT_IDCascade
F_178QTYUNIT_IDCALSCALEQTYUNIT_IDCascade
F_206QTYUNIT_IDCATENTSHIPQUANTITYMEASURECascade
F_207QTYUNIT_IDCATENTSHIPSIZEMEASURECascade
F_208QTYUNIT_IDCATENTSHIPWEIGHTMEASURECascade
F_3559QTYUNIT_IDATTRDESCQTYUNIT_IDCascade
F_3563QTYUNIT_IDATTRVALDESCQTYUNIT_IDCascade
F_3584QTYUNIT_IDINVAVLQUANTITYMEASURECascade
F_3585QTYUNIT_IDINVCNFQUANTITYMEASURECascade
F_3690QTYUNIT_IDSUBSCRIPTIONFFMFREQ_UOMCascade
F_3691QTYUNIT_IDSUBSCRIPTIONPAYMENTFREQ_UOMCascade
F_3692QTYUNIT_IDSUBSCRIPTIONTIMEPERIOD_UOMCascade
F_394QTYUNIT_IDINVENTORYQUANTITYMEASURECascade
F_425QTYUNIT_IDMANIFESTWEIGHTMEASURECascade
F_469QTYUNIT_IDOFFERQTYUNIT_IDCascade
F_572QTYUNIT_IDPATTRVALUEQTYUNIT_IDCascade
F_640QTYUNIT_IDQTYCONVERTQTYUNIT_ID_FROMCascade
F_641QTYUNIT_IDQTYCONVERTQTYUNIT_ID_TOCascade
F_646QTYUNIT_IDQTYFORMATQTYUNIT_IDCascade
F_648QTYUNIT_IDQTYUNITDSCQTYUNIT_IDCascade
F_649QTYUNIT_IDQTYUNITMAPQTYUNIT_IDCascade
F_679QTYUNIT_IDRFQPRODQTYUNIT_IDCascade
F_688QTYUNIT_IDRFQRSPPRODQTYUNIT_IDCascade