Table llx socpeople

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

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Contenu

La table llx_socpeople contient les contacts (personnes) des sociétés (clients et fournisseurs)

Contains the contact people of companies (clients or providers).

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

Structure

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)		PRI	NULL	auto_increment	technical index
datec	datetime	YES		NULL		creation date
tms	timestamp	NO		CURRENT_TIMESTAMP		timestamp (date last modified)
fk_soc	int(11)	YES	MUL	NULL		foreign key to llx_societe
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		foreign key to llx_c_pays
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)
fk_user_creat	int(11)	YES	MUL	0		foreign key to llx_user (user who created this contact)
fk_user_modif	int(11)	YES		NULL		foreign key to llx_user (user who changed this contact)
note	text	YES		NULL		note