> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # LocaleText table > Multi-language text items. Used for user-defined field labels. Must be assigned correct name to match the language they start SuperOffice in. This table should be viewed in conjunction with FieldLabel. If a row in FieldLable has active = 1 this table will need to contain at least one row with the same resourceId as the FieldLabel row. The language id can be either 0 or one of the Windows language ID's; SuperOffice will pick the correct language on startup according to the user settings. If a label cannot be found with the given language and also not with language 0, it will not be substituted. ## LocaleText Table (169) Multi-language text items. Used for user-defined field labels. Must be assigned correct name to match the language they start SuperOffice in. This table should be viewed in conjunction with FieldLabel. If a row in FieldLable has active = 1 this table will need to contain at least one row with the same resourceId as the FieldLabel row. The language id can be either 0 or one of the Windows language ID's; SuperOffice will pick the correct language on startup according to the user settings. If a label cannot be found with the given language and also not with language 0, it will not be substituted. ## Fields | Name | Description | Type | Nullable | | ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------- | :------: | | LocaleText\_id | Primary key | PK | No | | languageId | Language ID | Id | No | | typeId | 1=label 2=table 3=column 4=import field 5=import object 6=import GUI category 7=contact udef label 8=role name, 9 = role tooltip, 10 = functionright label, 11 = functionright descriptionid; 12=function right description; 16=status monitor name; 19=contact udef label; 20=person udef label; 21=project udef label; 22=sale udef label; 23=appointment udef label; 24=document udef label; 31=tzlocation city | UShort | No | | resourceId | Resource ID | Id | No | | text | The text string itself | String(254) | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | | isBuiltin | 1 = this row is populated and maintained by SuperOffice | UShort | Yes | LocaleText table relationship diagram ## Indexes | Fields | Types | Description | | ------------------------------ | -------------- | ----------------- | | resourceId | Id | Index | | languageId, typeId, resourceId | Id, UShort, Id | Clustered, Unique | ## Relationships | Table | Description | | ------------------------ | ------------------------------------------------------------------ | | [associate](./associate) | Employees, resources and other users - except for External persons | ## Replication Flags * Replicate changes DOWN from central to satellites and travellers. * Replicate changes UP from satellites and travellers back to central. * Copy to satellite and travel prototypes. ## Security Flags * No access control via user's Role. ## Related topics - [Preference section FieldLabels](/en/admin/user-preferences/reference/field-labels.md) - [Resource providers](/en/api/localization/language/resource-providers.md) - [Role table](/en/database/tables/role.md) - [StatusDef table](/en/database/tables/statusdef.md) - [text table](/en/database/tables/text.md) - [TZLocation table](/en/database/tables/tzlocation.md)