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 Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ITEMSPC_ID+STORE_ID+FFMCENTER_ID	Primary Key
I0000597	FFMCENTER_ID	Non-Unique Index
I0000598	STORE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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 Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_399	ITEMSPC_ID+STORE_ID+FFMCENTER_ID	INVRESERVE	ITEMSPC_ID+STORE_ID+FFMCENTER_ID	Cascade