• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

PrefDesc Table (184)

Some tooltip text!
• 4 minutes to read
 • 4 minutes to read

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.

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 ●

PrefDesc table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top