FieldLabel Table (168)
•
Environment: onsite, online
• 2 minutes to read
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 |
Null |
| FieldLabel_id |
Primary key |
PK |
|
| resourceId |
Text resource ID |
Id |
|
| parentId |
ID (not resource) of label that is a parent of this one |
Id |
● |
| active |
1 = label substitution is active |
UShort |
● |
| registered |
Registered when |
UtcDateTime |
|
| registered_associate_id |
Registered by whom |
FK associate |
|
| updated |
Last updated when |
UtcDateTime |
|
| updated_associate_id |
Last updated by whom |
FK associate |
|
| updatedCount |
Number of updates made to this record |
UShort |
|
Indexes
| Fields |
Types |
Description |
| FieldLabel_id |
PK |
Clustered, Unique |
| resourceId |
Id |
Index |
Relationships
| Table |
Description |
| 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.