---
title: "SYSTEMUSERS (Data Dictionary)"
description: "System Users"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/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/es/
---

# SYSTEMUSERS: Data Dictionary System Users

`read only`

- Catálogo: `DataDictionary`
- Esquema: `Invantive`
- Label: System Users

Known users.

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `SYSTEMUSERS`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CODE` | `varchar2(240)` | Code | [ ] |  | Code. |
| `COGNITO_USER_ID` | `varchar2(240)` | ID de usuario de Cognito | [ ] |  | Identifier of the user in the Invantive Cloud user administration. |
| `COMPANY_ADDRESS_LINE_1` | `varchar2(240)` | Dirección de la empresa del usuario, línea 1 | [ ] |  | Address line 1 of the company of the user. |
| `COMPANY_ADDRESS_LINE_2` | `varchar2(240)` | Dirección de la empresa del usuario, línea 2 | [ ] |  | Address line 2 of the company of the user. |
| `COMPANY_ADDRESS_LINE_3` | `varchar2(240)` | Dirección de la empresa del usuario, línea 3 | [ ] |  | Address line 3 of the company of the user. |
| `COMPANY_BIC` | `varchar2(240)` | Empresa BIC | [ ] |  | BIC of company of user. |
| `COMPANY_CITY` | `varchar2(240)` | Ciudad de la empresa | [ ] |  | City of the company of the user. |
| `COMPANY_COC_NUMBER` | `varchar2(240)` | Número de la Cámara de Comercio de la Compañía | [ ] |  | CoC number of the company of the user. |
| `COMPANY_COUNTRY` | `varchar2(240)` | País de la empresa | [ ] |  | Country of the company of the user. |
| `COMPANY_CURRENCY_CODE` | `varchar2(240)` | Código de moneda de la empresa | [ ] |  | Code of the currency the company of the user keeps its books in. |
| `COMPANY_DATE_ESTABLISHED` | `date` | Empresa del usuario: Fundada | [ ] |  | Date established of the company of the user. |
| `COMPANY_EMAIL_ADDRESS` | `varchar2(240)` | Correo electrónico de la empresa | [ ] |  | Email address of the company of the user. |
| `COMPANY_EMPLOYEES` | `int32` | Empleados de la empresa del usuario | [ ] |  | Number of employees of the company of the user. |
| `COMPANY_GLN_NUMBER` | `varchar2(240)` | Número GLN de la empresa | [ ] |  | Global Location Number (GLN) of the company of the user. |
| `COMPANY_IBAN` | `varchar2(240)` | IBAN de la empresa | [ ] |  | IBAN of company of user. |
| `COMPANY_ID` | `varchar2(240)` | ID de la Empresa | [ ] |  | ID of company of user. |
| `COMPANY_LEGAL_STRUCTURE` | `varchar2(240)` | Estructura jurídica de la empresa del usuario | [ ] |  | Legal structure of the company of the user. |
| `COMPANY_NAME` | `varchar2(240)` | Nombre de la Compañía | [ ] |  | Name of company of user. |
| `COMPANY_PAYPAL_IDENTIFIER` | `varchar2(240)` | Identificador de PayPal de la empresa del usuario | [ ] |  | PayPal identifier of the company of the user. |
| `COMPANY_PHONE` | `varchar2(240)` | Teléfono de la Empresa | [ ] |  | Phone number of company of user. |
| `COMPANY_POSTAL_CODE` | `varchar2(240)` | Código postal de la empresa | [ ] |  | Postal code of the company of the user. |
| `COMPANY_RSIN_NUMBER` | `varchar2(240)` | Número RSIN de la empresa | [ ] |  | RSIN number  of company of user. |
| `COMPANY_SIRET_NUMBER` | `varchar2(240)` | Número SIRET de la empresa | [ ] |  | SIRET number  of company of user. |
| `COMPANY_STATE` | `varchar2(240)` | Estado de la empresa | [ ] |  | State or province of the company of the user. |
| `COMPANY_TRADENAMES` | `varchar2(240)` | Nombres comerciales de la empresa del usuario | [ ] |  | Tradenames of the company of the user. |
| `COMPANY_VAT_NUMBER` | `varchar2(240)` | Número de IVA de la empresa | [ ] |  | VAT number of company of user. |
| `COMPANY_WAGE_TAX_NUMBER` | `varchar2(240)` | Número de impuesto salarial de la empresa | [ ] |  | Wage tax number of the company of the user. |
| `COMPANY_WEB_SITE` | `varchar2(240)` | Sitio web de la empresa | [ ] |  | Website of company of user. |
| `EMAIL_ADDRESS` | `varchar2(240)` | Dirección de Correo Electrónico | [ ] |  | Email address. |
| `FIRST_NAME` | `varchar2(240)` | Primer Nombre | [ ] |  | First name. |
| `GENDER` | `varchar2(240)` | Gender | [ ] |  | Gender. |
| `ID` | `number` | ID | [x] |  | ID. |
| `LANGUAGE` | `varchar2(240)` | Language | [ ] |  | Language. |
| `LAST_LOGON_TIME` | `datetime` | Último inicio de sesión | [ ] |  | Last Logon Time (UTC). |
| `LAST_NAME` | `varchar2(240)` | Apellido | [ ] |  | Last name. |
| `LINKED_IN` | `varchar2(240)` | LinkedIn | [ ] |  | LinkedIn account. |
| `LOG_ON_CODE` | `varchar2(240)` | Código de Inicio de Sesión | [ ] |  | Log on code. |
| `MIDDLE_NAME` | `varchar2(240)` | Segundo Nombre | [ ] |  | Middle name. |
| `MOBILE_NUMBER` | `varchar2(240)` | Número de Teléfono Móvil | [ ] |  | Mobile phone number. |
| `NAME` | `varchar2(240)` | Name | [ ] |  | Name. |
| `NATIONALITY` | `varchar2(240)` | Nationality | [ ] |  | Nationality. |
| `PHONE_NUMBER` | `varchar2(240)` | Número de Teléfono | [ ] |  | Phone number. |
| `PICTURE_BLOB` | `blob` | Picture | [ ] |  | Binary representation of the picture of the user. |
| `PICTURE_MIME_TYPE` | `varchar2(240)` | Tipo de MIME | [ ] |  | MIME type of picture of user. |
| `PICTURE_URL` | `varchar2(240)` | Imagen (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)` | Identificación de Usuario | [ ] |  | Identifier of the user on the platform. |
| `WEBSITE` | `varchar2(240)` | Website | [ ] |  | Personal website. |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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