# AllAdministrationAssignedTypes: Exact Online All Administration Assigned Types
All Administration Assigned Types
## Documentation:
Types assigned to administrations 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: `aat`
- Label: All Administration Assigned Types
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 `AllAdministrationAssignedTypes` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `ADMINISTRATIONTYPES_ADMINISTRATION_ACTIVITYSECTOR_CODE_ATTR` | `varchar2` | Activity Sector Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_ACTIVITYSUBSECTOR_CODE_ATTR` | `varchar2` | Activity Sub Sector Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_ADDRESSLINE1` | `varchar2` | Administration Address Line 1 | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_ADDRESSLINE2` | `varchar2` | Administration Address Line 2 | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_ADDRESSLINE3` | `varchar2` | Administration Address Line 3 | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_BLOCKINGSTATUS` | `varchar2` | Administration Blocking Status | | 0=Not blocked,
1=Backup,
2=Conversion busy,
3=Conversion shadow,
4=Conversion waiting,
5=Copy data waiting,
6=Copy data busy |
| `ADMINISTRATIONTYPES_ADMINISTRATION_BUSINESSTYPE_CODE_ATTR` | `varchar2` | Administration Business Type Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CHAMBEROFCOMMERCE` | `varchar2` | Administration Chamber of Commerce | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CHAMBEROFCOMMERCEESTABLISHMENT` | `varchar2` | Administration Chamber of Commerce Establishment | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CITY` | `varchar2` | Administration City | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CODE_ATTR` | `varchar2` | Administration Code | | The internal unique code of the administration. |
| `ADMINISTRATIONTYPES_ADMINISTRATION_COMPANYSIZE_CODE_ATTR` | `varchar2` | Administration Company Size Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_COUNTRY_CODE_ATTR` | `varchar2` | Country Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_COUNTRY_DESCRIPTION_TERMID_ATTR` | `number` | | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_COUNTRY_DESCRIPTION` | `varchar2`(255) | Country Description | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CURRENCY_CODE_ATTR` | `varchar2` | Administration Currency Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CURRENCY_DESCRIPTION_TERMID_ATTR` | `number` | | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_CURRENCY_DESCRIPTION` | `varchar2`(255) | Administration Currency Description | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_DIGITALPOSTBOXES` | `varchar2` | Administration Digital Post Boxes | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_DIVISIONCLASSNAMES` | `varchar2` | Administration Division Class Names | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_EMAIL` | `varchar2` | Administration Email | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_ENDDATE` | `date` | Administration End Date | | End date: YYYY-MM-DD |
| `ADMINISTRATIONTYPES_ADMINISTRATION_ETTSOURCE` | `varchar2` | Administration ETT Source | | 0=Not applicable,
1=ProAcc PersProf,
2=ProAcc Corporate,
3=ProAcc Studio,
4=Cubic,
5=Globe,
6=ExactOnLine,
7=Winbooks,
8=Auditfile - Twinfield,
9=Auditfile - Microsoft Navision Attain,
10=Auditfile - iMUIS,
11=Auditfile - Reeleezee Audit,
12=Auditfile - SAP SBO NL,
13=Auditfile - Yuki,
14=Auditfile - Snelstart
Reserve [15 to 18] for dataswitcher conversion sources, not displaying it in documentation
15=DataSwitcher - Vero
16=DataSwitcher - SageBob
17=DataSwitcher - ExpertM
18=DataSwitcher - Adsolut |
| `ADMINISTRATIONTYPES_ADMINISTRATION_FAX` | `varchar2` | Administration Fax | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_HOMEPAGE` | `varchar2` | Administration Home Page | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_NAME` | `varchar2` | Administration Name | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_NUMBER_ATTR` | `number` | Administration Number | | The external code of the administration as shown in the administration card. |
| `ADMINISTRATIONTYPES_ADMINISTRATION_PHONE` | `varchar2` | Administration Phone | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_PHONEEXT` | `varchar2` | Administration Phone Extension | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_POSTCODE` | `varchar2` | Administration Postal Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_SBICODE_CODE_ATTR` | `varchar2` | SBI Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_SEPADDCREDITORIDENTIFIER` | `varchar2` | Administration SEPA Direct Dunning Creditor Identifier | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_STARTDATE` | `date` | Administration Start Date | | Start date: YYYY-MM-DD |
| `ADMINISTRATIONTYPES_ADMINISTRATION_STATE_CODE_ATTR` | `varchar2` | Status Code | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_STATE_DESCRIPTION_TERMID_ATTR` | `number` | | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_STATE_DESCRIPTION` | `varchar2`(255) | Status Description | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_USERADMINISTRATIONS` | `varchar2` | Administration User Administrations | | |
| `ADMINISTRATIONTYPES_ADMINISTRATION_VATNUMBER` | `varchar2` | Administration VAT Number | | |
| `CODE_ATTR` | `varchar2` | Code | | |
| `DESCRIPTION` | `varchar2` | Description | | |
| `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. |
| `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. |
| `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. |