This topic describes the database schema changes between WebSphere Commerce 5.4 and WebSphere Commerce 5.6. The changes are grouped into the following sections:
- Tables added since version 5.4
- Tables removed since version 5.4
- Deprecated tables
- Tables containing deprecated columns
- Tables containing new columns
- Tables containing changed columns
Tables added since version 5.4
- 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.
- 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.
- ACPOLSUBGP
- Reserved for IBM internal use.
- 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.
- BUSAUDIT
- This table contains the WebSphere Commerce business auditing records captureed when the business auditing component is enabled.
- CACHEIVL
- This table records changes to product or category information in the database. It can be populated by user-defined database triggers.
- 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.
- 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.
- 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.
- CWMEMBER
- This table stores collaborative workspace member information.
- 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.
- FILEUPLOAD
- This table contains the information of uploaded files.
- MBRGRPDESC
- This table contains locale specific information for the entries in the MBRGRP table.
- 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.
- MUSRTRVW
- Reserved for IBM internal use.
- NOTIFY
- Reserved for IBM internal use.
- ORDITPROMOCD
- This contains promotion codes that were captured with an order for the orderitems in the order.
- 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.
- PAREQINFO
- 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.
- 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.
- 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
- REFKEYS
- The table represents a foreign relationship between tables that does not already exist in the database.
- REPDLVRY
- This table describes how StoreEntities want their automated commerce reports to be delivered.
- RFQCATEGRY
- This table holds categories created in each RFQ.
- 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.
- RFQTARGET
- This table holds the target stores for RFQs.
- ROLEDESC
- SEGMENTATION
- This table defines data mining segments (or models) used with WebSphere Commerce Analyzer.
- SEGMENTATION_REF
- Descriptions of the WCA Data Mining segments
- 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.
- STOREREL
- Each row of this table describes a relationship between stores.
- 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.
- WSALESVW
- Reserved for IBM internal use.
- WUSRTRVW
- Reserved for IBM internal use.
Tables containing new columns
- ATTACHMENT
- MARKFORDELETE
- DESCRIPTION
- FILENAME
- FILESIZE
- CREATEMETHOD
- IMAGE1
- IMAGE2
- CONTENT
- RESERVED
- ATTRIBUTE
- QTYUNIT_ID
- GROUPNAME
- NOTEINFO
- MULTITYPE
- ATTRVALUE
- QTYUNIT_ID
- ATTACHMENT_ID
- CATENTRY
- STARTDATE
- ENDDATE
- RANK
- CATGROUP
- RANK
- CATGRPDESC
- NOTE
- CATGRPPS
- USAGE
- CATGRPREL
- CATALOG_ID_LINK
- CATGRPTPC
- STORE_ID
- CATTOGRP
- CATALOG_ID_LINK
- CLEANCONF
- STATEMENTTYPE
- CONTRACT
- FAMILY_ID
- CPPMN
- NUMACPALLOWED
- FFMCENTER
- EXTFFMSTORENUM
- INVENTORYOPFLAGS
- INTVSCHED
- STOREENT_ID
- ITEMFFMCTR
- RESTOCKTIME
- MASSOCCECE
- DATE1
- STORE_ID
- MASSOCGPGP
- DATE1
- STORE_ID
- MSGSTORE
- EXPIRY
- TRANSPORT_ID
- STOREENT_ID
- OICOMPLIST
- SUPPLIERDATA
- SUPPLIERPARTNUMBER
- RFQPROD_ID
- ORDERITEMS
- SUPPLIERDATA
- SUPPLIERPARTNUMBER
- AVAILQUANTITY
- ORDERS
- COMMENTS
- NOTIFICATIONID
- ORDISTAT
- SUPPLIERDATA
- ORDSTAT_ID
- ORDITAX
- TAXCGRY_DSC
- ORDRELEASE
- EXTORDNUM
- EXTREF
- ORDSTAT
- OSCODE
- ORGENTITY
- STATUS
- PATTRVALUE
- ORDERITEMS_ID
- MANDATORY
- ATTACHMENT_ID
- CHANGEABLE
- RFQPROD_ID
- RFQRSPPROD_ID
- CORRELATIONGROUP
- PROFILE
- ARCHIVEMSG
- RFQ
- RULETYPE
- TRACKNUMBER
- VERSIONFLAGS
- EXTRFQNUM
- FIELD1
- FIELD2
- FIELD3
- FIELD4
- FIELD5
- FIELD6
- RFQPROD
- RFQPROD_ID
- RFQPRODNAME
- RFQCATEGRY_ID
- CHANGEABLE
- PRICEADJUSTMENT
- NEGOTIATIONTYPE
- FIELD1
- FIELD2
- FIELD3
- FIELD4
- RFQRSP
- VERSIONFLAGS
- STORE_ID
- PREVRSP
- ACCEPTACTION
- EXTRFQRESPONSENUM
- FIELD1
- FIELD2
- FIELD3
- FIELD4
- FIELD5
- FIELD6
- RFQRSPPROD
- RFQRSPPROD_ID
- RFQPROD_ID
- SKUGENFLAG
- PRICEADJUSTMENT
- FIELD1
- FIELD2
- FIELD3
- FIELD4
- SCHACTIVE
- SCSPRIORITY
- STADDRESS
- URL
- STORE
- CRTDBYCNTR_ID
- LASTUPDATESTATUS
- STOREENT
- MARKFORDELETE
- TMPBOLIST
- BASEITEM_ID
- MARKFORDELETE
- FORCEBACKORDER
- TMPCMPLIST
- BASEITEM_ID
- MARKFORDELETE
- TRADING
- REFTRADING_ID
- TRDREFAMT
- TRDREFAMT_ID
- USRTRAFFIC
- STORE_ID
- CATGROUP_ID
- CATENTRY_ID
Tables removed since version 5.4
- CACHLOG
- This table records changes to product or category information in the database. CACHLOG is populated by the cachlog triggers. Refer to Cache invalidation triggers from the online help.
- CATALGDESC
- Reserved for IBM internal use.
- CATEGRYREL
- Reserved for IBM internal use.
- ENUMDESC
- This table contains language specific descriptions of enumerations used in the Catalog Manager Web Editor.
- PRICE
- Reserved for IBM internal use.
- PRICEDESC
- Reserved for IBM internal use.
- PRODDSTATR
- Reserved for IBM internal use.
- WCCATDESC
- Reserved for IBM internal use.
- WCCATEGORY
- Reserved for IBM internal use.
- WCCATRTCAT
- Reserved for IBM internal use.
- WCCATSTORS
- Reserved for IBM internal use.
- WCMLANG
- This table contains the current installed Language for the Catalog Manager Web Editor.
- WCPRDCTPID
- Reserved for IBM internal use.
- WCPRDPRICE
- Reserved for IBM internal use.
- WCPRODCATP
- Reserved for IBM internal use.
- WCPRODDESC
- Reserved for IBM internal use.
- WCPRODSHIP
- Reserved for IBM internal use.
- WCPRODUCT
- Reserved for IBM internal use.
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
- ACACGPDESC DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ACACTDESC DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ACATTRDESC DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ACCOUNT COMMENTS
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- ACPOLDESC DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ACRELDESC DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ACRELGRP CONDITIONS
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (2500) NULL
- ACRESGPDES DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- ACRESGRP CONDITIONS
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (2500) NULL
- ACRSCGDES DISPLAYNAME
- Version 5.4: VARCHAR (128) NOT NULL
- Version 5.6: VARCHAR (254) NOT NULL
- BASEITMDSC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- BZRPENTSTG VALUE
- Version 5.4: LONG VARCHAR NOT NULL
- Version 5.6: VARCHAR (4000) NOT NULL
- CALCODEDSC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CALMETHOD DESCRIPTION
- Version 5.4: VARCHAR (254) NULL
- Version 5.6: VARCHAR (508) NULL
- CATALOGDSC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CATCONFINF REFERENCE
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CATCONFINF URL
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (254) NULL
- CATENTDESC AUXDESCRIPTION1
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CATENTDESC AUXDESCRIPTION2
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CATENTDESC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- CATENTDESC NAME
- Version 5.4: CHARACTER (64) NULL
- Version 5.6: CHARACTER (128) NULL
- CATENTDESC XMLDETAIL
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- CATGRPDESC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CLEANCONF STATEMENT
- Version 5.4: LONG VARCHAR NOT NULL
- Version 5.6: VARCHAR (4000) NOT NULL
- COLLDESC MARKETINGTEXT
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CONTRACT COMMENTS
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- CONTRLRULE RULETEXT
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- EMSPOT DEFAULTRULE
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- FFMCENTDS DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- FLDOMNDESC DESCRIPTION
- Version 5.4: VARCHAR (64) NULL
- Version 5.6: VARCHAR (128) NULL
- FLOWDESC DESCRIPTION
- Version 5.4: VARCHAR (64) NULL
- Version 5.6: VARCHAR (128) NULL
- FLTRANSDSC EVENTDESC
- Version 5.4: VARCHAR (64) NULL
- Version 5.6: VARCHAR (128) NULL
- FLTYPEDESC DESCRIPTION
- Version 5.4: VARCHAR (64) NULL
- Version 5.6: VARCHAR (128) NULL
- FORUM DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- FORUMMSG ACTREMARK
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- FORUMMSG MSGBODY
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- INITIATIVE RULE
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- INVOICE INVOICEXML
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- MBRATTRVAL STRINGVALUE
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- MBRGRPCOND CONDITIONS
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- MESSAGE CONTENT
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- MSGSTORE MESSAGE
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: BLOB (1000000) NULL
- MSGVIEW CONTENT
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- ORDPAYMTHD XMLDATA
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- PARTICIPNT INFORMATION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- PARTROLEDS DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- PATTRVALUE TERMCOND_ID
- Version 5.4: BIGINT NOT NULL
- Version 5.6: BIGINT NULL
- PAYSTATUS SETSWAKEUPMSG
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- PAYSUMMARY PAYSUMMARYXML
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- POLICYDESC DESCRIPTION
- Version 5.4: VARCHAR (254) NOT NULL
- Version 5.6: VARCHAR (508) NOT NULL
- POLICYDESC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- PRODUCTSET XMLDEFINITION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- REFUNDMTHD RETURNXML
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- RFQPROD CATENTRY_ID
- Version 5.4: BIGINT NOT NULL
- Version 5.6: BIGINT NULL
- RFQRSPPROD CATENTRY_ID
- Version 5.4: BIGINT NOT NULL
- Version 5.6: BIGINT NULL
- RLDISCOUNT RULEXML
- Version 5.4: LONG VARCHAR NOT NULL
- Version 5.6: CLOB (1000000) NULL
- ROLE DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- RULECLSREG NAME
- Version 5.4: VARCHAR (64) NULL
- Version 5.6: VARCHAR (128) NULL
- SETSTATUS SETSWAKEUPMSG
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- SHIPMODE TRACKINGURL
- Version 5.4: VARCHAR (64) NULL
- Version 5.6: VARCHAR (254) NULL
- STAGLOG STGLDCOLS
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- STORE STATUS
- Version 5.4: INTEGER NULL
- Version 5.6: INTEGER NOT NULL, DEFAULT 1
- STORECGRY NAME
- Version 5.4: CHARACTER (50) NULL
- Version 5.6: CHARACTER (50) NOT NULL
- STOREENTDS DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- TCDESC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- TCSUBTYPDS DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- TFTRENGDSC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- TRDDESC LONGDESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- TRDPSCNXML XMLDEFINITION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- TRDTYPEDSC DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- USERPROF DESCRIPTION
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- USRTRAFFIC PREVURL
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (254) NULL
- USRTRAFFIC QUERYSTRING
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- USRTRAFFIC REFURL
- Version 5.4: LONG VARCHAR NULL
- Version 5.6: VARCHAR (254) NULL