Each rows contains information about reserved quantities, amount on backorder, and amount allocated to backorders for items owned by a store at a fulfillment center.
Column Description(s):
Column Name | Column Type | Description |
ITEMSPC_ID |
BIGINT NOT NULL |
The inventory item. |
STORE_ID |
INTEGER NOT NULL |
The merchant store. |
FFMCENTER_ID |
INTEGER NOT NULL |
The fulfillment center ID. |
QTYBACKORDERED |
INTEGER NOT NULL DEFAULT 0 |
The quantity of this item backordered for this store and fulfillment center. |
QTYALLOCBACKORDER |
INTEGER NOT NULL DEFAULT 0 |
Amount of in stock inventory allocated to a backorder. |
LASTUPDATE |
TIMESTAMP |
Timestamp of the last update. |
QTYRESERVED |
INTEGER NOT NULL DEFAULT 0 |
Reserved amount. May be used for auctions or other purposes. |
RESTOCKTIME |
TIMESTAMP |
Next planned restock time. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031234970 |
ITEMSPC_ID+STORE_ID+FFMCENTER_ID |
Primary Key |
I0000597 |
FFMCENTER_ID |
Non-Unique Index |
I0000598 |
STORE_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_404 |
FFMCENTER_ID |
FFMCENTER |
FFMCENTER_ID |
Cascade |
F_405 |
ITEMSPC_ID |
ITEMSPC |
ITEMSPC_ID |
Cascade |
F_403 |
STORE_ID |
STORE |
STORE_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_399 |
ITEMSPC_ID STORE_ID FFMCENTER_ID |
INVRESERVE |
ITEMSPC_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.