Database Table: STORE

Each row of this table represents a Store. A Store is a StoreEntity.

Column Name Column Type Column Description
ALLOCATIONGOODFOR INTEGER
NOT NULL, DEFAULT 43200
Specifies the usage of the ReleaseExpiredAllocations scheduler job. The job can reverse available to promise (ATP)inventory allocations when the specified number of seconds have passed since the allocations were made. If number of seconds specified is zero, ATP inventory allocation is not used by this Store. The INVENTORY table is used instead.
AVSACCEPTCODES VARCHAR (64)
NULL
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.
BOPMPADFACTOR INTEGER
NULL, DEFAULT 0
If this Store calculates order amounts (such as tax or shipping charges) differently for different FulfillmentCenters, the order amount for a previously submitted Order may change when FulfillmentCenters are allocated for backordered OrderItems. The padding factor value is the percentage amount 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.
CRTDBYCNTR_ID BIGINT
NULL
The contract used to create the store.
DEFAULTBOOFFSET INTEGER
NOT NULL, DEFAULT 7776000
When an estimated availability time cannot be determined for a backordered OrderItem, by default it will be set to this many seconds in the future.
DIRECTORY VARCHAR (254)
NULL
The directory in which store-specific Web assets, such as JSP files and property files, are found. The actual location of these assets in the file system is based on the value of this column, plus several configuration parameters in the WebSphere Commerce configuration file: StoresDocRoot, StoresWebPath, and StoresPropertiesPath.
For example, if StoresDocRoot is D:\WebSphere\CommerceServer\stores, StoresWebPath is web, StorePropertiesPath is properties, and the value of this column is mystore, then the JSP files will be located in the directory. D:\WebSphere\CommerceServer\stores\web\mystore and the property files will be located in D:\WebSphere\CommerceServer\stores\properties\mystore.
FFMCENTER_ID INTEGER
NULL
The default FulfillmentCenter for the Store.
FFMCSELECTIONFLAGS INTEGER
NOT NULL, DEFAULT 0
Contains bit flags that specify policy used by the default implementation of GetEligibleFulfillmentCenters concerning the selection of a FulfillmentCenter for an OrderItem whose Status is "B":
1 = preferCurrent - give preference to the currently assigned FulfillmentCenter, if any
2 = noChange - do not change the currently assigned FulfillmentCenter, if any.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
LANGUAGE_ID INTEGER
NULL
The default Language for information displayed to customers shopping in the Store. For a list of language components, see the LANGUAGE table.
LASTUPDATESTATUS TIMESTAMP
NULL
Indicates the last time the status of the store was updated.
MAXBOOFFSET INTEGER
NOT NULL, DEFAULT 7776000
If the estimated availability time for a backordered OrderItem exceeds this many seconds in the future, it will automatically be set to this many seconds in the future. As a result, an item cannot be backordered for longer than the time specified here.
OID CHARACTER (32)
NULL
Reserved for IBM internal use.
PRICEREFFLAGS INTEGER
NOT NULL, DEFAULT 0
Contains bit flags that control which TradingAgreements 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 OrderItems. 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.
QUOTEGOODFOR INTEGER
NULL, DEFAULT 43200
If this many seconds have passed since an Order was prepared, the prices and other monetary amounts in the Order may change when OrderProcess is run on an Order for which the customer has not yet committed to pay.
REJECTEDORDEXPIRY INTEGER
NULL, DEFAULT 259200
Orders with payment in Declined state longer than this number of seconds are candidates for cancellation.
RMAGOODFOR INTEGER
NULL, DEFAULT 86400
The time period in seconds for which return merchandise authorization (RMA)calculations are good. If this time period elapses before a RMA is completed, charges or credits and approval will be recalculated.
RTNFFMCTR_ID INTEGER
NULL
Default Fulfillment Center for returning merchandise to the Store.
STATUS INTEGER
NOT NULL, DEFAULT 1
Indicates the status of the store:
1 = open
0 = close
-1 = suspend
STORECGRY_ID INTEGER
NULL
The StoreCategory, if any, for this Store.
STOREGRP_ID INTEGER
NOT NULL
The StoreGroup for this Store.
STORELEVEL CHARACTER (10)
NULL
Reserved for IBM internal use.
STORETYPE CHARACTER (3)
NULL
Indicates one of the following StoreTypes, for use by a user interface that provides appropriate functions depending on the StoreType:
B2B = Business to Business.
B2C = Business to Consumer.
CHS = Reseller Hub.
CPS = Master Catalog Profile Store.
RHS = Reseller Hosted Store.
RPS = Reseller Profile Store.
DPS = Distributor Profile Store.
DPX = Distributor Proxy Store.
HCP = Commerce Hosting Hub.
PBS = Store Directory.
MPS = Merchant Profile Store.
MHS = Merchant Hosted Store.
SCP = Supplier Hub.
SPS = Supplier Profile Store.
SHS = Supplier Hosted Store.
STORE_ID INTEGER
NOT NULL
Generated unique key.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035111720 STORE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_772 RTNFFMCTR_ID FFMCENTER FFMCENTER_ID Cascade
F_773 STORECGRY_ID STORECGRY STORECGRY_ID Cascade
F_774 STOREGRP_ID STOREGRP STOREGRP_ID Cascade
F_775 STORE_ID STOREENT STOREENT_ID Cascade
F_776 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_777 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_925 CRTDBYCNTR_ID CONTRACT CONTRACT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1020 STORE_ID RFQTARGET 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_23 STORE_ID ACCOUNT STORE_ID Cascade
F_258 STORE_ID CPENDORDER STOREENT_ID Cascade
F_308 STORE_ID DISTARRANG WHOLESALESTORE_ID Cascade
F_309 STORE_ID DISTARRANG MERCHANTSTORE_ID Cascade
F_311 STORE_ID ECEOUT STORE_ID Cascade
F_393 STORE_ID INVENTORY STORE_ID Cascade
F_403 STORE_ID ITEMFFMCTR STORE_ID Cascade
F_462 STORE_ID MOPICONFIG STORE_ID Cascade
F_578 STORE_ID PAYSTATUS STORE_ID Cascade
F_623 STORE_ID PROFILE 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_697 STORE_ID RMA STORE_ID Cascade
F_748 STORE_ID SHPARRANGE 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_803 STORE_ID STORETRANS STORE_ID Cascade
F_859 STORE_ID TFTRADENG STORE_ID Cascade
F_911 STORE_ID WTAXINFO STORE_ID Cascade
F_916 STORE_ID STOREREL STORE_ID Cascade
F_917 STORE_ID STOREREL RELATEDSTORE_ID Cascade
F_93 STORE_ID AUCTSTRREL STORE_ID Cascade
F_930 STORE_ID SHPMODCLCD STORE_ID Cascade
F_934 STORE_ID ORDQUOTREL CHILDSTORE_ID Cascade
F_936 STORE_ID USRTRAFFIC STORE_ID Cascade
F_943 STORE_ID MASSOCCECE STORE_ID Cascade
F_944 STORE_ID MASSOCGPGP STORE_ID Cascade
F_945 STORE_ID CATGRPTPC STORE_ID Cascade
F_946 STORE_ID ICMETAFEAT STOREID Cascade
F_947 STORE_ID ICMETAPHOR STOREID Cascade
F_951 STORE_ID QUEUE STORE_ID Cascade
F_970 STORE_ID ICMERTREE STOREID Cascade
F_971 STORE_ID ICKNOWLEDG STOREID Cascade
F_986 STORE_ID FILEUPLOAD STORE_ID Cascade
F_99 STORE_ID AUTOBID STORE_ID Cascade