STORE

Each row of this table represents a store. A store is a store entity.

Column Descriptions:

NameTypeDescription
STORE_IDINTEGER NOT NULLGenerated unique key.
STOREGRP_IDINTEGER NOT NULLThe store group for this store.
STORECGRY_IDINTEGERThe store category, if any, for this store.
LANGUAGE_IDINTEGERThe default language for information displayed to customers shopping in the store. For a list of language components, see the LANGUAGE table.
FFMCENTER_IDINTEGERThe default fulfillment center for the store.
STATUSINTEGER NOT NULL DEFAULT 1The status of the store. Valid values are:
1
open
0
closed
-1
suspended
STORELEVELCHAR (10)STORELEVEL column is used as a flag to tell if various features are used in the store. The possible values are MC and MOBILE comma separated.
MC
The store uses store functions in Management Center.
MOBILE
The store has a mobile presence. Enables mapping of user agent to device format by using the wc-devices.xml file.
DIRECTORYVARCHAR (254)The base name of the directory in which store-specific Web assets, such as JSP files and property files, are found.
OIDCHAR (32)Reserved for IBM internal use.
QUOTEGOODFORINTEGER DEFAULT 43200If this many seconds have passed since an Order was prepared and the customer has not committed to pay, the prices and other monetary amounts in the Order may change when OrderProcess is run.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
ALLOCATIONGOODFORINTEGER NOT NULL DEFAULT 43200When this many seconds have passed since the allocations were made, the ReleaseExpiredAllocations scheduler job can reverse available to promise (ATP) inventory allocations. If 0, ATP inventory allocation is not used by this store, and the INVENTORY table is used instead.
MAXBOOFFSETINTEGER NOT NULL DEFAULT 7776000The maximum number of seconds that an item can be backordered. If the estimated availability time for a backordered order item exceeds this many seconds into the future, the availability date will automatically be set to this many seconds into the future. Thus, an item cannot be backordered longer than the interval specified here.
REJECTEDORDEXPIRYINTEGER DEFAULT 259200Orders with payment in declined state longer than this many seconds are candidates for cancellation.
FFMCSELECTIONFLAGSINTEGER NOT NULL DEFAULT 0Contains bit flags that specify policy used by the default implementation of GetEligibleFulfillmentCenters concerning the selection of a fulfillment center for an order item whose status is:
  • 1 = preferCurrent, give preference to the currently assigned fulfillment center, if any;
  • 2 = noChange, do not change the currently assigned fulfillment center, if any.
BOPMPADFACTORINTEGER DEFAULT 0If this store calculates order amounts (such as taxes or shipping charges) differently for different fulfillment centers, the order amount for a previously submitted order might change when fulfillment centers are allocated for backordered order items. This column specifies the percentage amount ("padding factor") by which the order amount presented to the payments subsystem can be increased, if necessary. For example, specify 5 to allow an increase of up to 5 percent.
RTNFFMCTR_IDINTEGERThe ID of the fulfillment center that is used as the default for returning merchandise to the store.
DEFAULTBOOFFSETINTEGER NOT NULL DEFAULT 7776000When an estimated availability time cannot be determined for a backordered order item, by default, it will be set to this many seconds into the future.
PRICEREFFLAGSINTEGER NOT NULL DEFAULT 0Contains bit flags that control which trading agreements and offers are searched when prices are refreshed by the default implementation of the GetContractunitPrices task command:
  • 0 = Default. Use trading agreements and offers referenced by order items. The task command fails if the trading agreements or offers cannot be used. The tradingId and offerId are not saved to the ORDITRD and ORDIOFFER tables.
  • 1 = usePreviousOnly. Use trading agreements and offers referenced by the order items. The task command fails if the trading agreements or offers cannot be used. The trading ID and offer ID are saved to the ORDITRD and ORDIOFFER tables.
  • 2 = usePreviousOrSearchAgain. Same as usePreviousOnly. If trading agreements or offers cannot be used, search trading agreements and offers in the ORDIOFFER and ORDITRD tables.
  • 4 = alwaysSearchAgain. Always search for saved trading agreements and offers in the ORDIOFFER and ORDITRD tables.
  • 8 = MergeQtyWithCatentry. Merge quantity of all order items with the same catentryId within an order to get the best price for them. The tradingId and offerId are not saved to the ORDITRD and ORDIOFFER tables.
STORETYPECHAR (3)Indicates one of the following store types. This indicator is used by a user interface to provide appropriate functions depending on the store type:
  • B2C = Consumer direct
  • BBB = Basic B2B direct
  • B2B = B2B direct
  • CHS = Channel hub
  • CPS = Catalog asset store
  • RHS = Consumer direct reseller store
  • BRH = B2B reseller store
  • RPS = Consumer direct reseller storefront asset store
  • BRP = B2B reseller storefront asset store
  • DPS = Distributor asset store
  • DPX = Distributor proxy store
  • SCP = Supplier hub
  • SCS = Supplier catalog asset store
  • SPS = Supplier asset store
  • SHS = Supplier hosted store
  • HCP = Hosting hub
  • PBS = Store directory
  • MHS = Consumer direct hosted store
  • BMH = B2B hosted store
  • MPS = Consumer direct hosted storefront asset store
  • BMP = B2B hosted storefront asset store.
RMAGOODFORINTEGER DEFAULT 86400The time period in seconds for which return merchandise authorization (RMA) calculations are valid. If this time period elapses before an RMA is completed, charges or credits and approval will be recalculated.
AVSACCEPTCODESVARCHAR (64)The payments subsystem AVS result codes that the store considers acceptable:
  • 0 = Both street address and postal code match;
  • 1 = Street address matches, but postal code does not;
  • 2 = Postal code matches, but street address does not;
  • 3 = Neither street address nor postal code match;
  • 4 = AVS result not available.
0 is always acceptable, regardless of it appears in this string. All values acceptable for this column are in VARCHAR format, not necessarily single digit numbers. For example, the value 14 means that 0 is acceptable (since 0 is always acceptable), 1 is acceptable, and 4 is acceptable. For more details about the payments subsystem AVS codes, refer to the payments subsystem documentation.
CRTDBYCNTR_IDBIGINTThe contract used to create the store.
LASTUPDATESTATUSTIMESTAMPIndicates the last time the status of the store was updated.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
ALLOCATIONOFFSETINTEGER NOT NULL DEFAULT 86400Amount of time before the requested ship date when inventory allocation should be performed. This time period provides a buffer for the store to reserve the inventory to the order and also allow for enough time to obtain inventory should there be an insufficient amount. See REQUESTEDSHIPDATE in ORDERITEMS.
MAXFOOFFSETINTEGER DEFAULT 7776000The maximum period of time that can be requested for a future ship date after the date the requested ship date is entered. See REQUESTEDSHIPDATE in ORDERITEMS.
INVENTORYOPFLAGINTEGER NOT NULL DEFAULT 0Contains bit flags indicating how to perform inventory operations. A value of 1 indicates that the RECEIPT table is updated during shipment confirmation.
BLOCKINGACTIVESMALLINT DEFAULT 1Specifies whether the order blocking feature is in use. The order blocking feature can be disabled for this particular store by setting this field to 0. The default value is 1.
BLKEXTASYNCHSMALLINT NOT NULL DEFAULT 0Allows the merchant-extensible code for order blocking to be run asynchronously. This column can be used when a merchant wants to test for blocking conditions by connecting to external systems. To enable this feature, this column must be set to 1. By default, it is turned off (that is, set to 0).
PERSISTENTSESSIONSMALLINT
  • 0 = The rememberMe function is disabled for registered customers and guest customers. This is the default value.
  • 1 = The rememberMe function is enabled for registered customers only.
  • 2 = The rememberMe function is enabled for guest customers only.
  • 3= The rememberMe function is enabled for registered customers and guest customers.
ORDERHISTACTIVECHAR (1) NOT NULL DEFAULT 'Y'Indicates whether order change history tracking is enabled. The default value is Y (Yes).
INVENTORYSYSTEMSMALLINT NOT NULL DEFAULT -1Indicates which inventory system is used:
  • -1 = ATP (Default value)
  • -2 = Non-ATP
  • -3 = No inventory
  • -4 = external inventory management system
  • -5 = DOM inventory system
