PrefDesc Table (184)
• 4 minutes to read
• 4 minutes to read
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 |
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.