SYSTEMUSERS: Data Dictionary System Users
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: System Users
Known users.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMUSERS 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 |
|---|---|---|---|---|---|
CODE |
varchar2 |
Code | Code. | ||
COGNITO_ |
varchar2 |
Cognito User ID | Identifier of the user in the Invantive Cloud user administration. | ||
COMPANY_ |
varchar2 |
User Company Address Line 1 | Address line 1 of the company of the user. | ||
COMPANY_ |
varchar2 |
User Company Address Line 2 | Address line 2 of the company of the user. | ||
COMPANY_ |
varchar2 |
User Company Address Line 3 | Address line 3 of the company of the user. | ||
COMPANY_ |
varchar2 |
Company BIC | BIC of company of user. | ||
COMPANY_ |
varchar2 |
Company City | City of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Chamber of Commerce Number | CoC number of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Country | Country of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Currency Code | Code of the currency the company of the user keeps its books in. | ||
COMPANY_ |
date |
User Company Established | Date established of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Email Address | Email address of the company of the user. | ||
COMPANY_ |
int32 |
User Company Employees | Number of employees of the company of the user. | ||
COMPANY_ |
varchar2 |
Company GLN Number | Global Location Number (GLN) of the company of the user. | ||
COMPANY_ |
varchar2 |
Company IBAN | IBAN of company of user. | ||
COMPANY_ |
varchar2 |
Company ID | ID of company of user. | ||
COMPANY_ |
varchar2 |
User Company Legal Structure | Legal structure of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Name | Name of company of user. | ||
COMPANY_ |
varchar2 |
User Company PayPal Identifier | PayPal identifier of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Phone | Phone number of company of user. | ||
COMPANY_ |
varchar2 |
Company ZIP Code | Postal code of the company of the user. | ||
COMPANY_ |
varchar2 |
Company RSIN Number | RSIN number of company of user. | ||
COMPANY_ |
varchar2 |
Company SIRET Number | SIRET number of company of user. | ||
COMPANY_ |
varchar2 |
Company State | State or province of the company of the user. | ||
COMPANY_ |
varchar2 |
User Company Tradenames | Tradenames of the company of the user. | ||
COMPANY_ |
varchar2 |
Company VAT Number | VAT number of company of user. | ||
COMPANY_ |
varchar2 |
Company Wage Tax Number | Wage tax number of the company of the user. | ||
COMPANY_ |
varchar2 |
Company Web Site | Website of company of user. | ||
EMAIL_ |
varchar2 |
Email Address | Email address. | ||
FIRST_ |
varchar2 |
First Name | First name. | ||
GENDER |
varchar2 |
Gender | Gender. | ||
ID |
number |
ID | ID. | ||
LANGUAGE |
varchar2 |
Language | Language. | ||
LAST_ |
datetime |
Last Logon | Last Logon Time (UTC). | ||
LAST_ |
varchar2 |
Last Name | Last name. | ||
LINKED_ |
varchar2 |
LinkedIn account. | |||
LOG_ |
varchar2 |
Log On Code | Log on code. | ||
MIDDLE_ |
varchar2 |
Middle Name | Middle name. | ||
MOBILE_ |
varchar2 |
Mobile Number | Mobile phone number. | ||
NAME |
varchar2 |
Name | Name. | ||
NATIONALITY |
varchar2 |
Nationality | Nationality. | ||
PHONE_ |
varchar2 |
Phone Number | Phone number. | ||
PICTURE_ |
blob |
Picture | Binary representation of the picture of the user. | ||
PICTURE_ |
varchar2 |
MIME Type | MIME type of picture of user. | ||
PICTURE_ |
varchar2 |
Picture (URL) | URL to picture of user. | ||
SKYPE |
varchar2 |
Skype | Skype address. | ||
TITLE |
varchar2 |
Title | Title. | ||
TWITTER |
varchar2 |
Twitter address. | |||
USER_ |
varchar2 |
User ID | Identifier of the user on the platform. | ||
WEBSITE |
varchar2 |
Website | Personal website. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: