UserSettings: Twinfield User Settings
read only
- Catalog:
Twinfield - Schema:
Views - Label: User Settings
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 54 |
| Full scan rows per minute | 1,690 |
| Point query rows per minute | 1,111 |
| Write rows per minute | 378 |
The result can be cached on the client.
Table Columns
The columns of the table UserSettings are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACCEPTEXTRACOST |
char |
Accept Extra Cost | Whether extra costs are accepted when the role of the user changes. | ||
ACCOUNT_ |
int32 |
Failed Logons | |||
ACCOUNT_ |
datetime |
Last Logon | Moment the user logged on last, in the time zone of the platform. | ||
ACCOUNT_ |
varchar2 |
Single Sign-on | |||
CODE |
varchar2 |
Code | Code of the user. | ||
COMPANY_ |
varchar2 |
Company ID | |||
COMPANY_ |
varchar2 |
Company Name | |||
CREATED |
datetime |
Created | |||
CULTURE |
varchar2 |
Culture | The culture Twinfield is shown in, such as nl-NL or en-GB. | ||
CULTURE_ |
varchar2 |
Culture Name | |||
CULTURE_ |
varchar2 |
Culture Native Name | |||
DEMO |
char |
Demo | Whether the user serves training purposes only. | ||
EMAIL |
varchar2 |
||||
EXCHANGEQUOTA |
int32 |
Exchange Quota | Twinfield Analysis quota. | ||
FILEMANAGERQUOTA |
int32 |
File Manager Quota | |||
INVITATIONSTATUS |
varchar2 |
Invitation Status | One of NotInvited, Invited or Active, on the Wolters Kluwer account of the user. | ||
ISCURRENTUSER |
char |
Is Current User | Whether this is the user the connection logged on with. | ||
LEVEL |
varchar2 |
Level | |||
MODIFIED |
datetime |
Modified | |||
NAME |
varchar2 |
Name | |||
NAMEVIEW |
varchar2 |
Name View | |||
OFFICE_ |
varchar2 |
Default Office | Company the user starts in. | ||
OFFICE_ |
varchar2 |
Default Office Name | |||
OFFICE_ |
char |
Office Restricted | Whether the user is restricted to the companies listed, rather than seeing every company of the organisation. | ||
ROLE |
varchar2 |
Role | Code of the role the user is linked to. | ||
ROLE_ |
varchar2 |
Role Level | |||
ROLE_ |
varchar2 |
Role Name | |||
ROLE_ |
varchar2 |
Role Short Name | |||
SHORTNAME |
varchar2 |
Short Name | |||
SMSLOGIN_ |
varchar2 |
SMS Logon Phone Number | Number the SMS is sent to when the SMS logon package is enabled. | ||
STATUS |
varchar2 |
Status | One of active, deleted or hide. A user used in a transaction becomes hidden rather than deleted. | ||
SUPPORT |
varchar2 |
Support | |||
SUPPORT_ |
int32 |
Support Count | |||
TOUCHED |
int32 |
Touched | Count of the number of times the settings were changed. | ||
TYPE |
varchar2 |
Type | One of accountant, accountantcustomer or regular. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
View Twinfield.Views.UserSettings is added
The view has 35 columns and can select.
- importance 3