# Me: Exact Online Me - Catalog: `ExactOnlineREST` - Schema: `System` - Primary Keys: `UserID` - Label: Me Can retrieve data and change data using insert, update and delete. ## 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 | Documentation | |---|:---:|---|:---:|---| | `AccountingDivision` | `int32` | Accounting Division | ☐ | Accounting division number. | | `Application` | `varchar2`(240) | Application | ☑ | Application being used. | | `CurrentDivision` | `int32` | Current Division | ☑ | Division number that is currently used in the API. You should use a division number in the url. | | `CustomerCode` | `varchar2` | Customer Code | ☐ | | | `DataContainerID` | `varchar2` | Data Container ID | ☑ | ID of the data container. | | `Division` | `int32` | Division ID | ☑ | Division number of the user. | | `DivisionCustomer` | `guid` | Division Customer | ☐ | Owner account of the division. | | `DivisionCustomerCode` | `varchar2`(18) | Division Customer Code | ☐ | Owner account code of the division. | | `DivisionCustomerName` | `varchar2` | Division Customer Name | ☐ | Owner account name of the division. | | `DivisionCustomerSiretNumber` | `varchar2` | Division Customer Siret Number | ☐ | Owner account SIRET Number of the division for French legislation. | | `DivisionCustomerVatNumber` | `varchar2`(35) | Division Customer VAT Number | ☐ | Owner account VAT Number of the division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the division. | | `DossierDivision` | `int32` | File Division | ☐ | Dossier division number (optional). | | `Email` | `varchar2`(128) | Email | ☐ | Email address of the user. | | `EmployeeID` | `guid` | Employee ID | ☐ | Employee ID. | | `EnvironmentApiBaseUrl` | `varchar2`(60) | Exact Online Environment API Base URL | ☑ | API base URL of the Exact Online environment. | | `EnvironmentTopLevelDomain` | `varchar2`(30) | Exact Online Environment Top-level Domain | ☑ | Top-level domain of the Exact Online environment. | | `FirstName` | `varchar2`(64) | First Name | ☐ | First name. | | `FullName` | `varchar2`(240) | Full Name | ☐ | Full name of the user. | | `Gender` | `varchar2`(1) | Gender | ☐ | Gender: M=Male, V=Female, O=Unknown. | | `Initials` | `varchar2`(10) | Initials | ☐ | Initials. | | `IsAccountancySubscription` | `char` | Is Accountancy Subscription | ☑ | Whether the user is connected using an accountancy subscription. | | `IsClientUser` | `char` | Is Client User | ☑ | Client user of an accountant: either a portal user or a non-accountant user with his own license (internal use). | | `IsEmployeeSelfServiceUser` | `char` | | ☑ | | | `IsEntrepreneurSubscription` | `char` | Is Entrepreneur Subscription | ☑ | Whether the user is connected using an entrepreneur subscription. | | `IsMyFirmLiteUser` | `char` | Is My Firm Lite User | ☑ | | | `IsMyFirmPortalUser` | `char` | Is My Firm Portal User | ☑ | MyFirm user of accountant with limited access and specific start page (internal use). | | `IsOEIMigrationMandatory` | `char` | | ☑ | | | `IsStarterUser` | `char` | Is Starter User | ☑ | | | `Language` | `varchar2`(30) | Language | ☐ | Language spoken by this user. | | `LanguageCode` | `varchar2`(30) | Language Code | ☐ | Language (culture) that is used in Exact Online. | | `LastName` | `varchar2`(60) | Last Name | ☐ | Last name. | | `Legislation` | `int64` | Legislation | ☑ | Legislation. | | `MiddleName` | `varchar2` | Middle Name | ☐ | Middle name. | | `Mobile` | `varchar2`(25) | Mobile | ☐ | Mobile phone. | | `Nationality` | `varchar2` | Nationality | ☐ | Nationality. | | `PackageCode` | `varchar2` | | ☐ | | | `Phone` | `varchar2`(25) | Phone | ☐ | Phone number. | | `PhoneExtension` | `varchar2`(15) | Phone Extension | ☐ | Phone number extension. | | `PictureUrl` | `varchar2` | Picture (URL) | ☐ | Url that can be used to retrieve the picture of the user. | | `ServerTime` | `varchar2` | Server Time | ☐ | The current date and time in Exact Online. | | `ServerUtcOffset` | `double` | Server UTC Offset | ☑ | The time difference with UTC in seconds. | | `ThumbnailPicture` | `blob` | Thumbnail Picture | ☐ | Binary thumbnail picture of this user. | | `ThumbnailPictureFormat` | `varchar2` | Thumbnail Picture Format | ☐ | File type of the picture. | | `Title` | `varchar2` | Title | ☐ | Title. | | `UserCustomerAddressLine1` | `varchar2` | | ☐ | Address line 1 of the owning customer of the subscription and user account. | | `UserCustomerAddressLine2` | `varchar2` | | ☐ | Address line 2 of the owning customer of the subscription and user account. | | `UserCustomerAddressLine3` | `varchar2` | | ☐ | Address line 3 of the owning customer of the subscription and user account. | | `UserCustomerChamberOfCommerceNumber` | `varchar2` | User Customer CoC Number | ☐ | Chamber of Commerce number of the owning customer of the subscription and user account. | | `UserCustomerCity` | `varchar2` | User Customer City | ☐ | City of the owning customer of the subscription and user account. | | `UserCustomerCode` | `varchar2` | User Customer Code | ☑ | ID of the owning customer of the subscription and user account. | | `UserCustomerCountry` | `varchar2` | | ☐ | Country of the owning customer of the subscription and user account. | | `UserCustomerCurrencyCode` | `varchar2` | | ☐ | Currency code of the owning customer of the subscription and user account. | | `UserCustomerDescription` | `varchar2` | User Customer Description | ☑ | ID of the owning customer of the subscription and user account. | | `UserCustomerEmail` | `varchar2` | User Customer Email | ☐ | Email of the owning customer of the subscription and user account. | | `UserCustomerId` | `guid` | User Customer ID | ☑ | ID of the owning customer of the subscription and user account. | | `UserCustomerPhone` | `varchar2` | User Customer Phone | ☐ | Phone of the owning customer of the subscription and user account. | | `UserCustomerPostalCode` | `varchar2` | | ☐ | Postal code of the owning customer of the subscription and user account. | | `UserCustomerRsinNumber` | `varchar2` | | ☐ | RSIN number of the owning customer of the subscription and user account. | | `UserCustomerSiretNumber` | `varchar2` | | ☐ | SIRET number of the owning customer of the subscription and user account. | | `UserCustomerState` | `varchar2` | | ☐ | State of the owning customer of the subscription and user account. | | `UserCustomerVatNumber` | `varchar2` | | ☐ | VAT number of the owning customer of the subscription and user account. | | `UserCustomerWebsite` | `varchar2` | User Customer Website | ☐ | Website of the owning customer of the subscription and user account. | | `UserID` | `guid` | User ID | ☑ | Primary key. | | `UserName` | `varchar2` | User Name | ☐ | Login name of the user. |