Stores all kit level information for an Order item that is a kit. A kit may contain other kits and catalog entries outside of a kit. This table stores information about kit components and the OICOMPLIST table stores information about catalog entries outside of a kit.
Column Descriptions
| Column Name
| Column Type
| Description |
| OICOMPREL_ID
| BIGINT NOT NULL
| Unique primary key.
|
| ORDERITEMS_ID
| BIGINT
| The OrderItem Id for this instance of the top level kit, now that it is part of an Order.
|
| ITEMSPC_ID
| BIGINT NOT NULL
| The Item specification for this kit entry.
|
| PARENT_ID
| BIGINT
| Pointer to the parent kit. It is NULL if the entry is the top level kit.
|
| REQUIRED
| SMALLINT DEFAULT 1
| Indicates if this kit is required or optional to complete the parent kit.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| CONFIGURATION_ID
| VARCHAR(128)
| If the top level kit is a dynamic kit, this value indicates the external Id assigned by the configurator to this kit. A dynamic kit can only contain other dynamic kits, not prebuilt nor static kits.
|