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

# AllAdministrationCustomers: Exact Online Administration Customers

`read only` `XML`

- Catalog: `ExactOnlineXML`
- Schema: `XML`
- Primary Keys: `code`
- Label: Administration Customers

All Administration Customers

Can only retrieve data.

## Summary

All Exact Online customers licensed.

Additional where-clause columns supported:
- division

## API Source

- XML topic: `AllAdministrationCustomers`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Estimated rows | 500 |
| Estimated size (bytes) | 0 |

The result can be cached on the client.

## Table Columns

The columns of the table `AllAdministrationCustomers` 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 |
|---|---|---|:---:|---|---|
| `CODE` | `varchar2` | Code | [x] |  | Code of customer in Exact Online division 1. |
| `DIVISION_CNT` | `int32` | Number of Divisions | [x] |  | Number of divisions of the customer. |
| `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_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 | [x] |  | Number of first division of the customer. |
| `DIVISION_FIRST_DESCRIPTION` | `varchar2` | First Division Description | [x] |  | 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 | [x] |  | Incrementing ID of the transaction. |
| `NAME` | `varchar2` | Name | [x] |  | Name. |
| `ROWNUM` | `int64` | Row Number | [x] |  | Number of the row within the results, starting at 1. |



## 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)

