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 |