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 | Code of customer in Exact Online division 1. | ||
DIVISION_ |
int32 |
Number of Divisions | Number of divisions of the customer. | ||
DIVISION_ |
int32 |
Number of Active Divisions | Number of divisions of the customer. | ||
DIVISION_ |
int32 |
Number of Archived Divisions | Number of divisions of the customer. | ||
DIVISION_ |
int32 |
Number of Inactive Divisions | Number of divisions of the customer. | ||
DIVISION_ |
int32 |
Number of Main Divisions | Number of divisions of the customer. | ||
DIVISION_ |
int32 |
First Active Division | Number of first active division of the customer. | ||
DIVISION_ |
int32 |
First Archived Division | Number of first archived division of the customer. | ||
DIVISION_ |
int32 |
First Division Code | Number of first division of the customer. | ||
DIVISION_ |
varchar2 |
First Division Description | Name of first division of the customer. | ||
DIVISION_ |
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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: