# ContactsRead: Exact Online Contacts (Read-only) - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `ID` - Label: Contacts (Read-only) The data in this table is partitioned per value of the `Division` column. This is a read-only table. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## Table Columns The columns of the table `ContactsRead` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | The account to which the contact belongs. | | `AccountIsCustomer` | `char` | Account is Customer | ☑ | Indicates if account is a customer. | | `AccountIsSupplier` | `char` | Account Is Supplier | ☐ | Indicates if account is a supplier. | | `AccountMainContact` | `guid` | Account Main Contact | ☐ | Reference to the main contact of the account. | | `AccountName` | `varchar2`(50) | Account Name | ☐ | Name of account. | | `AddressLine2` | `varchar2`(60) | Address Line 2 | ☐ | Second address line. | | `AddressStreet` | `varchar2` | Address Street | ☐ | Street name of the address. | | `AddressStreetNumber` | `varchar2` | Address Street Number | ☐ | Street number of the address. | | `AddressStreetNumberSuffix` | `varchar2` | Address Street Number Suffix | ☐ | Street number suffix of the address. | | `AllowMailing` | `int32` | Allow Mailing | ☐ | Obsolete. | | `BirthDate` | `datetime` | Birth Date | ☐ | Birth date. | | `BirthName` | `varchar2` | Birth Name | ☐ | Obsolete. Please don't use this field anymore as it may overwrite LastName. | | `BirthNamePrefix` | `varchar2` | Birth Name Prefix | ☐ | Obsolete. Please don't use this field anymore as it may overwrite MiddleName. | | `BirthPlace` | `varchar2` | Birth Place | ☐ | Birth place. | | `BusinessEmail` | `varchar2`(128) | Business Email Address | ☐ | Email address of the contact. | | `BusinessFax` | `varchar2`(25) | Business Fax | ☐ | Fax of the contact. | | `BusinessMobile` | `varchar2`(25) | Business Mobile | ☐ | Mobile of the contact. | | `BusinessPhone` | `varchar2`(25) | Business Phone | ☐ | Phone of the contact. | | `BusinessPhoneExtension` | `varchar2`(15) | Business Phone Extension | ☐ | Phone extension of the contact. | | `City` | `varchar2`(30) | City | ☐ | City. | | `Code` | `varchar2` | Code | ☐ | Code of the account. | | `Country` | `varchar2`(30) | Country | ☐ | Country code. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `Division` | `int32` | Division | ☐ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `Email` | `varchar2`(128) | Email | ☐ | Email address of the contact. | | `EndDate` | `datetime` | End Date | ☐ | End date. | | `FirstName` | `varchar2`(64) | First Name | ☐ | First name. Provide at least first name or last name to create a new contact. | | `FullName` | `varchar2`(240) | Full Name | ☐ | Full name (First name Middle name Last name). | | `Gender` | `varchar2` | Gender | ☐ | Gender. | | `HID` | `int32` | HID | ☐ | Contact ID. | | `ID` | `guid` | ID | ☑ | Primary key. | | `IdentificationDate` | `datetime` | Identification Date | ☐ | Identification date. | | `IdentificationDocument` | `guid` | Identification Document | ☐ | Reference to the identification document of the contact. | | `IdentificationUser` | `guid` | Identification User | ☐ | Reference to the user responsible for identification. | | `Initials` | `varchar2`(10) | Initials | ☐ | Initials. | | `IsAnonymised` | `int16` | Is Anonymised | ☑ | Indicates whether the contact is anonymised. | | `IsMailingExcluded` | `char` | Is Mailing Excluded | ☐ | Indicates whether contacts are excluded from the marketing list. | | `IsMainContact` | `char` | Is Main Contact | ☐ | Indicates if this is the main contact of the linked account. | | `JobTitleDescription` | `varchar2` | Job Title Description | ☐ | Jobtitle of the contact. | | `Language` | `varchar2`(30) | Language | ☐ | Language code. | | `LastName` | `varchar2`(60) | Last Name | ☐ | Last name. Provide at least first name or last name to create a new contact. | | `LeadPurpose` | `guid` | Lead Purpose | ☐ | Reference to Lead Purpose. | | `LeadSource` | `guid` | Lead Source | ☐ | Reference to Lead Source. | | `MarketingNotes` | `varchar2` | Marketing Notes | ☐ | The user should be able to do a full text search on these notes to gather contacts for a marketing campaign. | | `MiddleName` | `varchar2` | Middle Name | ☐ | Middle name. | | `Mobile` | `varchar2`(25) | Mobile | ☐ | Business phone of the contact. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `Nationality` | `varchar2` | Nationality | ☐ | Nationality. | | `Notes` | `varchar2` | Notes | ☐ | Extra remarks. | | `PartnerName` | `varchar2` | Partner Name | ☐ | Last name of partner. | | `PartnerNamePrefix` | `varchar2` | Partner Name Prefix | ☐ | Middlename of partner. | | `Person` | `guid` | Person | ☐ | Reference to the personal information of this contact such as name, gender, address etc. | | `Phone` | `varchar2`(25) | Phone | ☐ | Phone of the contact. | | `PhoneExtension` | `varchar2`(15) | Phone Extension | ☐ | Phone extension of the contact. | | `Picture` | `blob` | Picture | ☐ | This field is write-only. The picture can be downloaded through PictureUrl and PictureThumbnailUrl. | | `PictureName` | `varchar2` | Picture Name | ☐ | Filename of the picture. | | `PictureThumbnailUrl` | `varchar2` | Picture Thumbnail (URL) | ☐ | Url to retrieve the picture thumbnail. | | `PictureUrl` | `varchar2` | Picture (URL) | ☐ | Url to retrieve the picture. | | `Postcode` | `varchar2`(20) | Postal Code | ☐ | Postcode. | | `SocialSecurityNumber` | `varchar2` | Social Security Number | ☐ | Social security number. | | `StartDate` | `datetime` | Start Date | ☐ | Start date. | | `State` | `varchar2`(30) | State | ☐ | State/Province code. | | `Title` | `varchar2` | Title | ☐ | Title. | | `TitleAbbreviation` | `varchar2` | | ☐ | | | `TitleDescription` | `varchar2` | | ☐ | |