Each rows contains information about the components
of a configured OrderItem.
Column Descriptions:
Name | 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) | 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. |
SUPPLIERPARTNUMBER | VARCHAR (254) | Reserved for HCL internal use. |
RFQPROD_ID | BIGINT | The RFQ product to which this component is
related. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
OICOMPREL_ID | BIGINT | The nested kit that this component refers to. A
kit might contain other kits. The OICOMPREL table stores
information about the sub kits. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | 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 |
I0001100 | ORDERITEMS_ID+CONFIGURATIONID | Non-Unique Index |
I0001263 | OICOMPREL_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_1032 | RFQPROD_ID | RFQPROD | RFQPROD_ID | Cascade |
F_1074 | OICOMPREL_ID | OICOMPREL | OICOMPREL_ID | Cascade |
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 Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_3473 | OICOMPLIST_ID | ORDITEMCONF | OICOMPLIST_ID | Cascade |