invantive documentation
Invantive Support ForumsLog In / Sign Up

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_FAILEDLOGONS int32 Failed Logons
ACCOUNT_LASTLOGON datetime Last Logon Moment the user logged on last, in the time zone of the platform.
ACCOUNT_SSO varchar2 Single Sign-on
CODE varchar2 Code Code of the user.
COMPANY_CODE varchar2 Company ID
COMPANY_NAME varchar2 Company Name
CREATED datetime Created
CULTURE varchar2 Culture The culture Twinfield is shown in, such as nl-NL or en-GB.
CULTURE_NAME varchar2 Culture Name
CULTURE_NATIVENAME varchar2 Culture Native Name
DEMO char Demo Whether the user serves training purposes only.
EMAIL varchar2 Email
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_DEFAULT varchar2 Default Office Company the user starts in.
OFFICE_DEFAULT_NAME varchar2 Default Office Name
OFFICE_RESTRICTED 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_LEVEL varchar2 Role Level
ROLE_NAME varchar2 Role Name
ROLE_SHORTNAME varchar2 Role Short Name
SHORTNAME varchar2 Short Name
SMSLOGIN_PHONENUMBER 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_COUNT 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

All changes of the driver, 26.0 to 27.0