Stores all the kit level information for an Order Item that is a kit that contains other kits. 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 Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031242210 |
OICOMPREL_ID |
Primary Key |
I0000963 |
ITEMSPC_ID |
Non-Unique Index |
I0000964 |
PARENT_ID |
Non-Unique Index |
I0000966 |
ORDERITEMS_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1229 |
ITEMSPC_ID |
ITEMSPC |
ITEMSPC_ID |
Cascade |
F_1228 |
ORDERITEMS_ID |
ORDERITEMS |
ORDERITEMS_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1074 |
OICOMPREL_ID |
OICOMPLIST |
OICOMPREL_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.