---
title: "Me (Exact Online)"
description: "Me"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/exactonline/ExactOnlineREST.System.Me
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.System.Me
updated: 2026-11-16T20:58:11Z
license: https://documentation.invantive.eu/es/
---

# Me: Exact Online Me

`insert` `update` `delete` `REST`

- Catálogo: `ExactOnlineREST`
- Esquema: `System`
- Llaves Primarias: `UserID`
- Label: Me

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

## Fuente de la API

- Punto final: `/api/v1/current/Me`
- Metadatos: `/api/v1/current/$metadata`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 7,200 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |

El resultado se puede almacenar en la Caché del cliente.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `Me`. 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 |
|---|---|---|:---:|---|---|
| `AccountingDivision` | `int32` | División de Contabilidad | [ ] | filters on the platform, writable | Accounting division number. |
| `Application` | `varchar2(240)` | Application | [x] | writable | Application being used. |
| `CurrentDivision` | `int32` | División Actual | [x] | filters on the platform, writable | Division number that is currently used in the API.You should use a division number in the url. |
| `CustomerCode` | `varchar2` | Código de Cliente | [ ] | filtros de la plataforma |  |
| `DataContainerID` | `varchar2` | ID del Contenedor de Datos | [x] | writable | ID of the data container. |
| `Division` | `int32` | ID de la Empresa | [x] | writable | Division number of the user. |
| `DivisionCustomer` | `guid` | Cliente de la división | [ ] | filters on the platform, writable | Owner account of the division. |
| `DivisionCustomerCode` | `varchar2(18)` | Código de cliente de la división | [ ] | filters on the platform, writable | Owner account code of the division. |
| `DivisionCustomerName` | `varchar2` | Nombre del cliente de la división | [ ] | filters on the platform, writable | Owner account name of the division. |
| `DivisionCustomerSiretNumber` | `varchar2` | Número SIRET del cliente de la división | [ ] | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. |
| `DivisionCustomerVatNumber` | `varchar2(35)` | Número de IVA de la división | [ ] | filters on the platform, writable | Owner account VAT Number of the division. |
| `DivisionLabel` | `varchar2(128)` | Etiqueta de división | [x] | writable | Label of the division. |
| `DossierDivision` | `int32` | División de archivos | [ ] | filters on the platform, writable | Dossier division number (optional). |
| `Email` | `varchar2(128)` | Email | [ ] | filters on the platform, writable | Dirección de correo electrónico del usuario. |
| `EmployeeID` | `guid` | Identificación del Empleado | [ ] | filters on the platform, writable | Employee ID. |
| `EnvironmentApiBaseUrl` | `varchar2(60)` | URL base de la API de Exact Online Environment | [x] | writable | API base URL of the Exact Online environment. |
| `EnvironmentTopLevelDomain` | `varchar2(30)` | Dominio de primer nivel «Exact Online Environment» | [x] | writable | Top-level domain of the Exact Online environment. |
| `FirstName` | `varchar2(64)` | Primer Nombre | [ ] | filters on the platform, writable | First name. |
| `FullName` | `varchar2(240)` | Nombre Completo | [ ] | filters on the platform, writable | Full name of the user. |
| `Gender` | `varchar2(1)` | Gender | [ ] | filters on the platform, writable | Gender: M=Male, V=Female, O=Unknown. |
| `Initials` | `varchar2(10)` | Initials | [ ] | filters on the platform, writable | Initials. |
| `IsAccountancySubscription` | `char` | ¿Es una suscripción a un servicio de contabilidad? | [x] | writable | Whether the user is connected using an accountancy subscription. |
| `IsClientUser` | `char` | ¿Es un usuario cliente? | [x] | filters on the platform, writable | Client user of an accountant: either a portal user or a non-accountant user with his own license (internal use). |
| `IsEmployeeSelfServiceUser` | `char` | itgen_eol_isemployeeselfserviceuser | [x] | filtros de la plataforma |  |
| `IsEntrepreneurSubscription` | `char` | ¿Qué es la suscripción a Entrepreneur? | [x] | writable | Whether the user is connected using an entrepreneur subscription. |
| `IsMyFirmLiteUser` | `char` | ¿Soy usuario de la versión Lite de My Firm? | [x] | filtros de la plataforma |  |
| `IsMyFirmPortalUser` | `char` | ¿Soy usuario del portal de mi empresa? | [x] | filters on the platform, writable | MyFirm user of accountant with limited access and specific start page (internal use). |
| `IsOEIMigrationMandatory` | `char` | itgen_eol_isoeimigrationmandatory | [x] | filtros de la plataforma |  |
| `IsStarterUser` | `char` | Es un usuario principiante | [x] | filtros de la plataforma |  |
| `Language` | `varchar2(30)` | Language | [ ] | filters on the platform, writable | Language spoken by this user. |
| `LanguageCode` | `varchar2(30)` | Código del idioma | [ ] | filters on the platform, writable | Language (culture) that is used in Exact Online. |
| `LastName` | `varchar2(60)` | Apellido | [ ] | filters on the platform, writable | Last name. |
| `Legislation` | `int64` | Legislation | [x] | filters on the platform, writable | Legislation. |
| `MiddleName` | `varchar2` | Segundo Nombre | [ ] | filters on the platform, writable | Middle name. |
| `Mobile` | `varchar2(25)` | Mobile | [ ] | filters on the platform, writable | Mobile phone. |
| `Nationality` | `varchar2` | Nationality | [ ] | filters on the platform, writable | Nationality. |
| `PackageCode` | `varchar2` | itgen_eol_packagecode | [ ] | filtros de la plataforma |  |
| `Phone` | `varchar2(25)` | Phone | [ ] | filters on the platform, writable | Phone number. |
| `PhoneExtension` | `varchar2(15)` | Extensión Telefónica | [ ] | filters on the platform, writable | Phone number extension. |
| `PictureUrl` | `varchar2` | Imagen (URL) | [ ] | filters on the platform, writable | Url that can be used to retrieve the picture of the user. |
| `ServerTime` | `varchar2` | Hora del Servidor | [ ] | filters on the platform, writable | The current date and time in Exact Online. |
| `ServerUtcOffset` | `double` | Desplazamiento UTC del Servidor | [x] | filters on the platform, writable | The time difference with UTC in seconds. |
| `ThumbnailPicture` | `blob` | Miniatura de Imagen | [ ] | filters on the platform, writable | Binary thumbnail picture of this user. |
| `ThumbnailPictureFormat` | `varchar2` | Formato de Miniatura de Imagen | [ ] | filters on the platform, writable | File type of the picture. |
| `Title` | `varchar2` | Title | [ ] | filters on the platform, writable | Title. |
| `UserCustomerAddressLine1` | `varchar2` | Dirección del cliente: línea 1 | [ ] | writable | Address line 1 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine2` | `varchar2` | Dirección del cliente: línea 2 | [ ] | writable | Address line 2 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine3` | `varchar2` | Dirección del cliente: línea 3 | [ ] | writable | Address line 3 of the owning customer of the subscription and user account. |
| `UserCustomerChamberOfCommerceNumber` | `varchar2` | Número de CoC del cliente | [ ] | writable | Chamber of Commerce number of the owning customer of the subscription and user account. |
| `UserCustomerCity` | `varchar2` | Usuario Cliente Ciudad | [ ] | writable | City of the owning customer of the subscription and user account. |
| `UserCustomerCode` | `varchar2` | Código de cliente del usuario | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerCountry` | `varchar2` | Usuario Cliente País | [ ] | writable | Country of the owning customer of the subscription and user account. |
| `UserCustomerCurrencyCode` | `varchar2` | Código de moneda del cliente | [ ] | writable | Currency code of the owning customer of the subscription and user account. |
| `UserCustomerDescription` | `varchar2` | Descripción del usuario/cliente | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerEmail` | `varchar2` | Correo electrónico del usuario/cliente | [ ] | writable | Email of the owning customer of the subscription and user account. |
| `UserCustomerId` | `guid` | ID de cliente del usuario | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerPhone` | `varchar2` | Usuario Cliente Teléfono | [ ] | writable | Phone of the owning customer of the subscription and user account. |
| `UserCustomerPostalCode` | `varchar2` | Código postal del cliente | [ ] | writable | Postal code of the owning customer of the subscription and user account. |
| `UserCustomerRsinNumber` | `varchar2` | Número RSIN del cliente | [ ] | writable | RSIN number of the owning customer of the subscription and user account. |
| `UserCustomerSiretNumber` | `varchar2` | Número SIRET del cliente | [ ] | writable | SIRET number of the owning customer of the subscription and user account. |
| `UserCustomerState` | `varchar2` | Estado del usuario/cliente | [ ] | writable | State of the owning customer of the subscription and user account. |
| `UserCustomerVatNumber` | `varchar2` | Número de IVA del cliente | [ ] | writable | VAT number of the owning customer of the subscription and user account. |
| `UserCustomerWebsite` | `varchar2` | Usuario Cliente Página web | [ ] | writable | Website of the owning customer of the subscription and user account. |
| `UserID` | `guid` | Identificación de Usuario | [x] | filters on the platform, writable | Primary key. |
| `UserName` | `varchar2` | Nombre de Usuario | [ ] | filters on the platform, writable | Login name of the user. |

## Teclas

| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
| `Me_EmployeeID_Employees_fk` | `EmployeeID` | [Employees](ExactOnlineREST.Payroll.Employees)`.ID` | Key |  |

## Ejemplos de queries

```sql
--
-- Financial transaction lines from all journals and selected companies. Note that LineNumber 0 reflects the header and 9999 the VAT.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-incremental-transactionlinesincremental.html
--
-- Related forum post: https://forums.invantive.eu/t/recommended-and-popular-exact-online-tables-for-2022/2340
--
select *
from   ExactOnlineREST.Incremental.TransactionLinesIncremental@eol
limit  100
```

```sql
--
-- Retrieve list of all Exact Online companies. For accountants, companies of customers are also included.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-system-systemdivisions.html
--
-- Related forum post: https://forums.invantive.eu/t/selecting-partitions-administrations-via-the-use-sql-statement/2172
--
select *
from   ExactOnlineREST.System.SystemDivisions@eol
limit  100
```


## Notas de la Versión

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

- [Exact Online](/es/release-notes/drivers?driver=exact-online)
