Table llx contrat
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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 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 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 |