| uid | title | description | so.generated | keywords | so.date | so.topic | so.envir | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|
table-PrefDesc |
PrefDesc table |
Preference description, drives the Preference GUI. Maintenance client - controls all preferences in SuperOffice. You find an overview off all standard preference on http;//techdoc.superoffice.com. May be used by third-party developers to add system preferences to be updated from SuperOffice Maintenance client, instead of ini-files. |
true |
|
11.04.2021 |
reference |
|
| 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 | ● |
[!includedetails]
| Fields | Types | Description |
|---|---|---|
| PrefDesc_id | PK | Clustered, Unique |
| prefsection | String(199) | Index |
| prefkey | String(199) | Index |
- 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.
- No access control via user's Role.