Table llx societe
Jump to navigation
Jump to search
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
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：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 | 1 | multi company id | ||
| ref_ext | varchar(60) | YES | UNI | NULL | A field only stored and read by Dolibarr but not used. You can use it to store your id of thirdparty into another external system. This will help synchronisation tools. | |
| ref_int | varchar(60) | YES | NULL | |||
| 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 | ||
| status | tinyint(4) | YES | 1 | Thirdparty status : 0=activity ceased, 1= in activity | ||
| code_client | varchar(24) | YES | MUL | NULL | client's code | |
| code_fournisseur | varchar(24) | YES | NULL | Supplier code | ||
| code_compta | varchar(24) | YES | NULL | Customer account code | ||
| code_compta_fournisseur | varchar(24) | YES | NULL | Supplier account code | ||
| address | varchar(255) | YES | NULL | company address | ||
| zip | varchar(10) | YES | NULL | postal code | ||
| town | varchar(50) | YES | NULL | town | ||
| fk_departement | int(11) | YES | 0 | ID of province/state (llx_c_departements->rowid) | ||
| fk_pays | int(11) | YES | 0 | ID of country (llx_c_pays->rowid) | ||
| phone | 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 | This column/field does not exist anymore in 3.3.0+ | ||
| fk_effectif | int(11) | YES | 0 | ID of range of number of employees (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 legal status (llx_c_forme_juridique->rowid) | ||
| fk_currency | int(11) | YES | 0 | |||
| siren | varchar(128) | YES | NULL | IDProf1 | ||
| siret | varchar(128) | YES | NULL | IDProf2 | ||
| ape | varchar(128) | YES | NULL | IDProf3 | ||
| idprof4 | varchar(128) | YES | NULL | IDProf4 | ||
| idprof5 | varchar(128) | YES | NULL | IDProf5 | ||
| idprof6 | varchar(128) | YES | NULL | idprof6 (this column/field has been newly added) | ||
| tva_intra | varchar(20) | YES | NULL | VAT ID | ||
| capital | double | YES | NULL | capital of society | ||
| description | text | YES | NULL | |||
| fk_stcomm | int(11) | NO | 0 | ID of commercial status (llx_c_stcomm->id) | ||
| note_private | text | YES | NULL | private note | ||
| note_public | text | YES | NULL | public_note | ||
| prefix_comm | varchar(5) | YES | MUL | NULL | prefix commercial | |
| client | tinyint(4) | YES | 0 | type of client (0/1/2/3) 1=customer 2=prospect 3=customer+prospect | ||
| fournisseur | tinyint(4) | YES | 0 | is it a third party supplier (0/1)? | ||
| supplier_account | varchar(32) | YES | NULL | account of a supplier | ||
| fk_prospectlevel | varchar(12) | YES | NULL | ID of prospect level (llx_c_prospectlevel->code) | ||
| customer_bad | tinyint(4) | YES | 0 | is the customer deadbeat (0/1)? | ||
| customer_rate | double | YES | 0 | reliability rate of customer (0 to 1)? | ||
| supplier_rate | double | YES | 0 | reliability rate of supplier (0 to 1)? | ||
| fk_user_creat | int(11) | YES | MUL | NULL | ID of user who created the entry (llx_user->rowid) | |
| fk_user_modif | int(11) | YES | MUL | NULL | ID of user who last modified the entry (llx_user->rowid) | |
| remise_client | double | YES | 0 | systematic discount for the customer | ||
| mode_reglement | tinyint(4) | YES | NULL | default payment mode | ||
| cond_reglement | tinyint(4) | YES | NULL | default payment conditions | ||
| tva_assuj | tinyint(4) | YES | 1 | Supplier: issues invoices with VAT? / Customer: is subject to VAT? | ||
| localtax1_assuj | tinyint(4) | YES | 0 | is subject to localtax1? | ||
| localtax2_assuj | tinyint(4) | YES | 0 | is subject to localtax2? | ||
| barcode | varchar(255) | YES | NULL | This field is used to store barcode value of thirdparty when module barcode is enabled | ||
| fk_barcode_type | int(11) | YES | 0 | This field is used to store barcode type (EAN, ISBN, ...) of thirdparty when module barcode is enabled | ||
| price_level | int(11) | YES | NULL | level of price for multiprices | ||
| outstanding_limit | double(24,8) | YES | NULL | Amount of allowed outstanding invoices before warning | ||
| default_lang | varchar(6) | YES | NULL | default language for this thirdparty | ||
| logo | varchar(255) | YES | NULL | |||
| canvas | varchar(32) | YES | NULL | |||
| import_key | varchar(14) | YES | NULL | Code used to save the import id. 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