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

# Me: Exact Online Me

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

- Catalogue : `ExactOnlineREST`
- Schéma : `System`
- Clés primaires : `UserID`
- Label: Me

Permet de récupérer et de modifier des données à l'aide de `insert`, `update` et `delete`.

## Source de l'API

- Point de terminaison : `/api/v1/current/Me`
- Métadonnées : `/api/v1/current/$metadata`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 7,200 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |

Le résultat peut être mis en cache côté client.

## Colonnes de table

Les colonnes de la table `Me` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AccountingDivision` | `int32` | Service comptable | [ ] | filters on the platform, writable | Accounting division number. |
| `Application` | `varchar2(240)` | Application | [x] | writable | Application being used. |
| `CurrentDivision` | `int32` | Division actuelle | [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` | Code client | [ ] | filtres disponibles sur la plateforme |  |
| `DataContainerID` | `varchar2` | ID du conteneur de données | [x] | writable | ID of the data container. |
| `Division` | `int32` | ID de l'entreprise | [x] | writable | Division number of the user. |
| `DivisionCustomer` | `guid` | Division Clients | [ ] | filters on the platform, writable | Owner account of the division. |
| `DivisionCustomerCode` | `varchar2(18)` | Code client de la division | [ ] | filters on the platform, writable | Owner account code of the division. |
| `DivisionCustomerName` | `varchar2` | Division Nom du client | [ ] | filters on the platform, writable | Owner account name of the division. |
| `DivisionCustomerSiretNumber` | `varchar2` | Division - Numéro SIRET du client | [ ] | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. |
| `DivisionCustomerVatNumber` | `varchar2(35)` | Numéro de TVA client de la division | [ ] | filters on the platform, writable | Owner account VAT Number of the division. |
| `DivisionLabel` | `varchar2(128)` | Étiquette de division | [x] | writable | Label of the division. |
| `DossierDivision` | `int32` | Division des fichiers | [ ] | filters on the platform, writable | Dossier division number (optional). |
| `Email` | `varchar2(128)` | Email | [ ] | filters on the platform, writable | Adresse e-mail de l'utilisateur. |
| `EmployeeID` | `guid` | ID d'employé | [ ] | filters on the platform, writable | Employee ID. |
| `EnvironmentApiBaseUrl` | `varchar2(60)` | URL de base de l'API Exact Online Environment | [x] | writable | API base URL of the Exact Online environment. |
| `EnvironmentTopLevelDomain` | `varchar2(30)` | Domaine de premier niveau « Exact Online Environment » | [x] | writable | Top-level domain of the Exact Online environment. |
| `FirstName` | `varchar2(64)` | Prénom | [ ] | filters on the platform, writable | First name. |
| `FullName` | `varchar2(240)` | Nom complet pour utilisation dans les listes | [ ] | 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` | Abonnement à « Accountancy » | [x] | writable | Whether the user is connected using an accountancy subscription. |
| `IsClientUser` | `char` | Est-ce un utilisateur client ? | [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] | filtres disponibles sur la plateforme |  |
| `IsEntrepreneurSubscription` | `char` | Abonnement à Entrepreneur | [x] | writable | Whether the user is connected using an entrepreneur subscription. |
| `IsMyFirmLiteUser` | `char` | Suis-je un utilisateur de la version Lite de My Firm ? | [x] | filtres disponibles sur la plateforme |  |
| `IsMyFirmPortalUser` | `char` | Je suis un utilisateur du portail de mon cabinet | [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] | filtres disponibles sur la plateforme |  |
| `IsStarterUser` | `char` | Est-il un utilisateur débutant ? | [x] | filtres disponibles sur la plateforme |  |
| `Language` | `varchar2(30)` | Language | [ ] | filters on the platform, writable | Language spoken by this user. |
| `LanguageCode` | `varchar2(30)` | Code de langue | [ ] | filters on the platform, writable | Language (culture) that is used in Exact Online. |
| `LastName` | `varchar2(60)` | Nom | [ ] | filters on the platform, writable | Last name. |
| `Legislation` | `int64` | Legislation | [x] | filters on the platform, writable | Legislation. |
| `MiddleName` | `varchar2` | Deuxième prénom | [ ] | 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 | [ ] | filtres disponibles sur la plateforme |  |
| `Phone` | `varchar2(25)` | Phone | [ ] | filters on the platform, writable | Phone number. |
| `PhoneExtension` | `varchar2(15)` | Poste téléphonique | [ ] | filters on the platform, writable | Phone number extension. |
| `PictureUrl` | `varchar2` | Image (URL) | [ ] | filters on the platform, writable | Url that can be used to retrieve the picture of the user. |
| `ServerTime` | `varchar2` | Temps de serveur | [ ] | filters on the platform, writable | The current date and time in Exact Online. |
| `ServerUtcOffset` | `double` | Décalage horaire UTC du serveur | [x] | filters on the platform, writable | The time difference with UTC in seconds. |
| `ThumbnailPicture` | `blob` | Vignette | [ ] | filters on the platform, writable | Binary thumbnail picture of this user. |
| `ThumbnailPictureFormat` | `varchar2` | Format des vignettes | [ ] | filters on the platform, writable | File type of the picture. |
| `Title` | `varchar2` | Title | [ ] | filters on the platform, writable | Title. |
| `UserCustomerAddressLine1` | `varchar2` | Adresse du client – Ligne 1 | [ ] | writable | Address line 1 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine2` | `varchar2` | Adresse du client – Ligne 2 | [ ] | writable | Address line 2 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine3` | `varchar2` | Adresse du client – Ligne 3 | [ ] | writable | Address line 3 of the owning customer of the subscription and user account. |
| `UserCustomerChamberOfCommerceNumber` | `varchar2` | Numéro CoC de l'utilisateur/client | [ ] | writable | Chamber of Commerce number of the owning customer of the subscription and user account. |
| `UserCustomerCity` | `varchar2` | Utilisateur Client Ville | [ ] | writable | City of the owning customer of the subscription and user account. |
| `UserCustomerCode` | `varchar2` | Code client de l'utilisateur | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerCountry` | `varchar2` | Utilisateur Client Pays | [ ] | writable | Country of the owning customer of the subscription and user account. |
| `UserCustomerCurrencyCode` | `varchar2` | Code de devise du client utilisateur | [ ] | writable | Currency code of the owning customer of the subscription and user account. |
| `UserCustomerDescription` | `varchar2` | Description du client utilisateur | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerEmail` | `varchar2` | Adresse e-mail de l'utilisateur/client | [ ] | writable | Email of the owning customer of the subscription and user account. |
| `UserCustomerId` | `guid` | Identifiant client | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerPhone` | `varchar2` | Utilisateur Client Téléphone | [ ] | writable | Phone of the owning customer of the subscription and user account. |
| `UserCustomerPostalCode` | `varchar2` | Code postal du client | [ ] | writable | Postal code of the owning customer of the subscription and user account. |
| `UserCustomerRsinNumber` | `varchar2` | Numéro RSIN de l'utilisateur/client | [ ] | writable | RSIN number of the owning customer of the subscription and user account. |
| `UserCustomerSiretNumber` | `varchar2` | Numéro SIRET du client | [ ] | writable | SIRET number of the owning customer of the subscription and user account. |
| `UserCustomerState` | `varchar2` | État de l'utilisateur/client | [ ] | writable | State of the owning customer of the subscription and user account. |
| `UserCustomerVatNumber` | `varchar2` | Numéro de TVA de l'utilisateur/client | [ ] | writable | VAT number of the owning customer of the subscription and user account. |
| `UserCustomerWebsite` | `varchar2` | Site web destiné aux utilisateurs et aux clients | [ ] | writable | Website of the owning customer of the subscription and user account. |
| `UserID` | `guid` | ID utilisateur | [x] | filters on the platform, writable | Primary key. |
| `UserName` | `varchar2` | Nom d'Utilisateur | [ ] | filters on the platform, writable | Login name of the user. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `Me_EmployeeID_Employees_fk` | `EmployeeID` | [Employees](ExactOnlineREST.Payroll.Employees)`.ID` | Key |  |

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


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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