> ## 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.

# FieldLabel table

> Field label override table, makes it possible to override internal string resources. Define your own text for the panels in SuperOffice, e.g. rename Project to Cars in SOAdmin - System Options - Labels  This table contains controlling data for the string substitution mechanism. There is one row in this table for each label or string that can be substituted; the active field indicates whether the string is actually being substituted or not. Initially, all rows have this field set to 0. The table is loaded with initial data during database setup.  Only SuperOffice Development has the necessary expertise to safely add rows to this table.  If a row has active = 1, the table LocaleText should contain one or more rows pointing back to this table, with the actual text to be used.

## FieldLabel Table (168)

Field label override table, makes it possible to override internal string resources. Define your own text for the panels in SuperOffice, e.g. rename Project to Cars in SOAdmin - System Options - Labels  This table contains controlling data for the string substitution mechanism. There is one row in this table for each label or string that can be substituted; the active field indicates whether the string is actually being substituted or not. Initially, all rows have this field set to 0. The table is loaded with initial data during database setup.  Only SuperOffice Development has the necessary expertise to safely add rows to this table.  If a row has active = 1, the table LocaleText should contain one or more rows pointing back to this table, with the actual text to be used.

## Fields

| Name                      | Description                                             | Type                            | Nullable |
| ------------------------- | ------------------------------------------------------- | ------------------------------- | :------: |
| FieldLabel\_id            | Primary key                                             | PK                              |    No    |
| resourceId                | Text resource ID                                        | Id                              |    No    |
| parentId                  | ID (not resource) of label that is a parent of this one | Id                              |    Yes   |
| active                    | 1 = label substitution is active                        | UShort                          |    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    |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/FieldLabel.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=7b23ec14cca521137e58f4fa02ae7521" alt="FieldLabel table relationship diagram" width="395" height="59" data-path="media/loc/en/database/tables/FieldLabel.png" />

## Indexes

| Fields     | Types | Description |
| ---------- | ----- | ----------- |
| resourceId | Id    | Index       |

## 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)
- [SuperOffice.WebApi.Data.UserPreferenceStrings.FieldLabels](/en/api/reference/webapi/SuperOffice.WebApi.Data.UserPreferenceStrings.FieldLabels.md)
- [LocaleText table](/en/database/tables/localetext.md)
- [Get User Defined Field From Field Label](/en/api/reference/restful/agent/userdefinedfieldinfo_agent/get-user-defined-field-from-field-label.md)
- [Get Published User Defined Field From Field Label](/en/api/reference/restful/agent/userdefinedfieldinfo_agent/get-published-user-defined-field-from-field-label.md)
- [UDefField table](/en/database/tables/udeffield.md)