AFAS Online Data Model
AFASPocket_Contacts: Contacts (AFAS Pocket) |
Name: AFASPocket_Contacts
Catalog: AfasOnline
Schema: GetConnector
Label: Contacts (AFAS Pocket)
Documentation:
AFASPocket_Contacts
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): /connectors/AFASPocket_Contacts
Insert Service URL (OData-specific): /connectors/AFASPocket_Contacts
Update Service URL (OData-specific): /connectors/AFASPocket_Contacts
Delete Service URL (OData-specific): /connectors/AFASPocket_Contacts
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
city |
string(50) |
Woonplaats |
|
|
country |
string(3) |
country |
|
|
customer |
boolean |
Verkooprelatie |
|
|
date_of_birth |
datetime |
Geboortedatum |
|
|
email_work |
string(255) |
E-mail werk |
|
|
firstname |
string(50) |
Voornaam |
|
|
gender |
string(10) |
Geslacht |
|
|
housenumber |
int32 |
Huisnummer |
|
|
housenumber_extension |
string(30) |
Toev. aan huisnr. |
|
|
id |
string(15) |
Nummer |
|
|
initials |
string(15) |
Voorletters |
|
|
lastname |
string(80) |
Achternaam |
|
|
name |
string(255) |
Naam |
|
|
phone_mobile |
string(255) |
Mobiel werk |
|
|
phone_work |
string(255) |
Telefoonnr. werk |
|
|
position |
string(50) |
Omschrijving functie |
|
|
prefix |
string(15) |
Voorvoegsel |
|
|
street |
string(60) |
Straat |
|
|
type |
string(100) |
Soort basic contact |
|
|
updated_at |
datetime |
Gewijzigd op |
|
|
website |
string(255) |
Website |
|
|
zipcode |
string(15) |
Postcode |
|
|
07-10-2019 20:5017.33.149-BETA+2365
