# AllUsers: Exact Online Users across All Customers Users across All Customers ## Documentation: All users across all customers.chr(13) || chr(10) || chr(13) || chr(10)chr(13) || chr(10) || chr(13) || chr(10)Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- division - Catalog: `ExactOnlineXML` - Schema: `XML` - Alias: `aur` - Primary Keys: `id_attr` - Label: Users across All Customers This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. - Filters on API Server: division ## View Columns The columns of the view `AllUsers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUTHENTICATION_ATTR` | `number` | Authentication | | Possible values: 0=No login rights, 4=Federated authentication (EIS), 10=Forms and TOTP authentication | | `BIRTHDATE` | `date` | Birth Date | | | | `BIRTHNAME` | `varchar2` | Birth Name | | | | `BIRTHNAMEPREFIX` | `varchar2` | Birth Name Prefix | | | | `DIVISION_CODE` | `varchar2` | Administration ID | ☑ | Internal unique number of the Exact Online administration. | | `DIVISION_HID` | `int64` | Administration | ☑ | Number of the Exact Online administration. Not guaranteed to be unique. | | `DIVISION_NAME` | `varchar2`(240) | Administration Name | ☑ | Name of the Exact Online administration. Not guaranteed to be unique. | | `EMAIL` | `varchar2` | Email | | | | `ENDDATE` | `date` | End Date | | End date: YYYY-MM-DD | | `FAX` | `varchar2` | Fax | | | | `FIRSTNAME` | `varchar2` | First Name | | | | `FULLNAME` | `varchar2` | Full Name | | | | `GENDER_ATTR` | `varchar2` | Gender | | | | `ID_ATTR` | `varchar2` | ID | ☑ | | | `IMAGE_BINARYDATA` | `blob` | Image Binary Data | | | | `IMAGE_ID_ATTR` | `varchar2` | Image ID | | | | `IMAGE_NAME` | `varchar2` | Image Name | | | | `INITIALS` | `varchar2` | Initials | | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `ISANONYMISED` | `boolean` | Is Anonymised | | | | `LANGUAGE_CODE_ATTR` | `varchar2` | Language Code | | | | `LANGUAGE_DESCRIPTION_TERMID_ATTR` | `number` | Language Description Term ID | | | | `LANGUAGE_DESCRIPTION` | `varchar2`(255) | Language Description | | | | `LASTNAME` | `varchar2` | Last Name | | | | `MIDDLENAME` | `varchar2` | Middle Name | | | | `MOBILE` | `varchar2` | Mobile | | | | `NATIONALITY_CODE_ATTR` | `varchar2` | Nationality Code | | | | `NATIONALITY_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `NATIONALITY_DESCRIPTION` | `varchar2`(255) | Nationality Description | | | | `NICKNAME` | `varchar2` | Nick Name | | | | `NOTE` | `varchar2` | Note | | Notes can contain many different characters, make sure to use a CDATA section. | | `PARTNERNAME` | `varchar2` | Name of Partner | | | | `PARTNERNAMEPREFIX` | `varchar2` | Partner Name Prefix | | | | `PHONE` | `varchar2` | Phone | | | | `PHONEEXT` | `varchar2` | Phone Extension | | | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. | | `SOCIALSECURITYNUMBER` | `varchar2` | Social Security Number | | | | `STARTDATE` | `date` | Start Date | | Start date: YYYY-MM-DD | | `TITLE_ABBREVIATION` | `varchar2` | Title Abbreviation | | | | `TITLE_CODE_ATTR` | `varchar2` | Title Code | | | | `TITLE_DESCRIPTION_TERMID_ATTR` | `number` | Title Description Term ID | | | | `TITLE_DESCRIPTION` | `varchar2`(255) | Title Description | | | | `TITLE_GENDER` | `varchar2` | Title Gender | | | | `TITLE_HEADING` | `varchar2` | Title Heading | | | | `TITLE_LANGUAGE` | `varchar2` | Title Language | | | | `USERADMINISTRATIONS` | `varchar2` | User Administrations | | | | `USERNAME_ATTR` | `varchar2` | User Name | ☑ | | | `USERTYPES` | `varchar2` | User Types | | |