Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: OICOMPLIST
Each rows contains information about the components of a configured OrderItem.
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 The nested kit that this component refers to. A kit might contain other kits. The OICOMPREL table stores information about the sub kits.
Indexes Index Name Indexed Column Names Index Type SQL100520030358420 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 I0001263 OICOMPREL_ID 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3473 OICOMPLIST_ID ORDITEMCONF OICOMPLIST_ID Cascade
Related reference
_vcc_freeselect_bottom_