invantive documentation
Invantive Support ForumsLog In / Sign Up

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 `` 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 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/acceptExtraCost Whether extra costs are accepted when the role of the user changes.
ACCOUNT_FAILEDLOGONS int32 Failed Logons /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/account/failedlogons
ACCOUNT_LASTLOGON datetime Last Logon /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/account/lastlogon Moment the user logged on last, in the time zone of the platform.
ACCOUNT_SSO varchar2 Single Sign-on /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/account/sso
CODE varchar2 Code /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/code Code of the user.
COMPANY_CODE varchar2 Company ID
COMPANY_NAME varchar2 Company Name
CREATED datetime Created /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/created
CULTURE varchar2 Culture /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/culture The culture Twinfield is shown in, such as nl-NL or en-GB.
CULTURE_NAME varchar2 Culture Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/culture/name
CULTURE_NATIVENAME varchar2 Culture Native Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/culture/nativename
DEMO char Demo /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/demo Whether the user serves training purposes only.
EMAIL varchar2 Email /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/email
EXCHANGEQUOTA int32 Exchange Quota /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/exchangequota Twinfield Analysis quota.
FILEMANAGERQUOTA int32 File Manager Quota /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/filemanagerquota
INVITATIONSTATUS varchar2 Invitation Status /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/invitationstatus One of NotInvited, Invited or Active, on the Wolters Kluwer account of the user.
ISCURRENTUSER char Is Current User /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/iscurrentuser Whether this is the user the connection logged on with.
LEVEL varchar2 Level /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/level
MODIFIED datetime Modified /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/modified
NAME varchar2 Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/name
NAMEVIEW varchar2 Name View /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/nameview
OFFICE_DEFAULT varchar2 Default Office /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/office/default Company the user starts in.
OFFICE_DEFAULT_NAME varchar2 Default Office Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/office/default/name
OFFICE_RESTRICTED char Office Restricted /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/office/restricted Whether the user is restricted to the companies listed, rather than seeing every company of the organisation.
ROLE varchar2 Role /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/role Code of the role the user is linked to.
ROLE_LEVEL varchar2 Role Level /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/role/level
ROLE_NAME varchar2 Role Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/role/name
ROLE_SHORTNAME varchar2 Role Short Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/role/shortname
SHORTNAME varchar2 Short Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/shortname
SMSLOGIN_PHONENUMBER varchar2 SMS Logon Phone Number /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/smslogin/phonenumber Number the SMS is sent to when the SMS logon package is enabled.
STATUS varchar2 Status /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/status One of active, deleted or hide. A user used in a transaction becomes hidden rather than deleted.
SUPPORT varchar2 Support /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/support
SUPPORT_COUNT int32 Support Count /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/support/count
TOUCHED int32 Touched /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/touched Count of the number of times the settings were changed.
TYPE varchar2 Type /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/user/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

All changes of the driver, 26.0 to 27.0