# OwnerAdministrationAssignedTypes: Exact Online Current Customer Administration Assigned Types
## 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`
- Label: Current Customer Administration Assigned Types
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
## View Columns
The columns of the view `OwnerAdministrationAssignedTypes` 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 |
|---|:---:|---|:---:|---|
| `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. |