WebSphere Commerce database table: OICOMPLIST

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


Column Description(s):
Column NameColumn TypeDescription
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 thay 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
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031242040 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback