TAB_SOCIETE Class

Agency.

Show:

ID_CREATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Creator.


Default: 0

ID_SOCIETE

Int(11)

Unique identifier.

SOCIETE_ADR

Varchar(250)

Address.


Default: ''

SOCIETE_CP

Char(10)

Postcode.


Default: ''

SOCIETE_CREATEDAT

Datetime

Update date.

SOCIETE_EFFECTIF

Int(6)

Personnel.


Default: 0

SOCIETE_EMAIL

Varchar(100)

Email 1.


Default: ''

SOCIETE_ETAT

Tinyint(1)

State :

  • 0 : Archived
  • 1 : Current


Default: 1

SOCIETE_GROUPE

Varchar(100)

Group.


Default: ''

SOCIETE_NAF

Varchar(100)

APE code.


Default: ''

SOCIETE_NIC

Char(5)

Internal ranking number.


Default: ''

SOCIETE_PAYS

Varchar(100)

Country.


Default: 'France'

SOCIETE_RAISON

Varchar(100)

Name.


Default: ''

SOCIETE_RCS

Varchar(100)

Registered office.


Default: ''

SOCIETE_SIREN

Varchar(100)

National identification number.


Default: ''

SOCIETE_STATUT

Varchar(100)

Legal status.


Default: ''

SOCIETE_SUBDIVISION

Varchar(6)

Sub division (ISO-3166-2).


Default: ''

SOCIETE_TEL

Char(20)

Phone 1.


Default: ''

SOCIETE_TVA

Varchar(100)

V.A.T Number.


Default: ''

SOCIETE_UPDATEDAT

Datetime

Update date.

SOCIETE_VILLE

Varchar(100)

Town.


Default: ''

SOCIETE_WEB

Varchar(100)

Website.


Default: ''