Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: Incremental > Tables

ContactsIncremental: Exact Online Contacts (Incremental)

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Incremental

Primary Keys: ID

Label: Contacts (Incremental)

The data in this table is partitioned per value of the Division column.

This is a read-only view. The Exact Online API may not support changing the data or the Invantive SQL 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.

Field Selection Method: NotRequired

View Columns

The columns of the view ContactsIncremental are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

Account

guid

Account

 

AccountIsCustomer

boolean

Account is Customer

 

AccountIsSupplier

boolean

Account Is Supplier

 

AccountMainContact

guid

Account Main Contact

 

AddressLine2

string

Address Line 2

 

AddressStreet

string

Address Street

 

AddressStreetNumber

string

Address Street Number

 

AddressStreetNumberSuffix

string

Address Street Number Suffix

 

AllowMailing

int32

Allow Mailing

 

BirthDate

datetime

Birth Date

 

BirthName

string

Birth Name

 

BirthNamePrefix

string

Birth Name Prefix

 

BirthPlace

string

Birth Place

 

BusinessEmail

string

Business Email Address

 

BusinessFax

string

Business Fax

 

BusinessMobile

string

Business Mobile

 

BusinessPhone

string

Business Phone

 

BusinessPhoneExtension

string

Business Phone Extension

 

City

string

City

 

Code

string

Code

 

Country

string

Country

 

Created

datetime

Created

 

Creator

guid

Creator

 

Division

int32

Division

 

Email

string

Email

 

EndDate

datetime

End Date

 

FirstName

string

First Name

 

FullName

string

Full Name

 

Gender

string

Gender

 

HID

int32

HID

 

ID

guid

ID

 

IdentificationDate

datetime

Identification Date

 

IdentificationDocument

guid

Identification Document

 

IdentificationUser

guid

Identification User

 

Initials

string

Initials

 

IsAnonymised

int16

Is Anonymised

 

IsMailingExcluded

boolean

Is Mailing Excluded

 

IsMainContact

boolean

Is Main Contact

 

JobTitleDescription

string

Job Title Description

 

Language

string

Language

 

LastName

string

Last Name

 

LeadPurpose

guid

Lead Purpose

 

LeadSource

guid

Lead Source

 

MarketingNotes

string

Marketing Notes

 

MiddleName

string

Middle Name

 

Mobile

string

Mobile

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

Nationality

string

Nationality

 

Notes

string

Notes

 

PartnerName

string

Partner Name

 

PartnerNamePrefix

string

Partner Name Prefix

 

Person

guid

Person

 

Phone

string

Phone

 

PhoneExtension

string

Phone Extension

 

Picture

byte[]

Picture

 

PictureName

string

Picture Name

 

PictureThumbnailUrl

string

Picture Thumbnail (URL)

 

PictureUrl

string

Picture (URL)

 

Postcode

string

Postal Code

 

SocialSecurityNumber

string

Social Security Number

 

StartDate

datetime

Start Date

 

State

string

State

 

Timestamp

int64

Timestamp

 

Title

string

Title

 

 

07-11-2021 09:07 Version 20.2.94-PROD+3513