Known users.
Catalog: DataDictionary
Schema: Invantive
Alias: usr
Label: System Users
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
The columns of the view SYSTEMUSERS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CODE |
string(240) |
Code |
☐ |
Code. |
COMPANY_ID |
string(240) |
Company ID |
☐ |
ID of company of user. |
COMPANY_NAME |
string(240) |
Company Name |
☐ |
Name of company of user. |
COMPANY_PHONE |
string(240) |
Company Phone |
☐ |
Phone number of company of user. |
COMPANY_SIRET_NUMBER |
string(240) |
Company SIRET Number |
☐ |
SIRET number of company of user. |
COMPANY_VAT_NUMBER |
string(240) |
Company VAT Number |
☐ |
VAT number of company of user. |
COMPANY_WEB_SITE |
string(240) |
Company Web Site |
☐ |
Website of company of user. |
EMAIL_ADDRESS |
string(240) |
Email Address |
☐ |
Email address. |
FIRST_NAME |
string(240) |
First Name |
☐ |
First name. |
GENDER |
string(240) |
Gender |
☐ |
Gender. |
ID |
int32 |
ID |
☑ |
ID. |
LANGUAGE |
string(240) |
Language |
☐ |
Language. |
LAST_LOGON_TIME |
datetime |
Last Logon |
☐ |
Last Logon Time (UTC). |
LAST_NAME |
string(240) |
Last Name |
☐ |
Last name. |
LINKED_IN |
string(240) |
☐ |
LinkedIn account. |
|
LOG_ON_CODE |
string(240) |
Log On Code |
☐ |
Log on code. |
MIDDLE_NAME |
string(240) |
Middle Name |
☐ |
Middle name. |
MOBILE_NUMBER |
string(240) |
Mobile Number |
☐ |
Mobile phone number. |
NAME |
string(240) |
Name |
☐ |
Name. |
NATIONALITY |
string(240) |
Nationality |
☐ |
Nationality. |
PHONE_NUMBER |
string(240) |
Phone Number |
☐ |
Phone number. |
PICTURE_BLOB |
byte[] |
Picture |
☐ |
Binary representation of the picture of the user. |
PICTURE_MIME_TYPE |
string(240) |
MIME Type |
☐ |
MIME type of picture of user. |
PICTURE_URL |
string(240) |
Picture (URL) |
☐ |
URL to picture of user. |
SKYPE |
string(240) |
Skype |
☐ |
Skype address. |
TITLE |
string(240) |
Title |
☐ |
Title. |
string(240) |
☐ |
Twitter address. |
||
WEBSITE |
string(240) |
Website |
☐ |
Personal website. |
17-05-2021 11:57 Version 20.1.419-BETA+3191