OICOMPREL

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:

NameTypeDescription
OICOMPREL_IDBIGINT NOT NULLUnique primary key. Also used to identify this entry as a unique node in the nested kit.
ORDERITEMS_IDBIGINTThe OrderItem Id for this instance of the top level kit, now that it is part of an Order.
ITEMSPC_IDBIGINT NOT NULLThe Item specification for this kit entry.
PARENT_IDBIGINTPointer to the parent kit. It is NULL if the entry is the top level kit.
REQUIREDSMALLINT DEFAULT 1Indicates if this kit is required to complete the parent kit.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
CONFIGURATION_IDVARCHAR (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:

NameColumn NamesType
<SYSTEM-GENERATED>OICOMPREL_IDPrimary Key
I0000963ITEMSPC_IDNon-Unique Index
I0000964PARENT_IDNon-Unique Index
I0000966ORDERITEMS_IDNon-Unique Index
I0001101CONFIGURATION_ID+ORDERITEMS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1228ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_1229ITEMSPC_IDITEMSPCITEMSPC_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1074OICOMPREL_IDOICOMPLISTOICOMPREL_IDCascade