Deprecated tables and columns

If a database table or column is marked as deprecated, then the table or column is outdated by newer constructs. Deprecated sections are supported for reasons of compatibility with an earlier version only. These tables or columns are obsolete or can become obsolete in future versions of WebSphere Commerce.

Tables and views that are deprecated

• ACCCMDGRP

• ACCCMDTYPE

• ACCCUSTEXC

• ACCMBRGRP

• ACPOLSUBGP

• APPLY_INIT

• APPLY_MEMBER

• APPLY_RESULT

• AUCPAYINFO

• AUCTBIDVW

• AUCTDESC

• AUCTION

• AUCTIONLOG

• AUCTSTRREL

• AUCTSTYLE

• AUCTVIEW

• AUTOBID

• AUTOBIDLOG

• BID

• BIDLOG

• BIDORDRREL

• BIDPAYMENT

• BIDPAYSUM

• BILLITEMS

• BROADCAST

• BUADDR

• BUCONT

• BUYORG

• BUYSUPSEC

• BZRPENT

• BZRPENTAT

• BZRPENTSTG

• BZSRVCFG

• BZSVCCFG

• BZSVCSTA

• CAMPAIGN

• CATENTATTR

• CATGRPATTR

• CATPRDREL

• CMBITEMS

• COLLABWS

• CONTRLRULE

• CPEMAILMAP

• CPGNLOG

• CPGNSTATS

• CPITMAP

• CPOFFER

• CPPMN

• CPPMNACC

• CPPMNCAT

• CPPMNDESC

• CPPMNDISC

• CPPMNORD

• CPPMNPROD

• CPPMNVAL

• CPWALLET

• CURMSGID

• CWMEMBER

• DAEMON

• DBDELIVERY

• DBDTFREQ

• DBMEAS

• DBMEASFM

• DBTEMPLATE

• DBVIEW

• EMLCAMPREL

• ESMAPOBJ

• ESMAPTYP

• EXPERIMENT

• EXPLOG

• EXPRESULT

• EXPSTATS

• EXPTYPE

• FORUM

• FORUMMSG

• HISTOATTR

• HISTOFREQ

• HISTONVP

• HMBITEMS

• ICCNCPTLNK

• ICCONSTRNT

• ICCONSTVAL

• ICDATAREG

• ICDEWIDREG

• ICEXPLDESC

• ICEXPLFEAT

• ICFEATPROP

• ICKNOWDESC

• ICKNOWLEDG

• ICMERDESC

• ICMERTREE

• ICMETAFEAT

• ICMETAPHOR

• ICMETAREG

• ICMETAPROP

• ICMREGDESC

• ICROOTCAT

• ICTPRICES

• INIRULEVAL

• INITIATIVE

• INTVSCHED

• LMEVENTMAP

• LMSERVER

• MBINFO

• MBRVIEWPRF

• MEMBRAUCT

• MERPROFILE

• MESSAGE

• MGPTRDPSCN

• MLTIME

• MOPICONFIG

• MSALESVW

• MSGCOUNTVW

• MSGMEMREL

• MSGVIEW

• NSLOG

• OIBTB

• ORCPMAP

• ORDPAYMTHD

• PAREQINFO

• PASTATS

• PAYMTHD

• PAYMTHDDSC

• PAYMTHDSUP

• PCSTATS

• PESTATS

• PKGITEMREL

• PX_CDPROMO

• PX_PROMPROM

• QUEUE

• QUEUECSR

• QUEUEDESC

• REFUNDMTHD

• REPORT

• RLDISCOUNT

• RULECLSREG

• RULEVALUE

• SASTATS

• SEGMENTATION

• SEGMENTATION_REF

• SHBTB

• SHDCACRM

• STBRCODES

• STBRWSER

• STCGRYDESC

• STCONF

• STDCNTRY

• STDOMAIN

• STDPRICEVW

• STERROR

• STGUINDTAB

• STFLNAME

• STMERCNF

• STOREINV

• TCPITMAP

• TORCPMAP

• WCSDICTNRY

• WCSDTNRYDS

Columns that are deprecated

• DMACTIVITY.FLOWXML

• EDPPAYINST.DEPRECATED

• EDPREFINST.DEPRECATED

• MBRGRP.DESCRIPTION

• TRADEPOSCN.FLAGS

• PVCBUFFER.PARAMETERS

• PVCDEVMDL.MODELNAME

• PVCDEVSPEC.SESSIONTYPE

• STORECGRY.REMARK

• TAXTYPE.SEQUENCE

• USERPVCDEV.DEVICEIDENTIFIER

Tables that are reserved for IBM usage

Note: The following list does not include tables that are deprecated.

• ALCHARGE

• BUACCTDET

• CMFILEDIR

• DKPDCREL

• ECEOUT

• ECETMPT

• ECTPTITM

• FLCOMPOSE

• FLDOMNDESC

• FLINSTANCE

• FLOW

• FLOWADMIN

• FLOWDESC

• FLOWDOMAIN

• FLOWTYPE

• FLSTATEDCT

• FLSTATEGP

• FLSTATEREL

• FLSTDCTDSC

• FLSTGPDSC

• FLTRANSDSC

• FLTRANSITN

• FLTYPEDESC

• NOTIFY

• ONLOG

• ONQUEUE

• ONSLOG

• ORDBTB

• ORDCHNLTYP

• ORDERMSG

• ORDIPROF

• OUTPUTQ

• OUTPUTQDSC

• PATTRDESC

• PAYSTATUS

• PAYSYNCH

• PRATRSTATR

• PRCEOFFPRD

• PRCOFFRPRC

• PRDATRAVAL

• PRODATR

• PX_TEMPLATE

• SETSTATUS

• SITE

• TFALGOPOL

• TFALGOREG

• TFALGOTYPE

• TFALGPOLDS

• TFALGTYPDS

• TFALREGDSC

• TFDOMAIN

• TFDOMDSC

• TFEXTENG

• TFSBDOMAIN

• TFSBDOMDSC

• TFTRADENG

• TFTRENGDSC

• TMPBOLIST

• TMPCMPLIST

• TMPFFCLIST

• TMPPROCID

• TMPRADTL

• TMPRCTLIST

• UTMERINFO

• UTREGIP

• WTAXINFO

• WCSGBLDATA

Related concepts
WebSphere Commerce database schema