invantive documentation
Invantive Support ForumsLog In / Sign Up

profit_debtor: AFAS Profit Debtors

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Debtors

Can only retrieve data.

Summary

Profit_Debtor

API Source

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

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 profit_debtor 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
adressline1 varchar2(255) Adresregel 1 (straat - huisnr) fetched only when named, AdressLine1
adressline3 varchar2(255) Adresregel 3 (postc - wpl) fetched only when named, AdressLine3
adressline4 varchar2(255) Adresregel 4 (land) fetched only when named, AdressLine4
autopayment char Automatisch incasseren fetched only when named, AutoPayment
bcco varchar2(15) Nummer org./pers. fetched only when named, BcCo
blocked char Geblokkeerd voor levering fetched only when named, Blocked
chofcommnr varchar2(30) KVK-nummer fetched only when named, ChOfCommNr
collectaccount varchar2(16) Verzamelrekening fetched only when named, CollectAccount
createdate datetime Aangemaakt op fetched only when named, CreateDate
creditlimit number Kredietlimiet fetched only when named, CreditLimit
currencyid varchar2(3) Valuta fetched only when named, CurrencyId
debtorid varchar2(16) Nummer debiteur fetched only when named, DebtorId
debtorname varchar2(80) Naam debiteur fetched only when named, DebtorName
email varchar2(255) E-mail werk fetched only when named, Email
iban varchar2(40) IBAN-nummer fetched only when named, IBAN
modifieddate datetime Gewijzigd op fetched only when named, ModifiedDate
paycon varchar2(5) Betaalvoorwaarde fetched only when named, PayCon
searchname varchar2(10) Zoeknaam fetched only when named, SearchName
telnr varchar2(255) Telefoonnr. werk fetched only when named, TelNr
vatduty varchar2(3) Btw-plicht fetched only when named, VatDuty
vatnr varchar2(21) Btw-identificatienummer fetched only when named, VatNr