invantive documentation
Invantive Support ForumsLog In / Sign Up

caseware_administraties: AFAS Profit Companies (CaseWare)

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Companies (CaseWare)

Can only retrieve data.

Summary

CaseWare administraties

API Source

  • Endpoint: /connectors/CaseWare_Administraties
  • Metadata: metainfo/get/CaseWare_Administraties

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 caseware_administraties 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
administratie int32 Administratie fetched only when named, Administratie
adresregel_1_straat_huisnr_ varchar2(59) Adresregel 1 (straat - huisnr) fetched only when named, Adresregel_1__straat_-_huisnr_
adresregel_2_toevoeging_ varchar2(59) Adresregel 2 (toevoeging) fetched only when named, Adresregel_2__toevoeging_
adresregel_3_postc_wpl_ varchar2(59) Adresregel 3 (postc - wpl) fetched only when named, Adresregel_3__postc_-_wpl_
adresregel_4_land_ varchar2(59) Adresregel 4 (land) fetched only when named, Adresregel_4__land_
contactpersoon varchar2(50) Contactpersoon fetched only when named, Contactpersoon
fax varchar2(80) Fax fetched only when named, Fax
kix_coderegel varchar2(18) KIX-coderegel fetched only when named, Kix_coderegel
naam varchar2(80) Naam fetched only when named, Naam
telefoon varchar2(80) Telefoonnr. fetched only when named, Telefoon