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:

NameTypeDescription
ITEMSPC_IDBIGINT NOT NULLThe inventory item.
STORE_IDINTEGER NOT NULLThe merchant store.
FFMCENTER_IDINTEGER NOT NULLThe fulfillment center ID.
QTYBACKORDEREDINTEGER NOT NULL DEFAULT 0The quantity of this item backordered for this store and fulfillment center.
QTYALLOCBACKORDERINTEGER NOT NULL DEFAULT 0Amount of in stock inventory allocated to a backorder.
LASTUPDATETIMESTAMPTimestamp of the last update.
QTYRESERVEDINTEGER NOT NULL DEFAULT 0Reserved amount. May be used for auctions or other purposes.
RESTOCKTIMETIMESTAMPNext planned restock time.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ITEMSPC_ID+STORE_ID+FFMCENTER_IDPrimary Key
I0000597FFMCENTER_IDNon-Unique Index
I0000598STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_403STORE_IDSTORESTORE_IDCascade
F_404FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_405ITEMSPC_IDITEMSPCITEMSPC_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_399ITEMSPC_ID+STORE_ID+FFMCENTER_IDINVRESERVEITEMSPC_ID+STORE_ID+FFMCENTER_IDCascade