- SASTATS
This table is deprecated and is 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
This table is used to log the status of broadcast commands for each of the clones.
- SCHCMD
The URLsthat can be used as a scheduled job by a store. This is for the Scheduler menu in the Administration Console.
- SCHCONFIG
This table contains all scheduled job entries.
- SCHERRORLOG
This table contains the exception information when a job fails to execute successfully.
- SCHORDERS
This table contains the entries for scheduled orders.
- SCHREPORT
- SCHSTATUS
This table is a log of the status of scheduled jobs.
- SEGMENTATION
This table is deprecated and is provided for backward compatibility only.
- SEGMENTATION_REF
This table is deprecated and is provided for backward compatibility only.
- SELLER_ORG_REQUEST
This table holds the details of the approval record.
- SEOPAGEDEF
This table holds the SEO page definition for a particular pageName at a site/store level
- SEOPAGEDEFDESC
This table holds the language specific title and meta description for a particular page definition.
- SEOPAGEDEFOVR
This table holds the SEO page definition overrides defined for a particular catalogEntryID or catGroupID
- SEOPAGEDEFSUBPARAM
This table holds the 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
This table is used to 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
This table holds the token and sitemap information for a particular URL
- SEOURLKEYWORD
This table holds the store and language specific SEO URL keyword information
- SETCURR
The table contains information about the different national currencies. The currency alphabetic and numeric codes are derived from the ISO 4217 standard.
- SETCURRDSC
This table stores the text descriptions for each of the currency in the SETCURR table in each of the supported language.
- SETSTATUS
Reserved for HCL internal use.
- SHBTB
This table is deprecated and is provided for backward compatibility only.
- SHDCACRM
This table is deprecated and is provided for backward compatibility only.
- SHIPINFO
This table is used to 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
This table can be 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 HCL internal use. The data and schema in the HCL Commerce database may change depending on which HCL Commerce version is installed and which features are enabled. The SITE table is used to record version information related to the HCL Commerce schema and data. The information is used by various HCL Commerce utilities. Note: All records in the SITE table should not be modified.
- SMTPHOST
This table maintains a list of SMTP servers where HCL 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
This table stores the 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 HCL Commerce search integration.
- SRCHCONFEXT
The configuration table extended for SRCHCONF for HCL Commerce search integration.
- SRCHPROPRELV
This table stores 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 HCL internal use. This command registry allows the server to look up an implementation and default parameters for a command interface
- SRCH_COMPCONFIG
Reserved for HCL internal use. This stores the component configuration for a particular commerce instance
- SRCH_KEYS
Reserved for HCL internal use. Primary key generation store
- SRCH_SCHACTIVE
Reserved for HCL internal use. The list containing what job will need to be run and the time when the job should execute
- SRCH_SCHBRDCST
Reserved for HCL internal use. This table is used to log the status of broadcast commands for each of the clones
- SRCH_SCHCONFIG
Reserved for HCL internal use. This table contains all scheduled job entries
- SRCH_SCHERRLOG
Reserved for HCL internal use. This table contains the exception information when a job fails to execute successfully
- SRCH_SCHREPORT
This table holds ...
- SRCH_SCHSTATUS
Reserved for HCL internal use. This table is a 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. Store addresses can be staged using the staging server.
- STAGLOG
This table holds 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
This table is deprecated and is provided for backward compatibility only
- STBRWSER
This table is deprecated and is provided for backward compatibility only
- STCGRYDESC
This table is deprecated and is provided for backward compatibility only
- STCONF
This table is deprecated and is provided for backward compatibility only
- STDCNTRY
This table is deprecated and is provided for backward compatibility only
- STDOMAIN
This table is deprecated and is 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
This table is deprecated and is provided for backward compatibility only
- STFLNAME
This table is deprecated and is 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
This table is deprecated and is 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
This table is deprecated and is 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
This table holds the 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
This table holds the relationship between StoreEntities and the CatalogEntries that they can display and process.
- STORECGRP
This table holds the 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 that is used by the storefront code for dynamic rendering.
- STOREDEF
Each row of this table contains default information for a Store.
- STOREDEFCAT
This table holds the 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 HCL 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
This table stores the mapping information indicates which merchant id is used for a specific store.
- STOREPLTYPES
This table stores the 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 HCL 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
This table stores the properties of subscriptions and recurring orders that has been placed by a specific shopper.
- SUBSCRRENEW
This table is used to record the list of subscriptions that were created after renewal of existing subscriptions
- SUBSCRSCHJOBS
This table is used to 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
This table stores the 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
This table contains the 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
This table stores the 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.