Database schema changes between from version 5.1 to version 5.6

This topic describes the database schema changes between WebSphere Commerce 5.1 and WebSphere Commerce 5.6. The changes are grouped into the following sections:

Tables added since version 5.1

ACACGPDESC
This table stores locale specific display information for the ACACTGRP table. The Administration Console GUI displays the locale specific display names from this table.
ACACTACTGP
This table captures the association between access control actions and action groups.
ACACTDESC
This table stores locale specific display information for the actions stored in the ACACTION table.
ACACTGRP
This table stores all the access control action groups. An action group can contain one or more actions. The association between actions and action groups is captured in the ACACTACTGP table.
ACACTION
This table is a master list of all the actions in the system. Typically the actions map to the controller commands and views in the system. This table stores all the actions that can be performed on the resources in the system.
ACATTR
This table is a master list of the attributes based on which some resources can be grouped. These attributes can be used to form implicit groups of resources.
ACATTRDESC
This table stores locale specific display information corresponding to the ACATTR table.
ACCLOGMAIN
This table contains information about access violation. Entries are created only if a violation has occurred. There will only be one entry per request. Detailed information is stored in the ACCLOGSUB table.
ACCLOGSUB
This table contains detailed information of the request causing access violation. The entries are linked to the ACCLOGMAIN table.
ACCOUNT
Each row of this table represents a business account between a Buyer organization and a Seller organization. A business account can be used to organize various Trading Agreements and to specify special Trading Terms and Conditions.
ACORGPOL
This table enables an organization to be exempted from one or more of the template policies. This table is deprecated and is provided for backward compatibility only.
ACPLGPDESC
This table stores locale specific information for the ACPOLGRP table.
ACPLGPSUBS
This table stores the association between access control policy groups and organizational entities. An organizational entity that is associated with a policy group is said to subscribe to that policy group. The access control policies belonging to that policy group will apply to that organization. An organization can subscribe to multiple policy groups and the same policy group can be subscribed to by multiple organizations.
ACPOLDESC
This table stores locale specific information for the ACPOLICY table.
ACPOLGPPOL
This table stores the association between access control policy groups and access control policies. An access control policy that belongs to a policy group will be applied to all the organizations that subscribe to that policy group.
ACPOLGRP
This table stores all the access control policy groups in the system. Each a row in this table represents a policy group.
ACPOLICY
This table stores all the access control policies in the system. Each policy is a row in the policy table. Every policy refers to an action group, a member group, a resource group and optionally a relationship.
ACPOLSUBGP
Reserved for IBM internal use.
ACRELATION
This table is a master list of all the relations that exist in the system. These relationships are between resources that are protected and the members in the system.
ACRELDESC
This table stores locale specific information about relationships.
ACRELGRP
This table is a master list of all the relationship groups that exist in the system. These relationship groups are between resources that are protected and the users in the system.
ACRESACT
This table captures the relationship between resources and actions. Given a resource, you can find out the associated actions from this table.
ACRESATREL
Related reference
ACRESCGRY
This table stores all the resource categories in the system and the metadata information about them. The metadata includes information about the table and columns that store the resources belonging to this resource category.
ACRESGPDES
This table stores locale specific display information for the ACRESGRP table.
ACRESGPRES
This table associates resource groups with resource categories (or the classes of resources). You can use this table to group various resources in a group based on their class names.
ACRESGRP
This table stores all the resource groups in the system. The conditions column stores an XML document containing the constraints and attribute value pairs used for grouping the resources.
ACRESMEMRL
This table stores resource-member relationships for resources of the type of different resource categories. A combination of all the columns other than ACRESMEMRL_ID should be unique.
ACRESPRIM
This table stores the primary resource column names for a resource. A given resource can have more than one primary column.
ACRESREL
This table stores the relationship between resources. Given a resource, you can find out the possible relationships that it can have and also the table and the columns in which various relationships are stored.
ACRLGPDESC
This table stores locale specific information about relationship groups.
ACRSCGDES
This table stores locale specific display names for the resource categories.
APPLY_INIT
This table holds the results of the application of the mining model. The mining model is applied to information pertaining to campaign activities.
APPLY_MEMBER
This table contains the output from WebSphere Commerce Analyzer after the mining model is applied to members and the WebSphere Commerce Analyzer sample closed-loop script is run.
APPLY_RESULT
This table contains the result of a mining apply for contracts or accounts. This table is currently not used.
APRVSTATUS
Related reference
ATTACHMENT
This table contains information about Attachments. An Attachment is a supporting document for a trading document. For example, it can be a specification of a product, or a price list spreadsheet.
ATTACHUSG
The Attachment usage table.
AUCPAYINFO
Reserved for IBM internal use.
AUCTBIDVW
This view is a join of the AUCTVIEW and BID tables. The join is based on AUCT_ID and STORE_ID. For column descriptions, refer to either the AUCTVIEW or BID tables.
BASEITEM
BaseItems represent a general family of goods with a common name and description. BaseItems are used exclusively for fulfillment. Each CatalogEntry that represents a Product in the catalog has a corresponding BaseItem for fulfillment purposes.
BASEITMDSC
Each row of this table contains language-dependent information for a BaseItem.
BKORDALLOC
Each row contains information about the quantity required for this backordered order item and the amount of available inventory allocated to this item.
BKORDITEM
Each row contains the expected ship date of a backordered OrderItem.
BUSAUDIT
This table contains the WebSphere Commerce business auditing records captureed when the business auditing component is enabled.
BUYERPO
Each row of this table represents a Purchase Order Number that the Buyer organization of the Account has defined or used for Trading with the Seller organization. The number is only unique within the Account.
BUYERPOTYP
The Buyer Purchase Order Type table. This table defines the different types of Buyer Purchase Order for the Site.
BUYSUPMAP
This table is used to register the buyer organization using procurement systems with supplier organizations.
BUYSUPSEC
Reserved for IBM internal use.
BZSRVCFG
This table contains rule server configuration data. Each row represents a rule server.
BZSVCCFG
This table contains rule service configuration data. Each row represents a rule service configuration, including the rule server to which the service belongs.
BZSVCSTA
This table indicates the last-known status of a rule service. Each row represents status reported by an application clone for a rule service. This table is deprecated and is provided for backward compatibility only.
CACHEIVL
This table records changes to product or category information in the database. It can be populated by user-defined database triggers.
CALCODEMGP
The CalculationCodeQualifyMethod can use the rows of this table to restrict use of a CalculationCode to members of certain MemberGroups.
CATCLSFCOD
This table contains the assignment of classification codes to CatalogEntries.
CATCONFINF
This table holds additional information for CatalogEntries that represent Configurable Products. This information may be required by an external configurator to configure this CatalogEntry.
CATGRPPS
This table relates CatalogGroups to ProductSets. Every CatalogEntry under the Catalog sub-tree for this CatalogGroup is a member of the specified ProductSet.
CATGRPTPC
This table relates master catalogs with trading position containers. Each catalog entry belonging to the indicated master catalog must have a standard price offer supplied for the specified trading position container.
CATPRDREL
This table is deprecated and is provided for backward compatibility only.
CHARGETYPE
Charge or credit applied against a transaction which is not for product. Examples include expedite fees, customization fees, and restocking fees.
CHKARRANG
This table associates the defined store commands (SCHCMD) with the defined check commands (CHKCMD).
CHKCMD
The check commands that can be used by a store to determine whether the scheduled job needs execution. This is for the Scheduler menu in the Administration Console.
CHRGTYPDSC
This table contains the language-dependent descriptions of the Charge Type.
CLASIFCODE
This table contains all possible product classification codes under different classification domains (such as UNSPSC, SPSC, and so on) that can be assigned to CatalogEntries.
CLCDPROMO
This table stores information about the relationship between the Calculation Framework and the promotion standalone infrastructure. Each calculation code matches one promotion in the PX_PROMOTION table.
CLSFCODEDS
This table contains the language specific information of product classification code.
CNTRDISPLY
This table contains display information for a Contract.
CNTRNAME
This table contains name information for a Contract. The Contract name is used to force serialization on contract management.
CNTRSTORE
This table contains Store information for a Contract. The data is used to persist XML data needed by a contract to create a Store.
COLLABWS
This table stores collaborative workspace information.
CPEMAILMAP
This table stores the mapping between the coupon ID and the e-mail IDs of guest customers to whom specific coupon IDs were sent.
CPITMAP
This table stores all of the items from the given (completed) order that were applicable to the selected coupon set.
CPOFFER
This table contains the promotions that are available to be shown to customers in their offer list.
CPPMN
This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions.
CPPMNACC
This table stores the number of times a coupon has been accepted from the coupon promotion by the guest customer identified by the e-mail ID. It also stores the number of times the customer has redeemed coupons from this promotion.
CPPMNCAT
This table contains the purchase conditions for a category-level promotion. If the purchase condition type in the CPPMN table was C, then this table is used to find out all of the items that are required for this coupon to be redeemed. There can be more than one category condition for a given promotion. All of the purchase conditions for a coupon are combined using the AND operator.
CPPMNDESC
This table contains the language specific description of the promotion.
CPPMNDISC
This table contains the discount conditions for a promotion. Every coupon has exactly one calculation code.
CPPMNORD
This table contains the minimum purchase amount that must be in the shopping cart before this coupon is applicable.
CPPMNPROD
This table contains the purchase conditions for a promotion. If the purchase condition type in CPPMN table was "P", then this table is used to determine which items are required before this Coupon may be redeemed.
CPPMNVAL
Reserved for IBM internal use.
CPWALLET
This table contains the coupons that the user has accepted.
CREDITLINE
Each row of this table represents a credit line the account holder (buyer organization) has with the seller organization. This credit line is associated with a specific business account.
CWMEMBER
This table stores collaborative workspace member information.
DISTARRANG
Each row of this table represents a DistributionArrangement, enabling a Store to sell its own inventory.
EMLBADADDR
This table records information about users with invalid e-mail addresses. Each row corresponds to a user that has an invalid e-mail address.
EMLBOUNCED
Records information about bounced messages for e-mail activities. Each row corresponds to a bounced message for a particular recipient of a particular e-mail activity.
EMLCAMPREL
This table stores the relationship between an e-mail activity and a campaign. Each row represents the campaign to which the e-mail activity belongs.
EMLCFG
This table stores the configuration information about the accounts used in support of e-mail activities. Each store can have one inbound (POP3) and one outbound (SMTP) server configured.
EMLGRPREL
This table stores the relationship between an e-mail activity and its target customer segment.
EMLMSG
This table stores e-mail message templates. Each row corresponds to an e-mail message template which can be used within an e-mail activity.
EMLPOLICY
Stores bounce back e-mail retry policies.
EMLPROMO
This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.
EMLRCPTS
This table records the recipients of an e-mail activity.
EMLRPTEVTS
This table records e-mail events for each recipient of a particular e-mail activity. If a row does not exist for a recipient of an e-mail activity, the user has not yet caused an event.
EMLSTRPLCY
Stores the relationship between a store and a bounced e-mail retry policy.
EMLUSRRECV
This table stores whether the user prefers to receive e-mail activities or not.
EMSPOT
This table contains registered e-Marketing Spots.
FILEUPLOAD
This table contains the information of uploaded files.
FLCOMPOSE
Reserved for IBM internal use.
FLDOMNDESC
Reserved for IBM internal use.
FLINSTANCE
Reserved for IBM internal use.
FLOW
Reserved for IBM internal use.
FLOWADMIN
Reserved for IBM internal use.
FLOWDESC
Reserved for IBM internal use.
FLOWDOMAIN
Reserved for IBM internal use.
FLOWTYPE
Reserved for IBM internal use.
FLSTATEDCT
Reserved for IBM internal use.
FLSTATEGP
Reserved for IBM internal use.
FLSTATEREL
Reserved for IBM internal use.
FLSTDCTDSC
Reserved for IBM internal use.
FLSTGPDSC
Reserved for IBM internal use.
FLTRANSDSC
Reserved for IBM internal use.
FLTRANSITN
Reserved for IBM internal use.
FLTYPEDESC
Reserved for IBM internal use.
HISTOATTR
Reserved for IBM internal use.
HISTOFREQ
Reserved for IBM internal use.
HISTONVP
Reserved for IBM internal use.
INTVSCHED
This table describes the scheduling of campaign activities onto e-Marketing Spots.
INVADJCODE
Each row of this table defines an InventoryAdjustmentCode for a Store, or the Stores in a StoreGroup. Each code represents a reason for an InventoryAdjustment, such as broken, lost, or found.
INVADJDESC
Each row of this table contains language-dependent information about an InventoryAdjustmentCode.
INVADJUST
This table records adjustments made to inventory.
INVITMVW
This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item across all Stores and FulfillmentCenters.
INVOICE
This table stores the invoice XML generated for the order release. An order release is represented by a row in the ORDRELEASE table.
INVRESERVE
Each row contains information about existing inventory that has been reserved for such purposes as auctions. This reserved inventory is not available for customer orders until the reservation is reversed.
INVRSRVDSC
Each row contains language-specific descriptions for the types of inventory reservations that the user has defined.
INVRSRVTYP
Each row contains user-defined reservation types that can be used when reserving inventory.
INVSTFFMVW
This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item at a Store and FulfillmentCenter.
INVSTVW
This is a view derived from the RECEIPT and ITEMFFMCTR tables which contains the existing quantity available for an item for a given store across all FulfillmentCenters.
ITEMFFMCTR
Each rows contains information about reserved quantities, amount on backorder, and amount allocated to backorders for items owned by a store at a fulfillment center.
ITEMSPC
Information about specified items. A specified item is a product with values for all its attributes. A specified item could correspond to a 2L bottle of milk, with 2% fat content. A specified item is the customer view of what the merchant sells.
ITEMTYPE
Each row of this table represents a type of BaseItem.
ITEMVERSN
Each row of this table represents an ItemVersion for a BaseItem. An ItemVersion expires when its expiration date is in the past. Each BaseItem must only have a single ItemVersion defined.
LMEVENTMAP
LikeMinds event information. This information is also stored in the LikeMinds server database.
LMSERVER
This table holds the LikeMinds server information. This table is deprecated and is provided for backward compatibility only.
LPOPURAMT
This table is used to keep track of Purchase Amounts by Purchase Order number and by Orders. Entries are created only for Orders against Limited Purchase Order (PO) numbers.
MANIFEST
One record exists for each manifest (shipment confirmation) produced for an order release. If a release is packaged in two boxes there will be two rows in the manifest table.
MBRATTR
This table contains an attribute definition dictionary for members.
MBRATTRVAL
This table stores the values of attributes which are defined in the MBRATTR table for members.
MBRGRPCOND
This table stores the conditions for an implicit memberGroup.
MBRGRPDESC
This table contains locale specific information for the entries in the MBRGRP table.
MBRREL
This table stores membership hierarchy relationships among users and orgEntities. Note that memberGroup is not part of the membership hierarchy.
MBRROLE
This table stores role assignment for members. Each member can play one or more roles in the WebSphere Commerce system. When a member is assigned a role, the orgEntity for which the member plays that role can also be specified.
MLTIME
This table is used by the MassLoader component as register of current timestamp.
MSALESVW
This table is deprecated and is provided for backward compatibility only.
MSGARCHIVE
This table stores sent messages (if ARCHIVEMSG = "1" is set for the message profile). The stored messages can be resent using the integrated GUI in the Administration Console.
MSGCOUNTVW
Reserved for IBM internal use.
MUSRTRVW
Reserved for IBM internal use.
NOTIFY
Reserved for IBM internal use.
NUMBRUSG
Each row defines a NumberUsage object. Numbers such as quantities and monetary amounts can be rounded and formatted differently depending on their associated NumberUsage objects. The CurrencyManager and QuantityManager cache this information.
NUMBRUSGDS
Each row of this table contains language-dependent information for a NumberUsage. This table defines a usage of either a currency format or a quantity format. See also the NUMBRUSG table.
OICOMPLIST
Each rows contains information about the components of a configured OrderItem.
OPERATOR
This table is used to define operators.
OPERATRDSC
This table holds the language-dependent information related to an operator.
ORCPMAP
This table stores information about the electronic coupons that were applied to the given (completed) Order.
ORDCALCD
Each row of this table indicates to the CalculationCodeCombineMethod that a CalculationCode is directly attached to all OrderItems in an Order whose directCalculationCodeAttachment flag in ORDERITEMS.PREPAREFLAGS is 1.
ORDCHNLTYP
Reserved for IBM internal use.
ORDERMGP
This table is used to track the customer segments to which an Order is associated.
ORDIMEEXTN
This table contains procurement system specific OrderItem information.
ORDIOFFER
Each row of this table indicates an Offer that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.
ORDIPROF
Reserved for IBM internal use.
ORDITPROMOCD
This contains promotion codes that were captured with an order for the orderitems in the order.
ORDITRD
Each row of this table indicates a TradingAgreement that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.
ORDMEEXTN
This table contains procurement system specific order information.
ORDPICKHST
Details of the how inventory was picked from the receipt level when available inventory is allocated to an OrderItem.
ORDPROMOCD
This table contains promotion codes captured for an order.
ORDQUOTREL
Each row of this table represents a relationship between a parent Order and a child Order.
ORDRELEASE
Each row in this table represents an OrderRelease. An OrderRelease is a grouping of all OrderItems in an Order that are to be shipped to the same address using the same shipping mode from the same FulfillmentCenter at the same time.
ORDSHIPHST
Each row contains information about inventory that has been released for fulfillment of an OrderItem.
ORGCODE
This table contains the unique identification of an OrgEntity under different identification systems or domains. This can be used to identify buyer organizations and supplier organizations to each other in procurement systems.
OUTPUTQ
Reserved for IBM internal use.
OUTPUTQDSC
Reserved for IBM internal use.
PAREQINFO
PARTICIPNT
This table stores information about a participant for a TradingAgreement.
PARTROLE
This table stores role information about a participant for a TradingAgreement.
PARTROLEDS
This table stores descriptions for the role a participant plays a TradingAgreement.
PATTRDESC
This table contains personalization Attribute descriptions.
PATTRIBUTE
This is the personalization Attribute supported by the site.
PATTRPROD
The relationship table between the PATTRIBUTE and CATENTRY tables.
PATTRVALUE
The personalization Attribute Value table. This table holds the values associated with personalization attributes.
PAYSUMMARY
Each row of this table stores a payment summary XML that could be sent to an external accounting system. The summary is by Store, Account, and payment policy.
PICKBATCH
This table contains pick batch information. A pick batch groups together order releases for their processing as a unit at a FulfillmentCenter (picking inventory for OrderItems, packing them into boxes, and shipping to customer through selected carrier).
PLCYACCDSC
This table holds language-dependent information related to an account policy.
PLCYACCLCK
This table contains the account lockout policies for WebSphere Commerce stores.
PLCYACCT
This table stores the account policies.
PLCYLCKDSC
This table holds language-dependent information related to an account lockout policy.
PLCYPASSWD
This table stores password policies.
PLCYPWDDSC
This table holds language-dependent information related to a password policy.
PLCYTYCMIF
This table stores command interface relationship information for a business policy.
PLCYTYPDSC
This table describes the type of business policy for a policy.
POLICY
Each row in this table represents a business policy.
POLICYCMD
This table stores command relationship information for a business policy.
POLICYDESC
This table stores descriptions for a business policy.
POLICYTC
This table stores information about which business policy is referenced by a specific term or condition.
POLICYTYPE
This table stores information about the type of business policy for a policy.
PRATRSTATR
Reserved for IBM internal use.
PRCEOFFPRD
Reserved for IBM internal use.
PRCOFFRPRC
Reserved for IBM internal use.
PRDATRAVAL
Reserved for IBM internal use.
PROCBUYPRF
This table contains the buyer organization specific profile information of procurement system protocols to support Procurement System integration.
PROCMSGVW
This table contains the view names used to compose the response message sent to procurement systems. Response message composition can be customized (per buyer, per protocol) using this table.
PROCPROTCL
Each row of this table represents a procurement system protocol and its version number. For example, cXML, OCI, OBI, and so on.
PROCSYS
Each row of this table represents a Procurement System. Examples of Procurement systems are Ariba, Oracle, CommerceOne, and so on.
PRODATR
Reserved for IBM internal use.
PRODSETDSC
This table holds the language-dependent information related to ProductSets.
PRODUCTSET
This table holds the definition of a ProductSet. The actual representation of the ProductSet is held in the PRSETCEREL table.
PRSETCEREL
This table holds the expanded (published) form of a ProductSet.
PSETADJMNT
This table stores information on product set adjustments and shows which product set is referenced by a term and condition for a business policy.
PURCHASELT
This table stores information on stipulations or limitations on how much a customer can purchase based on a Contract.
PX_COUPON
This table contains all of the coupons issued to individual customers.
PX_DYNATTR
This table contains the details about any dynamic attributes that belong to promotion entities, such as promotion groups, promotion policies, and others.
PX_GROUP
Contains the promotion groups for the site.
PX_GRPPOLICY
This table contains relationships between promotion groups and promotion policies.
PX_POLICY
This table contains promotion policies.
PX_PROMOARG
This table contains details about how promotions are applied to an order.
PX_PROMOPOLICY
Reserved for IBM internal use.
PX_PROMOTION
PX_PROMPROM
Reserved for IBM internal use.
PX_TEMPLATE
Reserved for IBM internal use.
PX_TPLTGRP
Reserved for IBM internal use.
PX_USAGE
This table contains statistics about promotion usage.
QTYUNITMAP
Each row of this table maps a QuantityUnit (defined in the QTYUNIT table) to a unit of measurement code defined in an external standard.
QUEUE
This table contains customer care queue records for each store.
QUEUECSR
This table contains customer care queue assignment records for Customer Service Representatives.
QUEUEDESC
Customer Care Queue description
RA
Records general information about inventory expected from a vendor. "RA" stands for Replenishment Advisement. However, the term "Expected Inventory Record" is used to mean the same thing.
RABACKALLO
Each row contains information about how backorders are allocated against expected inventory.
RADETAIL
This table contains detailed information about items on an expected inventory record.
RCPTAVAIL
Defines which DistributionArrangements have access to received inventory.
RCPTITMVW
A view which summarizes the quantity of inventory available from the RECEIPT table for an item across all Stores and FulfillmentCenters.
RCPTSTFFVW
A view which summarizes the quantity of inventory available from the RECEIPT table for an item owned by a Store at a FulfillmentCenter.
RCPTSTVW
A view which summarizes the quantity of inventory available from the RECEIPT table for an item owned by a Store across all FulfillmentCenters.
RECEIPT
Each row contains information about each receipt of an item at a FulfillmentCenter.
REFKEYS
The table represents a foreign relationship between tables that does not already exist in the database.
REFUNDMTHD
Reserved for IBM internal use.
REPDLVRY
This table describes how StoreEntities want their automated commerce reports to be delivered.
RFQ
This table holds the basic RFQ data.
RFQCATEGRY
This table holds categories created in each RFQ.
RFQPROD
RFQ Request and Product relationship table. This table stores information about the products requested in an RFQ.
RFQRSP
RFQ Response table. This table stores the basic RFQ response information.
RFQRSPEVAL
This table holds all the response product evaluations for the RFQ.
RFQRSPPARL
This table holds the relationship of the personalized attributes in the RFQ and the response.
RFQRSPPROD
RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.
RFQRSPTCRL
The relationship between one specified RFQ term or condition, and an RFQ Response to this term or condition.
RFQTARGET
This table holds the target stores for RFQs.
RICHATTR
This summary table relates Attribute to AttrValue for each Catalog Entry. It contains pre-computed results based on the data existing in the underlying ATTRIBUTE and ATTRVALUE tables.
RICHATTRCG
This summary table relates Attribute to AttrValue for Catalog Entries in each CatGroup. It contains pre-computed results based on the data existing in the underlying ATTRIBUTE and ATTRVALUE tables.
RLDISCOUNT
This table defines the additional attributes of a promotion object for Blaze Rule Engine use.
RMA
This table is a container for return merchandise authorizations (RMAs).
RMAAUTHLOG
This table is a log of when each return merchandise authorization (RMA) was authorized. A single RMA may appear multiple times if changes were made and the RMA was re-authorized.
RMACHARGE
This table stores charges or credits, applied to a return merchandise authorization (RMA), which are not for sellable products or services. This can be applicable to the entire RMA or to a specific RMA item, such as restocking fees or shipping credits.
RMAIADJCRD
This table stores return merchandise authorization (RMA) item adjustment credits. These are the portion of an order item adjustment that is to be refunded to the buyer.
RMAIDNYRSN
A joint table which specifies reasons for denying a return merchandise authorization (RMA) item.
RMAITEM
This table stores item information for a return or credit for a return merchandise authorization (RMA).
RMAITEMCMP
This table describes the smallest unit of inventory items involved in a return merchandise authorization (RMA).
RMATAX
This table stores return merchandise authorization (RMA) tax credits.
ROLE
This table stores the roles defined in WebSphere Commerce. Once a role is created, you cannot change the name or description of a role using a graphical user interface tool.
ROLEDESC
RTNDNYDESC
This table stores the language-dependent descriptions of the reasons for denying return merchandise authorizations (RMAs).
RTNDNYRSN
This table stores denial reasons for return merchandise authorization (RMA) items. These are the reasons for which an RMA item was not automatically approved by the system.
RTNDSPCODE
This table stores return disposition codes to describe how a received item is disposed.
RTNDSPDESC
This table stores the language-dependent description of a return disposition code.
RTNRCPTDSP
This table describes how a returned item has been disposed.
RTNREASON
This table stores the reason for customer dissatisfaction with a product.
RTNRECEIPT
This table stores the receipt record that indicates that a returned item, from a return merchandise authorization (RMAA), has been received and specifies information about the received items.
RTNRSNDESC
This table stores the language-dependent description of the return reason codes.
SCHACTIVE
The list containing what job will need to be run and the time when the job should execute.
SCHCMD
The URLsthat can be used as a scheduled job by a store. This is for the Scheduler menu in the Administration Console.
SCHERRORLOG
This table contains the exception information when a job fails to execute successfully.
SEGMENTATION
This table defines data mining segments (or models) used with WebSphere Commerce Analyzer.
SEGMENTATION_REF
Descriptions of the WCA Data Mining segments
SHPARJURGP
Each row of this table indicates that a ShippingArrangement applies to all OrderItems whose shipping addresses match a ShippingJurisdictionGroup. Refer to SHPARRANGE.FLAGS.
SHPMODCLCD
The relationship between the calculation code and the shipmode for shipping promotion use.
SMTPHOST
This table maintains a 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.
STCGRYDESC
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.
STGUINDTAB
This is the configuration table to check for a unique index conflict.
STORECNTR
Each row of this table indicates that a Contract is deployed in a Store.
STOREITEM
Each row of this table contains attributes that affect how a particular Store allocates inventory for the specified items of a particular BaseItem. If there is no row for the Store, then the row for its StoreGroup is used.
STOREREL
Each row of this table describes a relationship between stores.
STORITMFFC
Each row of this table contains information about a BaseItem for a particular Store (or all the Stores in a StoreGroup) and FulfillmentCenter.
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.
TCATTR
This table stores information about the terms and conditions attributes specified within a contract. This table stores the XML data required by a term and condition.
TCDESC
This table stores descriptions for terms and conditions for a contract.
TCPITMAP
This table stores all of the items from the shopping cart that are applicable to the current coupon for the Coupon Decision Support system.
TCSUBTYPDS
Each row in this table contains a description for a sub-type of terms and conditions.
TCSUBTYPE
Each row in this table contains information about the implementation of a terms and conditions sub-type.
TCTYPE
This table contains the types of terms and conditions.
TERMCOND
This table contains terms and conditions used in trading agreements (business accounts, contracts, RFQs). To see how columns are used by different terms and conditions, refer to TERMCOND column mapping.
TFALGOPOL
Reserved for IBM internal use.
TFALGOREG
Reserved for IBM internal use.
TFALGOTYPE
Reserved for IBM internal use.
TFALGPOLDS
Reserved for IBM internal use.
TFALGTYPDS
Reserved for IBM internal use.
TFALREGDSC
Reserved for IBM internal use.
TFDOMAIN
Reserved for IBM internal use.
TFDOMDSC
Reserved for IBM internal use.
TFEXTENG
Reserved for IBM internal use.
TFSBDOMAIN
Reserved for IBM internal use.
TFSBDOMDSC
Reserved for IBM internal use.
TFTRADENG
Reserved for IBM internal use.
TFTRENGDSC
Reserved for IBM internal use.
TMPBOLIST
Reserved for IBM internal use.
TMPCMPLIST
Reserved for IBM internal use.
TMPFFCLIST
Reserved for IBM internal use.
TMPPROCID
Reserved for IBM internal use.
TMPRADTL
Reserved for IBM internal use.
TMPRCTLIST
Reserved for IBM internal use.
TORCPMAP
This table stores information about the coupons that are applicable on the current shopping cart while the decision support system is running.
TRADING
Each row in this table represents a TradingAgreement.
TRDATTACH
This table stores information about the trading to attachment relationship for a TradingAgreement.
TRDDEPAMT
This table is used to keep track of deposited amounts by TradingAgreements, by Orders or OrderItems.
TRDDESC
The trading agreement description table.
TRDPSCNXML
This table is used to store the XML document for a given trading position container.
TRDPURAMT
This table is used to keep track of Purchase Amounts by Trading Agreements, by Orders or OrderItems. Entries are created only for Trading Agreement with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.
TRDREFAMT
This table is used to keep track of Refund Amounts by Trading Agreements, by Orders and by RMA ID. Entries are created only for Trading Agreement with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.
TRDTYPE
This table stores information about the type of trading for a TradingAgreement.
TRDTYPEDSC
This table stores a description for TradingAgreement types in multiple languages.
VENDOR
Each row defines a Vendor who has a relationship with a Store, or all the Stores in a StoreGroup, generally to provide inventory.
VENDORDESC
Language-specific information about Vendors.
VERSIONSPC
Each row defines the relationship between a product version and a specified item.
WCSDICTNRY
Reserved for IBM internal use.
WCSDTNRYDS
This is a description table to the WCSDICTNRY table.
WSALESVW
Reserved for IBM internal use.
WUSRTRVW
Reserved for IBM internal use.

