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. However there is no storefront, tooling or server
side support for kits that contain other kits. This table stores
information about kit components and the OICOMPLIST table stores
information about catalog entries outside of a kit.
Column Descriptions:
Name | Type | Description |
OICOMPREL_ID | BIGINT NOT NULL | Unique primary key. Also used to identify this
entry as a unique node in the nested kit. |
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 to complete the
parent kit. |
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. |
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. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | OICOMPREL_ID | Primary Key |
I0000963 | ITEMSPC_ID | Non-Unique Index |
I0000964 | PARENT_ID | Non-Unique Index |
I0000966 | ORDERITEMS_ID | Non-Unique Index |
I0001101 | CONFIGURATION_ID+ORDERITEMS_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_1228 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_1229 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_1074 | OICOMPREL_ID | OICOMPLIST | OICOMPREL_ID | Cascade |