Company.

Show:

CSOC_ADR

Varchar(250)

Address.


Default: ''

CSOC_BAREMESEXCEPTION

Text

List of exceptional scales.

Each scale is described by :

Scales are separated by # character.

Example:

"2|Astreinte|10_11|1"

CSOC_CP

Char(10)

Postcode.


Default: ''

CSOC_DATE

Datetime

Creation date.

CSOC_DATEUPDATE

Datetime

Update date.

CSOC_EFFECTIF

Int(6)

Staff.


Default: 0

CSOC_FAX

Char(20)

Fax.


Default: ''

CSOC_INTERVENTION

Text

Expertise area.

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


Default: ''

CSOC_METIERS

Text

Information comments.

CSOC_NAF

Varchar(100)

APE code.


Default: ''

CSOC_NIC

Char(5)

Internal ranking number.


Default: ''

CSOC_NUMERO

Varchar(250)

Provider number.


Default: ''

CSOC_PAYS

Varchar(100)

Country.


Default: 'France'

CSOC_RCS

Varchar(100)

Registered office.


Default: ''

CSOC_SERVICES

Text

List of departments.

Departments are separated by | character.

Example:

"ingeneering|purchases"

CSOC_SIREN

Varchar(100)

National identification number.


Default: ''

CSOC_SOCIETE

Varchar(100)

Name.


Default: ''

CSOC_SOURCE

Varchar(100)

Origin's detail.


Default: ''

CSOC_STATUT

Varchar(100)

Legal status.


Default: ''

CSOC_SUBDIVISION

Varchar(6)

Sub division (ISO-3166-2).


Default: ''

CSOC_TEL

Char(20)

Phone 1.


Default: ''

CSOC_THUMBNAIL

Varchar(100)

Thumbnail.

CSOC_TVA

Varchar(100)

V.A.T Number.


Default: ''

CSOC_TYPE

Int(11)

Type.

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


Default: 0

CSOC_TYPESOURCE

Int(11)

Origin's type.

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


Default: -1

CSOC_VILLE

Varchar(100)

Town.


Default: ''

CSOC_WEB

Varchar(100)

Website.


Default: ''

ID_CREATOR

Int(11)


Default: 0

ID_CRMSOCIETE

Int(11)

Unique identifier.

ID_POLE

Int(11)


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

ID_RESPSOC

Int(11)

TAB_CRMSOCIETE.ID_RESPSOC.

Mother company.


Default: 0

ID_SOCIETE

Int(11)


Default: 0