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
- Tables removed since version 5.1
- Deprecated tables
- Tables containing deprecated columns
- Tables containing new columns
- Tables containing changed columns
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
- Version 5.1: CHARACTER (4) NOT NULL
- Version 5.6: CHARACTER (64) NOT NULL
- AUTOBIDLOG PAYTYPE
- Version 5.1: CHARACTER (4) NULL
- Version 5.6: CHARACTER (64) NULL
- BID PAYTYPE
- Version 5.1: CHARACTER (4) NOT NULL
- Version 5.6: CHARACTER (64) NOT NULL
- BIDLOG PAYTYPE
- Version 5.1: CHARACTER (4) NULL
- Version 5.6: CHARACTER (64) NULL
- BIDPAYMENT PAYTYPE
- Version 5.1: CHARACTER (4) NULL
- Version 5.6: CHARACTER (64) NULL
- BZRPENTSTG VALUE
- Version 5.1: LONG VARCHAR (32700) NOT NULL
- Version 5.6: VARCHAR (4000) NOT NULL
- CALCODE CODE
- Version 5.1: CHARACTER (30) NULL
- Version 5.6: CHARACTER (128) NOT NULL
- CALCODEDSC LONGDESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CALMETHOD DESCRIPTION
- Version 5.1: VARCHAR (254) NULL
- Version 5.6: VARCHAR (508) NULL
- CATALOGDSC LONGDESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CATENTDESC AUXDESCRIPTION1
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CATENTDESC AUXDESCRIPTION2
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CATENTDESC LONGDESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: CLOB (1000000) NULL
- CATENTDESC NAME
- Version 5.1: CHARACTER (64) NULL
- Version 5.6: CHARACTER (128) NULL
- CATENTDESC XMLDETAIL
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: CLOB (1000000) NULL
- CATENTSHIP QUANTITYMEASURE
- Version 5.1: CHARACTER (16) NOT NULL
- Version 5.6: CHARACTER (16) NOT NULL, DEFAULT 'C62'
- CATGRPDESC LONGDESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CLEANCONF DAYSARG
- Version 5.1: CHARACTER (10) NULL
- Version 5.6: CHARACTER (10) NOT NULL
- CLEANCONF NAMEARG
- Version 5.1: CHARACTER (10) NULL
- Version 5.6: CHARACTER (10) NOT NULL
- CLEANCONF TYPE
- Version 5.1: CHARACTER (40) NULL
- Version 5.6: CHARACTER (40) NOT NULL
- COLLDESC MARKETINGTEXT
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CONTRACT MEMBER_ID
- Version 5.1: BIGINT NULL
- Version 5.6: BIGINT NOT NULL
- CONTRACT NAME
- Version 5.1: VARCHAR (254) NULL
- Version 5.6: VARCHAR (200) NOT NULL
- CONTRLRULE RULETEXT
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- CPGNLOG INITIATIVE_ID
- Version 5.1: INTEGER NULL
- Version 5.6: INTEGER NOT NULL
- FFMCENTDS DESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- FORUM DESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- FORUMMSG ACTREMARK
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- FORUMMSG MSGBODY
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- ICEXPLDESC NAME
- Version 5.1: VARCHAR (64) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ICEXPLFEAT COLUMNNAME
- Version 5.1: CHARACTER (18) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- INVENTORY QUANTITYMEASURE
- Version 5.1: CHARACTER (16) NOT NULL
- Version 5.6: CHARACTER (16) NOT NULL, DEFAULT 'C62'
- KEYS COLUMNNAME
- Version 5.1: CHARACTER (18) NOT NULL
- Version 5.6: VARCHAR (18) NOT NULL
- KEYS TABLENAME
- Version 5.1: CHARACTER (18) NOT NULL
- Version 5.6: VARCHAR (18) NOT NULL
- MBRGRP DESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (512) NULL
- MESSAGE CONTENT
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: CLOB (1000000) NULL
- MSGSTORE MESSAGE
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: BLOB (1000000) NULL
- MSGVIEW CONTENT
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: CLOB (1000000) NULL
- OFFER IDENTIFIER
- Version 5.1: BIGINT NOT NULL, DEFAULT 1
- Version 5.6: BIGINT NULL
- ORDOPTIONS NOTIFYMERCHANT
- Version 5.1: SMALLINT NULL
- Version 5.6: INTEGER NULL
- ORDOPTIONS NOTIFYSHOPPER
- Version 5.1: SMALLINT NULL
- Version 5.6: INTEGER NULL
- ORGENTITY DESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (512) NULL
- PAYSTATUS PENDING
- Version 5.1: SMALLINT NULL
- Version 5.6: INTEGER NULL
- PAYSTATUS SETSWAKEUPMSG
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- PKGATTRVAL LANGUAGE_ID
- Version 5.1: INTEGER NULL
- Version 5.6: INTEGER NOT NULL
- PVCDEVMDL MODELNAME
- Version 5.1: VARCHAR (40) NOT NULL
- Version 5.6: VARCHAR (40) NULL
- PVCDEVSPEC SESSIONTYPE
- Version 5.1: VARCHAR (32) NOT NULL
- Version 5.6: VARCHAR (32) NULL
- RULECLSREG NAME
- Version 5.1: VARCHAR (64) NULL
- Version 5.6: VARCHAR (128) NULL
- SCHCONFIG SCCAPPTYPE
- Version 5.1: VARCHAR (20) NULL
- Version 5.6: CHARACTER (20) NULL
- SCHCONFIG SCCPATHINFO
- Version 5.1: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- SCHCONFIG SCCQUERY
- Version 5.1: VARCHAR (1000) NULL
- Version 5.6: VARCHAR (3000) NULL
- SETSTATUS PENDING
- Version 5.1: SMALLINT NULL
- Version 5.6: INTEGER NULL
- SETSTATUS SETSWAKEUPMSG
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- SHIPMODE TRACKINGURL
- Version 5.1: VARCHAR (64) NULL
- Version 5.6: VARCHAR (254) NULL
- SHPARRANGE SHIPMODE_ID
- Version 5.1: INTEGER NOT NULL
- Version 5.6: INTEGER NULL
- SHPJCRULE FFMCENTER_ID
- Version 5.1: INTEGER NOT NULL
- Version 5.6: INTEGER NULL
- SHPJCRULE JURSTGROUP_ID
- Version 5.1: INTEGER NOT NULL
- Version 5.6: INTEGER NULL
- SHPJCRULE SHIPMODE_ID
- Version 5.1: INTEGER NOT NULL
- Version 5.6: INTEGER NULL
- STAGLOG STGKEY5NAME
- Version 5.1: CHARACTER (32) NULL, DEFAULT NULL
- Version 5.6: CHARACTER (32) NULL
- STAGLOG STGLDCOLS
- Version 5.1: LONG VARCHAR (32700) NULL, DEFAULT NULL
- Version 5.6: VARCHAR (4000) NULL
- STAGLOG STGLDPTH
- Version 5.1: VARCHAR (254) NULL, DEFAULT NULL
- Version 5.6: VARCHAR (254) NULL
- STAGLOG STGNKEY5
- Version 5.1: VARCHAR (254) NULL, DEFAULT NULL
- Version 5.6: VARCHAR (254) NULL
- STAGLOG STGOKEY5
- Version 5.1: VARCHAR (254) NULL, DEFAULT NULL
- Version 5.6: VARCHAR (254) NULL
- STAGLOG STGTABLE
- Version 5.1: CHARACTER (18) NOT NULL
- Version 5.6: CHARACTER (10) NOT NULL
- STORE STATUS
- Version 5.1: INTEGER NULL
- Version 5.6: INTEGER NOT NULL, DEFAULT 1
- STORECGRY NAME
- Version 5.1: CHARACTER (50) NULL
- Version 5.6: CHARACTER (50) NOT NULL
- STOREENTDS DESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- SUBKEYS TABLENAME
- Version 5.1: CHARACTER (18) NOT NULL
- Version 5.6: CHARACTER (10) NOT NULL
- TAXJCRULE FFMCENTER_ID
- Version 5.1: INTEGER NOT NULL
- Version 5.6: INTEGER NULL
- TAXJCRULE JURSTGROUP_ID
- Version 5.1: INTEGER NOT NULL
- Version 5.6: INTEGER NULL
- TRADEPOSCN NAME
- Version 5.1: VARCHAR (254) NULL
- Version 5.6: VARCHAR (254) NOT NULL
- USERPROF DESCRIPTION
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- USRTRAFFIC PREVURL
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (254) NULL
- USRTRAFFIC QUERYSTRING
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (4000) NULL
- USRTRAFFIC REFURL
- Version 5.1: LONG VARCHAR (32700) NULL
- Version 5.6: VARCHAR (254) NULL