Tables containing new columns

ATTRIBUTE
  • USAGE
  • QTYUNIT_ID
  • GROUPNAME
  • NOTEINFO
  • MULTITYPE
ATTRVALUE
  • OPERATOR_ID
  • QTYUNIT_ID
  • ATTACHMENT_ID
AUCTION
  • AUCPAYINFO_ID
  • INVRSRVID
  • AUCMODE
  • PRICELIMIT
  • QUANTLIMIT
  • DURLENGTH
AUCTIONLOG
  • AUCPAYINFO_ID
  • INVRSRVID
  • AUCMODE
  • PRICELIMIT
  • QUANTLIMIT
  • DURLENGTH
AUCTVIEW
  • INVRSRVID
  • AUCPAYINFO_ID
  • AUCMODE
  • PRICELIMIT
  • QUANTLIMIT
  • DURLENGTH
AUTOBID
  • AUCPAYINFO_ID
AUTOBIDLOG
  • AUCPAYINFO_ID
BID
  • AUCPAYINFO_ID
  • INITPRICE
  • LIMITPRICE
  • BIDMODE
BIDLOG
  • AUCPAYINFO_ID
  • INITPRICE
  • LIMITPRICE
  • BIDMODE
BIDPAYMENT
  • AUCPAYINFO_ID
