Enabling multiple languages on an object or on a table creates a secondary table connection. For example, L_ITEM is the secondary table for the ITEM object.
You use the MAXATTRIBUTE table to determine which tables and columns are multiple language supported or multiple language enabled. The flag for multiple language supported (MLSUPPORTED=1) indicates whether the values in the column are stored in multiple languages or not. This flag is read-only and cannot be changed.
The flag for multiple language enabled (MLINUSE=1) indicates whether the column is enabled to store the values in multiple languages.
To view the tables and columns that are enabled for multiple languages, access a Structured Query Language (SQL) editor and type select objectname,attributename from maxattribute where mlinuse= 1;.
Tables | Columns |
---|---|
ALNDOMAIN | DESCRIPTION |
ASSETATTRIBUTE | DESCRIPTION |
COMMTEMPLATE | MESSAGE SUBJECT |
COMPANIES | NAME NAME_LONGDESCRIPTION |
CTRLCONDPROP | CTRLCONDPROP |
ITEM | DESCRIPTION_LONGDESCRIPTION DESCRIPTION |
MAXAPPS | DESCRIPTION |
MAXATTRIBUTE | TITLE REMARKS |
MAXATTRIBUTECFG | TITLE REMARKS |
MAXDOMAIN | DESCRIPTION |
MAXLABELS | VALUE |
MAXMENU | HEADERDESCRIPTION |
MAXMESSAGES | EXPLANATION ADMINRESPONSE BUTTONTEXT SYSTEMACTION VALUE OPERATORRESPONSE |
MAXMODULES | DESCRIPTION |
MAXOBJECT | DESCRIPTION |
MAXOBJECTCFG | DESCRIPTION |
MAXSERVICE | DESCRIPTION |
NUMERICDOMAIN | DESCRIPTION |
PALETTEITEM | DESCRIPTION |
REPORT | DESCRIPTION |
REPORTLABEL | LABELVALUE FONTNAME |
REPORTLOOKUP | LABELOVERRIDE |
SIGOPTION | DESCRIPTION |
SOLUTION | DESCRIPTION |
SYNONYMDOMAIN | DESCRIPTION |