# AllAdministrationCustomers: Exact Online Administration Customers All Administration Customers ## Documentation: All Exact Online customers licensed.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: `acr` - Primary Keys: `code` - Label: Administration 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 `AllAdministrationCustomers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CODE` | `varchar2` | Code | ☑ | Code of customer in Exact Online division 1. | | `DIVISION_CNT_ACTIVE` | `int32` | Number of Active Divisions | ☐ | Number of divisions of the customer. | | `DIVISION_CNT_ARCHIVED` | `int32` | Number of Archived Divisions | ☐ | Number of divisions of the customer. | | `DIVISION_CNT_INACTIVE` | `int32` | Number of Inactive Divisions | ☐ | Number of divisions of the customer. | | `DIVISION_CNT_MAIN` | `int32` | Number of Main Divisions | ☐ | Number of divisions of the customer. | | `DIVISION_CNT` | `int32` | Number of Divisions | ☑ | Number of divisions of the customer. | | `DIVISION_FIRST_ACTIVE` | `int32` | First Active Division | ☐ | Number of first active division of the customer. | | `DIVISION_FIRST_ARCHIVED` | `int32` | First Archived Division | ☐ | Number of first archived division of the customer. | | `DIVISION_FIRST_CODE` | `int32` | First Division Code | ☑ | Number of first division of the customer. | | `DIVISION_FIRST_DESCRIPTION` | `varchar2` | First Division Description | ☑ | Name of first division of the customer. | | `DIVISION_FIRST_INACTIVE` | `int32` | First Inactive Division | ☐ | Number of first inactive division of the customer. | | `ID` | `guid` | ID | ☑ | Incrementing ID of the transaction. | | `NAME` | `varchar2` | Name | ☑ | Name. | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. |