| Name | Description | Type | Additional 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 | globally unique identifier | ||
| db_functionbis_id | 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 | string | ||
| phone |
Phone number of the contact |
string |
Max length: 255 |
| mobile |
Mobile number of the contact |
string |
Max length: 255 |
|
|
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 | boolean | ||
| e_document | boolean | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| contact_picture | Collection of byte |