---
title: "visionplanner_administrations (AFAS Profit)"
description: "itgen_aoe_visionplanner_administrations"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.visionplanner_administrations
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.visionplanner_administrations
updated: 2026-11-07T09:24:19Z
license: https://documentation.invantive.eu/en/
---

# visionplanner_administrations: AFAS Profit itgen_aoe_visionplanner_administrations

`read only` `REST`

- Catalog: `AfasOnline`
- Schema: `GetConnector`
- Label: itgen_aoe_visionplanner_administrations

Can only retrieve data.

## Summary

Visionplanner_administrations

## API Source

- Endpoint: `/connectors/Visionplanner_administrations`
- Metadata: `metainfo/get/Visionplanner_administrations`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 353 |
| Full scan rows per minute | 65,100 |
| Point query rows per minute | 169 |

The result can be cached on the client.

## Table Columns

The columns of the table `visionplanner_administrations` 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 |
|---|---|---|:---:|---|---|
| `administrationid` | `int32` | Administratie | [ ] | fetched only when named, `AdministrationId` |  |
| `city` | `varchar2(50)` | Woonplaats | [ ] | fetched only when named, `City` |  |
| `cocid` | `varchar2(30)` | KVK-nummer | [ ] | fetched only when named, `CoCId` |  |
| `cocreport` | `varchar2(100)` | KvK-rapportage | [ ] | fetched only when named, `CoCReport` |  |
| `fiscalid` | `varchar2(9)` | Fiscaalnummer | [ ] | fetched only when named, `FiscalId` |  |
| `housenumber` | `int32` | Huisnummer | [ ] | fetched only when named, `Housenumber` |  |
| `housenumberaddition` | `varchar2(30)` | Toev. aan huisnr. | [ ] | fetched only when named, `HousenumberAddition` |  |
| `land` | `varchar2(40)` | Land | [ ] | fetched only when named, `Land` |  |
| `legalform` | `varchar2(100)` | Rechtsvorm | [ ] | fetched only when named, `LegalForm` |  |
| `name` | `varchar2(80)` | Naam | [ ] | fetched only when named, `Name` |  |
| `postalcode` | `varchar2(15)` | Postcode | [ ] | fetched only when named, `PostalCode` |  |
| `sbicode` | `varchar2(10)` | SBI Code | [ ] | fetched only when named, `SBICode` |  |
| `statutoryname` | `varchar2(80)` | Naam (statutair) | [ ] | fetched only when named, `StatutoryName` |  |
| `statutoryplace` | `varchar2(80)` | Zetel van de rechtspersoon | [ ] | fetched only when named, `StatutoryPlace` |  |
| `street` | `varchar2(60)` | Straat | [ ] | fetched only when named, `Street` |  |
| `telephone` | `varchar2(80)` | Telefoonnr. | [ ] | fetched only when named, `Telephone` |  |
| `website` | `varchar2(255)` | Website | [ ] | fetched only when named, `Website` |  |

