> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

## 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](./enums/prefdescvaluetype.mdx)     |    Yes   |
| maxLevel                  | Lowest allowed setting level, set by user, but not lower than sysMaxLevel                                             | Enum [PreferenceLevel](./enums/preferencelevel.mdx)         |    Yes   |
| sysMaxLevel               | Lowest allowed setting level, set by SuperOffice                                                                      | Enum [PreferenceLevel](./enums/preferencelevel.mdx)         |    Yes   |
| accessFlags               | 1=wizard mode, 2=level 0, 4=admin gui, 8=crm gui                                                                      | Enum [PrefDescAccessFlags](./enums/prefdescaccessflags.mdx) |    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](./associate.mdx)                             |    No    |
| updated                   | Last updated when                                                                                                     | UtcDateTime                                                 |    No    |
| updated\_associate\_id    | Last updated by whom                                                                                                  | FK [associate](./associate.mdx)                             |    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   |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/PrefDesc.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=47934242dc3664f4100c003b6b031547" alt="PrefDesc table relationship diagram" width="674" height="59" data-path="media/loc/en/database/tables/PrefDesc.png" />

## Indexes

| Fields      | Types       | Description |
| ----------- | ----------- | ----------- |
| prefsection | String(199) | Index       |
| prefkey     | String(199) | Index       |

## Relationships

| Table                          | Description                                                                                                                                                                                                         |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [associate](./associate)       | Employees, resources and other users - except for External persons                                                                                                                                                  |
| [PrefDescLine](./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

- [SuperOffice.WebApi.Data.CultureDataFormatter](/en/api/reference/webapi/SuperOffice.WebApi.Data.CultureDataFormatter.md)
- [PrefDescLine table](/en/database/tables/prefdescline.md)
- [Enum PrefDescAccessFlags](/en/automation/crmscript/reference/CRMScript.NetServer.PrefDescAccessFlags.md)
- [Enum PrefDescValueType](/en/automation/crmscript/reference/CRMScript.NetServer.PrefDescValueType.md)
- [Enum values for PrefDescValueType](/en/database/tables/enums/prefdescvaluetype.md)
- [SuperOffice.WebApi.Data.PrefDescValueType](/en/api/reference/webapi/SuperOffice.WebApi.Data.PrefDescValueType.md)
