STORITMFFC

Each row of this table contains information about a BaseItem for a particular Store (or all the Stores in a StoreGroup) and FulfillmentCenter.

Column Descriptions:

NameTypeDescription
BASEITEM_IDBIGINT NOT NULLThe BaseItem.
STOREENT_IDINTEGER NOT NULLThe Store or StoreGroup for this row. Attributes in this row apply to the specified Store, or to Stores in the specified StoreGroup that do not have their own row.
FFMCENTER_IDINTEGER NOT NULLThe FulfillmentCenter.
SHIPPINGOFFSETINTEGER NOT NULL DEFAULT 86400An estimate of the number of seconds it takes from the time an OrderItem is released for fulfillment until it is shipped to the customer.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>BASEITEM_ID+STOREENT_ID+FFMCENTER_IDPrimary Key
I0000797FFMCENTER_IDNon-Unique Index
I0000798STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_805STOREENT_IDSTOREENTSTOREENT_IDCascade
F_806FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_807BASEITEM_IDBASEITEMBASEITEM_IDCascade