WebSphere Commerce database table: STORE

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

Column Descriptions
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 as follows:
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 B:
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 a 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:
1 = usePreviousOnly - use the ones referenced by the order items, or fail if they can no longer be used;
2 = usePreviousOrSearchAgain - same as usePreviousOnly, but instead of failing when they can no longer be used, search the ones saved in the ORDIOFFER and ORDITRD tables;
4 = alwaysSearchAgain - always search the ones saved in the ORDIOFFER and ORDITRD tables;
8 = MergeQtyWithCatentry - merge quantity for all order items with the same catentry id within an order to get a best price for them. It will not save the tradingId and offerId in the ORDITRD and ORDIOFFER.
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;
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;
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, whether or not 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 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 No PERSISTENTSESSION external description assigned yet
ORDERHISTACTIVE CHAR(1) NOT NULL DEFAULT 'Y' Indicate order change history track enabled or not. Yes by default.
INVENTORYSYSTEM SMALLINT NOT NULL DEFAULT -1 Indicates which inventory system is used: -1=ATP, -2=Non-ATP or -3=No inventory. This setting will be transparent to order component, and only be checked by inventory component to determine different inventory behavior. Default value is -1.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235253530 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

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

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_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_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_911 STORE_ID WTAXINFO STORE_ID Cascade
Related reference