UserSettingsByUserCode: Twinfield User Settings by User Code
read only per partition XML
- Catalog:
Twinfield - Schema:
Settings - Primary Keys:
code - Label: User Settings by User Code
The data in this table is partitioned per value of the COMPANY_CODE column.
Can only retrieve data.
Summary
Settings of one user, named by code. Every user of a company is answered by the view UserSettings. The nested blocks the answer also holds - the offices the user may see, the time and expenses settings and the SMS logon services - are not exposed, with the exception of the single-valued elements of each.
API Source
- XML service:
webservices/processxml.asmx - XML topic:
user - XML path:
/user
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 | 87 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
code |
`` | Code of the user to read. | ||
COMPANY_ |
`` | Code of company. |
Table Columns
The columns of the table UserSettingsByUserCode 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
Table function Twinfield.Settings.UserSettingsByUserCode is added
The table function has 35 columns and can select.
- importance 3