Database Table: OICOMPLIST

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

Column Name Column Type Column Description
CATALOGQUANTITY DOUBLE
NULL
The quantity of the CatalogEntry for this component.
CATENTRY_ID BIGINT
NULL
The CatalogEntry that this component refers to.
CONFIGURATIONID VARCHAR (128)
NULL
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.
CURRENCY CHARACTER (3)
NULL
The currency of the unit price of this component. This is a currency code as per ISO 4217 standards.
INVENTORYQUANTITY INTEGER
NULL
The quantity of the SpecifiedItem which is needed to satisfy an order for one unit of the configured OrderItem.
ITEMSPC_ID BIGINT
NULL
The SpecifiedItem ID for the component.
OICOMPLIST_ID BIGINT
NOT NULL
Generated unique identifier.
ORDERITEMS_ID BIGINT
NULL
The OrderItem to which this component is related.
REQUIRED CHARACTER (1)
NULL, 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.
SUPPLIERDATA VARCHAR (254)
NULL
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)
NULL
Reserved for IBM internal use.
UNITPRICE DECIMAL (20,5)
NULL
The unit price of this component.
Indexes:
Index Name Indexed Column Names Index Type
I0000301 ORDERITEMS_ID Non-Unique Index
SQL030416035012100 OICOMPLIST_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_474 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_475 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_476 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable