---
title: "SYSTEMUSERS (Data Dictionary)"
description: "System Users"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMUSERS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMUSERS
updated: 2026-11-16T20:45:49Z
license: https://documentation.invantive.eu/nl/
---

# SYSTEMUSERS: Data Dictionary System Users

`read only`

- Catalogus: `DataDictionary`
- Schema: `Invantive`
- Label: System Users

Known users.

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `SYSTEMUSERS` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CODE` | `varchar2(240)` | Code | [ ] |  | Code. |
| `COGNITO_USER_ID` | `varchar2(240)` | Cognito Gebruikers-ID | [ ] |  | Identifier of the user in the Invantive Cloud user administration. |
| `COMPANY_ADDRESS_LINE_1` | `varchar2(240)` | Gebruiker Bedrijf Adresregel 1 | [ ] |  | Address line 1 of the company of the user. |
| `COMPANY_ADDRESS_LINE_2` | `varchar2(240)` | Gebruiker Bedrijf Adresregel 2 | [ ] |  | Address line 2 of the company of the user. |
| `COMPANY_ADDRESS_LINE_3` | `varchar2(240)` | Gebruiker Bedrijf Adresregel 3 | [ ] |  | Address line 3 of the company of the user. |
| `COMPANY_BIC` | `varchar2(240)` | Bedrijf BIC | [ ] |  | BIC of company of user. |
| `COMPANY_CITY` | `varchar2(240)` | Bedrijf Stad | [ ] |  | City of the company of the user. |
| `COMPANY_COC_NUMBER` | `varchar2(240)` | Bedrijf Kamer van Koophandel Nummer | [ ] |  | CoC number of the company of the user. |
| `COMPANY_COUNTRY` | `varchar2(240)` | Bedrijf Land | [ ] |  | Country of the company of the user. |
| `COMPANY_CURRENCY_CODE` | `varchar2(240)` | Bedrijf Valutacode | [ ] |  | Code of the currency the company of the user keeps its books in. |
| `COMPANY_DATE_ESTABLISHED` | `date` | Gebruiker Bedrijf Opgericht | [ ] |  | Date established of the company of the user. |
| `COMPANY_EMAIL_ADDRESS` | `varchar2(240)` | Zakelijk E-mailadres | [ ] |  | Email address of the company of the user. |
| `COMPANY_EMPLOYEES` | `int32` | Gebruiker Bedrijf Medewerkers | [ ] |  | Number of employees of the company of the user. |
| `COMPANY_GLN_NUMBER` | `varchar2(240)` | Bedrijf GLN-nummer | [ ] |  | Global Location Number (GLN) of the company of the user. |
| `COMPANY_IBAN` | `varchar2(240)` | Bedrijf IBAN | [ ] |  | IBAN of company of user. |
| `COMPANY_ID` | `varchar2(240)` | Bedrijf ID | [ ] |  | ID of company of user. |
| `COMPANY_LEGAL_STRUCTURE` | `varchar2(240)` | Gebruiker Bedrijf Juridische Structuur | [ ] |  | Legal structure of the company of the user. |
| `COMPANY_NAME` | `varchar2(240)` | Naam bedrijf | [ ] |  | Name of company of user. |
| `COMPANY_PAYPAL_IDENTIFIER` | `varchar2(240)` | Gebruiker Bedrijf PayPal-ID | [ ] |  | PayPal identifier of the company of the user. |
| `COMPANY_PHONE` | `varchar2(240)` | Bedrijf Telefoon | [ ] |  | Phone number of company of user. |
| `COMPANY_POSTAL_CODE` | `varchar2(240)` | Bedrijf Postcode | [ ] |  | Postal code of the company of the user. |
| `COMPANY_RSIN_NUMBER` | `varchar2(240)` | Bedrijf RSIN Nummer | [ ] |  | RSIN number  of company of user. |
| `COMPANY_SIRET_NUMBER` | `varchar2(240)` | Bedrijf SIRET-nummer | [ ] |  | SIRET number  of company of user. |
| `COMPANY_STATE` | `varchar2(240)` | Bedrijf Staat | [ ] |  | State or province of the company of the user. |
| `COMPANY_TRADENAMES` | `varchar2(240)` | Gebruiker Bedrijf Handelsnamen | [ ] |  | Tradenames of the company of the user. |
| `COMPANY_VAT_NUMBER` | `varchar2(240)` | Bedrijf BTW Nummer | [ ] |  | VAT number of company of user. |
| `COMPANY_WAGE_TAX_NUMBER` | `varchar2(240)` | Bedrijf Loonbelastingnummer | [ ] |  | Wage tax number of the company of the user. |
| `COMPANY_WEB_SITE` | `varchar2(240)` | Bedrijfswebsite | [ ] |  | Website of company of user. |
| `EMAIL_ADDRESS` | `varchar2(240)` | E-mailadres | [ ] |  | Email address. |
| `FIRST_NAME` | `varchar2(240)` | Voornaam | [ ] |  | First name. |
| `GENDER` | `varchar2(240)` | Gender | [ ] |  | Gender. |
| `ID` | `number` | ID | [x] |  | ID. |
| `LANGUAGE` | `varchar2(240)` | Language | [ ] |  | Language. |
| `LAST_LOGON_TIME` | `datetime` | Laatste Aanmelding | [ ] |  | Last Logon Time (UTC). |
| `LAST_NAME` | `varchar2(240)` | Achternaam | [ ] |  | Last name. |
| `LINKED_IN` | `varchar2(240)` | LinkedIn | [ ] |  | LinkedIn account. |
| `LOG_ON_CODE` | `varchar2(240)` | Aanmeldcode | [ ] |  | Log on code. |
| `MIDDLE_NAME` | `varchar2(240)` | Tussenvoegsel | [ ] |  | Middle name. |
| `MOBILE_NUMBER` | `varchar2(240)` | Mobielnummer | [ ] |  | Mobile phone number. |
| `NAME` | `varchar2(240)` | Name | [ ] |  | Name. |
| `NATIONALITY` | `varchar2(240)` | Nationality | [ ] |  | Nationality. |
| `PHONE_NUMBER` | `varchar2(240)` | Telefoonnummer | [ ] |  | 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)` | Afbeelding (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)` | Gebruikers-ID | [ ] |  | Identifier of the user on the platform. |
| `WEBSITE` | `varchar2(240)` | Website | [ ] |  | Personal website. |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Data Dictionary](/nl/release-notes/drivers?driver=data-dictionary)
