WebSphere Commerce database table: OICOMPLIST

Each rows contains information about the components of a configured OrderItem.

Column Descriptions
Column Name Column Type Description
ITEMSPC_ID BIGINT The SpecifiedItem ID for the component.
OICOMPLIST_ID BIGINT NOT NULL Generated unique identifier.
CATENTRY_ID BIGINT The CatalogEntry that this component refers to.
ORDERITEMS_ID BIGINT The OrderItem to which this component is related.
CATALOGQUANTITY DOUBLE The quantity of the CatalogEntry for this component.
INVENTORYQUANTITY INTEGER The quantity of the SpecifiedItem which is needed to satisfy an order for one unit of the configured OrderItem.
REQUIRED CHAR(1) DEFAULT 'Y' Indicates if this Item is required to fulfill the OrderItem:
Y = Yes. If there is insufficient inventory for this Item, then the OrderItem must be backordered.
N = No. If there is insufficient inventory for this Item, the OrderItem may still be allocated.
CONFIGURATIONID VARCHAR(128) The configuration ID (supplied, for example, by an external configurator system) to uniquely define a set of components before they are associated with an OrderItem.
UNITPRICE DECIMAL (20,5) The unit price of this component.
CURRENCY CHAR(3) The currency of the unit price of this component. This is a currency code as per ISO 4217 standards.
SUPPLIERDATA VARCHAR(254) Opaque to WebSphere Commerce. This attribute can be returned with a quotation, and sent when an Order is placed on an external system. For example, it could contain a supplier distribution center ID.
SUPPLIERPARTNUMBER VARCHAR(254) Reserved for IBM internal use.
RFQPROD_ID BIGINT The RFQ product to which this component is related.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
OICOMPREL_ID BIGINT No OICOMPREL_ID external description assigned yet

Indexes
Index Name Indexed Column Names Index Type
SQL060903235216870 OICOMPLIST_ID Primary Key
I0000301 ORDERITEMS_ID Non-Unique Index
I0000371 RFQPROD_ID Non-Unique Index
I0000627 CATENTRY_ID Non-Unique Index
I0000628 ITEMSPC_ID Non-Unique Index
I0001100 ORDERITEMS_ID+CONFIGURATIONID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_475 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_474 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_1074 OICOMPREL_ID OICOMPREL OICOMPREL_ID Cascade
F_476 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_1032 RFQPROD_ID RFQPROD RFQPROD_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_3473 OICOMPLIST_ID ORDITEMCONF OICOMPLIST_ID Cascade
Related reference