WebSphere Commerce database table: STOREITEM

Reference > Database > WebSphere Commerce database tables > S

WebSphere Commerce database table: STOREITEM

Each row of this table contains attributes that affect how a particular Store allocates inventory for the specified items of a particular Base Item. If there is no row for the Store, then the row for its Store Group is used.

Column Name Column Type Description
BASEITEM_ID BIGINT NOT NULL The Base Item.
STOREENT_ID INTEGER NOT NULL The Store or Store Group for this row. Attributes in this row apply to the specified Store, or to Stores in the specified Store Group that do not have their own row.
TRACKINVENTORY CHAR(1) NOT NULL DEFAULT 'Y' Controls whether or not inventory is tracked in the RECEIPT table.
N = Inventory is not tracked (there are no entries in the RECEIPT table).
Y = Inventory is tracked in the RECEIPT table.
E = Inventory is tracked externally
FORCEBACKORDER CHAR(1) NOT NULL DEFAULT 'N' Can be used to temporarily suspend allocation of specified items for this Base Item.
N = Inventory can be allocated (typical behavior).
Y = Inventory cannot be allocated, even if there is enough inventory.
RELEASESEPARATELY CHAR(1) NOT NULL DEFAULT 'N' Controls how Order Items for specified items for this Base Item are released.
N = Order Items may be released along with other Order Items.
Y = Order Items must be released separately (in their own boxes).
FOREIGNSKU CHAR(20) Customizable.
FOREIGNSYSTEM BIGINT Customizable.
LASTUPDATE TIMESTAMP The most recent time this row was updated.
CREDITABLE CHAR(1) NOT NULL DEFAULT 'Y' Whether the merchant will, without an override, issue a credit for this item.
N = Sold as-is.
Y = Creditable.
The requirement for the return of merchandise is evaluated separately.
BACKORDERABLE CHAR(1) NOT NULL DEFAULT 'Y' Can be used to indicate that specified items for this Base Item cannot be backordered.
N = Items may not be backordered.
Y = Items may be backordered.
RETURNNOTDESIRED CHAR(1) NOT NULL DEFAULT 'N' Item return not wanted, even if customer is willing or able to return it. For example, perishable food items.
N = Request for credit evaluated based on the customers intention to return the item, and customer is required to return merchandise.
Y = Request for credit evaluated as if return is expected, but customer is not required to return merchandise.
MINQTYFORSPLIT INTEGER NOT NULL DEFAULT 0 Used by the default AllocateInventory task command implementation. Order Items will not be automatically split during inventory allocation if the remaining unallocated quantity would be less than the specified minimum quantity.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030434250 BASEITEM_ID+STOREENT_ID Primary Key
I0000791 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_797 BASEITEM_ID BASEITEM BASEITEM_ID Cascade
F_796 STOREENT_ID STOREENT STOREENT_ID Cascade

Related reference

ATP inventory data model

ATP inventory orders data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
BASEITEM_ID	BIGINT NOT NULL	The Base Item.
STOREENT_ID	INTEGER NOT NULL	The Store or Store Group for this row. Attributes in this row apply to the specified Store, or to Stores in the specified Store Group that do not have their own row.
TRACKINVENTORY	CHAR(1) NOT NULL DEFAULT 'Y'	Controls whether or not inventory is tracked in the RECEIPT table. N = Inventory is not tracked (there are no entries in the RECEIPT table). Y = Inventory is tracked in the RECEIPT table. E = Inventory is tracked externally
FORCEBACKORDER	CHAR(1) NOT NULL DEFAULT 'N'	Can be used to temporarily suspend allocation of specified items for this Base Item. N = Inventory can be allocated (typical behavior). Y = Inventory cannot be allocated, even if there is enough inventory.
RELEASESEPARATELY	CHAR(1) NOT NULL DEFAULT 'N'	Controls how Order Items for specified items for this Base Item are released. N = Order Items may be released along with other Order Items. Y = Order Items must be released separately (in their own boxes).
FOREIGNSKU	CHAR(20)	Customizable.
FOREIGNSYSTEM	BIGINT	Customizable.
LASTUPDATE	TIMESTAMP	The most recent time this row was updated.
CREDITABLE	CHAR(1) NOT NULL DEFAULT 'Y'	Whether the merchant will, without an override, issue a credit for this item. N = Sold as-is. Y = Creditable. The requirement for the return of merchandise is evaluated separately.
BACKORDERABLE	CHAR(1) NOT NULL DEFAULT 'Y'	Can be used to indicate that specified items for this Base Item cannot be backordered. N = Items may not be backordered. Y = Items may be backordered.
RETURNNOTDESIRED	CHAR(1) NOT NULL DEFAULT 'N'	Item return not wanted, even if customer is willing or able to return it. For example, perishable food items. N = Request for credit evaluated based on the customers intention to return the item, and customer is required to return merchandise. Y = Request for credit evaluated as if return is expected, but customer is not required to return merchandise.
MINQTYFORSPLIT	INTEGER NOT NULL DEFAULT 0	Used by the default AllocateInventory task command implementation. Order Items will not be automatically split during inventory allocation if the remaining unallocated quantity would be less than the specified minimum quantity.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL100520030434250	BASEITEM_ID+STOREENT_ID	Primary Key
I0000791	STOREENT_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_797	BASEITEM_ID	BASEITEM	BASEITEM_ID	Cascade
F_796	STOREENT_ID	STOREENT	STOREENT_ID	Cascade