PrefDesc Table (184)
• 4 minutes to read
Preference description, drives the Preference GUI. Maintenance client - controls all preferences in SuperOffice. May be used by third-party developers to add system preferences to be updated from SuperOffice Maintenance client, instead of ini-files.
Fields
Name |
Description |
Type |
Null |
PrefDesc_id |
Primary key |
PK |
|
prefsection |
Preference section name |
String(199) |
|
prefkey |
Preference key name |
String(199) |
|
name |
Multi-language name |
String(254) |
● |
valueType |
1=number, 2=text, 3=bool, 4=list of values; 5=list table ref; 6=contact ID, 7=Person ID, 8=Project ID, 9=Selection ID |
Enum PrefDescValueType |
● |
maxLevel |
Lowest allowed setting level, set by user, but not lower than sysMaxLevel |
Enum PreferenceLevel |
● |
sysMaxLevel |
Lowest allowed setting level, set by SuperOffice |
Enum PreferenceLevel |
● |
accessFlags |
1=wizard mode, 2=level 0, 4=admin gui, 8=crm gui |
Enum PrefDescAccessFlags |
● |
maxValue |
Max value (if type 1); list table ID (if type 5) |
Int |
● |
minValue |
Min value (if type 1); list extra id (if type 5) |
Int |
● |
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 |
|
description |
Description of preference, multi-language parsed |
String(2047) |
● |
isBuiltin |
1 = This row populated and maintained by SuperOffice |
UShort |
● |
requiredLicense |
Licenses the user/installation must have if this reference is to be shown. Comma-separated list of owner.module pairs |
String(254) |
● |
rank |
Rank field for ordering sections, and keys within sections |
Int |
● |
subGroup |
Keys that share a value (including NULL) in this field are shown together; a visual spacer is shown between groups |
String(128) |
● |
minLevel |
The minimum (furthest away from User) level this preference can be set for |
Int |
● |

Value for field 'accessflags' in table 'prefdesc'
This enumeration consists of flag values that can be combined
accessflags |
ID |
Comment |
Unknown |
0 |
Unknown - used when initializing |
WizardMode |
1 |
Wizard mode is password-protected and only accessible to SuperOffice personnel. |
Level0 |
2 |
Preference settable only by CRM superuser |
adminGUI |
4 |
Show preference in SOADMIN GUI |
CRMGUI |
8 |
Show preference in CRM GUI |
Value for field 'valueType' in table 'prefdesc'
valueType |
ID |
Comment |
Unknown |
0 |
Unknown - used when initializing |
Number |
1 |
Preference value is a number |
Text |
2 |
Preference value is a text (max len 99 characters) |
Bool |
3 |
Preference value is Boolean |
ListOfValues |
4 |
Preference value is a list of separate value |
ListTableRef |
5 |
Preference value is a record ID in the given MDO list table |
TimeList |
6 |
Preference value is a time, value is seconds since midnight (28800 = 08:00) |
ContactID |
7 |
Preference value is a contact ID |
PersonID |
8 |
Preference value is a person ID |
ProjectID |
9 |
Preference value is a project ID |
SelectionID |
10 |
Preference value is a selection ID |
PosSize |
11 |
Obsolete: Windows position and size |
TimeZone |
12 |
TimeZone location |
Indexes
Fields |
Types |
Description |
PrefDesc_id |
PK |
Clustered, Unique |
prefsection |
String(199) |
Index |
prefkey |
String(199) |
Index |
Relationships
Table |
Description |
associate |
Employees, resources and other users - except for External persons |
PrefDescLine |
Preference description - multiple choice line - drives the Preference GUI. May be used by third-party developers to add system preferences to be updated from SuperOffice Maintenance client, instead of ini-files. |
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.