Contact

    API Details

    Property Value
    Endpoint /tablesGeneral/contacts
    Table name Contact
    Table id 5050
    Table caption Contact
    Data per company True
    Group General

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    no No. Code 20 *
    name Name Text 100
    searchName Search Name Code 100
    name2 Name 2 Text 50
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    phoneNo Phone No. Text 30
    telexNo Telex No. Text 20
    territoryCode Territory Code Code 10 Territory
    currencyCode Currency Code Code 10 Currency
    languageCode Language Code Code 10 Language
    registrationNumber Registration No. Text 50
    salespersonCode Salesperson Code Code 20 Salesperson/Purchaser
    countryRegionCode Country/Region Code Code 10 Country/Region
    formatRegion Format Region Text 80 Language Selection
    lastDateModified Last Date Modified Date 4
    faxNo Fax No. Text 30
    telexAnswerBack Telex Answer Back Text 20
    vatRegistrationNo VAT Registration No. Text 20
    postCode Post Code Code 20
    county County Text 30
    eMail Email Text 80
    homePage Home Page Text 80
    noSeries No. Series Code 20 No. Series
    image Image Media 16
    privacyBlocked Privacy Blocked Boolean 4
    minor Minor Boolean 4
    parentalConsentReceived Parental Consent Received Boolean 4
    type Type Option 4 Company, Person
    companyNo Company No. Code 20
    companyName Company Name Text 100
    lookupContactNo Lookup Contact No. Code 20 Contact
    firstName First Name Text 30
    middleName Middle Name Text 30
    surname Surname Text 30
    jobTitle Job Title Text 30
    initials Initials Text 30
    extensionNo Extension No. Text 30
    mobilePhoneNo Mobile Phone No. Text 30
    pager Pager Text 30
    organizationalLevelCode Organizational Level Code Code 10 Organizational Level
    excludeFromSegment Exclude from Segment Boolean 4
    externalID External ID Code 20
    contactBusinessRelation Contact Business Relation Option 4 , Customer, Vendor, Bank Account, Employee, None, Other, Multiple
    correspondenceType Correspondence Type Option 4 , Hard Copy, Email, Fax
    salutationCode Salutation Code Code 10 Salutation
    searchEMail Search Email Code 80
    lastTimeModified Last Time Modified Time 4
    eMail2 Email 2 Text 80
    xrmId Xrm Id GUID 16
    oudNummer Old Number Code 20
    relBestNr RelBestNo. Code 20
    contactbeheerder Contact Manager Code 50 User Setup
    naamContactbeheerder Name Contact Manager Text 50
    telefoonOverdag Phone No. during Office Hours Text 30
    naam3 Name 3 Text 30
    naam4 Name 4 Text 30
    telefoon3 Phone 3 Text 30
    telefoon4 Phone 4 Text 30
    telefoon5 Phone 5 Text 30
    mobiel2 Mobile Phone 2 Text 30
    mobiel3 Mobile Phone 3 Text 30
    mobiel4 Mobile Phone 4 Text 30
    mobiel5 Mobile Phone 5 Text 30
    emailForOrders E-mail for Orders Text 80
    email3 E-Mail 3 (notification quotes) Text 80
    email4 E-Mail 4 (notification orders) Text 80
    email5 E-Mail 5 (notification notes) Text 80
    telefoon2 Phone 2 Text 30
    beheergevernrVvEnr Owner No./Ass. of Owners No. Code 20 Vendor
    eigenaarnr Owner No. Code 20 Customer
    customerNo Customer No. Code 20 Customer
    vendorNo Vendor No. Code 20 Vendor
    geslacht Gender Option 4 , Man, Vrouw
    burgerlijkeStaat Marital Status Code 20 Marital Status
    socialSecurityNo Social Security No. Code 10
    woonbonnr Housing Ticket No. Code 10
    ihsGeblokkeerd IHS Blocked Boolean 4
    datumBlokkade Blocking Date Date 4
    handelsregisternr Registration No. Text 20
    postbus PO box Code 20 Post Code
    postcodePostbus Post Code PO Box Code 20
    birthDate Birth Date Date 4
    contactbeheerder2 Contact Manager 2 Code 50 User Setup
    naamContactbeheerder2 Name Contact Manager 2 Text 50
    inactief Inactive Boolean 4
    redenInactief Reason Inactive Text 30
    registrationNo Personal Registration No. Code 20
    registratieDate Registratie Date Date 4
    status Status Code 10
    woonlijnNo Woonlijn No. Code 20
    werknemernr Employee No. Code 20 Employee
    medewerkernr Employee No. Code 20 Salesperson/Purchaser
    huisnummer House No. Integer 4
    toevoegsel House No. Addition Code 20
    straat Street Text 50
    notAutoUpdateName No Auto Update Contract Name Boolean 4
    freezeNameFields FreezeNameFields Boolean 4
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    overlijdensdatum Date of Death Date 4
    wrbRegistrationNo WRB Registration No. Code 20
    wrbActiveringsdatum Activation Date Date 4
    wrbWoningzoekendesoort Type Rental Applicant Code 10 WRB Property Searcher Type
    wrbAutomUitschrBijAccept Auto Termination on Acceptation Boolean 4
    inkomen Income Decimal 12
    vermogen Equity Decimal 12
    vermogend Wealthy Boolean 4
    inwonendKindTbvWRB Resident Child Boolean 4
    wrbInschrijvingsdatum Registration Date Date 4
    wrbParticipantWoningaanbod Participant Housing Offer Boolean 4
    sortingID Sorting ID Code 20
    christianNames Christian Name(s) Text 50
    placeOfBirth Place of Birth Text 30 Post Code
    profession Profession Text 50
    matrimonialRights Matrimonial Rights Option 4 , Community of Goods, Prenuptial Agreement
    birthName Birth Name Text 50
    memberOA Member Owners Association Boolean 4
    roleInOA Role in Owners Association Code 10 Role in OA
    socialInstitution Social Institution Boolean 4
    verificationCode Verification Code Text 8
    supervisor Supervisor Boolean 4
    owner Legal Owner Boolean 4
    submitMaintenanceRequest Submit Maintenance Request Permitted Boolean 4
    handlingMaintenanceRequest Handling Maintenance Request Option 4 , Charge to Owner, Award to Supervisor
    sipAddress SIP Address Text 250
    customerTemplate Customer TemplateEMP Code 10
    contactAnonymized Contact Anonymized Boolean 4
    anonymizationType Anonymization Type Option 4 Default, Vendor, Exclude
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8