BUSPROF
  • REQUISITIONERID
CALCODE
  • DESCRIPTION
  • DISPLAYLEVEL
  • STARTDATE
  • ENDDATE
  • FLAGS
  • PRECEDENCE
CALRANGE
  • MARKFORDELETE
CAMPAIGN
  • TYPE
  • STATUS
CATALOG
  • TPCLEVEL
CATENTDESC
  • KEYWORD
CATENTRY
  • ITEMSPC_ID
  • BASEITEM_ID
  • STATE
  • STARTDATE
  • ENDDATE
  • RANK
CATGPENREL
  • LASTUPDATE
CATGROUP
  • RANK
CATGRPATTR
  • SEQUENCE
CATGRPDESC
  • KEYWORD
  • NOTE
CATGRPREL
  • LASTUPDATE
  • CATALOG_ID_LINK
CATTOGRP
  • LASTUPDATE
  • SEQUENCE
  • CATALOG_ID_LINK
CLEANCONF
  • OBJECTNAME
  • STATEMENT
  • SEQUENCE
  • STATEMENTTYPE
CONTRACT
  • MAJORVERSION
  • MINORVERSION
  • ORIGIN
  • USAGE
  • MARKFORDELETE
  • COMMENTS
  • TIMECREATED
  • TIMEUPDATED
  • TIMEAPPROVED
  • TIMEACTIVATED
  • TIMEDEPLOYED
  • FAMILY_ID
