Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: 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 Name Column Type Description BASEITEM_ID BIGINT NOT NULL The BaseItem. STOREENT_ID INTEGER NOT NULL The 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_ID INTEGER NOT NULL The FulfillmentCenter. SHIPPINGOFFSET INTEGER NOT NULL DEFAULT 86400 An estimate of the number of seconds it takes from the time an OrderItem is released for fulfillment until it is shipped to the customer. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030435130 BASEITEM_ID+STOREENT_ID+FFMCENTER_ID Primary Key I0000797 FFMCENTER_ID Non-Unique Index I0000798 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_807 BASEITEM_ID BASEITEM BASEITEM_ID Cascade F_806 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade F_805 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference
_vcc_freeselect_bottom_