Multiple language tables and associated columns

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;.

By default, the following tables and associated columns are enabled for multiple languages.
Table 1. Multiple language tables and associated columns
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


Feedback