CURFMTDESC
  • NUMBRUSG_ID
CURFORMAT
  • NUMBRUSG_ID
  • MINAPPROVEAMOUNT
DISPCGPREL
  • LANGUAGE_ID
DISPENTREL
  • LANGUAGE_ID
FFMCENTER
  • DEFAULTSHIPOFFSET
  • MARKFORDELETE
  • EXTFFMSTORENUM
  • INVENTORYOPFLAGS
INITIATIVE
  • CAMPAIGN_ID
  • TYPE
  • STATUS
  • RULE
  • RESULTTYPE
  • SELLTYPE
JURST
  • MARKFORDELETE
JURSTGROUP
  • MARKFORDELETE
LANGUAGE
  • MIMECHARSET
MASSOCCECE
  • DATE1
  • STORE_ID
MASSOCGPGP
  • DATE1
  • STORE_ID
MBRGRP
  • LASTUPDATE
  • LASTUPDATEDBY
MBRGRPMBR
  • EXCLUDE
MBRGRPTYPE
  • PROPERTIES
MEMBER
  • STATE
MSGSTORE
  • EXPIRY
  • TRANSPORT_ID
  • STOREENT_ID
ORDADJUST
  • DISPLAYLEVEL
ORDERITEMS
  • TERMCOND_ID
  • TRADING_ID
  • ITEMSPC_ID
  • ALLOCADDRESS_ID
  • LINEITEMTYPE
  • OUTPUTQ_ID
  • INVENTORYSTATUS
  • FULFILLMENTSTATUS
  • LASTALLOCUPDATE
  • TIMERELEASED
  • TIMESHIPPED
  • ESTAVAILTIME
  • ALLOCATIONGROUP
  • CORRELATIONGROUP
  • PROMISEDAVAILTIME
  • SHIPPINGOFFSET
  • NEEDEDQUANTITY
  • ALLOCQUANTITY
  • ALLOCFFMC_ID
  • ORDRELEASENUM
  • CONFIGURATIONID
  • SUPPLIERDATA
  • SUPPLIERPARTNUMBER
  • AVAILQUANTITY
