invantive documentation
Invantive Support ForumsLog In / Sign Up

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(240) Code Code.
COGNITO_USER_ID varchar2(240) Cognito User ID Identifier of the user in the Invantive Cloud user administration.
COMPANY_ADDRESS_LINE_1 varchar2(240) User Company Address Line 1 Address line 1 of the company of the user.
COMPANY_ADDRESS_LINE_2 varchar2(240) User Company Address Line 2 Address line 2 of the company of the user.
COMPANY_ADDRESS_LINE_3 varchar2(240) User Company Address Line 3 Address line 3 of the company of the user.
COMPANY_BIC varchar2(240) Company BIC BIC of company of user.
COMPANY_CITY varchar2(240) Company City City of the company of the user.
COMPANY_COC_NUMBER varchar2(240) Company Chamber of Commerce Number CoC number of the company of the user.
COMPANY_COUNTRY varchar2(240) Company Country Country of the company of the user.
COMPANY_CURRENCY_CODE varchar2(240) Company Currency Code Code of the currency the company of the user keeps its books in.
COMPANY_DATE_ESTABLISHED date User Company Established Date established of the company of the user.
COMPANY_EMAIL_ADDRESS varchar2(240) Company Email Address Email address of the company of the user.
COMPANY_EMPLOYEES int32 User Company Employees Number of employees of the company of the user.
COMPANY_GLN_NUMBER varchar2(240) Company GLN Number Global Location Number (GLN) of the company of the user.
COMPANY_IBAN varchar2(240) Company IBAN IBAN of company of user.
COMPANY_ID varchar2(240) Company ID ID of company of user.
COMPANY_LEGAL_STRUCTURE varchar2(240) User Company Legal Structure Legal structure of the company of the user.
COMPANY_NAME varchar2(240) Company Name Name of company of user.
COMPANY_PAYPAL_IDENTIFIER varchar2(240) User Company PayPal Identifier PayPal identifier of the company of the user.
COMPANY_PHONE varchar2(240) Company Phone Phone number of company of user.
COMPANY_POSTAL_CODE varchar2(240) Company ZIP Code Postal code of the company of the user.
COMPANY_RSIN_NUMBER varchar2(240) Company RSIN Number RSIN number of company of user.
COMPANY_SIRET_NUMBER varchar2(240) Company SIRET Number SIRET number of company of user.
COMPANY_STATE varchar2(240) Company State State or province of the company of the user.
COMPANY_TRADENAMES varchar2(240) User Company Tradenames Tradenames of the company of the user.
COMPANY_VAT_NUMBER varchar2(240) Company VAT Number VAT number of company of user.
COMPANY_WAGE_TAX_NUMBER varchar2(240) Company Wage Tax Number Wage tax number of the company of the user.
COMPANY_WEB_SITE varchar2(240) Company Web Site Website of company of user.
EMAIL_ADDRESS varchar2(240) Email Address Email address.
FIRST_NAME varchar2(240) First Name First name.
GENDER varchar2(240) Gender Gender.
ID number ID ID.
LANGUAGE varchar2(240) Language Language.
LAST_LOGON_TIME datetime Last Logon Last Logon Time (UTC).
LAST_NAME varchar2(240) Last Name Last name.
LINKED_IN varchar2(240) LinkedIn LinkedIn account.
LOG_ON_CODE varchar2(240) Log On Code Log on code.
MIDDLE_NAME varchar2(240) Middle Name Middle name.
MOBILE_NUMBER varchar2(240) Mobile Number Mobile phone number.
NAME varchar2(240) Name Name.
NATIONALITY varchar2(240) Nationality Nationality.
PHONE_NUMBER varchar2(240) Phone Number Phone number.
PICTURE_BLOB blob Picture Binary representation of the picture of the user.
PICTURE_MIME_TYPE varchar2(240) MIME Type MIME type of picture of user.
PICTURE_URL varchar2(240) Picture (URL) URL to picture of user.
SKYPE varchar2(240) Skype Skype address.
TITLE varchar2(240) Title Title.
TWITTER varchar2(240) Twitter Twitter address.
USER_ID varchar2(240) User ID Identifier of the user on the platform.
WEBSITE varchar2(240) Website Personal website.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: