---
title: "profit_debtor (AFAS Profit)"
description: "Debtors"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/afas/AfasOnline.GetConnector.profit_debtor
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.profit_debtor
updated: 2026-11-17T12:39:29Z
license: https://documentation.invantive.eu/nl/
---

# profit_debtor: AFAS Profit Debtors

`read only` `REST`

- Catalogus: `AfasOnline`
- Schema: `GetConnector`
- Label: Debtors

Kan alleen gegevens ophalen.

## Samenvatting

Profit_Debtor

## API-bron

- Eindpunt: `/connectors/Profit_Debtor`
- Metagegevens: `metainfo/get/Profit_Debtor`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 353 |
| Aantal rijen per minuut bij volledige scan | 65,100 |
| Aantal rijen per minuut in een Query | 169 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Tabelkolommen

De kolommen van de tabel `profit_debtor` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | 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` |  |