ORDERS
  • ORGENTITY_ID
  • PROVIDERORDERNUM
  • SHIPASCOMPLETE
  • ORDCHNLTYP_ID
  • COMMENTS
  • NOTIFICATIONID
ORDICALCD
  • ORDICALCD_ID
  • CALFLAGS
  • CALPARMTYPE
  • CALPARMAMT
ORDISTAT
  • SUPPLIERDATA
  • ORDSTAT_ID
ORDITAX
  • TAXCGRY_DSC
ORDPAYMTHD
  • REFUNDNUMBER
  • TRADING_ID
  • ACCOUNT_ID
  • RMA_ID
  • POLICY_ID
  • PAYSUMMARY_ID
  • BUYERPO_ID
  • CREDITLINE_ID
  • ACTUALAMOUNT
  • CHARGEAMOUNT
  • CHARGETIME
  • CHARGEAMTCURR
  • XMLDATA
  • STRINGFIELD1
  • STRINGFIELD2
  • STRINGFIELD3
  • STRINGFIELD4
  • STATUS
  • BIGINTFIELD1
  • BIGINTFIELD2
  • BIGINTFIELD3
  • DECIMALFIELD1
  • DECIMALFIELD2
  • DECIMALFIELD3
ORDSTAT
  • OSCODE
