PrefDesc table - SuperOffice

PrefDesc Table (184)

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	Nullable
PrefDesc_id	Primary key	PK	No
prefsection	Preference section name	String(199)	No
prefkey	Preference key name	String(199)	No
name	Multi-language name	String(254)	Yes
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	Yes
maxLevel	Lowest allowed setting level, set by user, but not lower than sysMaxLevel	Enum PreferenceLevel	Yes
sysMaxLevel	Lowest allowed setting level, set by SuperOffice	Enum PreferenceLevel	Yes
accessFlags	1=wizard mode, 2=level 0, 4=admin gui, 8=crm gui	Enum PrefDescAccessFlags	Yes
maxValue	Max value (if type 1); list table ID (if type 5)	Int	Yes
minValue	Min value (if type 1); list extra id (if type 5)	Int	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
description	Description of preference, multi-language parsed	String(2047)	Yes
isBuiltin	1 = This row populated and maintained by SuperOffice	UShort	Yes
requiredLicense	Licenses the user/installation must have if this reference is to be shown. Comma-separated list of owner.module pairs	String(254)	Yes
rank	Rank field for ordering sections, and keys within sections	Int	Yes
subGroup	Keys that share a value (including NULL) in this field are shown together; a visual spacer is shown between groups	String(128)	Yes
minLevel	The minimum (furthest away from User) level this preference can be set for	Int	Yes

Indexes

Fields	Types	Description
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.

Related topics

PrefDescLine table Enum PrefDescAccessFlags Enum PrefDescValueType Enum values for PrefDescValueType Enum values for PrefDescAccessFlags Get Preference Description Lines By Pref Desc Id

⌘I