LANGUAGE

Each row of this table represents a language. HCL Commerce supports multiple languages and is translated into ten languages by default. Using the predefined ISO codes users can add other supported languages.

Column Descriptions:

Name	Type	Description
LANGUAGE_ID	INTEGER NOT NULL	The language ID (primary key of this table) for each language. Foreign key to the tables that contain language-dependent information. The following is the list of language components (language ID codes) of the locale: -1 = English (US) -2 = French -3 = German -4 = Italian -5 = Spanish -6 = Brazilian Portuguese -7 = Simplified Chinese -8 = Traditional Chinese -9 = Korean -10 = Japanese -20 = Russian -21 = Romanian -22 = Polish
LOCALENAME	CHAR (16) NOT NULL	A Java locale used to represent a political, geographical, or cultural region that has a distinct language and customs. The following is the list of locale used for formatting: en_US = United States fr_FR = France de_DE = Germany it_IT = Italy es_ES = Spain pt_BR = Brazil zh_CN = China zh_TW = Taiwan ko_KR = Korea ja_JP = Japan ru_RU = Russian ro_RO = Romanian pl_PL = Polish
LANGUAGE	CHAR (5)	Language component of the locale. NOTE: A value must be entered for this column: en = English (US) fr = French de = German it = Italian es = Spanish pt = Brazilian Portuguese zh = Simplified Chinese zh = Traditional Chinese ko = Korean ja = Japanese ru = Russian ro = Romanian pl = Polish To choose another language component, refer to the existing ISO codes.
COUNTRY	CHAR (5)	Country or region component of the locale. NOTE: A value must be entered for this column: US = United States FR = France DE = Germany IT = Italy ES = Spain BR = Brazil CN = China TW = Taiwan KR = Korea JP = Japan RU = Russia RO = Romania PL = Poland To choose another country or region, refer to the existing ISO codes.
VARIANT	CHAR (10)	Variant component of the locale. Used to specify the locale encoding character set or to further segregate a distinct formatting custom for a political, geographical, or cultural region.
ENCODING	VARCHAR (32)	The character encoding value that the browser uses to display the page in the selected language.
MIMECHARSET	VARCHAR (32)	The MIME character encoding value that the notification system uses to encode a message for the selected language.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	LANGUAGE_ID	Primary Key

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1	LANGUAGE_ID	ACACGPDESC	LANGUAGE_ID	Cascade
F_1008	LANGUAGE_ID	ACPLGPDESC	LANGUAGE_ID	Cascade
F_1029	LANGUAGE_ID	ROLEDESC	LANGUAGE_ID	Cascade
F_1031	LANGUAGE_ID	MBRGRPDESC	LANGUAGE_ID	Cascade
F_109	LANGUAGE_ID	BASEITMDSC	LANGUAGE_ID	Cascade
F_1106	LANGUAGE_ID	ATCHTGTDSC	LANGUAGE_ID	Cascade
F_1112	LANGUAGE_ID	ATCHASTLG	LANGUAGE_ID	Cascade
F_1117	LANGUAGE_ID	ATCHRELDSC	LANGUAGE_ID	Cascade
F_1121	LANGUAGE_ID	ATCHRLUSDS	LANGUAGE_ID	Cascade
F_1124	LANGUAGE_ID	CMFWKSPCDSC	LANGUAGE_ID	Cascade
F_1126	LANGUAGE_ID	CMFTGDSC	LANGUAGE_ID	Cascade
F_1132	LANGUAGE_ID	CMFTASKDSC	LANGUAGE_ID	Cascade
F_1165	LANGUAGE_ID	CCOMMENT	LANGUAGE_ID	Cascade
F_1167	LANGUAGE_ID	BUSCHNDESC	LANGUAGE_ID	Cascade
F_1187	LANGUAGE_ID	DKPDCDESC	LANGUAGE_ID	Cascade
F_1194	LANGUAGE_ID	TICKLER	LANGUAGE_ID	Cascade
F_1200	LANGUAGE_ID	TKLACTHIST	LANGUAGE_ID	Cascade
F_1204	LANGUAGE_ID	TKLRACTDSC	LANGUAGE_ID	Cascade
F_1207	LANGUAGE_ID	TKLRRSNDSC	LANGUAGE_ID	Cascade
F_1222	LANGUAGE_ID	BLKRSNDESC	LANGUAGE_ID	Cascade
F_1234	LANGUAGE_ID	PRCORSNDSC	LANGUAGE_ID	Cascade
F_158	LANGUAGE_ID	CALCODEDSC	LANGUAGE_ID	Cascade
F_180	LANGUAGE_ID	CALSCALEDS	LANGUAGE_ID	Cascade
F_184	LANGUAGE_ID	CATALOGDSC	LANGUAGE_ID	Cascade
F_195	LANGUAGE_ID	CATENTATTR	LANGUAGE_ID	Cascade
F_197	LANGUAGE_ID	CATENTDESC	LANGUAGE_ID	Cascade
F_218	LANGUAGE_ID	CATGRPATTR	LANGUAGE_ID	Cascade
F_220	LANGUAGE_ID	CATGRPDESC	LANGUAGE_ID	Cascade
F_237	LANGUAGE_ID	CHRGTYPDSC	LANGUAGE_ID	Cascade
F_242	LANGUAGE_ID	CLSFCODEDS	LANGUAGE_ID	Cascade
F_250	LANGUAGE_ID	COLLDESC	LANGUAGE_ID	Cascade
F_257	LANGUAGE_ID	COUNTRY	LANGUAGE_ID	Cascade
F_269	LANGUAGE_ID	CPPMNDESC	LANGUAGE_ID	Cascade
F_28	LANGUAGE_ID	ACPOLDESC	LANGUAGE_ID	Cascade
F_290	LANGUAGE_ID	CURFMTDESC	LANGUAGE_ID	Cascade
F_297	LANGUAGE_ID	DISPCGPREL	LANGUAGE_ID	Cascade
F_302	LANGUAGE_ID	DISPENTREL	LANGUAGE_ID	Cascade
F_315	LANGUAGE_ID	FFMCENTDS	LANGUAGE_ID	Cascade
F_321	LANGUAGE_ID	FLDOMNDESC	LANGUAGE_ID	Cascade
F_329	LANGUAGE_ID	FLOWDESC	LANGUAGE_ID	Cascade
F_337	LANGUAGE_ID	FLSTDCTDSC	LANGUAGE_ID	Cascade
F_339	LANGUAGE_ID	FLSTGPDSC	LANGUAGE_ID	Cascade
F_341	LANGUAGE_ID	FLTRANSDSC	LANGUAGE_ID	Cascade
F_347	LANGUAGE_ID	FLTYPEDESC	LANGUAGE_ID	Cascade
F_35	LANGUAGE_ID	ACRELDESC	LANGUAGE_ID	Cascade
F_3517	LANGUAGE_ID	ATTRDICTGRPDESC	LANGUAGE_ID	Cascade
F_3549	LANGUAGE_ID	PX_DESCRIPTION	LANGUAGE_ID	Cascade
F_3558	LANGUAGE_ID	ATTRDESC	LANGUAGE_ID	Cascade
F_3561	LANGUAGE_ID	ATTRVALDESC	LANGUAGE_ID	Cascade
F_3571	LANGUAGE_ID	STLOCATTR	LANGUAGE_ID	Cascade
F_3573	LANGUAGE_ID	STLOCDS	LANGUAGE_ID	Cascade
F_3575	LANGUAGE_ID	GEONDDS	LANGUAGE_ID	Cascade
F_358	LANGUAGE_ID	ICCONSTVAL	LANGUAGE_ID	Cascade
F_360	LANGUAGE_ID	ICEXPLDESC	LANGUAGE_ID	Cascade
F_364	LANGUAGE_ID	ICKNOWDESC	LANGUAGE_ID	Cascade
F_3665	LANGUAGE_ID	CATFLTDSC	LANGUAGE_ID	Cascade
F_367	LANGUAGE_ID	ICMERDESC	LANGUAGE_ID	Cascade
F_3683	LANGUAGE_ID	CLSATTRSRCHCONF	LANGUAGE_ID	Cascade
F_3685	LANGUAGE_ID	CFCONDVAL	LANGUAGE_ID	Cascade
F_3687	LANGUAGE_ID	SRCHTERMASSOC	LANGUAGE_ID	Cascade
F_3699	LANGUAGE_ID	SEOPAGEDEFDESC	LANGUAGE_ID	Cascade
F_3706	LANGUAGE_ID	SEOURLKEYWORD	LANGUAGE_ID	Cascade
F_3709	LANGUAGE_ID	SRCHCONFEXT	LANGUAGE_ID	Cascade
F_3722	LANGUAGE_ID	CATENTDESCOVR	LANGUAGE_ID	Cascade
F_3738	LANGUAGE_ID	FACETDESC	LANGUAGE_ID	Cascade
F_3743	LANGUAGE_ID	COLLIMGMAPAREA	LANGUAGE_ID	Cascade
F_3745	LANGUAGE_ID	SRCHATTRDESC	LANGUAGE_ID	Cascade
F_3748	LANGUAGE_ID	PLWIDGETDEFDESC	LANGUAGE_ID	Cascade
F_375	LANGUAGE_ID	ICMREGDESC	LANGUAGE_ID	Cascade
F_389	LANGUAGE_ID	INVADJDESC	LANGUAGE_ID	Cascade
F_400	LANGUAGE_ID	INVRSRVDSC	LANGUAGE_ID	Cascade
F_413	LANGUAGE_ID	LANGPAIR	LANGUAGE_ID	Cascade
F_414	LANGUAGE_ID	LANGPAIR	LANGUAGE_ID_ALT	Cascade
F_416	LANGUAGE_ID	LANGUAGEDS	LANGUAGE_ID	Cascade
F_417	LANGUAGE_ID	LANGUAGEDS	LANGUAGE_ID_DESC	Cascade
F_42	LANGUAGE_ID	ACRESGPDES	LANGUAGE_ID	Cascade
F_465	LANGUAGE_ID	NUMBRUSGDS	LANGUAGE_ID	Cascade
F_471	LANGUAGE_ID	OFFERDESC	LANGUAGE_ID	Cascade
F_481	LANGUAGE_ID	OPERATRDSC	LANGUAGE_ID	Cascade
F_487	LANGUAGE_ID	ORDADJDSC	LANGUAGE_ID	Cascade
F_5	LANGUAGE_ID	ACACTDESC	LANGUAGE_ID	Cascade
F_53	LANGUAGE_ID	ACRLGPDESC	LANGUAGE_ID	Cascade
F_556	LANGUAGE_ID	OUTPUTQDSC	LANGUAGE_ID	Cascade
F_56	LANGUAGE_ID	ACRSCGDES	LANGUAGE_ID	Cascade
F_562	LANGUAGE_ID	PARTROLEDS	LANGUAGE_ID	Cascade
F_564	LANGUAGE_ID	PATTRDESC	LANGUAGE_ID	Cascade
F_574	LANGUAGE_ID	PAYMTHDDSC	LANGUAGE_ID	Cascade
F_589	LANGUAGE_ID	PKGATTR	LANGUAGE_ID	Cascade
F_591	LANGUAGE_ID	PKGATTRVAL	LANGUAGE_ID	Cascade
F_597	LANGUAGE_ID	PLCYACCDSC	LANGUAGE_ID	Cascade
F_601	LANGUAGE_ID	PLCYLCKDSC	LANGUAGE_ID	Cascade
F_603	LANGUAGE_ID	PLCYPWDDSC	LANGUAGE_ID	Cascade
F_606	LANGUAGE_ID	PLCYTYPDSC	LANGUAGE_ID	Cascade
F_611	LANGUAGE_ID	POLICYDESC	LANGUAGE_ID	Cascade
F_620	LANGUAGE_ID	PRODSETDSC	LANGUAGE_ID	Cascade
F_642	LANGUAGE_ID	QTYFMTDESC	LANGUAGE_ID	Cascade
F_647	LANGUAGE_ID	QTYUNITDSC	LANGUAGE_ID	Cascade
F_71	LANGUAGE_ID	ATTRIBUTE	LANGUAGE_ID	Cascade
F_719	LANGUAGE_ID	RTNDNYDESC	LANGUAGE_ID	Cascade
F_723	LANGUAGE_ID	RTNDSPDESC	LANGUAGE_ID	Cascade
F_732	LANGUAGE_ID	RTNRSNDESC	LANGUAGE_ID	Cascade
F_743	LANGUAGE_ID	SETCURRDSC	LANGUAGE_ID	Cascade
F_756	LANGUAGE_ID	SHPMODEDSC	LANGUAGE_ID	Cascade
F_758	LANGUAGE_ID	STATEPROV	LANGUAGE_ID	Cascade
F_76	LANGUAGE_ID	ATTRVALUE	LANGUAGE_ID	Cascade
F_777	LANGUAGE_ID	STORE	LANGUAGE_ID	Cascade
F_79	LANGUAGE_ID	AUCTDESC	LANGUAGE_ID	Cascade
F_793	LANGUAGE_ID	STOREENTDS	LANGUAGE_ID	Cascade
F_798	LANGUAGE_ID	STORELANG	LANGUAGE_ID	Cascade
F_809	LANGUAGE_ID	STORLANGDS	LANGUAGE_ID	Cascade
F_819	LANGUAGE_ID	TAXCGRYDS	LANGUAGE_ID	Cascade
F_825	LANGUAGE_ID	TCDESC	LANGUAGE_ID	Cascade
F_829	LANGUAGE_ID	TCSUBTYPDS	LANGUAGE_ID	Cascade
F_845	LANGUAGE_ID	TFALGPOLDS	LANGUAGE_ID	Cascade
F_847	LANGUAGE_ID	TFALGTYPDS	LANGUAGE_ID	Cascade
F_849	LANGUAGE_ID	TFALREGDSC	LANGUAGE_ID	Cascade
F_851	LANGUAGE_ID	TFDOMDSC	LANGUAGE_ID	Cascade
F_857	LANGUAGE_ID	TFSBDOMDSC	LANGUAGE_ID	Cascade
F_861	LANGUAGE_ID	TFTRENGDSC	LANGUAGE_ID	Cascade
F_873	LANGUAGE_ID	TRDDESC	LANGUAGE_ID	Cascade
F_883	LANGUAGE_ID	TRDTYPEDSC	LANGUAGE_ID	Cascade
F_897	LANGUAGE_ID	USERS	LANGUAGE_ID	Cascade
F_9	LANGUAGE_ID	ACATTRDESC	LANGUAGE_ID	Cascade
F_903	LANGUAGE_ID	VENDORDESC	LANGUAGE_ID	Cascade
F_909	LANGUAGE_ID	WCSDTNRYDS	LANGUAGE_ID	Cascade
F_920	LANGUAGE_ID	STRELTYPDS	LANGUAGE_ID	Cascade
F_950	LANGUAGE_ID	STCGRYDESC	LANGUAGE_ID	Cascade
F_953	LANGUAGE_ID	QUEUEDESC	LANGUAGE_ID	Cascade