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 (thirdparties are customers, suppliers, prospects).
Contient les tiers enregistrés dans Dolibarr (les tiers sont les clients, fournisseurs ou prospects).
Contiene los terceros registrados en Dolibarr.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| nom | varchar(60) | YES | NULL | name | ||
| entity | int(11) | NO | UNI | 1 | multi company id | |
| ref_ext | varchar(60) | NO | UNI | 1 | A field only stored and read by dolibarr but not used. You can use it to store your id of tirdparty into another external system. This will help synchro tools. | |
| statut | tinyint(4) | YES | 0 | state | ||
| parent | int(11) | YES | NULL | parent | ||
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| datec | datetime | YES | NULL | creation date | ||
| datea | datetime | YES | NULL | activation date | ||
| 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_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 | ||
| idprof5 | varchar(16) | YES | NULL | IDProf5 | ||
| idprof6 | varchar(16) | YES | NULL | IDProf6 | ||
| tva_intra | varchar(20) | YES | NULL | VAT ID | ||
| capital | real | YES | NULL | capital of society | ||
| fk_stcomm | int(11) | YES | 0 | ID of commercial status (llx_c_stcomm->id) | ||
| note | text | YES | NULL | comentary | ||
| 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 thirdparty | ||
| import_key | varchar(14) | YES | NULL | Code use to track record import. See page Field Import key. |
Keys
| 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
Ask to contact@dolibarr.org to request an account to contribute to this documentation
