Table llx contrat

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

返回
开发文档

Content/Contenu/Contenido

Contains the contrats. The contrats details are in Table llx_contratdet

Contient des contrats, les détails du contrat sont dans la Table llx_contratdet

Contiene los contratos, los detalles de los contratos están en Table llx_contratdet

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
ref	varchar(30)	YES	UNI	NULL		contrat reference
entity	int(11)	NO		1		See page Field Multi company id. (llx_entity->rowid)
ref_ext	varchar(30)	NO				See page Field ref_ext.
tms	timestamp	NO		CURRENT_TIMESTAMP		last update date
date_c	datetime	YES		NULL		creation date
date_contract	datetime	YES		NULL		date of contract
statut	smallint(6)	YES		0		status of contract
mise_en_service	datetime	YES		NULL		date of contract activation
fin_validite	datetime	YES		NULL		date of end validation
date_cloture	datetime	YES		NULL		date of contract close
fk_soc	int(11)	NO	MUL			ID society (llx_societe->rowid)
fk_projet	int(11)	YES		NULL		ID of proyect (llx_projet->rowid)
fk_commercial_signature	int(11)	NO				obsolete
fk_commercial_suivi	int(11)	NO				obsolete
fk_user_author	int(11)	NO	MUL	0		ID creator user (llx_user->rowid)
fk_user_mis_en_service	int(11)	YES		NULL		ID activator user (llx_user->rowid)
fk_user_cloture	int(11)	YES		NULL		ID closer user (llx_user->rowid)
note	text	YES		NULL		comentary
note_public	text	YES		NULL		public comentary

 

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_contrat_ref	UNIQUE	ref,entity
idx_contrat_fk_soc	MULTIPLE	fk_soc
idx_contrat_fk_user_author	MULTIPLE	fk_user_author