ORDTAX
  • LASTUPDATE
ORGENTITY
  • STATUS
PROFILE
  • ARCHIVEMSG
PVCBINDING
  • PVCBINDING_ID
PVCBUFFER
  • PARAMETERS2K
PVCDEVMDL
  • DEVMDLNAME
QTYFMTDESC
  • NUMBRUSG_ID
QTYFORMAT
  • NUMBRUSG_ID
SCHCONFIG
  • STOREENT_ID
  • INTERFACENAME
SHIPMODE
  • MARKFORDELETE
SHPARRANGE
  • FLAGS
STADDRESS
  • URL
STENCALUSG
  • CALMETHOD_ID_APP
  • CALMETHOD_ID_SUM
  • CALMETHOD_ID_FIN
  • USAGEFLAGS
  • CALMETHOD_ID_INI
  • SEQUENCE
STORE
  • ALLOCATIONGOODFOR
  • MAXBOOFFSET
  • REJECTEDORDEXPIRY
  • FFMCSELECTIONFLAGS
  • BOPMPADFACTOR
  • RTNFFMCTR_ID
  • DEFAULTBOOFFSET
  • PRICEREFFLAGS
  • STORETYPE
  • RMAGOODFOR
  • AVSACCEPTCODES
  • CRTDBYCNTR_ID
  • LASTUPDATESTATUS
