WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex 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 NameColumn Name(s)Foreign Table NameForeign 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 NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_399 ITEMSPC_ID STORE_ID FFMCENTER_ID INVRESERVE ITEMSPC_ID Cascade

Feedback