invantive documentation
Invantive Support ForumsLog In / Sign Up

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