---
title: "Me (Exact Online)"
description: "Me"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.System.Me
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.System.Me
updated: 2026-11-01T17:55:09Z
license: https://documentation.invantive.eu/en/
---

# Me: Exact Online Me

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

- Catalog: `ExactOnlineREST`
- Schema: `System`
- Primary Keys: `UserID`
- Label: Me

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/api/v1/current/Me`
- Metadata: `/api/v1/current/$metadata`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |

The result can be cached on the client.

## Table Columns

The columns of the table `Me` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AccountingDivision` | `int32` | Accounting Division | [ ] | filters on the platform, writable | Accounting division number. |
| `Application` | `varchar2(240)` | Application | [x] | writable | Application being used. |
| `CurrentDivision` | `int32` | Current Division | [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` | Customer Code | [ ] | filters on the platform |  |
| `DataContainerID` | `varchar2` | Data Container ID | [x] | writable | ID of the data container. |
| `Division` | `int32` | Division ID | [x] | writable | Division number of the user. |
| `DivisionCustomer` | `guid` | Division Customer | [ ] | filters on the platform, writable | Owner account of the division. |
| `DivisionCustomerCode` | `varchar2(18)` | Division Customer Code | [ ] | filters on the platform, writable | Owner account code of the division. |
| `DivisionCustomerName` | `varchar2` | Division Customer Name | [ ] | filters on the platform, writable | Owner account name of the division. |
| `DivisionCustomerSiretNumber` | `varchar2` | Division Customer Siret Number | [ ] | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. |
| `DivisionCustomerVatNumber` | `varchar2(35)` | Division Customer VAT Number | [ ] | filters on the platform, writable | Owner account VAT Number of the division. |
| `DivisionLabel` | `varchar2(128)` | Division Label | [x] | writable | Label of the division. |
| `DossierDivision` | `int32` | File Division | [ ] | filters on the platform, writable | Dossier division number (optional). |
| `Email` | `varchar2(128)` | Email | [ ] | filters on the platform, writable | Email address of the user. |
| `EmployeeID` | `guid` | Employee ID | [ ] | filters on the platform, writable | Employee ID. |
| `EnvironmentApiBaseUrl` | `varchar2(60)` | Exact Online Environment API Base URL | [x] | writable | API base URL of the Exact Online environment. |
| `EnvironmentTopLevelDomain` | `varchar2(30)` | Exact Online Environment Top-level Domain | [x] | writable | Top-level domain of the Exact Online environment. |
| `FirstName` | `varchar2(64)` | First Name | [ ] | filters on the platform, writable | First name. |
| `FullName` | `varchar2(240)` | Full Name | [ ] | 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` | Is Accountancy Subscription | [x] | writable | Whether the user is connected using an accountancy subscription. |
| `IsClientUser` | `char` | Is Client User | [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] | filters on the platform |  |
| `IsEntrepreneurSubscription` | `char` | Is Entrepreneur Subscription | [x] | writable | Whether the user is connected using an entrepreneur subscription. |
| `IsMyFirmLiteUser` | `char` | Is My Firm Lite User | [x] | filters on the platform |  |
| `IsMyFirmPortalUser` | `char` | Is My Firm Portal User | [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] | filters on the platform |  |
| `IsStarterUser` | `char` | Is Starter User | [x] | filters on the platform |  |
| `Language` | `varchar2(30)` | Language | [ ] | filters on the platform, writable | Language spoken by this user. |
| `LanguageCode` | `varchar2(30)` | Language Code | [ ] | filters on the platform, writable | Language (culture) that is used in Exact Online. |
| `LastName` | `varchar2(60)` | Last Name | [ ] | filters on the platform, writable | Last name. |
| `Legislation` | `int64` | Legislation | [x] | filters on the platform, writable | Legislation. |
| `MiddleName` | `varchar2` | Middle Name | [ ] | 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 | [ ] | filters on the platform |  |
| `Phone` | `varchar2(25)` | Phone | [ ] | filters on the platform, writable | Phone number. |
| `PhoneExtension` | `varchar2(15)` | Phone Extension | [ ] | filters on the platform, writable | Phone number extension. |
| `PictureUrl` | `varchar2` | Picture (URL) | [ ] | filters on the platform, writable | Url that can be used to retrieve the picture of the user. |
| `ServerTime` | `varchar2` | Server Time | [ ] | filters on the platform, writable | The current date and time in Exact Online. |
| `ServerUtcOffset` | `double` | Server UTC Offset | [x] | filters on the platform, writable | The time difference with UTC in seconds. |
| `ThumbnailPicture` | `blob` | Thumbnail Picture | [ ] | filters on the platform, writable | Binary thumbnail picture of this user. |
| `ThumbnailPictureFormat` | `varchar2` | Thumbnail Picture Format | [ ] | filters on the platform, writable | File type of the picture. |
| `Title` | `varchar2` | Title | [ ] | filters on the platform, writable | Title. |
| `UserCustomerAddressLine1` | `varchar2` | User Customer Address Line 1 | [ ] | writable | Address line 1 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine2` | `varchar2` | User Customer Address Line 2 | [ ] | writable | Address line 2 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine3` | `varchar2` | User Customer Address Line 3 | [ ] | writable | Address line 3 of the owning customer of the subscription and user account. |
| `UserCustomerChamberOfCommerceNumber` | `varchar2` | User Customer CoC Number | [ ] | writable | Chamber of Commerce number of the owning customer of the subscription and user account. |
| `UserCustomerCity` | `varchar2` | User Customer City | [ ] | writable | City of the owning customer of the subscription and user account. |
| `UserCustomerCode` | `varchar2` | User Customer Code | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerCountry` | `varchar2` | User Customer Country | [ ] | writable | Country of the owning customer of the subscription and user account. |
| `UserCustomerCurrencyCode` | `varchar2` | User Customer Currency Code | [ ] | writable | Currency code of the owning customer of the subscription and user account. |
| `UserCustomerDescription` | `varchar2` | User Customer Description | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerEmail` | `varchar2` | User Customer Email | [ ] | writable | Email of the owning customer of the subscription and user account. |
| `UserCustomerId` | `guid` | User Customer ID | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerPhone` | `varchar2` | User Customer Phone | [ ] | writable | Phone of the owning customer of the subscription and user account. |
| `UserCustomerPostalCode` | `varchar2` | User Customer Postal Code | [ ] | writable | Postal code of the owning customer of the subscription and user account. |
| `UserCustomerRsinNumber` | `varchar2` | User Customer RSIN Number | [ ] | writable | RSIN number of the owning customer of the subscription and user account. |
| `UserCustomerSiretNumber` | `varchar2` | User Customer Siret Number | [ ] | writable | SIRET number of the owning customer of the subscription and user account. |
| `UserCustomerState` | `varchar2` | User Customer State | [ ] | writable | State of the owning customer of the subscription and user account. |
| `UserCustomerVatNumber` | `varchar2` | User Customer VAT Number | [ ] | writable | VAT number of the owning customer of the subscription and user account. |
| `UserCustomerWebsite` | `varchar2` | User Customer Website | [ ] | writable | Website of the owning customer of the subscription and user account. |
| `UserID` | `guid` | User ID | [x] | filters on the platform, writable | Primary key. |
| `UserName` | `varchar2` | User Name | [ ] | filters on the platform, writable | Login name of the user. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `Me_EmployeeID_Employees_fk` | `EmployeeID` | [Employees](ExactOnlineREST.Payroll.Employees)`.ID` | Key |  |

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



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

