ITEMTYPE

Each row of this table represents a type of BaseItem.

Column Descriptions:

NameTypeDescription
ITEMTYPE_IDCHAR (4) NOT NULLPrimary key. Only the following values are allowed: ITEM = normal item. DNKT = dynamic kit. STKT = static kit.
DESCRIPTIONVARCHAR (254)A brief description of the ItemType.
OIDVARCHAR (64)Reserved for IBM internal use.
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>ITEMTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_106ITEMTYPE_IDBASEITEMITEMTYPE_IDCascade