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 Descriptions
| 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.
|