STORECAT
  • MASTERCATALOG
  • LASTUPDATE
STOREENT
  • SETCCURR
  • MARKFORDELETE
TAXCGRY
  • MARKFORDELETE
TAXJCRULE
  • TAXJCRULE_ID
TRADEPOSCN
  • PRODUCTSET_ID
  • PRECEDENCE
  • MARKFORDELETE
  • TYPE
USERPVCDEV
  • PVCSESSION_ID
USERREG
  • PLCYACCT_ID
  • TIMEOUT
  • PASSWORDRETRIES
  • SALT
  • PASSWORDCREATION
  • PASSWORDINVALID
USRTRAFFIC
  • SESSIONID
  • STORE_ID
  • CATGROUP_ID
  • CATENTRY_ID

Tables removed since version 5.1

CACHLOG
The CACHLOG table records when product or category information is changed in the database. Several tables populate the CACHLOG table using DB2 triggers.
CMPGNINTV
This is a relationship table between the IDs of campaign and initiative.
CMPGNRV
This is a relationship table between the IDs of campaign and rulevalue.
INTVMPE
This is a relationship table between initiative and marketing page element (e-marketing spot).
INTVSGMT
This is a relationship table between initiative and segment.
MAFAMILY
This table contains the data describing a Marketing Asset Family.A Marketing Asset Type belongs to one of the Marketing Asset Family.
MATYPE
This table contains the data describing a Marketing Asset Type.A Marketing Asset Type belongs to a Marketing Asset Family.
MPE
This table contains the data describing a marketing page element.A marketing page element is also called an e-marketing spot.
MPETYPE
The table contains the data describing a marketing page element type.A marketing page element is also called a e-marketing spot.
SEGMENT
This table contains the data describing a segment. A segment is also called a customer profile.
ZIPCODE
This table is reserved for IBM internal use only

Deprecated tables

