Table llx societe
From Dolibarr Wiki
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Content/Contenu/Contenido
Contains the list of third parties stored in Dolibarr.
Contient les tiers enregistrés dans Dolibarr.
Contiene los terceros registrados en Dolibarr.
Structure
Table
Version 1.5 2010/02/21
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| statut | tinyint(4) | YES | 0 | state | ||
| parent | int(11) | YES | NULL | parent | ||
| tms | timestamp | NO | CURRENT_TIMESTAMP | last update date | ||
| datec | datetime | YES | NULL | creation date | ||
| datea | datetime | YES | NULL | activation date | ||
| nom | varchar(60) | YES | NULL | name | ||
| entity | int(11) | NO | UNI | 1 | multi company id | |
| code_client | varchar(15) | YES | UNI | NULL | client code | |
| code_fournisseur | varchar(15) | YES | NULL | supplier code | ||
| code_compta | varchar(15) | YES | NULL | accounting client code | ||
| code_compta_fournisseur | varchar(15) | YES | NULL | accounting supplier code | ||
| adress | varchar(255) | YES | NULL | company adresse | ||
| cp | varchar(10) | YES | NULL | postal code | ||
| ville | varchar(50) | YES | NULL | town | ||
| fk_departement | int(11) | YES | 0 | ID of departement (llx_c_departements->rowid) | ||
| fk_pays | int(11) | YES | 0 | ID of country (llx_c_pays->rowid) | ||
| tel | varchar(20) | YES | NULL | phone number | ||
| fax | varchar(20) | YES | NULL | fax number | ||
| url | varchar(255) | YES | NULL | web url | ||
| varchar(128) | YES | NULL | ||||
| fk_secteur | int(11) | YES | 0 | ID of sector | ||
| fk_effectif | int(11) | YES | 0 | ID of workers range (llx_c_effectif->id) | ||
| fk_typent | int(11) | YES | 0 | ID of type of entity (llx_c_typent->id) | ||
| fk_forme_juridique | int(11) | YES | 0 | ID of juridical status (llx_c_forme_juridique->rowid) | ||
| siren | varchar(16) | YES | NULL | IDProf1 | ||
| siret | varchar(16) | YES | NULL | IDProf2 | ||
| ape | varchar(16) | YES | NULL | IDProf3 | ||
| idprof4 | varchar(16) | YES | NULL | IDProf4 | ||
| tva_intra | varchar(20) | YES | NULL | VAT ID | ||
| capital | real | YES | NULL | capital of society | ||
| description | text | YES | NULL | brief description about society | ||
| fk_stcomm | int(11) | YES | 0 | ID of commercial status (llx_c_stcomm->id) | ||
| note | text | YES | NULL | comentary | ||
| services | tinyint(4) | YES | 0 | services | ||
| prefix_comm | varchar(5) | YES | UNI | NULL | prefix commercial | |
| client | tinyint(4) | YES | 0 | type of client (0/1/2) | ||
| fournisseur | tinyint(4) | YES | 0 | is it a supplier third pary (0/1)? | ||
| supplier_account | varchar(32) | YES | NULL | customer account to a provider | ||
| fk_prospectlevel | varchar(12) | YES | NULL | ID of prospect level (llx_c_prospectlevel->code) | ||
| customer_bad | tinyint(4) | YES | 0 | is the costumer deadbeat (0/1)? | ||
| customer_rate | real | YES | 0 | reliability rate customer (0 to 1)? | ||
| supplier_rate | real | YES | 0 | reliability rate supplier (0 to 1)? | ||
| fk_user_creat | int(11) | YES | MUL | NULL | ID of creator user (llx_user->rowid) | |
| fk_user_modif | int(11) | YES | MUL | NULL | ID of modifier user (llx_user->rowid) | |
| remise_client | real | YES | 0 | systematic discount for the customer | ||
| mode_reglement | tinyint(4) | YES | NULL | mode of payment by default | ||
| cond_reglement | tinyint(4) | YES | NULL | payment conditions by default | ||
| tva_assuj | tinyint(4) | YES | 1 | is subject to VAT? | ||
| localtax1_assuj | tinyint(4) | YES | 0 | is subject to localtax1? | ||
| localtax2_assuj | tinyint(4) | YES | 0 | is subject to localtax2? | ||
| gencod | varchar(255) | YES | NULL | bar code | ||
| price_level | tinyint(4) | YES | NULL | level of price for multiprices | ||
| default_lang | varchar(6) | YES | NULL | default language for this society | ||
| import_key | varchar(14) | YES | NULL | import key |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_societe_prefix_comm | UNIQUE | prefix_comm,entity |
| uk_societe_code_client | UNIQUE | code_client,entity |
| idx_societe_user_creat | MULTIPLE | fk_user_creat |
| idx_societe_user_modif | MULTIPLE | fk_user_modif |
Note
Third parties can be:
- suppliers or customers companies (depending on the sub-elements defined) or both.
- A normal person.
- A foundation.
Un tiers peut être:
- une entreprises cliente ou fournisseur (ou les deux)
- une personne physique
- une association/fondation
Un tercero puede ser:
- una empresa cliente o proveedor (o los dos)
- una persona física
- una asociación/fundación
