# AllAdministrations: Exact Online Administrations All Administrations ## Documentation: All 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: `aan` - Primary Keys: `code_attr` - Label: Administrations 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 `AllAdministrations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACTIVITYSECTOR_CODE_ATTR` | `varchar2` | Activity Sector Code | | | | `ACTIVITYSUBSECTOR_CODE_ATTR` | `varchar2` | Activity Sub Sector Code | | | | `ADDRESSLINE1` | `varchar2` | Address Line 1 | | | | `ADDRESSLINE2` | `varchar2` | Address Line 2 | | | | `ADDRESSLINE3` | `varchar2` | Address Line 3 | | | | `ADMINISTRATIONTYPES` | `varchar2` | Administration Types | | | | `BLOCKINGSTATUS` | `varchar2` | Blocking Status | | 0=Not blocked, 1=Backup, 2=Conversion busy, 3=Conversion shadow, 4=Conversion waiting, 5=Copy data waiting, 6=Copy data busy | | `BUSINESSTYPE_CODE_ATTR` | `varchar2` | Business Type Code | | | | `CHAMBEROFCOMMERCE` | `varchar2` | Chamber of Commerce | | | | `CHAMBEROFCOMMERCEESTABLISHMENT` | `varchar2` | Chamber of Commerce Establishment | | | | `CITY` | `varchar2` | City | | | | `CODE_ATTR` | `varchar2` | Code | ☑ | The internal unique code of the administration. | | `COMPANYSIZE_CODE_ATTR` | `varchar2` | Company Size Code | | | | `COUNTRY_CODE_ATTR` | `varchar2` | Country Code | | | | `COUNTRY_DESCRIPTION_TERMID_ATTR` | `number` | Country Description Term ID | | | | `COUNTRY_DESCRIPTION` | `varchar2`(255) | Country Description | | | | `CURRENCY_CODE_ATTR` | `varchar2` | Currency Code | | | | `CURRENCY_DESCRIPTION_TERMID_ATTR` | `number` | Currency Description Term ID | | | | `CURRENCY_DESCRIPTION` | `varchar2`(255) | Currency Description | | | | `DIGITALPOSTBOXES` | `varchar2` | Digital Post Boxes | | | | `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. | | `DIVISIONCLASSNAMES` | `varchar2` | Division Class Names | | | | `EMAIL` | `varchar2` | Email | | | | `ENDDATE` | `date` | End Date | | End date: YYYY-MM-DD | | `ETTSOURCE` | `varchar2` | 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 | | `FAX` | `varchar2` | Fax | | | | `HOMEPAGE` | `varchar2` | Home Page | | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `NAME` | `varchar2` | Name | | | | `NUMBER_ATTR` | `number` | Number | | The external code of the administration as shown in the administration card. | | `PHONE` | `varchar2` | Phone | | | | `PHONEEXT` | `varchar2` | Phone Extension | | | | `POSTCODE` | `varchar2` | Postal Code | | | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. | | `SBICODE_CODE_ATTR` | `varchar2` | SBI Code Code | | | | `SEPADDCREDITORIDENTIFIER` | `varchar2` | SEPA Direct Dunning Creditor Identifier | | | | `STARTDATE` | `date` | Start Date | | Start date: YYYY-MM-DD | | `STATE_CODE_ATTR` | `varchar2` | State Code | | | | `STATE_DESCRIPTION_TERMID_ATTR` | `number` | | | | | `STATE_DESCRIPTION` | `varchar2`(255) | State Description | | | | `USERADMINISTRATIONS` | `varchar2` | User Administrations | | | | `VATNUMBER` | `varchar2` | VAT Number | | |