S
- SASTATS
Deprecated. Provided for backward compatibility only.- SCHACTIVE
The list containing what job will need to be run and the time when the job should execute.- SCHBRDCST
Log the status of broadcast commands for each of the clones.- SCHCMD
The URLs that can be used as a scheduled job by a store. This is for the Scheduler menu in the Administration Console.- SCHCONFIG
All scheduled job entries.- SCHERRORLOG
Exception information when a job fails to execute successfully.- SCHORDERS
Entries for scheduled orders.- SCHREPORT
- SCHSTATUS
Log of the status of scheduled jobs.- SEGMENTATION
Deprecated. Provided for backward compatibility only.- SEGMENTATION_REF
Deprecated. Provided for backward compatibility only.- SEOPAGEDEF
SEO page definition for a particular pageName at a site/store level- SEOPAGEDEFDESC
Language specific title and meta description for a particular page definition.- SEOPAGEDEFOVR
SEO page definition overrides defined for a particular catalogEntryID or catGroupID- SEOPAGEDEFSUBPARAM
Predefined substitution parameters which can be used while creating the title and meta description. At run-time the substitution parameter will be replaced with the values based on the request properties- SEOREDIRECT
Table to hold information about URL redirection as part of the SEO strategy to handle 404 and 301 redirects.- SEOREDIRECTTRAFFIC
Table to hold information about URL redirection as part of the SEO strategy to handle 404 and 301 redirects.- SEOTOKENUSGTYPE
Associate a primary token for every usage type defined in a store. This also holds information as to whether a token is static or not.- SEOURL
Token and sitemap information for a particular URL- SEOURLKEYWORD
Store and language specific SEO URL keyword information- SETCURR
Information about the different national currencies. The currency alphabetic and numeric codes are derived from the ISO 4217 standard.- SETCURRDSC
Text descriptions for each of the currency in the SETCURR table in each of the supported language.- SETSTATUS
Reserved for IBM internal use.- SHBTB
Deprecated. Provided for backward compatibility only.- SHDCACRM
Deprecated. Provided for backward compatibility only.- SHIPINFO
Store two different types of shipping information. Both sets of information will be passed in the generated PackSlip.xml file. The first set of information is to store shipping instructions. Only one set of shipping instructions will be captured for any order, address, and ship mode combination. The second set of information is to store a shipping carrier account number. A shipping carrier account number will be stored for any order and ship mode combination.- SHIPMODE
Each row of this table represents a ShippingMode for a StoreEntity. A Store can use its own ShippingModes, and the ShippingModes of its StoreGroup.- SHPARJURGP
Each row of this table indicates that a ShippingArrangement applies to all OrderItems whose shipping addresses match a ShippingJurisdictionGroup. Refer to SHPARRANGE.FLAGS.- SHPARRANGE
Each row of this table represents a ShippingArrangement, indicating that a FulfillmentCenter can ship products on behalf of a Store using a ShippingMode.- SHPJCRULE
Used by the shipping CalculationRuleQualifyMethod to choose a CalculationRule based on ShippingMode and FulfillmentCenter. It is used when the shipping address matches one of the ShippingJurisdictions in a particular ShippingJurisdictionGroup.- SHPMODCLCD
The relationship between the calculation code and the ship mode for shipping promotion use.- SHPMODEDSC
Each row of this table contains language-dependent information about a ShippingMode.- SITE
Reserved for IBM internal use. The data and schema in the WebSphere Commerce database may change depending on which WebSphere Commerce version is installed and which features are enabled. The SITE table is used to record version information related to the WebSphere Commerce schema and data. The information is used by various WebSphere Commerce utilities. All records in the SITE table should not be modified.- SMTPHOST
List of SMTP servers where WebSphere Commerce has successfully connected to in the past. Any entries in this table should represent a valid SMTP server name and port pair.- SRCHATTR
Each row represents the logical name of a catalog attribute that is defined in the search schema.- SRCHATTRDESC
Language-sensitive display name for a search column.- SRCHATTRPROP
Properties that are defined for each search index attribute. For example, the properties are rank, sort, catalogFilter, display, facet, filter and search.- SRCHCONF
The configuration table for WebSphere Commerce search integration.- SRCHCONFEXT
The configuration table extended for SRCHCONF for WebSphere Commerce search integration.- SRCHPROPRELV
Search relevancy values for a search field- SRCHSTAT
This table is used for capturing search related statistics at runtime.- SRCHTERM
This table contains search terms that a customer searches for, either as their inputted search term, or the substituted search term associations.- SRCHTERMASSOC
This table contains search term associations to suggest additional, different, or replacement products in search results. Search term associations include synonyms, replacement terms, and landing pages.- SRCH_CMDREG
Reserved for IBM internal use. This command registry allows the server to look up an implementation and default parameters for a command interface- SRCH_COMPCONFIG
Reserved for IBM internal use. This stores the component configuration for a particular commerce instance- SRCH_KEYS
Reserved for IBM internal use. Primary key generation store- SRCH_SCHACTIVE
Reserved for IBM internal use. The list containing what job will need to be run and the time when the job should execute- SRCH_SCHBRDCST
Reserved for IBM internal use. This table is used to log the status of broadcast commands for each of the clones- SRCH_SCHCONFIG
Reserved for IBM internal use. This table contains all scheduled job entries- SRCH_SCHERRLOG
Reserved for IBM internal use. This table contains the exception information when a job fails to execute successfully- SRCH_SCHREPORT
This table holds ...- SRCH_SCHSTATUS
Reserved for IBM internal use. Log of the status of scheduled jobs- STADDRESS
Each row of this table represents a store address. StoreEntities, FulfillmentCenters, and Vendors can have store addresses. Sore addresses can be staged using the staging server.- STAGLOG
Changes made on the Authoring or Staging environment that can be propagated to the Production Server using the StagingProp utility.- STATECODE
This table maps the internal StateProv Abbreviation Code to the State or Province Code. They are dictated by the third-party product or vendor identified in the PRODUCTVENDOR column.- STATEPROV
This table lists State and Province names (by country or region) in each of the supported Languages identified by LANGUAGE_ID.- STBRCODES
Deprecated. Provided for backward compatibility only- STBRWSER
Deprecated. Provided for backward compatibility only- STCGRYDESC
Deprecated. Provided for backward compatibility only- STCONF
Deprecated. Provided for backward compatibility only- STDCNTRY
Deprecated. Provided for backward compatibility only- STDOMAIN
Deprecated. Provided for backward compatibility only- STDPRICE
This summary table defines the standard (offer) price for each CatalogEntry. It contains pre-computed results based on the data existing in the underlying OFFER, OFFERPRICE, and TRADEPOSCN tables.- STDPRICEVW
This view is a proxy to the STDPRICE summary table to define the standard price (offer price) for each CatalogEntry.- STENCALUSG
Each row of this table contains information about how a CalculationUsage is used by a StoreEntity. If a column value is NULL for a Store, the Store uses the value specified for its StoreGroup.- STERROR
Deprecated. Provided for backward compatibility only- STFLNAME
Deprecated. Provided for backward compatibility only- STGMERTAB
The stage configuration table for all merchant tables.- STGMRSTTAB
The stage configuration table for all tables containing both merchant and site information.- STGSITETAB
The stage configuration table for all site tables.- STGUINDTAB
Deprecated. Provided for backward compatibility only.- STLFFMREL
This table holds relationships between store location and fulfillment center.- STLOC
Represents store location information.- STLOCATTR
Holds language specific store searchable attributes.- STLOCDS
Contains language specific store detailed descriptions.- STMERCNF
Deprecated. Provided for backward compatibility only- STORBLKRSN
Store level block reason code configuration. Used to configure whether a block reason code is turned on for a store and also configure whether this block reason code will generate ticklers.- STORE
Each row of this table represents a store. A store is a store entity.- STORECAT
Relationship between StoreEntities and the Catalogs that they offer.- STORECATOVRGRP
This table is used to hold the relationship between the store entities and catalog override groups they can use to display the catalog in the store front.- STORECENT
Relationship between StoreEntities and the CatalogEntries that they can display and process.- STORECGRP
Relationship between StoreEntities and the CatalogGroups that they can display and process.- STORECGRY
Each row of this table represents a StoreCategory. StoreCategories can be used to group Stores of similar types together for display purposes. For example, in order to display all clothing stores in a mall together in the mall directory, you could create a clothing StoreCategory.- STORECNTR
Each row of this table indicates that a Contract is deployed in a Store.- STORECONF
Store-specific configuration data used by the storefront code for dynamic rendering- STOREDEF
Each row of this table contains default information for a Store.- STOREDEFCAT
Relationship between store and the default catalog.- STOREENT
Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that can represent either a Store or a StoreGroup.- STOREENTDS
Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that can represent either a Store or a StoreGroup.- STOREGRP
Each row of this table represents a StoreGroup. A StoreGroup contains information that can be used by the Stores in that StoreGroup. A StoreGroup is a StoreEntity. In WebSphere Commerce, there is only one StoreGroup.- STOREINV
Reserved for IBM internal use. STOREINV is a view used by the Catalog search bean. It collates several fields from the INVENTORY table. There is a column ALLOCATIONGOODFOR in the STORE table. If this column is set to zero, the search bean makes use of this view.- STOREITEM
Each row of this table contains attributes that affect how a particular Store allocates inventory for the specified items of a particular Base Item. If there is no row for the Store, then the row for its Store Group is used.- STORELANG
Each row of this table indicates that a StoreEntity supports a language. See also the LANGPAIR table.- STOREMBRGP
Each row of this table indicates that a Store recognizes a MemberGroup as a customer group.- STOREMERCH
Mapping information indicates which merchant id is used for a specific store.- STOREPLTYPES
Relationship between the page layout type and the store.- STOREREL
Each row of this table describes a relationship between stores.- STORETPC
The relationship between store entity and trading position container.- STORETRANS
This table links the available site-level transports (specified in the TRANSPORT table) with the store where they are available.- STORITMFFC
Each row of this table contains information about a BaseItem for a particular Store (or all the Stores in a StoreGroup) and FulfillmentCenter.- STORLANGDS
Each row of this table contains a description, in a particular language, of a supported language. For example, the Spanish language might be described as "Espanol" in French but as "Spanish" in English.- STQOTCFG
This table is used to config the quote on a store entity.- STRELTYP
This table identifies all the store relationship types defined in WebSphere Commerce.- STRELTYPDS
This table describes all the store relationships defined in the STRELTYP table.- STTPCUSG
The usage types of a trading position container for a store entity.- SUBKEYS
This table is used by the IdResolver to resolve the primary identifiers of the database tables. If a new table is added to the schema, and if the primary identifier has to be resolved, an entry for that table has to be made in the SUBKEYS table. It is used in the same way as the KEYS table is used.- SUBORDADJ
Each row of this table represents a subtotal of all the OrderItemAdjustment amounts in an OrderAdjustment whose OrderItems have the same shipping address.- SUBORDERS
Each row of this table contains subtotals of amounts for all the OrderItems of an Order with the same shipping address.- SUBORDTAX
Each row of this table specifies the tax amount of a particular TaxCategory for all the OrderItems with the same shipping address as the SubOrder.- SUBSCPTYPE
This table defines all possible types of subscription a catalog entry can be subscribed to.- SUBSCRIPTION
Properties of subscriptions and recurring orders that has been placed by a specific shopper.- SUBSCRRENEW
Record the list of subscriptions created after renewal of existing subscriptions- SUBSCRSCHJOBS
Record the set of scheduled jobs to be executed against each subscription or a recurring order, as specified by the shopper. Typically, jobs for cancellation of subscriptions, creation of the next child order, expiry of subscriptions after the end date are stored in this table.- SUBSCRSUSPEND
Suspend start and end dates of subscriptions or recurring order as specified by the shopper. Multiple suspension periods can be specified for the same subscription or recurring order.- SUBSCRTEMPLATE
Properties associated with a subscription product template. For a subscription, there will be a single template for all subscribers who have purchased this subscription product. The item to fulfill as part of this subscription should be managed by the merchant. Initially this will contain the parent catalog entry ID of the subscription product and needs to be updated by the merchant if a different item needs to be shipped.- SUBSCRTMPLITEMLIST
Details of a catalog entry, with quantity and price details for a given subscription template ID. This item will be shipped as part of the child order when the subscription is to be fulfilled.