Database Table: ITEMFFMCTR

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034949160 FFMCENTER_ID, ITEMSPC_ID, STORE_ID Primary Key
Constraints:
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

Referenced By:
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