Contact.

Show:

CCON_ADR

Varchar(250)

Address.


Default: ''

CCON_APPLICATIONS

Text

List of activity areas.

Each activity area is described by key option.id for JSON response data.setting.activityArea of API /application/dictionary.

Activity areas are separated by | character.

Example:

"category1domain1|category2domain1"

CCON_CIVILITE

Int(11)

Civility.

cf. key id for JSON response data.setting.civility of API /application/dictionary.


Default: 0

CCON_COMMENTAIRE

Varchar(250)

Information comments.


Default: ''

CCON_CP

Char(10)

Postcode.


Default: ''

CCON_DATE

Datetime

Creation date.

CCON_DATEGDPR

Date

GDPR's expiration date.

CCON_DATELASTACTIVITY

Datetime

Last activity date.

CCON_DATEUPDATE

Datetime

Update date.

CCON_EMAIL

Varchar(100)

Email 1.


Default: ''

CCON_EMAIL2

Varchar(100)

Email 2.


Default: ''

CCON_EMAIL3

Varchar(100)

Email 3.


Default: ''

CCON_ETATGDPR

Tinyint(1)

GDPR's state : 0 : No GDPR consent 1 : GDPR consent's obtained

CCON_FAX

Char(20)

Fax.


Default: ''

CCON_FONCTION

Varchar(100)

Function.


Default: ''

CCON_NOM

Varchar(100)

Last name.


Default: ''

CCON_OUTILS

Text

List of tools.

Each tool is described by key id for JSON response data.setting.tool of API /application/dictionary.

Tools are separated by | character.

Example:

"tool1|tool2"

CCON_PAYS

Varchar(100)

Country.


Default: 'France'

CCON_PRENOM

Varchar(100)

First name.


Default: ''

CCON_SERVICE

Varchar(100)

Department.

Could be a customized string or one of TAB_CRMSOCIETE.CSOC_SERVICES.


Default: ''

CCON_SOURCE

Varchar(100)

Origin's detail.


Default: ''

CCON_SUBDIVISION

Varchar(6)

Sub division (ISO-3166-2).


Default: ''

CCON_TEL1

Char(20)

Phone 1.


Default: ''

CCON_TEL2

Char(20)

Phone 2.


Default: ''

CCON_THUMBNAIL

Varchar(100)

Thumbnail.

CCON_TYPE

Int(11)

Type.

cf. key id for JSON response data.setting.state.contact of API /application/dictionary.


Default: 0

CCON_TYPES

Text

Types :

Types are separated by | character.

Example:

"1|2"

CCON_TYPESOURCE

Int(11)

Origin's type.

cf. key id for JSON response data.setting.origin of API /application/dictionary


Default: -1

CCON_VILLE

Varchar(100)

Town.


Default: ''

ID_CREATOR

Int(11)


Default: 0

ID_CRMCONTACT

Int(11)

Unique identifier.

ID_CRMSOCIETE

Int(11)


Default: 0

ID_POLE

Int(11)


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

ID_SOCIETE

Int(11)


Default: 0