Dolibarr ERP CRM Wiki

Table llx socpeople: Difference between revisions

VisualWikitext
No edit summary
 
(9 intermediate revisions by 2 users not shown)
Line 7: Line 7:
= Contenu =
= Contenu =


La table '''llx_socpeople''' contient les contacts (personnes) des sociétés (clients et fournisseurs)
{{Flag en}} Contains the people or generic contacts linked to third parties or not (customers, suppliers...).


Contains the contact people of companies (clients or providers).
{{Flag fr}} Contient les contacts physiques (personnes, ou adresses génériques de personnes) liés ou non au tiers (clients, fournisseurs...)


Contiene los contactos físicos (personas) de las empresas (clientes y proveedores).
{{Flag sp}} Contiene los contactos físicos (personas) de las empresas (clientes, proveedores...).


= Structure =
= Structure =
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
== Table ==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 25: Line 26:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| index technique
| technical index
|-  
|-  
| datec  
| datec  
Line 37: Line 38:
| NULL  
| NULL  
|  
|  
| date de création
| creation date
|-
{{FieldTms}}
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| timestamp (date dernière modification)
|-  
|-  
| fk_soc  
| fk_soc  
Line 53: Line 47:
| NULL  
| NULL  
|  
|  
| clef étrangère vers llx_societe
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
| entity
| int(11)
| NO
|
| 1
|
| multi company id
|-  
|-  
| civilite  
| civilite  
Line 61: Line 63:
| NULL  
| NULL  
|  
|  
| civilité (en texte ex: MR, MME,...)
| civility (in text eg Mr, Mrs,...)
|-  
|-  
| name  
| name  
Line 69: Line 71:
| NULL  
| NULL  
|  
|  
| nom de famille
| last name
|-  
|-  
| firstname  
| firstname  
Line 77: Line 79:
| NULL  
| NULL  
|  
|  
| prénom
| first name
|-  
|-  
| address  
| address  
Line 85: Line 87:
| NULL  
| NULL  
|  
|  
| adresse
| address
|-  
|-  
| cp  
| cp  
Line 93: Line 95:
| NULL  
| NULL  
|  
|  
| code postal
| postcode
|-  
|-  
| ville  
| ville  
Line 101: Line 103:
| NULL  
| NULL  
|  
|  
| ville
| city
|-  
|-  
| fk_pays  
| fk_pays  
Line 109: Line 111:
| 0  
| 0  
|  
|  
| clef étrangère vers llx_c_pays
| ID of country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|-  
|-  
| birthday  
| birthday  
Line 117: Line 119:
| NULL  
| NULL  
|  
|  
| anniversaire/date de naissance
| anniversary/date of birth
|-  
|-  
| poste  
| poste  
Line 125: Line 127:
| NULL  
| NULL  
|  
|  
| fonction au sein de l'entreprise
| function within the company
|-  
|-  
| phone  
| phone  
Line 133: Line 135:
| NULL  
| NULL  
|  
|  
| téléphone
| telephone
|-  
|-  
| phone_perso  
| phone_perso  
Line 141: Line 143:
| NULL  
| NULL  
|  
|  
| téléphone personnel
| personal telephone
|-  
|-  
| phone_mobile  
| phone_mobile  
Line 149: Line 151:
| NULL  
| NULL  
|  
|  
| téléphone mobile (GSM)
| mobile phone (GSM)
|-  
|-  
| fax  
| fax  
Line 173: Line 175:
| NULL  
| NULL  
|  
|  
| identifiant sur le réseau Jabber (pourrait être un autre réseau également)
| identifier on the Jabber network (could be another network)
|-
| priv
| smallint(6)
| NO
|
| 0
|
|
|-  
|-  
| fk_user_creat  
| fk_user_creat  
Line 181: Line 191:
| 0  
| 0  
|  
|  
| clef étrangère vers llx_user (utilisateur qui a créé ce contact)
| user who created this contact ([[Table llx_user|llx_user]]->rowid)
|-  
|-  
| fk_user_modif  
| fk_user_modif  
Line 189: Line 199:
| NULL  
| NULL  
|  
|  
| clef étrangère vers llx_user (utilisateur qui a modifié ce contact)
| user who changed this contact ([[Table llx_user|llx_user]]->rowid)
|-  
|-  
| note  
| note  
Line 198: Line 208:
|  
|  
| note
| note
|}
|-
| default_lang
| varchar(6)
| YES
|
| NULL
|
| default language for this contact
|-
{{FieldImportKey}}
|}&nbsp;
 
== Keys ==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Fields</b>
|-
| PRIMARY
| PRIMARY
| rowid
|-
| idx_socpeople_fk_soc
| MULTIPLE
| fk_soc
|-
| idx_socpeople_fk_user_creat
| MULTIPLE
| fk_user_creat
|}&nbsp;

Latest revision as of 12:53, 10 August 2012


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Contenu

  Contains the people or generic contacts linked to third parties or not (customers, suppliers...).

  Contient les contacts physiques (personnes, ou adresses génériques de personnes) liés ou non au tiers (clients, fournisseurs...)

  Contiene los contactos físicos (personas) de las empresas (clientes, proveedores...).

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
datec datetime YES NULL creation date
tms timestamp NO Current date Date of last modification. See page Field Tms.
fk_soc int(11) YES MUL NULL ID of society (llx_societe->rowid)
entity int(11) NO 1 multi company id
civilite varchar(6) YES NULL civility (in text eg Mr, Mrs,...)
name varchar(50) YES NULL last name
firstname varchar(50) YES NULL first name
address varchar(255) YES NULL address
cp varchar(25) YES NULL postcode
ville varchar(255) YES NULL city
fk_pays int(11) YES 0 ID of country (llx_c_pays->rowid)
birthday date YES NULL anniversary/date of birth
poste varchar(80) YES NULL function within the company
phone varchar(30) YES NULL telephone
phone_perso varchar(30) YES NULL personal telephone
phone_mobile varchar(30) YES NULL mobile phone (GSM)
fax varchar(30) YES NULL fax
email varchar(255) YES NULL e-mail
jabberid varchar(255) YES NULL identifier on the Jabber network (could be another network)
priv smallint(6) NO 0
fk_user_creat int(11) YES MUL 0 user who created this contact (llx_user->rowid)
fk_user_modif int(11) YES NULL user who changed this contact (llx_user->rowid)
note text YES NULL note
default_lang varchar(6) YES NULL default language for this contact
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
idx_socpeople_fk_soc MULTIPLE fk_soc
idx_socpeople_fk_user_creat MULTIPLE fk_user_creat

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_socpeople&oldid=26745"