SYS_LANGUAGE_CODES

Language Codes

tableFINSYS

SYS_LANGUAGE_CODES — Language Codes. FIN table in the standard Ross ERP 8.0 schema: 5 columns, used by 72 programs. Columns, data types, keys, foreign keys and relationships.

Open SYS_LANGUAGE_CODES in the interactive Data Dictionary →

Part of SYS tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2SYS_LANGUAGE_CODEvarchar(8)PKLanguage Code
3SYS_CODE_DESCRIPTIONvarchar(30)Code Description
4SYS_ISO_LANGUAGE_CODEvarchar(2)ISO 2-character Language Code
5GEM_MODIFY_DATEdatetimeSystem timestamp of the most recent modification to the row, maintained by GEMBASE.

Referenced by · 5 foreign keys

SYS_COUNTRIESAP_CONTROLSAR_CONTROLSCUSTOMER_ADDRESSESCUSTOMER_ADDRESSES