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

Column Descriptions:

ITEMSPC_IDBIGINTThe SpecifiedItem ID for the component.
OICOMPLIST_IDBIGINT NOT NULLGenerated unique identifier.
CATENTRY_IDBIGINTThe CatalogEntry that this component refers to.
ORDERITEMS_IDBIGINTThe OrderItem to which this component is related.
CATALOGQUANTITYDOUBLEThe quantity of the CatalogEntry for this component.
INVENTORYQUANTITYINTEGERThe quantity of the SpecifiedItem which is needed to satisfy an order for one unit of the configured OrderItem.
REQUIREDCHAR (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.
CONFIGURATIONIDVARCHAR (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.
UNITPRICEDECIMAL (20,5)The unit price of this component.
CURRENCYCHAR (3)The currency of the unit price of this component. This is a currency code as per ISO 4217 standards.
SUPPLIERDATAVARCHAR (254)This column is not populated or used by WebSphere Commerce. The value for this column can be generated and used by the external system that originates an order. This value can be returned with a quotation, and sent when an order is placed on an external system. For example, this column can be used to contain a supplier distribution center ID. This field is not supported within the Order Noun for component services.
SUPPLIERPARTNUMBERVARCHAR (254)Reserved for IBM internal use.
RFQPROD_IDBIGINTThe RFQ product to which this component is related.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
OICOMPREL_IDBIGINTThe nested kit that this component refers to. A kit might contain other kits. The OICOMPREL table stores information about the sub kits.


NameColumn NamesType
I0000301ORDERITEMS_IDNon-Unique Index
I0000371RFQPROD_IDNon-Unique Index
I0000627CATENTRY_IDNon-Unique Index
I0000628ITEMSPC_IDNon-Unique Index
I0001263OICOMPREL_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType