Locales

The Locales (md_locale) view allows you to add, modify, copy, and delete records in the locales table.

  • A locale is simply an identifier for a particular combination of language and region.

  • The following set of locales are supported by the Java Development Kit (JDK) classes:

    Locale Language Country
    ar_AE Arabic United Arab Emirates
    ar_BH Arabic Bahrain
    ar_DZ Arabic Algeria
    ar_EG Arabic Egypt
    ar_IQ Arabic Iraq
    ar_JO Arabic Jordan
    ar_KW Arabic Kuwait
    ar_LB Arabic Lebanon
    ar_LY Arabic Lybia
    ar_MA Arabic Morocco
    ar_OM Arabic Oman
    ar_QA Arabic Qatar
    ar_SA Arabic Saudi Arabia
    ar_SD Arabic Sudan
    ar_TN Arabic Tunisia
    ar_YE Arabic Yemen
    be_BY Byelorussian Byelorussia
    bg_BG Bulgarian Bulgaria
    ca_ES Catalan Spain
    cs_CZ Czech Czech Republic
    da_DK Danish Denmark
    de_AT German Austria
    de_AT_EURO German Austria
    de_CH German Switzerland
    de_DE German Germany
    de_DE_EURO German Germany
    de_LU German Luxembourg
    de_LU_EURO German Luxembourg
    el_GR Greek Greece
    en_AU English Australia
    en_CA English Canada
    en_GB English United Kingdom
    en_IE English Ireland
    en_IE_EURO English Ireland
    en_NZ English New Zealand
    en_US English United States
    en_ZA English South Africa
    es_AR Spanish Argentina
    es_BO Spanish Bolivia
    es_CL Spanish Chile
    es_CO Spanish Columbia
    es_CR Spanish Costa Rica
    es_DO Spanish Dominican Republic
    es_EC Spanish Equador
    es_ES Spanish Spain
    es_ES_EURO Spanish Spain
    es_GT Spanish Guatemala
    es_HN Spanish Honduras
    es_MX Spanish Mexico
    es_NI Spanish Nicaragua
    es_PA Spanish Panama
    es_PE Spanish Peru
    es_PR Spanish Puerto Rico
    es_PY Spanish Paraguay
    es_SV Spanish El Salvador
    es_UY Spanish Uruguay
    es_VE Spanish Venezuela
    et_EE Estonian Estonia
    fi_FI Finnish Finland
    fi_FI_EURO Finnish Finland
    fr_BE French Belgium
    fr_CA French Canada
    fr_CH French Switzerland
    fr_FR French France
    fr_FR_EURO French France
    fr_LU French Luxembourg
    fr_LU_EURO French Luxembourg
    hr_HR Croatian Croatia
    hu_HU Hungarian Hungary
    is_IS Icelandic Iceland
    it_IT Italian Italy
    it_IT_EURO Italian Italy
    iw_IL Hebrew Isreal
    ja_JP Japanese Japan
    ko_KR Korean Korea
    lt_LT Lithuanian Lithuania
    lv_LV Latvian Latvia
    mk_MK Macedonian Macedonia
    nl_BE Dutch Belgium
    nl_BE_EURO Dutch Belgium
    nl_NL Dutch Netherlands
    nl_NL_EURO Dutch Netherland
    no_NO Norwegian (Nynorsk) Norway
    no_NO_B Norwegian (Bokmal) Norway
    pl_PL Polish Poland
    pt_BR Portuguese Brazil
    pt_PT Portuguese Portugal
    pt_PT_EURO Portuguese Portugal
    ro_RO Romanian Romania
    ru_RU Russian Russia
    sh_YU Serbo-Croatian Yugoslavia
    sk_SK Slovakian Slovakia
    sl_SL Slovenian Slovenia
    sq_AL Albanian Albania
    sr_YU Serbian (Cyrillic) Yugoslavia
    sv_SE Swedish Sweden
    th_TH Thai Thailand
    tr_TR Turkish Turkey
    uk_UA Ukranian Ukraine
    zh_CN Chinese (Simplified) China
    zh_HK Chinese Hong Kong
    zh_TW Chinese (Traditional) Taiwan

  • The product's components (e.g. views, messages, portal menus) are displayed in the language associated with a user's locale. An environment's default locale is defined in the System Properties field in the environments table, but users have the ability to override this setting via their preferences.

  • Language-specific descriptions for all user data (e.g. item descriptions, division names, warehouse descriptions) are also displayed in the user's language of choice. However, this feature is dependent upon an alternate description having been defined in the table options table for the table in question, and an alternate description having been assigned to the records themselves. The System Properties field identifies the locales that map to the primary description. All other locales map to the alternate description.

The following list defines every field available in the locales (md_locale) table in alphabetical order:

  • Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Description - this field is not maintainable. An expression column that shows the text associated with the description literal key or the overridden description.

  • Description Literal Key - the literal key for the locale's description.

  • Extra Attributes - a CLOB-type field used to store additional JSON information.

  • Is Available - the following options are available:

    • Yes (default) - the locale is available.

    • No - the locale is not available.

    Note: A locale is available only once it is supported by the systems defined by the meta database. To support a locale, all of the literals in the meta database must be translated.

  • Key - the unique identifier for a given locale. Key composed of language + "_" + country. Language is lowercased and abbreviated. Its code is based on ISO 639. Country is uppercased and abbreviated. The country or region code is based on ISO 3166.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.