Localization tables
Glossary Item Box
Localization tables are created for objects with at least one localizable column. These tables store localizable data for all languages (cultures) except for the default one.
The default localization table name is Sys[schema_name]Lcz, where [schema_name] is the object schema with the localizable columns. General localization table structure:
Table 1. – General localization table structure
Column name | Description |
---|---|
Id | Record identifier. |
ModifiedOn | Modification date. |
RecordId | A link to the localized record in the main object table. |
SysCultureId | Culture link. |
LczColumn1 | Columns corresponding to the object's localizable columns. |
LczColumn2 | |
... | |
LczColumnN |
The localization table structure of the Random object with the LocalizableText column:
Fig. 1. The link between the main table and the localization table.
Use the object designer to specify / change the name of the table. Go to the advanced schema object properties and specify the name of the localization object.
Fig. 2. Localization table name in the object designer