Reference > Database > WebSphere Commerce database tables > I


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

Indexes
Index Name Indexed Column Names Index Type
SQL100520030347520 ITEMSPC_ID+STORE_ID+FFMCENTER_ID Primary Key
I0000597 FFMCENTER_ID Non-Unique Index
I0000598 STORE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Names Constraint Type
F_399 ITEMSPC_ID STORE_ID FFMCENTER_ID INVRESERVE ITEMSPC_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search