ACCCMDGRP
This table defines all commands and views that require access control and categorize them into different groups. This table is deprecated and is provided for backward compatibility only.
ACCCMDTYPE
This table defines all the valid ACCCMDTYPE_ID that can be used in the ACCCMDGRP table. This table is deprecated and is provided for backward compatibility only.
ACCCUSTEXC
This table excludes a command or view from a customer group for a specific owner. This table is deprecated and is provided for backward compatibility only.
ACCMBRGRP
This table is used to assign an administrative user to various access groups for a particular store owner. This table is deprecated and is provided for backward compatibility only.
ACORGPOL
This table enables an organization to be exempted from one or more of the template policies. This table is deprecated and is provided for backward compatibility only.
BILLITEMS
This table is deprecated and is provided for backward compatibility only.
BROADCAST
This table is deprecated and is provided for backward compatibility only.
BZRPENT
This table contains the data for a Brokat Repository Entry. This table reflects the directory structure of the Brokat repository. This table is deprecated and is provided for backward compatibility only.
BZRPENTAT
This table contains the data for the attributes for a Brokat repository item. This table is deprecated and is provided for backward compatibility only.
BZRPENTSTG
This table contains the data for the Brokat repository entry storage. This is a paged storage for Brokat repository item. This table is deprecated and is provided for backward compatibility only.
BZSVCSTA
This table indicates the last-known status of a rule service. Each row represents status reported by an application clone for a rule service. This table is deprecated and is provided for backward compatibility only.
CATPRDREL
This table is deprecated and is provided for backward compatibility only.
CMBITEMS
This table is deprecated and is provided for backward compatibility only.
DAEMON
This table is deprecated and is provided for backward compatibility only.
DBDELIVERY
This table is deprecated and is provided for backward compatibility only.
DBDTFREQ
This table is deprecated and is provided for backward compatibility only.
DBMEAS
This table is deprecated and is provided for backward compatibility only.
DBMEASFM
This table is deprecated and is provided for backward compatibility only.
DBTEMPLATE
This table is deprecated and is provided for backward compatibility only.
DBVIEW
This table is deprecated and is provided for backward compatibility only.
HMBITEMS
This table is deprecated and is provided for backward compatibility only.
INIRULEVAL
This table contains the data for an initial rule value. This table is deprecated and is provided for backward compatibility only.
LMSERVER
This table holds the LikeMinds server information. This table is deprecated and is provided for backward compatibility only.
MGPTRDPSCN
A row in this table associates a TradingPositionContainer with a MemberGroup. Task commands can use this relationship to restrict use of the TradingPositionContainer to members of certain MemberGroups. (See also the STOREMBRGP table.) This table is deprecated and is provided for backward compatibility only. Use TermAndCondition objects and Participant objects to limit the use of TradingPositionContainers to certain customers. See the TRADING, TERMCOND, and PARTICIPNT tables for current information.
MOPICONFIG
This table is deprecated and is provided for backward compatibility only.
MSALESVW
This table is deprecated and is provided for backward compatibility only.
NSLOG
This table is deprecated and is provided for backward compatibility only.
OIBTB
This table is deprecated and is provided for backward compatibility only.
PAYMTHD
This table is a site-wide table that lists all the Cashier profiles used in the store group. Each profile has a unique integer ID and a name. This table is deprecated and is provided for backward compatibility only.
PAYMTHDDSC
This table is a site-wide table that contains a short description of the Cashier profiles in each of the supported language. This table is deprecated and is provided for backward compatibility only.
PAYMTHDSUP
This table lists all the profiles supported by the Store or StoreGroup. This table is deprecated and is provided for backward compatibility only.
PKGITEMREL
This table holds the relationship between Packages, and the Items they contain. This table is deprecated and is provided for backward compatibility only.
REPORT
This table is deprecated and is provided for backward compatibility only.
RULEVALUE
This table contains the data for a rule value. This table is deprecated and is provided for backward compatibility only.
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.
STERROR
This table is deprecated and is provided for backward compatibility only.
STFLNAME
This table is deprecated and is provided for backward compatibility only.
STMERCNF
This table is deprecated and is provided for backward compatibility only.

Tables containing deprecated columns

ACPOLICY
POLICYTYPE
ORGENTITY
MEMBER_ID
PVCBUFFER
PARAMETERS
PVCDEVMDL
MODELNAME
PVCDEVSPEC
SESSIONTYPE
STORECGRY
REMARK
TAXTYPE
SEQUENCE
TRADEPOSCN
FLAGS
USERPVCDEV
DEVICEIDENTIFIER
USERS
REGISTERTYPE

Tables containing changed columns

AUTOBID PAYTYPE
AUTOBIDLOG PAYTYPE
BID PAYTYPE
BIDLOG PAYTYPE
BIDPAYMENT PAYTYPE
BZRPENTSTG VALUE
CALCODE CODE
CALCODEDSC LONGDESCRIPTION
CALMETHOD DESCRIPTION
CATALOGDSC LONGDESCRIPTION
CATENTDESC AUXDESCRIPTION1
CATENTDESC AUXDESCRIPTION2
CATENTDESC LONGDESCRIPTION
CATENTDESC NAME
CATENTDESC XMLDETAIL
CATENTSHIP QUANTITYMEASURE
CATGRPDESC LONGDESCRIPTION
CLEANCONF DAYSARG
CLEANCONF NAMEARG
CLEANCONF TYPE
COLLDESC MARKETINGTEXT
CONTRACT MEMBER_ID
CONTRACT NAME
CONTRLRULE RULETEXT
CPGNLOG INITIATIVE_ID
FFMCENTDS DESCRIPTION
FORUM DESCRIPTION
FORUMMSG ACTREMARK
FORUMMSG MSGBODY
ICEXPLDESC NAME
ICEXPLFEAT COLUMNNAME
INVENTORY QUANTITYMEASURE
KEYS COLUMNNAME
KEYS TABLENAME
MBRGRP DESCRIPTION
MESSAGE CONTENT
MSGSTORE MESSAGE
MSGVIEW CONTENT
OFFER IDENTIFIER
ORDOPTIONS NOTIFYMERCHANT
ORDOPTIONS NOTIFYSHOPPER
ORGENTITY DESCRIPTION
PAYSTATUS PENDING
PAYSTATUS SETSWAKEUPMSG
PKGATTRVAL LANGUAGE_ID
PVCDEVMDL MODELNAME
PVCDEVSPEC SESSIONTYPE
RULECLSREG NAME
SCHCONFIG SCCAPPTYPE
SCHCONFIG SCCPATHINFO
SCHCONFIG SCCQUERY
SETSTATUS PENDING
SETSTATUS SETSWAKEUPMSG
SHIPMODE TRACKINGURL
SHPARRANGE SHIPMODE_ID
SHPJCRULE FFMCENTER_ID
SHPJCRULE JURSTGROUP_ID
SHPJCRULE SHIPMODE_ID
STAGLOG STGKEY5NAME
STAGLOG STGLDCOLS
STAGLOG STGLDPTH
STAGLOG STGNKEY5
STAGLOG STGOKEY5
STAGLOG STGTABLE
STORE STATUS
STORECGRY NAME
STOREENTDS DESCRIPTION
SUBKEYS TABLENAME
TAXJCRULE FFMCENTER_ID
TAXJCRULE JURSTGROUP_ID
TRADEPOSCN NAME
USERPROF DESCRIPTION
USRTRAFFIC PREVURL
USRTRAFFIC QUERYSTRING
USRTRAFFIC REFURL

Feedback