OICOMPLIST

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

Column Descriptions:

NameTypeDescription
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 HCL internal use.
RFQPROD_IDBIGINTThe RFQ product to which this component is related.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>OICOMPLIST_IDPrimary Key
I0000301ORDERITEMS_IDNon-Unique Index
I0000371RFQPROD_IDNon-Unique Index
I0000627CATENTRY_IDNon-Unique Index
I0000628ITEMSPC_IDNon-Unique Index
I0001100ORDERITEMS_ID+CONFIGURATIONIDNon-Unique Index
I0001263OICOMPREL_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1032RFQPROD_IDRFQPRODRFQPROD_IDCascade
F_1074OICOMPREL_IDOICOMPRELOICOMPREL_IDCascade
F_474ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_475CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_476ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3473OICOMPLIST_IDORDITEMCONFOICOMPLIST_IDCascade