Merchant data scope

The following table lists the database tables under the merchant data scope.

Table name Unique index on
Integer 1 Integer 2 Char 1 Integer 3 Char 2
ACCCMDGRP Yes
ACCCUSTEXC Yes Yes
ACCOUNT Yes
ACORGPOL Yes Yes
ACPOLDESC Yes Yes
ACPOLICY Yes
ATTACHMENT Yes
ATTRIBUTE Yes Yes
ATTRVALUE Yes Yes
BASEITEM Yes
BASEITEM Yes Yes
BUYERPO Yes
CALCODE Yes
CALCODEDSC Yes Yes
CALCODEMGP Yes Yes
CALCODTXEX Yes Yes
CALMETHOD Yes
CALRANGE Yes
CALRLOOKUP Yes
CALRULE Yes
CALRULEMGP Yes Yes
CALSCALE Yes
CALSCALEDS Yes Yes
CATALOG Yes
CATALOGDSC Yes Yes
CATCNTR Yes Yes
CATCONFINF Yes
CATENCALCD Yes
CATENTATTR Yes
CATENTDESC Yes Yes
CATENTREL Yes Yes Yes
CATENTRY Yes
CATENTSHIP Yes
CATGPCALCD Yes
CATGPENREL Yes Yes Yes
CATGROUP Yes
CATGRPATTR Yes Yes
CATGRPDESC Yes Yes
CATGRPPS Yes Yes Yes
CATGRPREL Yes Yes Yes
CATGRPTPC Yes Yes Yes
CATTOGRP Yes Yes
CHARGETYPE Yes
CHRGTYPDSC Yes Yes
CNTRDISPLY Yes
CNTRNAME Yes Yes
CONTRACT Yes
CREDITLINE Yes
CRULESCALE Yes Yes
CURCONVERT Yes
CURCVLIST Yes Yes Yes Yes
CURFMTDESC Yes Yes Yes
CURFORMAT Yes Yes
CURLIST Yes Yes
DISPCGPREL Yes
DISPENTREL Yes
DISTARRANG Yes
FLOWADMIN Yes
INVADJCODE Yes
INVADJDESC Yes Yes
ITEMSPC Yes
ITEMVERSN Yes
JURST Yes
JURSTGPREL Yes Yes
JURSTGROUP Yes
LANGPAIR Yes Yes Yes
LISTPRICE Yes Yes
MASSOCCECE Yes
MASSOCGPGP Yes
MBRATTRVAL Yes
MBRGRPUSG Yes Yes
MBRREL Yes Yes
MBRROLE Yes Yes Yes
MGPTRDPSCN Yes Yes
OFFER Yes
OFFERDESC Yes Yes
OFFERPRICE Yes Yes
PARTICIPNT Yes
PATTRDESC Yes Yes
PATTRIBUTE Yes
PATTRPROD Yes Yes
PKGATTR Yes
PKGATTRVAL Yes
PKGITEMREL Yes Yes Yes
POLICY Yes
POLICYCMD Yes Yes
POLICYDESC Yes Yes
POLICYTC Yes Yes
PRODSETDSC Yes Yes
PRODUCTSET Yes
PRSETCEREL Yes Yes
QTYFMTDESC Yes Yes Yes
QTYFORMAT Yes Yes
RTNDNYDESC Yes Yes
RTNDNYRSN Yes
RTNDSPCODE Yes
RTNDSPDESC Yes Yes
RTNREASON Yes
RTNRSNDESC Yes Yes
SHPARJURGP Yes Yes
SHPARRANGE Yes
SHPJCRULE Yes
SHPMODEDSC Yes Yes
STENCALUSG Yes Yes
STORECAT Yes Yes
STORECENT Yes Yes
STORECGRP Yes Yes
STORECNTR Yes Yes
STOREDEF Yes
STOREITEM Yes Yes
STORELANG Yes Yes
STOREMBRGP Yes Yes
STORITMFFC Yes Yes Yes
STORLANGDS Yes Yes Yes
TAXCGRY Yes
TAXCGRYDS Yes Yes
TAXJCRULE Yes Yes Yes
TCDESC Yes Yes
TDPSCNCNTR Yes Yes
TERMCOND Yes
TRADEPOSCN Yes
TRADING Yes
TRDATTACH Yes Yes
TRDDESC Yes Yes
TXCDCLASS Yes
VENDOR Yes
VENDORDESC Yes Yes
VERSIONSPC Yes
VIEWREG Yes Yes Yes

Feedback