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 Name | Column Type | Column Description |
---|---|---|
FFMCENTER_ID | INTEGER NOT NULL |
The fulfillment center ID. |
ITEMSPC_ID | BIGINT NOT NULL |
The inventory item. |
LASTUPDATE | TIMESTAMP NULL |
Timestamp of the last update. |
QTYALLOCBACKORDER | INTEGER NOT NULL, DEFAULT 0 |
Amount of in stock inventory allocated to a backorder. |
QTYBACKORDERED | INTEGER NOT NULL, DEFAULT 0 |
The quantity of this item backordered for this store and fulfillment center. |
QTYRESERVED | INTEGER NOT NULL, DEFAULT 0 |
Reserved amount. May be used for auctions or other purposes. |
RESTOCKTIME | TIMESTAMP NULL |
Next planned restock time. |
STORE_ID | INTEGER NOT NULL |
The merchant store. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034949160 | FFMCENTER_ID, ITEMSPC_ID, STORE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_403 | STORE_ID | STORE | STORE_ID | Cascade |
F_404 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
F_405 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_399 | FFMCENTER_ID+ITEMSPC_ID+STORE_ID | INVRESERVE | FFMCENTER_ID+ITEMSPC_ID+STORE_ID | Cascade |