Contacts: Exact Online Contactpersonen |
Catalogus: ExactOnlineREST
Schema: CRM
Primaire Sleutels: ID
Label: Contactpersonen
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Contacts 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.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Account |
guid |
Account |
☐ |
The account to which the contact belongs. |
AccountIsCustomer |
boolean |
Account is Klant |
☑ |
Indicates if account is a customer. |
AccountIsSupplier |
boolean |
Account is Leverancier |
☐ |
Indicates if account is a supplier. |
AccountMainContact |
guid |
Account Hoofdcontactpersoon |
☐ |
Reference to the main contact of the account. |
AccountName |
string(50) |
Accountnaam |
☐ |
Name of account. |
AddressLine2 |
string(60) |
Adresregel 2 |
☐ |
Second address line. |
AddressStreet |
string |
Adres Straat |
☐ |
Street name of the address. |
AddressStreetNumber |
string |
Adres Straat Nummer |
☐ |
Street number of the address. |
AddressStreetNumberSuffix |
string |
Adres Straat Nummer Achtervoegsel |
☐ |
Street number suffix of the address. |
AllowMailing |
int32 |
Mailing Toestaan |
☐ |
Obsolete. |
BirthDate |
datetime |
Geboortedatum |
☐ |
Birth date. |
BirthName |
string |
Geboortenaam |
☐ |
Obsolete. Please don't use this field anymore as it may overwrite LastName. |
BirthNamePrefix |
string |
Geboortenaam Voorvoegsel |
☐ |
Obsolete. Please don't use this field anymore as it may overwrite MiddleName. |
BirthPlace |
string |
Geboorteplaats |
☐ |
Birth place. |
BusinessEmail |
string(128) |
Zakelijk E-mailadres |
☐ |
Email address of the contact. |
BusinessFax |
string(25) |
Bedrijfsfax |
☐ |
Fax of the contact. |
BusinessMobile |
string(25) |
Bedrijfsmobiel |
☐ |
Mobile of the contact. |
BusinessPhone |
string(25) |
Bedrijfstelefoon |
☐ |
Phone of the contact. |
BusinessPhoneExtension |
string(15) |
Bedrijfstelefoon Extensie |
☐ |
Phone extension of the contact. |
City |
string(30) |
Plaats |
☐ |
City. |
Code |
string |
Code |
☐ |
Code of the account. |
Country |
string(30) |
Land |
☐ |
Country code. |
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
CustomField |
string |
{res:itgen_eol_customfield} |
☐ |
|
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
string(128) |
☐ |
Email address of the contact. |
||
EndDate |
datetime |
Einddatum |
☐ |
End date. |
FirstName |
string(64) |
Voornaam |
☐ |
First name. Provide at least first name or last name to create a new contact. |
FullName |
string(240) |
Volledige Naam |
☐ |
Full name (First name Middle name Last name). |
Gender |
string |
Geslacht |
☐ |
Gender. |
HID |
int32 |
HID |
☐ |
Contact ID. |
ID |
guid |
ID |
☑ |
Primary key. |
IdentificationDate |
datetime |
Identificatiedatum |
☐ |
Identification date. |
IdentificationDocument |
guid |
Identificatiedocument |
☐ |
Reference to the identification document of the contact. |
IdentificationUser |
guid |
Identificatiegebruiker |
☐ |
Reference to the user responsible for identification. |
Initials |
string(10) |
Initialen |
☐ |
Initials. |
IsAnonymised |
int16 |
Is Geanonimiseerd |
☑ |
Indicates whether the contact is anonymised. |
IsMailingExcluded |
boolean |
Is Mailing Uitgesloten |
☐ |
Indicates whether contacts are excluded from the marketing list. |
IsMainContact |
boolean |
Is Hoofdcontact |
☐ |
Indicates if this is the main contact of the linked account. |
JobTitleDescription |
string |
Functieomschrijving |
☐ |
Jobtitle of the contact. |
Language |
string(30) |
Taal |
☐ |
Language code. |
LastName |
string(60) |
Achternaam |
☐ |
Last name. Provide at least first name or last name to create a new contact. |
LeadPurpose |
guid |
Lead Doel |
☐ |
Reference to Lead Purpose. |
LeadSource |
guid |
Lead Bron |
☐ |
Reference to Lead Source. |
MarketingNotes |
string |
Marketing Notities |
☐ |
The user should be able to do a full text search on these notes to gather contacts for a marketing campaign. |
MiddleName |
string |
Tussenvoegsel |
☐ |
Middle name. |
Mobile |
string(25) |
Mobiel |
☐ |
Business phone of the contact. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
Nationality |
string |
Nationaliteit |
☐ |
Nationality. |
Notes |
string |
Notities |
☐ |
Extra remarks. |
PartnerName |
string |
Partnernaam |
☐ |
Last name of partner. |
PartnerNamePrefix |
string |
Partner Naam Voorvoegsel |
☐ |
Middlename of partner. |
Person |
guid |
Persoon |
☐ |
Reference to the personal information of this contact such as name, gender, address etc. |
Phone |
string(25) |
Telefoon |
☐ |
Phone of the contact. |
PhoneExtension |
string(15) |
Telefoontoestel |
☐ |
Phone extension of the contact. |
Picture |
byte[] |
Afbeelding |
☐ |
This field is write-only. The picture can be downloaded through PictureUrl and PictureThumbnailUrl. |
PictureName |
string |
Naam Afbeelding |
☐ |
Filename of the picture. |
PictureThumbnailUrl |
string |
Miniatuurafbeelding (URL) |
☐ |
Url to retrieve the picture thumbnail. |
PictureUrl |
string |
Afbeelding (URL) |
☐ |
Url to retrieve the picture. |
Postcode |
string(20) |
Postcode |
☐ |
Postcode. |
SocialSecurityNumber |
string |
Burgerservicenummer |
☐ |
Social security number. |
StartDate |
datetime |
Startdatum |
☐ |
Start date. |
State |
string(30) |
Provincie |
☐ |
State/Province code. |
Title |
string |
Titel |
☐ |
Title. |
TitleAbbreviation |
string |
{res:itgen_eol_titleabbreviation} |
☐ |
|
TitleDescription |
string |
{res:itgen_eol_titledescription} |
☐ |
|
24-06-2025 18:54 Versie 24.1.116-BETA+5455