Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

SYSTEMUSERS: Data Dictionary System Users

Contents Previous Home Next More

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.

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_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

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.

TWITTER

string(240)

Twitter

Twitter address.

WEBSITE

string(240)

Website

Personal website.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191