SYSTEMUSERS: Data Dictionary System Users |
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 UniversalSQL 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.
View Columns
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_ADDRESS_LINE_1 |
string(240) |
|
☐ |
Address line 1 of the company of the user. |
COMPANY_ADDRESS_LINE_2 |
string(240) |
|
☐ |
Address line 2 of the company of the user. |
COMPANY_BIC |
string(240) |
Company BIC |
☐ |
BIC of company of user. |
COMPANY_CITY |
string(240) |
Company City |
☐ |
City of the company of the user. |
COMPANY_COC_NUMBER |
string(240) |
Company Chamber of Commerce Number |
☐ |
CoC number of the company of the user. |
COMPANY_DATE_ESTABLISHED |
datetime |
|
☐ |
Date established of the company of the user. |
COMPANY_EMAIL_ADDRESS |
string(240) |
Company Email Address |
☐ |
Email address of the company of the user. |
COMPANY_EMPLOYEES |
int32 |
|
☐ |
Number of employees of the company of the user. |
COMPANY_IBAN |
string(240) |
Company IBAN |
☐ |
IBAN of company of user. |
COMPANY_ID |
string(240) |
Company ID |
☐ |
ID of company of user. |
COMPANY_LEGAL_STRUCTURE |
string(240) |
|
☐ |
Legal structure of the company of the user. |
COMPANY_NAME |
string(240) |
Company Name |
☐ |
Name of company of user. |
COMPANY_PAYPAL_IDENTIFIER |
string(240) |
|
☐ |
PayPal identifier of the company of the user. |
COMPANY_PHONE |
string(240) |
Company Phone |
☐ |
Phone number of company of user. |
COMPANY_RSIN_NUMBER |
string(240) |
Company RSIN Number |
☐ |
RSIN number of company of user. |
COMPANY_SIRET_NUMBER |
string(240) |
Company SIRET Number |
☐ |
SIRET number of company of user. |
COMPANY_TRADENAMES |
string(240) |
|
☐ |
Tradenames of the company of the 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. |
18-10-2024 06:49 Version 24.0.345-PROD+4945