invantive documentation
Invantive Support ForumsLog In / Sign Up

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_CNT int32 Number of Divisions 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 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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: