Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STORE
Each row of this table represents a store. A store is a store entity.
Column Name Column Type Description STORE_ID INTEGER NOT NULL Generated unique key. STOREGRP_ID INTEGER NOT NULL The store group for this store. STORECGRY_ID INTEGER The store category, if any, for this store. LANGUAGE_ID INTEGER The default language for information displayed to customers shopping in the store. For a list of language components, see the LANGUAGE table. FFMCENTER_ID INTEGER The default fulfillment center for the store. STATUS INTEGER NOT NULL DEFAULT 1 The status of the store. Valid values are:
- 1 = open
- 0 = closed
- -1 = suspended
STORELEVEL CHAR(10) Reserved for IBM internal use. DIRECTORY VARCHAR(254) The base name of the directory in which store-specific Web assets, such as JSP files and property files, are found. OID CHAR(32) Reserved for IBM internal use. QUOTEGOODFOR INTEGER DEFAULT 43200 If 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. FIELD1 VARCHAR(254) Customizable. FIELD2 VARCHAR(254) Customizable. ALLOCATIONGOODFOR INTEGER NOT NULL DEFAULT 43200 When 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. MAXBOOFFSET INTEGER NOT NULL DEFAULT 7776000 The 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. REJECTEDORDEXPIRY INTEGER DEFAULT 259200 Orders with payment in declined state longer than this many seconds are candidates for cancellation. FFMCSELECTIONFLAGS INTEGER NOT NULL DEFAULT 0 Contains 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.
BOPMPADFACTOR INTEGER DEFAULT 0 If 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 WebSphere Commerce Payments can be increased, if necessary. For example, specify 5 to allow an increase of up to 5 percent. RTNFFMCTR_ID INTEGER The ID of the fulfillment center that is used as the default for returning merchandise to the store. DEFAULTBOOFFSET INTEGER NOT NULL DEFAULT 7776000 When 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. PRICEREFFLAGS INTEGER NOT NULL DEFAULT 0 Contains 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.
STORETYPE CHAR(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.
RMAGOODFOR INTEGER DEFAULT 86400 The 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. AVSACCEPTCODES VARCHAR(64) The WebSphere Commerce Payments 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 WebSphere Commerce Payments AVS codes, refer to the WebSphere Commerce Payments documentation.CRTDBYCNTR_ID BIGINT The contract used to create the store. LASTUPDATESTATUS TIMESTAMP Indicates the last time the status of the store was updated. OPTCOUNTER SMALLINT Reserved for IBM internal use. ALLOCATIONOFFSET INTEGER NOT NULL DEFAULT 86400 Amount 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. MAXFOOFFSET INTEGER DEFAULT 7776000 The 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. INVENTORYOPFLAG INTEGER NOT NULL DEFAULT 0 Contains bit flags indicating how to perform inventory operations. A value of 1 indicates that the RECEIPT table is updated during shipment confirmation. BLOCKINGACTIVE SMALLINT DEFAULT 1 Specifies 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. BLKEXTASYNCH SMALLINT NOT NULL DEFAULT 0 Allows 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).
PERSISTENTSESSION SMALLINT
- 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.
ORDERHISTACTIVE CHAR(1) NOT NULL DEFAULT 'Y' Indicates whether order change history tracking is enabled. The default value is Y (Yes). INVENTORYSYSTEM SMALLINT NOT NULL DEFAULT -1 Indicates 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030432770 STORE_ID Primary Key I0000778 FFMCENTER_ID Non-Unique Index I0000779 STORECGRY_ID Non-Unique Index I0000780 RTNFFMCTR_ID Non-Unique Index I0000781 CRTDBYCNTR_ID Non-Unique Index I0001288 STOREGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_925 CRTDBYCNTR_ID CONTRACT CONTRACT_ID Cascade F_772 RTNFFMCTR_ID FFMCENTER FFMCENTER_ID Cascade F_776 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade F_777 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade F_773 STORECGRY_ID STORECGRY STORECGRY_ID Cascade F_775 STORE_ID STOREENT STOREENT_ID Cascade F_774 STOREGRP_ID STOREGRP STOREGRP_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_23 STORE_ID ACCOUNT STORE_ID Cascade F_93 STORE_ID AUCTSTRREL STORE_ID Cascade F_99 STORE_ID AUTOBID STORE_ID Cascade F_103 STORE_ID AUTOBIDLOG STORE_ID Cascade F_113 STORE_ID BID STORE_ID Cascade F_119 STORE_ID BIDLOG STORE_ID Cascade F_191 STORE_ID CATENCALCD STORE_ID Cascade F_211 STORE_ID CATGPCALCD STORE_ID Cascade F_945 STORE_ID CATGRPTPC STORE_ID Cascade F_258 STOREENT_ID CPENDORDER STORE_ID Cascade F_1144 STORE_ID CTXMGMT STORE_ID Cascade F_308 WHOLESALESTORE_ID DISTARRANG STORE_ID Cascade F_309 MERCHANTSTORE_ID DISTARRANG STORE_ID Cascade F_311 STORE_ID ECEOUT STORE_ID Cascade F_986 STORE_ID FILEUPLOAD STORE_ID Cascade F_971 STOREID ICKNOWLEDG STORE_ID Cascade F_970 STOREID ICMERTREE STORE_ID Cascade F_946 STOREID ICMETAFEAT STORE_ID Cascade F_947 STOREID ICMETAPHOR STORE_ID Cascade F_3582 STORE_ID INVAVL STORE_ID Cascade F_3587 STORE_ID INVCNFREL STORE_ID Cascade F_393 STORE_ID INVENTORY STORE_ID Cascade F_403 STORE_ID ITEMFFMCTR STORE_ID Cascade F_943 STORE_ID MASSOCCECE STORE_ID Cascade F_944 STORE_ID MASSOCGPGP STORE_ID Cascade F_462 STORE_ID MOPICONFIG STORE_ID Cascade F_934 CHILDSTORE_ID ORDQUOTREL STORE_ID Cascade F_578 STORE_ID PAYSTATUS STORE_ID Cascade F_623 STORE_ID PROFILE STORE_ID Cascade F_3605 STORE_ID PX_CDPOOL STORE_ID Cascade F_951 STORE_ID QUEUE STORE_ID Cascade F_650 STORE_ID RA STORE_ID Cascade F_661 STORE_ID RECEIPT STORE_ID Cascade F_677 STORE_ID RFQ STORE_ID Cascade F_1020 STORE_ID RFQTARGET STORE_ID Cascade F_697 STORE_ID RMA STORE_ID Cascade F_748 STORE_ID SHPARRANGE STORE_ID Cascade F_930 STORE_ID SHPMODCLCD STORE_ID Cascade F_784 STORE_ID STORECNTR STORE_ID Cascade F_786 STORE_ID STOREDEF STORE_ID Cascade F_802 STORE_ID STOREMBRGP STORE_ID Cascade F_3467 STORE_ID STOREMERCH STORE_ID Cascade F_916 STORE_ID STOREREL STORE_ID Cascade F_917 RELATEDSTORE_ID STOREREL STORE_ID Cascade F_803 STORE_ID STORETRANS STORE_ID Cascade F_859 STORE_ID TFTRADENG STORE_ID Cascade F_1198 STORE_ID TICKLER STORE_ID Cascade F_1206 STORE_ID TKLRACTION STORE_ID Cascade F_1209 STORE_ID TKLRREASON STORE_ID Cascade F_3600 STORE_ID UPLOADFILE STORE_ID Cascade F_911 STORE_ID WTAXINFO STORE_ID Cascade
Related reference
- Ship data model
- Calculation scale data model
- Calculation rule - discount data model
- Order trading agreement data model
- Customer care data model
- Receipt data model
- Store data model
- User traffic data model
- Vendor data model
- Order management - RMA data model
- Order item - allocated data model
- Order item - backordered data model
- Order release data model
- Product Advisor data model
- Messaging data model
- Offers data model
- Calculation rule data model
- Fulfillment data model
- ATP inventory adjustment data model
- ATP inventory expected data model
- ATP inventory reservations data model
- Auction data model
- Auction logs data model
- Calculation code data model
- Calculation code - indirect attachment data model
- Contract data model
- Request for Quote (RFQ) data model
_vcc_freeselect_bottom_