AFAS Online Data Model
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 |
|
|
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
