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
|