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
- Vendor data model
- ATP inventory data model
- ATP inventory orders data model
- ATP inventory reservations data model
_vcc_freeselect_bottom_