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