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.
|