This setting is used by the inventory component to determine inventory behavior.
UP_DIRECTORYVARCHAR (254)The equivalent value of the DIRECTORY column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STORE_IDPrimary Key
I0000778FFMCENTER_IDNon-Unique Index
I0000779STORECGRY_IDNon-Unique Index
I0000780RTNFFMCTR_IDNon-Unique Index
I0000781CRTDBYCNTR_IDNon-Unique Index
I0001288STOREGRP_IDNon-Unique Index
IPF00026UP_DIRECTORYNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_772RTNFFMCTR_IDFFMCENTERFFMCENTER_IDCascade
F_773STORECGRY_IDSTORECGRYSTORECGRY_IDCascade
F_774STOREGRP_IDSTOREGRPSTOREGRP_IDCascade
F_775STORE_IDSTOREENTSTOREENT_IDCascade
F_776FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_777LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_925CRTDBYCNTR_IDCONTRACTCONTRACT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1020STORE_IDRFQTARGETSTORE_IDCascade
F_103STORE_IDAUTOBIDLOGSTORE_IDCascade
F_113STORE_IDBIDSTORE_IDCascade
F_1144STORE_IDCTXMGMTSTORE_IDCascade
F_119STORE_IDBIDLOGSTORE_IDCascade
F_1198STORE_IDTICKLERSTORE_IDCascade
F_1206STORE_IDTKLRACTIONSTORE_IDCascade
F_1209STORE_IDTKLRREASONSTORE_IDCascade
F_191STORE_IDCATENCALCDSTORE_IDCascade
F_211STORE_IDCATGPCALCDSTORE_IDCascade
F_23STORE_IDACCOUNTSTORE_IDCascade
F_258STORE_IDCPENDORDERSTOREENT_IDCascade
F_308STORE_IDDISTARRANGWHOLESALESTORE_IDCascade
F_309STORE_IDDISTARRANGMERCHANTSTORE_IDCascade
F_311STORE_IDECEOUTSTORE_IDCascade
F_3467STORE_IDSTOREMERCHSTORE_IDCascade
F_3582STORE_IDINVAVLSTORE_IDCascade
F_3587STORE_IDINVCNFRELSTORE_IDCascade
F_3600STORE_IDUPLOADFILESTORE_IDCascade
F_3605STORE_IDPX_CDPOOLSTORE_IDCascade
F_393STORE_IDINVENTORYSTORE_IDCascade
F_403STORE_IDITEMFFMCTRSTORE_IDCascade
F_462STORE_IDMOPICONFIGSTORE_IDCascade
F_578STORE_IDPAYSTATUSSTORE_IDCascade
F_623STORE_IDPROFILESTORE_IDCascade
F_650STORE_IDRASTORE_IDCascade
F_661STORE_IDRECEIPTSTORE_IDCascade
F_677STORE_IDRFQSTORE_IDCascade
F_697STORE_IDRMASTORE_IDCascade
F_748STORE_IDSHPARRANGESTORE_IDCascade
F_784STORE_IDSTORECNTRSTORE_IDCascade
F_786STORE_IDSTOREDEFSTORE_IDCascade
F_802STORE_IDSTOREMBRGPSTORE_IDCascade
F_803STORE_IDSTORETRANSSTORE_IDCascade
F_859STORE_IDTFTRADENGSTORE_IDCascade
F_911STORE_IDWTAXINFOSTORE_IDCascade
F_916STORE_IDSTORERELSTORE_IDCascade
F_917STORE_IDSTORERELRELATEDSTORE_IDCascade
F_93STORE_IDAUCTSTRRELSTORE_IDCascade
F_930STORE_IDSHPMODCLCDSTORE_IDCascade
F_934STORE_IDORDQUOTRELCHILDSTORE_IDCascade
F_943STORE_IDMASSOCCECESTORE_IDCascade
F_944STORE_IDMASSOCGPGPSTORE_IDCascade
F_945STORE_IDCATGRPTPCSTORE_IDCascade
F_946STORE_IDICMETAFEATSTOREIDCascade
F_947STORE_IDICMETAPHORSTOREIDCascade
F_951STORE_IDQUEUESTORE_IDCascade
F_970STORE_IDICMERTREESTOREIDCascade
F_971STORE_IDICKNOWLEDGSTOREIDCascade
F_986STORE_IDFILEUPLOADSTORE_IDCascade
F_99STORE_IDAUTOBIDSTORE_IDCascade