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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035111720 | STORE_ID | Primary Key |
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 |
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 |