Reference > Database > WebSphere Commerce database tables > T

WebSphere Commerce database table: TMPCMPLIST

Reserved for IBM internal use.

Column Name	Column Type	Description
ITEMSPC_ID	BIGINT	Reserved for IBM internal use.
VERSIONSPC_ID	BIGINT	Reserved for IBM internal use.
EXPLODED	CHAR(1)	Reserved for IBM internal use.
TRACKINVENTORY	CHAR(1)	Reserved for IBM internal use.
SID	BIGINT NOT NULL	Reserved for IBM internal use.
TOTALNEED	INTEGER	Reserved for IBM internal use.
UNITQTY	INTEGER	Reserved for IBM internal use.
QTYAVAILABLE	INTEGER	Reserved for IBM internal use.
QTYBUILDABLE	INTEGER	Reserved for IBM internal use.
QTYALLOCBO	INTEGER	Reserved for IBM internal use.
REQUIRED	CHAR(1)	Reserved for IBM internal use.
BASEITEM_ID	BIGINT	Reserved for IBM internal use.
MARKFORDELETE	INTEGER	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
OICOMPLIST_ID	BIGINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000251	SID	Non-Unique Index

Related reference

• Views and temporary tables data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search