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 BaseItem. If there is no row for the Store, then the row for its StoreGroup is used.

Column Name Column Type Column Description
BACKORDERABLE CHARACTER (1)
NOT NULL, DEFAULT 'Y'
Can be used to indicate that specified items for this BaseItem cannot be backordered.
N = Items may not be backordered.
Y = Items may be backordered.
BASEITEM_ID BIGINT
NOT NULL
The BaseItem.
CREDITABLE CHARACTER (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.
FORCEBACKORDER CHARACTER (1)
NOT NULL, DEFAULT 'N'
Can be used to temporarily suspend allocation of specified items for this BaseItem.
N = Inventory can be allocated (normal behavior).
Y = Inventory cannot be allocated, even if there is enough inventory.
FOREIGNSKU CHARACTER (20)
NULL
Customizable.
FOREIGNSYSTEM BIGINT
NULL
Customizable.
LASTUPDATE TIMESTAMP
NULL
The most recent time this row was updated.
MINQTYFORSPLIT INTEGER
NOT NULL, DEFAULT 0
Used by the default AllocateInventory task command implementation. OrderItems will not be automatically split during inventory allocation if the remaining unallocated quantity in the new OrderItem would be less than the specified minimum quantity.
RELEASESEPARATELY CHARACTER (1)
NOT NULL, DEFAULT 'N'
Controls how OrderItems for specified items for this BaseItem are released.
N = OrderItems may be released along with other OrderItems.
Y = OrderItems must be released separately (in their own boxes).
RETURNNOTDESIRED CHARACTER (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 Y = Request for credit evaluated as if return is expected.
STOREENT_ID INTEGER
NOT NULL
The Store or StoreGroup for this row. Attributes in this row apply to the specified Store, or to Stores in the specified StoreGroup that do not have their own row.
TRACKINVENTORY CHARACTER (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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035115730 BASEITEM_ID, STOREENT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_796 STOREENT_ID STOREENT STOREENT_ID Cascade
F_797 BASEITEM_ID BASEITEM BASEITEM_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable