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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035115730 | BASEITEM_ID, STOREENT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|