Each rows contains information about the components of a configured OrderItem.
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 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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |