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 in the new Order Item would be less than the specified minimum quantity. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031315520 | BASEITEM_ID+STOREENT_ID | Primary Key |
I0000791 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_797 | BASEITEM_ID | BASEITEM | BASEITEM_ID | Cascade |
F_796 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |