# OwnerAdministrations: Exact Online Current Customer Administrations
## Documentation:
Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- codechr(13) || chr(10) || chr(13) || chr(10)- number_fromchr(13) || chr(10) || chr(13) || chr(10)- number_tochr(13) || chr(10) || chr(13) || chr(10)- startdate_fromchr(13) || chr(10) || chr(13) || chr(10)- startdate_to
- Catalog: `ExactOnlineXML`
- Schema: `XML`
- Primary Keys: `code_attr`
- Label: Current Customer Administrations
The data in this table is partitioned per value of the `Division` column.
- Retrieve: True
- Insert: True
- Update: True
- Delete: False
- Filters on API Server: division
- code
- number_from
- number_to
- startdate_from
- startdate_to
## Table Columns
The columns of the table `OwnerAdministrations` 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 | 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 | | |