NameDescriptionTypeAdditional information
id

Primary key

globally unique identifier

Required

firstname

Firstname of the contact

string

Max length: 50

lastname

Lastname of the contact. If you have one single field available for firstname+lastname then use Lastname

string

Required

Max length: 50

company_id

company of the contact

globally unique identifier
db_language_id

Language of the contact.If empty, will use the default on the system

globally unique identifier
db_title_id

Foreign key of the contact's title/salutation (e.g. Mr, Mrs, Dr).

globally unique identifier
db_functionbis_id

Foreign key of the contact's secondary function/role classification.

globally unique identifier
archived

Archive this contact to not have it anymore on the search

boolean
functions

Function of the contact (ServiceManager,...)

string

Max length: 64

notes

Free-text notes/remark about the contact.

string
phone

Phone number of the contact

string

Max length: 255

mobile

Mobile number of the contact

string

Max length: 255

email

email

string

Max length: 255

e_login

e_login

string

Max length: 50

e_servicedesk

e_servicedesk

boolean
e_new_password

new_e_password

string

Max length: 50

e_commerce

Indicates this contact is allowed to place orders through the e-commerce portal.

boolean
e_document

Indicates this contact is allowed to access shared documents through the e-Service portal.

boolean
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

date
contact_picture

Photo/picture of the contact, as raw image bytes.

Collection of byte