Table llx contrat

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

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


Content/Contenu/Contenido

En verysmall.png Contains the contrats. The contrats details are in Table llx_contratdet

Fr verysmall.png Contient des contrats, les détails du contrat sont dans la Table llx_contratdet

Es verysmall.png 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 date Date of last modification. See page Field Tms.
date_c datetime YES NULL creation date
date_contract datetime YES NULL date of contract
statut smallint(6) YES 0 status of contract, 0=draft,1=validated
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
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_contrat_ref UNIQUE ref,entity
idx_contrat_fk_soc MULTIPLE fk_soc
idx_contrat_fk_user_author MULTIPLE fk_user_author