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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000301 | ORDERITEMS_ID | Non-Unique Index |
SQL030416035012100 | OICOMPLIST_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|