---
title: "Me (Exact Online)"
description: "Me"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/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/it/
---

# Me: Exact Online Me

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

- Catalogo: `ExactOnlineREST`
- Schema: `System`
- Chiavi primarie: `UserID`
- Label: Me

È possibile recuperare e modificare i dati utilizzando `insert`, `update` e `delete`.

## Codice sorgente dell'API

- Punto finale: `/api/v1/current/Me`
- Metadati: `/api/v1/current/$metadata`

## Caratteristiche prestazionali

| Characteristic | Value |
|---|---:|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |

Il risultato può essere memorizzato nella memoria cache sul client.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `Me`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AccountingDivision` | `int32` | Divisione della Contabilità | [ ] | filters on the platform, writable | Accounting division number. |
| `Application` | `varchar2(240)` | Application | [x] | writable | Application being used. |
| `CurrentDivision` | `int32` | Divisione attuale | [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` | Codice del Cliente | [ ] | filtri sulla piattaforma |  |
| `DataContainerID` | `varchar2` | ID di contenitore di dati | [x] | writable | ID of the data container. |
| `Division` | `int32` | ID dell'azienda | [x] | writable | Division number of the user. |
| `DivisionCustomer` | `guid` | Divisione Clienti | [ ] | filters on the platform, writable | Owner account of the division. |
| `DivisionCustomerCode` | `varchar2(18)` | Codice cliente della divisione | [ ] | filters on the platform, writable | Owner account code of the division. |
| `DivisionCustomerName` | `varchar2` | Divisione Nome cliente | [ ] | filters on the platform, writable | Owner account name of the division. |
| `DivisionCustomerSiretNumber` | `varchar2` | Divisione - Numero SIRET del cliente | [ ] | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. |
| `DivisionCustomerVatNumber` | `varchar2(35)` | Partita IVA del cliente della divisione | [ ] | filters on the platform, writable | Owner account VAT Number of the division. |
| `DivisionLabel` | `varchar2(128)` | Etichetta della divisione | [x] | writable | Label of the division. |
| `DossierDivision` | `int32` | Divisione File | [ ] | filters on the platform, writable | Dossier division number (optional). |
| `Email` | `varchar2(128)` | Email | [ ] | filters on the platform, writable | Indirizzo e-mail dell'utente. |
| `EmployeeID` | `guid` | ID dell'impiegato | [ ] | filters on the platform, writable | Employee ID. |
| `EnvironmentApiBaseUrl` | `varchar2(60)` | URL di base dell'API di Exact Online Environment | [x] | writable | API base URL of the Exact Online environment. |
| `EnvironmentTopLevelDomain` | `varchar2(30)` | Dominio di primo livello "Exact Online Environment" | [x] | writable | Top-level domain of the Exact Online environment. |
| `FirstName` | `varchar2(64)` | Nome | [ ] | filters on the platform, writable | First name. |
| `FullName` | `varchar2(240)` | Nome completo per l'uso nelle liste | [ ] | 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` | È un abbonamento ai servizi di contabilità? | [x] | writable | Whether the user is connected using an accountancy subscription. |
| `IsClientUser` | `char` | È un utente 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] | filtri sulla piattaforma |  |
| `IsEntrepreneurSubscription` | `char` | Abbonamento a Entrepreneur | [x] | writable | Whether the user is connected using an entrepreneur subscription. |
| `IsMyFirmLiteUser` | `char` | Sono un utente di My Firm Lite? | [x] | filtri sulla piattaforma |  |
| `IsMyFirmPortalUser` | `char` | Sono un utente del portale della mia azienda? | [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] | filtri sulla piattaforma |  |
| `IsStarterUser` | `char` | È un utente principiante | [x] | filtri sulla piattaforma |  |
| `Language` | `varchar2(30)` | Language | [ ] | filters on the platform, writable | Language spoken by this user. |
| `LanguageCode` | `varchar2(30)` | Codice della lingua | [ ] | filters on the platform, writable | Language (culture) that is used in Exact Online. |
| `LastName` | `varchar2(60)` | Cognome | [ ] | filters on the platform, writable | Last name. |
| `Legislation` | `int64` | Legislation | [x] | filters on the platform, writable | Legislation. |
| `MiddleName` | `varchar2` | Secondo nome | [ ] | 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 | [ ] | filtri sulla piattaforma |  |
| `Phone` | `varchar2(25)` | Phone | [ ] | filters on the platform, writable | Phone number. |
| `PhoneExtension` | `varchar2(15)` | Estensione del telefono | [ ] | filters on the platform, writable | Phone number extension. |
| `PictureUrl` | `varchar2` | Immagine (URL) | [ ] | filters on the platform, writable | Url that can be used to retrieve the picture of the user. |
| `ServerTime` | `varchar2` | Ora del server | [ ] | filters on the platform, writable | The current date and time in Exact Online. |
| `ServerUtcOffset` | `double` | Differenza rispetto all'UTC del server | [x] | filters on the platform, writable | The time difference with UTC in seconds. |
| `ThumbnailPicture` | `blob` | Immagine in miniatura | [ ] | filters on the platform, writable | Binary thumbnail picture of this user. |
| `ThumbnailPictureFormat` | `varchar2` | Formato dell'immagine in miniatura | [ ] | filters on the platform, writable | File type of the picture. |
| `Title` | `varchar2` | Title | [ ] | filters on the platform, writable | Title. |
| `UserCustomerAddressLine1` | `varchar2` | Indirizzo del cliente - Riga 1 | [ ] | writable | Address line 1 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine2` | `varchar2` | Indirizzo del cliente - Riga 2 | [ ] | writable | Address line 2 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine3` | `varchar2` | Indirizzo del cliente - Riga 3 | [ ] | writable | Address line 3 of the owning customer of the subscription and user account. |
| `UserCustomerChamberOfCommerceNumber` | `varchar2` | Numero del codice fiscale del cliente utente | [ ] | writable | Chamber of Commerce number of the owning customer of the subscription and user account. |
| `UserCustomerCity` | `varchar2` | Città del cliente utente | [ ] | writable | City of the owning customer of the subscription and user account. |
| `UserCustomerCode` | `varchar2` | Codice cliente utente | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerCountry` | `varchar2` | Utente Cliente Paese | [ ] | writable | Country of the owning customer of the subscription and user account. |
| `UserCustomerCurrencyCode` | `varchar2` | Utente Cliente Codice Valuta | [ ] | writable | Currency code of the owning customer of the subscription and user account. |
| `UserCustomerDescription` | `varchar2` | Descrizione dell'utente/cliente | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerEmail` | `varchar2` | E-mail del cliente utente | [ ] | writable | Email of the owning customer of the subscription and user account. |
| `UserCustomerId` | `guid` | ID cliente utente | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerPhone` | `varchar2` | Telefono del cliente utente | [ ] | writable | Phone of the owning customer of the subscription and user account. |
| `UserCustomerPostalCode` | `varchar2` | Codice postale del cliente | [ ] | writable | Postal code of the owning customer of the subscription and user account. |
| `UserCustomerRsinNumber` | `varchar2` | Numero RSIN del cliente | [ ] | writable | RSIN number of the owning customer of the subscription and user account. |
| `UserCustomerSiretNumber` | `varchar2` | Numero SIRET del cliente | [ ] | writable | SIRET number of the owning customer of the subscription and user account. |
| `UserCustomerState` | `varchar2` | Stato dell'utente/cliente | [ ] | writable | State of the owning customer of the subscription and user account. |
| `UserCustomerVatNumber` | `varchar2` | Partita IVA del cliente | [ ] | writable | VAT number of the owning customer of the subscription and user account. |
| `UserCustomerWebsite` | `varchar2` | Sito web del cliente utente | [ ] | writable | Website of the owning customer of the subscription and user account. |
| `UserID` | `guid` | ID Utente | [x] | filters on the platform, writable | Primary key. |
| `UserName` | `varchar2` | Nome Utente | [ ] | filters on the platform, writable | Login name of the user. |

## Chiavi

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

## Esempi di Query

```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
```


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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