Please enable JavaScript to view this site.

Navigation: Catalog: AfasOnline > Schemas > Schema: GetConnector > Tables

Profit_Debtor: Debtors

Name: Profit_Debtor

Catalog: AfasOnline

Schema: GetConnector

Label: Debtors

Documentation:

Profit_Debtor

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): /connectors/Profit_Debtor

Insert Service URL (OData-specific): /connectors/Profit_Debtor

Update Service URL (OData-specific): /connectors/Profit_Debtor

Delete Service URL (OData-specific): /connectors/Profit_Debtor

Field Selection Method (OData-specific): NotRequired

Table Columns

Name

Data Type

Label

Required

Documentation

AdressLine1

string(255)

Adresregel 1 (straat - huisnr)

 

 

AdressLine3

string(255)

Adresregel 3 (postc - wpl)

 

 

AdressLine4

string(255)

Adresregel 4 (land)

 

 

AutoPayment

boolean

Automatisch incasseren

 

 

BcCo

string(15)

Nummer org./pers.

 

 

Blocked

boolean

Geblokkeerd voor levering

 

 

ChOfCommNr

string(30)

KvK-nummer

 

 

CollectAccount

string(16)

Verzamelrekening

 

 

CreateDate

datetime

Aangemaakt op

 

 

CreditLimit

decimal

Kredietlimiet

 

 

CurrencyId

string(3)

Valuta

 

 

DebtorId

string(16)

Nummer debiteur

 

 

DebtorName

string(80)

Naam debiteur

 

 

Email

string(255)

E-mail werk

 

 

IBAN

string(40)

IBAN-nummer

 

 

ModifiedDate

datetime

Gewijzigd op

 

 

PayCon

string(5)

Betalingsvoorwaarde

 

 

SearchName

string(10)

Zoeknaam

 

 

TelNr

string(255)

Telefoonnr. werk

 

 

VatDuty

string(3)

Btw-plicht

 

 

VatNr

string(21)

Btw-nummer

 

 

 

07-10-2019 20:5017.33.149-BETA+2365