Reference > Database > WebSphere Commerce database tables > Database schema changes
Database schema changes from version 5.6.1 to version 7.0
This topic describes the database schema changes between WebSphere Commerce 5.6.1 and WebSphere Commerce 7.0. The changes are grouped into the following sections:
- Tables added since version 5.6.1
- Tables removed since version 5.6.1
- Deprecated tables
- Tables containing deprecated columns
- Tables containing new columns
- Tables containing changed columns
Tables added since version 5.6.1
- ATCHAST
- This table holds the metadata for the attachment asset in the attachment target.
- ATCHASTLG
- This table holds the attachment asset to language relationship.
- ATCHOBJTYP
- This table holds the information about the types of business objects that are configured to have attachments. For example, attachments can be associated to CATALOG, CATGROUP, and CATENTRY business objects.
- ATCHREL
- This table holds the attachment relation between a business object and an attachment target.
- ATCHRELDSC
- This is a description table for an attachment relation.
- ATCHRLUS
- This table holds usage information for attachment relations. For example, an attachment can be a warranty document related to a product. In this case the usage is 'warranty'.
- ATCHRLUSDS
- This table holds the description of an attachment relation usage.
- ATCHTGT
- This table holds information about the target, which is used to hold a collection of assets, for use as an attachment target.
- ATCHTGTDSC
- This table holds the description of an attachment target.
- ATTR
- This table holds an attribute that can be a shaable global attribute or a local attribute defined for a catalog entry.
- ATTRDESC
- This table holds the language sensitive attribute description.
- ATTRDICT
- Table used to store the attribute dictionaries configured for the site. Each attribute dictionary is owned by a store, but can be used by children stores through store path relationships. There can be only one attribute dictionary owned by any given store.
- ATTRDICTGRP
- Table used to store attribute dictionary attribute groups. These groups are a convenience mechanism used during administration of the attribute dictionary and when assigning attribute dictionary attributes to catalog entries or catalog groups. Attributes can belong to zero or more attribute groups.
- ATTRDICTGRPATTRREL
- No External description assigned yet
- ATTRDICTGRPDESC
- The table holds the attribute dictionary group description
- ATTRDICTGRPREL
- Defines the relationships between attribute dictionary attribute groups. An attribute dictionary attribute group can have only one parent group.
- ATTRVAL
- This table holds an attribute value that can be a shaable global attribute value or a local attribute value defined for a catalog entry.
- ATTRVALDESC
- This table holds the language sensitive attribute value description.
- BLKRSNCODE
- Stores the various reason codes for which an Order may be blocked.
- BLKRSNDESC
- Holds Reason code description in different locales
- BUSCHN
- This table contains business channel information.
- BUSCHNDESC
- This table contains business channel descriptions for different locales.
- CALADJUST
- A row in this table represents a calculation adjustment. A calculation adjustment is an adjustment created by a service representative to be applied to the calculation usage specified. Currently only shipping adjustments are supported.
- CATENTRYATTR
- This table holds the catalog entry attribute relation
- CCOMMENT
- This table contains information about a comment created by a user, user's organization, or comment Can be the user, the user's organization, or a customer service representative.
- CMFILE
- Contains the list of all the files that are content managed along with additional meta data.
- CMFILEDIR
- This table contains the directory structures for the content managed files. Reserved for IBM internal use.
- CMFTASK
- Holds the task information for workspaces
- CMFTASKDSC
- Holds the task description information for tasks in workspaces.
- CMFTASKGRP
- Holds the task group information for workspaces.
- CMFTGCMT
- Holds the task group comments for workspaces
- CMFTGDSC
- Holds the task group description information for workspaces.
- CMFTGTSKREL
- Holds the relationship between a task group and a task.
- CMFTSKMBREL
- Holds the task member-specific information.
- CMFWKSPC
- Holds workspace-specific information.
- CMFWKSPCDSC
- Holds workspace description-specific information.
- CMFWSTGREL
- Holds the relationship between a workspace and a task group.
- CMLARGEFILE
- Contains the physical bytes that makes up a particular managed file. This table contain only the contents of those files that are greater then 32K and have a storage type of 1 in the CMFILE table.
- CMMETADATA
- Records the business objects that have changed and the associated workspaces, task groups, and tasks that have made that change. This table will be used for resource locking and for determining the business objects that will be committed and published to production.
- CMSMALLFILE
- Contains the physical bytes that makes up a particular managed file. This table contains only the contents of those files that are less then or equal to 32K and have a storage type of 0 in the CMFILE table.
- CMWORKSPACE
- Contains a list of valid workspaces that may be assigned to an available schema pool.
- CMWSSCHEMA
- The association of the underlying database schemas that makes up the workspace along with the assigning the workspace to a workspace identifier.
- CTXDATA
- This table contains the data that associates with a particular activity.
- CTXMGMT
- This table contains the management information of each context service activity.
- DKADJMNT
- Stores adjustments to components within a specific dynamic kit.
- DKOFFER
- Stores prices of components within a dynamic kit
- DKPDCCATENTREL
- Contains relationships between predefined configurations and the dynamic kit catalog entries for which they are built.
- DKPDCCOMPLIST
- Contains the components within a predefined configuration.
- DKPDCDESC
- Contains the descriptions of predefined configurations.
- DKPDCOFFERREL
- Contains relationships between predefined configurations and the offers that price them.
- DKPDCREL
- Reserved for IBM internal use.
- DKPREDEFCONF
- Contains predefined configurations of dynamic kit catalog entries.
- DMACTATTR
- Attributes of a marketing activity.
- DMACTIVITY
- A definition of the interaction with a customer to market content.
- DMACTTYPE
- Types of marketing activities. These include web, e-mail, and dialog.
- DMCAMPAIGN
- A group of activities to meet specific marketing objectives.
- DMELEMENT
- Campaign elements associated with a marketing activity.
- DMELEMENTNVP
- Name value pairs associated with a campaign element.
- DMELEMENTTYPE
- Types of trigger, target and action campaign elements for an activity.
- DMELESTATS
- Statistics of trigger, target and action campaign elements within an activity.
- DMELETEMPLATE
- Template definitions of trigger, target, and action campaign elements. A trigger is used to wait for a customer to do something, or to wait for a certain period of time to elapse. When a trigger occurs, the activity flow can continue from where the trigger was defined in the flow. A target is used to qualify customers for subsequent actions or continue execution of the activity flow. Targets are usually based on a customer's behavior and segmentation. An action is a step to perform as part of the activity flow. Actions are the "to do" based on the previous sequence of triggers and targets. Most actions are for marketing purposes, such as display content in an e-marketing spot, or send the customer an e-mail.
- DMEMSPOTCMD
- The ordering scheme set up for stores and individual e-MarketingSpots.
- DMEMSPOTDEF
- The default content to display in an e-Marketing Spot.
- DMEMSPOTORD
- A list of ordering schemes in which to order marketing content displayed in an e-MarketingSpot.
- DMEMSPOTPAGE
- This table is currently not used.
- DMEMSPOTSTATS
- Statistics for an e-MarketingSpot within a marketing activity.
- DMEXPFAMILY
- The set of related marketing activities.
- DMEXPLOG
- This table contains the details of what was displayed to a customer on a store page in an e-Marketing Spot as a result of an experiment.
- DMEXPSTATS
- This table stores the statistics related to marketing experiments.
- DMEXPTYPE
- The types of experiments associated with a marketing activity
- DMMBRGRPPZN
- This table contains customers that are explicitly included in a member group by the customer's personalization ID. This works in conjunction with the explicit inclusion and exclusion rules that are specified in the MBRGRPMBR table and the implicit inclusion rules that are specified in the MBRGRPCOND table. If both multiple criteria are specified, the following algorithm is used to evaluate if a member belongs to a member group: Explicit exclusion by member ID takes first precedence, then explicit inclusion by member ID, then inclusion by personalization ID, and then finally implicit inclusion.
- DMPAGE
- This table is currently not used.
- DMTEMPLATETYPE
- Types of marketing activity templates.
- DMTRIGLSTN
- List of triggers that are being listened for in marketing activities.
- DMTRIGSND
- Time based triggers to send when the specified time has elapsed.
- DMUSERBHVR
- A customer's behavior within a site, and within a marketing activity.
- EDPATMPAY
- This table stores the value object Payment Instruction in WebSphere Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the WebSphere Commerce Payments intends to consume collectively.
- EDPATMREF
- This table stores the value object Payment Instruction in WebSphere Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the WebSphere Commerce Payments intends to consume collectively.
- EDPORDER
- This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
- EDPPAYHIST
- This table keeps the payment activity history for all committed operations on payment instructions and financial transactions.
- EDPPAYINST
- This table stores the information of the value object container Payment Instruction in Payment Rules.
- EDPREFINST
- This table stores the information of the value object container Refund Instruction in Payment Rules.
- EDPRELEASE
- This table stores the information of the value object container Release in Payment Rules.
- EDPRELHIST
- This table keeps the history for all operations on releases in Payment Rules.
- EDPRMA
- This table stores the information of the value object container Refund in Payment Rules.
- EMLCONTENT
- Stores the content of the e-mail template.
- EMLMCREL
- Stores the relationship between EMLMSG and EMLCONTENT table.
- ESMAPOBJ
- This table contains objects scheduled to E-Marketing Spot.
- ESMAPTYP
- This table contains object types that can be scheduled to E-Marketing Spot.
- EXCHORDERS
- IBM Internal Use Only.
- GEONDDS
- Holds geo node description.
- GEONODE
- Represents a geographical node in the geo tree.
- GEOTREE
- Represents a tree of geographic locations. This is a relationship table of GEONODE, such as country -> state -> city
- GRADDR
- This table stores address information for a gift registry.
- GRANNHIST
- This table stores a history of e-mail announcements sent regarding a gift registry. A registrant can send one or more announcements about their gift registry, and a history is stores in the database.
- GRANNTMPLT
- This table stores announcement e-mail template information. The registrant can select a template when sending an announcement for a gift registry.
- GREMLLIST
- This table stores e-mail information used for gift registries, such as gift registry announcements
- GRETDESC
- This tables describes the event type for a gift registry.
- GREVNTTYPE
- This tables stores event information for a gift registry.
- GREVTRMDLG
- This table stores information about gift registry reminders.
- GRGFTITM
- This tables stores information about a gift registry item.
- GRGFTREG
- This table stores gift registry profile information.
- GRPERATTR
- This tables store personalization attributes for gift registry items, such as monogramming.
- GRPURREC
- This tables stores purchase record information, regarding items bought from a gift registry list.
- GRREGRULE
- This tables stores information about business rules for gift registries.
- GRRGSTRNT
- This table stores information about a gift registry registrant.
- GRUSERAUTH
- This table authenticates a user's access to view or edit a gift registry. A gift registrant or co-registrant can view and change gift registry information. A gift giver can view a gift registry list.
- INVAVL
- Each row represents an inventory availability record cached by the Commerce database.
- INVCNF
- Each row represents an DOM inventory cache configuration.
- INVCNFREL
- Each row represents the relationship of an item and/or location with an inventory configuration.
- MERCHANT
- This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
- MERCHCONF
- This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
- MERCHCONFINFO
- This table stores the NVPs for properties of merchant information for a specific merchant configuration.
- MGPCONDELE
- This table stores member group condition elements.
- MGPCONDELENVP
- This table stores member group condition element values.
- OICOMPREL
- Stores all kit level information for an Order item that is a kit. A kit may contain other kits and catalog entries outside of a kit. This table stores information about kit components and the OICOMPLIST table stores information about catalog entries outside of a kit.
- OPSYSTEM
- This table is ued for storing Order Processing system.
- ORDCHGRSN
- This table is used for storing the order change reason code for different actions.
- ORDCHGRSNDS
- the order change reason code description for different languages.
- ORDERBLK
- Stores blocked Orders with reason code
- ORDERHIST
- This table is used to save order snapshots in XML format.
- ORDERITEMGIFT
- This table stores the relationship between an order item and a gift registry.
- ORDITEMCONF
- This table is used to check order item shipment confirmation and capture the order serial numbers
- ORDRLSTTLS
- Store release level charges.
- ORDUSERS
- Contains information about users that worked with an order.
- PPCBATCH
- The batch object representing the batch transaction
- PPCCREDIT
- This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
- PPCEXTDATA
- This table stores the non-standard protocol data required in the financial transaction which goes beyond the standard attributes defined in the payment instruction. It can be associated with a payment instruction or a financial transaction. When associated with a payment instruction, it can be used by all the financal transactions executed against the same payment instruction. When associated with a financial transaction, this extra data can be used by this same transaction and subsequent transactions.
- PPCPAYINST
- This table stores the value object Payment Instruction in WebSphere Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the WebSphere Commerce Payments intends to consume collectively.
- PPCPAYMENT
- This table stores the information of the value object container Payment for payment-related transactions in WebSphere Commerce Payments.
- PPCPAYTRAN
- This table stores the information of a financial transaction processed by a payment plug-in.
- PRCORSN
- Price Override Reason - This table stores the reason the merchant needed to override a system calculated price.
- PRCORSNDSC
- Price Override Reason Description - This table stores the language-dependent description of the price override reason codes.
- PX_DESCRIPTION
- This table contains promotion description information.
- PX_ELEMENT
- This table contains promotion element information.
- PX_ELEMENTNVP
- This table contains promotion element values.
- PX_PROMOAUDIT
- This table contains obsolete promotion information for auditing purpose.
- PX_PROMOAUTH
- This table contains additional authoring information that is managed by the Promotions tool in the Management Center user interface.
- PX_PROMOCD
- This table contains promotion and promotion code relation information.
- PX_RWDOPTION
- No External description assigned yet
- REPCUSTREL
- This table defines the relationship between a customer service representative or team of representatives, and the customer or customer group that they are assigned to.
- RMAITEMSERIAL
- This table is used to track return serial numbers.
- ROLEASNPRM
- Role Assignment Permission table. This table specifies the roles that users with a particular assigning role are able to assign to other users.
- SHDCACRM
- This table holds the relationship between the Scheduler Job ID and Initiative schedule ID. This relationship identifies which Job relates to which initiative schedule in order to modify the entry in the INTVSCHED table when an initiative schedule is updated or deleted.
- 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 shipmode 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 shipmode combination.
- 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.
- 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.
- STOREMERCH
- This table stores the mapping information indicates which merchant id is used for a specific store.
- STQOTCFG
- This table is used to config the quote on a store entity.
- TAGCLASS
- Stores the relationship between a tag and the class name of the tag's implementation class.
- TAGDISPLAY
- Defines a display type. The JSP snippet is used to define the display format when the displayname is specified.
- TAGDPLYREL
- Stores the relationship between the TAGCLASS and TAGDISPLAY tables.
- TICKLER
- This table holds to-do items requiring actions to resolve.
- TKLACTHIST
- This table holds the description of actions that can be performed on to-do items.
- TKLRACTDSC
- This table holds the description of actions that can be performed on to-do items.
- TKLRACTION
- This table holds the actions that can be performed on to-do items.
- TKLRREASON
- This table holds reasons for creating to-do items.
- TKLRRSNDSC
- This table holds description of reasons for creating to-do items.
- USERPWDHST
- This table stores the previously used passwords of a registered user. Each row of the table represents a password that has previously been used by the user. When a user changes their password, the change password process checks that the new password does not match any values for that user.
- WMMMAP
- This table is used when WebSphere Commerce is configured to use LDAP. It defines the mapping between WebSphere Commerce users and organizations in the MEMBER table, and entities in WebSphere Application Server Federated Repository (LDAP).
Tables containing new columns
ACCOUNT PRCPLCYPREF
USEPRCPLCYPREF
ADDRESS MOBILEPHONE1
MOBILEPHONE1CNTRY
BUSAUDIT WORKSPACE
TASKGRP
TASK
ACTION
BUSEVENT EVENT_SEARCHKEY
CALUSAGE STRELTYPNAMECFG
STRELTYPNAMERT
CATENCALCD CALFLAGS
CATENTREL MANDATORY
CATENTRY AVAILABILITYDATE
LASTORDERDATE
ENDOFSERVICEDATE
DISCONTINUEDATE
CATGPCALCD CALFLAGS
COLLDESC LONGMKTGTEXT
COUNTRY CALLINGCODE
EMLMSG STATUS
EMLBODYTYPE
EMLUSRRECV RECEIVESMS
EMSPOT USAGETYPE
FFMCENTER MAXNUMPICK
PICKDELAYINMIN
DROPSHIP
RECEIPTQUANTITY
OICOMPLIST OICOMPREL_ID
ORCOMMENT ORDCHGRSN_ID
SERVICEREP_ID
BUSCHN_ID
ORDERVERSION
FIELD1
FIELD2
FIELD3
ORDERITEMS ISEXPEDITED
REQUESTEDSHIPDATE
TIECODE
ORDERS TYPE
EDITOR_ID
BUSCHN_ID
SOURCEID
EXPIREDATE
BLOCKED
OPSYSTEM_ID
TRANSFERSTATUS
BUYERPO_ID
ORDRELEASE FFMCENTER_ID
ISEXPEDITED
SHIPMODE_ID
ADDRESS_ID
MEMBER_ID
STOREENT_ID
SITE EDITION
VERSION
RELEASE
MOD
FIXPACK
COMPNAME
STAGLOG STGFILTER
STORE ALLOCATIONOFFSET
MAXFOOFFSET
INVENTORYOPFLAG
BLOCKINGACTIVE
BLKEXTASYNCH
ORDERHISTACTIVE
INVENTORYSYSTEM
TMPCMPLIST OICOMPLIST_ID
USERDEMO DATEOFBIRTH
USERPROF RCVSMSNOTIFICATION
USERS PERSONALIZATIONID
Tables removed since version 5.6.1
- URLREG
- This table defines all the controller commands and their corresponding URI.
- VIEWREG
- This table defines the views.
Deprecated tables
- 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.
- BZSRVCFG
- This table contains rule server configuration data. Each row represents a rule server. This table is deprecated and is provided for backward compatibility only.
- BZSVCCFG
- This table contains rule service configuration data. Each row represents a rule service configuration, including the rule server to which the service belongs. 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.
- CATENTATTR
- This table is deprecated and is provided for backward compatibility only. Attributes in this table should be migrated to the ATTRIBUTE and ATTRVALUE tables as descriptive attributes.
- CATGRPATTR
- This table holds descriptive attributes for catalog groups. These attributes are only used for descriptive purposes. 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.
- 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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPITMAP
- This table stores all of the items from the given (completed) order that were applicable to the selected coupon set. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPOFFER
- This table contains the promotions that are available to be shown to customers in their offer list. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPPMN
- This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- 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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- 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 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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPPMNDESC
- This table contains the language specific description of the promotion. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPPMNDISC
- This table contains the discount conditions for a promotion. Every coupon has exactly one calculation code. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPPMNORD
- This table contains the minimum purchase amount that must be in the shopping cart before this coupon is applicable. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- 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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPPMNVAL
- Reserved for IBM internal use. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- CPWALLET
- This table contains the coupons that the user has accepted. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- 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.
- ICCNCPTLNK
- This table is deprecated and is provided for backward compatibility only. This table contains the information required for a Guided Sell answer to link to a metaphor (Product Exploration, Product Comparison, and Guided Sell) or to a URL.
- ICCONSTRNT
- This table is deprecated and is provided for backward compatibility only. This table stores constraints as specified in the Guided Sell metaphor.
- ICCONSTVAL
- This table is deprecated and is provided for backward compatibility only. This table holds the language dependant information related to a constraint.
- ICDATAREG
- This table is deprecated and is provided for backward compatibility only. This table contains a reference list of data types.
- ICDEWIDREG
- This table is deprecated and is provided for backward compatibility only. This table contains a reference list of Product Advisor widgets.
- ICEXPLDESC
- This table is deprecated and is provided for backward compatibility only. This table stores the language-dependent values for the feature metadata.
- ICEXPLFEAT
- This table is deprecated and is provided for backward compatibility only. This table stores the metadata for features extracted from WebSphere Commerce tables. The data in this table is unique to a feature, but independent of stores and languages.
- ICFEATPROP
- This table is deprecated and is provided for backward compatibility only. This table describes the properties of the features, which the Product Exploration and Product Comparison metaphors use.
- ICKNOWDESC
- This table is deprecated and is provided for backward compatibility only. This table stores the language-dependent text representing the questions and answers created for the Guided Sell metaphor.
- ICKNOWLEDG
- This table is deprecated and is provided for backward compatibility only. This table stores the questions and answers generated by the Guided Sell metaphor.
- ICMERDESC
- This table is deprecated and is provided for backward compatibility only. This table stores the language dependent text for the Guided Sell Question and Answer tree description.
- ICMERTREE
- This table is deprecated and is provided for backward compatibility only. This table contains the store and its associated Guided Sell metaphors.
- ICMETAFEAT
- This table is deprecated and is provided for backward compatibility only. This table identifies the features used by the Product Exploration and Product Comparison metaphors and the sequence in which the features display.
- ICMETAPHOR
- This table is deprecated and is provided for backward compatibility only. This table lists and briefly describes all the metaphors.
- ICMETAPROP
- This table is deprecated and is provided for backward compatibility only. This table describes the properties of the metaphors. This table is only used by the Guided Sell metaphor.
- ICMETAREG
- This table is deprecated and is provided for backward compatibility only. This table contains a reference list of Product Advisor metaphors.
- ICMREGDESC
- This table is deprecated and is provided for backward compatibility only. This tables stores the language-dependent text for the Product Advisor metaphors.
- ICROOTCAT
- This table is deprecated and is provided for backward compatibility only. When a search space is created, an entry is made in this table.
- ICTPRICES
- This table is deprecated and is provided for backward compatibility only. This table contains prices for catalog entries extracted from the LISTPRICE table.
- 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.
- MBRVIEWPRF
- This table is deprecated and is provided for backward compatibility only. This table stores messaging view preferences for members.
- 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.
- ORDPAYMTHD
- This table is deprecated and is provided for backward compatibility only. The Order Payment Method table contains order payment or refund methods selected for an order. It is also used to keep track of the actual amount charged or refunded against the order.
- PAREQINFO
- Reserved for IBM internal use. 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.
- REFUNDMTHD
- This table is deprecated and is provided for backward compatibility only.
- REPORT
- This table is deprecated and is provided for backward compatibility only.
- RLDISCOUNT
- This table defines the additional attributes of a promotion object for Blaze Rule Engine use. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
- 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
- DMACTIVITY
- FLOWXML
- EDPPAYINST
- DEPRECATED
- EDPREFINST
- DEPRECATED
- MBRGRP
- DESCRIPTION
- PVCBUFFER
- PARAMETERS
- PVCDEVMDL
- MODELNAME
- PVCDEVSPEC
- SESSIONTYPE
- STORECGRY
- REMARK
- TAXTYPE
- SEQUENCE
- TRADEPOSCN
- FLAGS
- USERPVCDEV
- DEVICEIDENTIFIER
Tables containing changed columns
ACACGPDESC DISPLAYNAME
ACACGPDESC DESCRIPTION
- Version 5.6.1: VARCHAR(254)
- v7.0: VARCHAR(700)
ACACTDESC DISPLAYNAME
ACACTDESC DESCRIPTION
- Version 5.6.1: VARCHAR(254)
- v7.0: VARCHAR(700)
ACPLGPDESC DISPLAYNAME
ACPLGPDESC DESCRIPTION
- Version 5.6.1: VARCHAR(254)
- v7.0: VARCHAR(700)
ACPOLDESC DISPLAYNAME
ACPOLDESC DESCRIPTION
- Version 5.6.1: VARCHAR(254)
- v7.0: VARCHAR(700)
ACRESGPDES DISPLAYNAME
ACRESGPDES DESCRIPTION
- Version 5.6.1: VARCHAR(254)
- v7.0: VARCHAR(700)
ACRSCGDES DISPLAYNAME
ACRSCGDES DESCRIPTION
- Version 5.6.1: VARCHAR(254)
- v7.0: VARCHAR(700)
ADDRESS ADDRESS1
- Version 5.6.1: VARCHAR(50)
- v7.0: VARCHAR(100)
BASEITEM PARTNUMBER
CATENCALCD CALCODE_ID
- Version 5.6.1: INTEGER NOT NULL
- v7.0: INTEGER
CATGPCALCD CALCODE_ID
- Version 5.6.1: INTEGER NOT NULL
- v7.0: INTEGER
EMLMSG JSPPATH
- Version 5.6.1: VARCHAR(254) NOT NULL
- v7.0: VARCHAR(254)
FFMCENTDS DISPLAYNAME
- Version 5.6.1: VARCHAR(80)
- v7.0: VARCHAR(254)
ICMREGDESC TITLE
ORCOMMENT COMMENTS
- Version 5.6.1: VARCHAR(1024)
- v7.0: VARCHAR(3000)
ORDERS STATUS
- Version 5.6.1: CHAR(1)
- v7.0: VARCHAR(3)
ORDPAYINFO VALUE
REFKEYS TABLENAME
- Version 5.6.1: CHAR(10)
- v7.0: CHAR(18) NOT NULL
REFKEYS FKTABLE_NAME
- Version 5.6.1: CHAR(10)
- v7.0: CHAR(18) NOT NULL
REFKEYS FKCOLUMN_NAME
- Version 5.6.1: CHAR(18)
- v7.0: CHAR(18) NOT NULL
RTNDNYDESC DESCRIPTION
RULECLSREG NAME
- Version 5.6.1: VARCHAR(128)
- v7.0: VARCHAR(140)
STOREENTDS DISPLAYNAME
_vcc_freeselect_bottom_
- Version 5.6.1: CHAR(80)
- v7.0: VARCHAR(254)