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

# Me: Exact Online Me

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

- Katalog: `ExactOnlineREST`
- Schema: `System`
- Primärschlüssel: `UserID`
- Label: Me

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## API-Quelle

- Endpunkt: `/api/v1/current/Me`
- Metadaten: `/api/v1/current/$metadata`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 7,200 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Tabellenspalten

Die Spalten der Tabelle `Me` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `AccountingDivision` | `int32` | Abteilung Buchhaltung | [ ] | filters on the platform, writable | Accounting division number. |
| `Application` | `varchar2(240)` | Application | [x] | writable | Application being used. |
| `CurrentDivision` | `int32` | Aktueller Geschäftsbereich | [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` | Kunde-Code | [ ] | Filter auf der Plattform |  |
| `DataContainerID` | `varchar2` | Datenkontainer ID | [x] | writable | ID of the data container. |
| `Division` | `int32` | Abteilung ID | [x] | writable | Division number of the user. |
| `DivisionCustomer` | `guid` | Geschäftsbereich Kunden | [ ] | filters on the platform, writable | Owner account of the division. |
| `DivisionCustomerCode` | `varchar2(18)` | Geschäftsbereichskundennummer | [ ] | filters on the platform, writable | Owner account code of the division. |
| `DivisionCustomerName` | `varchar2` | Abteilung Kundenname | [ ] | filters on the platform, writable | Owner account name of the division. |
| `DivisionCustomerSiretNumber` | `varchar2` | Geschäftsbereich Kunden-Siret-Nummer | [ ] | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. |
| `DivisionCustomerVatNumber` | `varchar2(35)` | Division Kundenumsatzsteuernummer | [ ] | filters on the platform, writable | Owner account VAT Number of the division. |
| `DivisionLabel` | `varchar2(128)` | Abteilungsbezeichnung | [x] | writable | Label of the division. |
| `DossierDivision` | `int32` | Dateiabteilung | [ ] | filters on the platform, writable | Dossier division number (optional). |
| `Email` | `varchar2(128)` | Email | [ ] | filters on the platform, writable | E-Mail-Adresse des Benutzers. |
| `EmployeeID` | `guid` | Mitarbeiter ID | [ ] | filters on the platform, writable | Employee ID. |
| `EnvironmentApiBaseUrl` | `varchar2(60)` | Basis-URL der Exact Online Environment API | [x] | writable | API base URL of the Exact Online environment. |
| `EnvironmentTopLevelDomain` | `varchar2(30)` | Exact Online-Umgebung – Top-Level-Domain | [x] | writable | Top-level domain of the Exact Online environment. |
| `FirstName` | `varchar2(64)` | Vorname | [ ] | filters on the platform, writable | First name. |
| `FullName` | `varchar2(240)` | Vollständiger 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` | Ist Buchhaltungsabonnement | [x] | writable | Whether the user is connected using an accountancy subscription. |
| `IsClientUser` | `char` | Ist Kundebenutzer | [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] | Filter auf der Plattform |  |
| `IsEntrepreneurSubscription` | `char` | Ist ein Unternehmerabonnement | [x] | writable | Whether the user is connected using an entrepreneur subscription. |
| `IsMyFirmLiteUser` | `char` | Bin ich ein „Firm Lite“-Nutzer? | [x] | Filter auf der Plattform |  |
| `IsMyFirmPortalUser` | `char` | Ist Meine Firma Portalbenutzer | [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] | Filter auf der Plattform |  |
| `IsStarterUser` | `char` | Ist Starter-Benutzer | [x] | Filter auf der Plattform |  |
| `Language` | `varchar2(30)` | Language | [ ] | filters on the platform, writable | Language spoken by this user. |
| `LanguageCode` | `varchar2(30)` | Sprachen-Code | [ ] | filters on the platform, writable | Language (culture) that is used in Exact Online. |
| `LastName` | `varchar2(60)` | Nachname | [ ] | filters on the platform, writable | Last name. |
| `Legislation` | `int64` | Legislation | [x] | filters on the platform, writable | Legislation. |
| `MiddleName` | `varchar2` | Zweiter 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 | [ ] | Filter auf der Plattform |  |
| `Phone` | `varchar2(25)` | Phone | [ ] | filters on the platform, writable | Phone number. |
| `PhoneExtension` | `varchar2(15)` | Telefon-Durchwahl | [ ] | filters on the platform, writable | Phone number extension. |
| `PictureUrl` | `varchar2` | Bild (URL) | [ ] | filters on the platform, writable | Url that can be used to retrieve the picture of the user. |
| `ServerTime` | `varchar2` | Serverzeit | [ ] | 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 Bild | [ ] | filters on the platform, writable | Binary thumbnail picture of this user. |
| `ThumbnailPictureFormat` | `varchar2` | Thumbnail Bild Format | [ ] | filters on the platform, writable | File type of the picture. |
| `Title` | `varchar2` | Title | [ ] | filters on the platform, writable | Title. |
| `UserCustomerAddressLine1` | `varchar2` | Adresse des Kunden – Zeile 1 | [ ] | writable | Address line 1 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine2` | `varchar2` | Adresse des Kunden – Zeile 2 | [ ] | writable | Address line 2 of the owning customer of the subscription and user account. |
| `UserCustomerAddressLine3` | `varchar2` | Adresse des Kunden – Zeile 3 | [ ] | writable | Address line 3 of the owning customer of the subscription and user account. |
| `UserCustomerChamberOfCommerceNumber` | `varchar2` | Benutzer-CoC-Nummer | [ ] | writable | Chamber of Commerce number of the owning customer of the subscription and user account. |
| `UserCustomerCity` | `varchar2` | Benutzer Kunde Ort | [ ] | writable | City of the owning customer of the subscription and user account. |
| `UserCustomerCode` | `varchar2` | Benutzer-Kundennummer | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerCountry` | `varchar2` | Benutzer Kunde Land | [ ] | writable | Country of the owning customer of the subscription and user account. |
| `UserCustomerCurrencyCode` | `varchar2` | Benutzer Kunde Währung | [ ] | writable | Currency code of the owning customer of the subscription and user account. |
| `UserCustomerDescription` | `varchar2` | Benutzer-Kundenbeschreibung | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerEmail` | `varchar2` | Benutzer, Kunde, E-Mail-Adresse | [ ] | writable | Email of the owning customer of the subscription and user account. |
| `UserCustomerId` | `guid` | Benutzer-Kunden-ID | [x] | writable | ID of the owning customer of the subscription and user account. |
| `UserCustomerPhone` | `varchar2` | Benutzer Kunde Telefon | [ ] | writable | Phone of the owning customer of the subscription and user account. |
| `UserCustomerPostalCode` | `varchar2` | Benutzer Kunde Postleitzahl | [ ] | writable | Postal code of the owning customer of the subscription and user account. |
| `UserCustomerRsinNumber` | `varchar2` | Benutzer-Kunden-RSIN-Nummer | [ ] | writable | RSIN number of the owning customer of the subscription and user account. |
| `UserCustomerSiretNumber` | `varchar2` | Siret-Nummer des Kunden | [ ] | writable | SIRET number of the owning customer of the subscription and user account. |
| `UserCustomerState` | `varchar2` | Benutzer-Kundenstatus | [ ] | writable | State of the owning customer of the subscription and user account. |
| `UserCustomerVatNumber` | `varchar2` | Umsatzsteuer-Identifikationsnummer des Kunden | [ ] | writable | VAT number of the owning customer of the subscription and user account. |
| `UserCustomerWebsite` | `varchar2` | Benutzer-Kunden-Website | [ ] | writable | Website of the owning customer of the subscription and user account. |
| `UserID` | `guid` | Benutzer-Kennung | [x] | filters on the platform, writable | Primary key. |
| `UserName` | `varchar2` | Benutzername | [ ] | filters on the platform, writable | Login name of the user. |

## Tasten

| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
| `Me_EmployeeID_Employees_fk` | `EmployeeID` | [Employees](ExactOnlineREST.Payroll.Employees)`.ID` | Key |  |

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


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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