Table llx contrat: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
mNo edit summary
Tag: 2017 source edit
 
(8 intermediate revisions by 3 users not shown)
Line 15: Line 15:


= 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 26: Line 27:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
|-
| tms
| ref
| timestamp
| varchar(30)
| YES
| UNI
| NULL
|  
|  
| contrat reference
{{FieldEntity}}
{{FieldRefExt}}
{{FieldTms}}
|-
| date_c
| datetime
| YES
|  
|  
| NULL
|  
|  
| creation date
|-
| date_contract
| datetime
| YES
|  
|  
| NULL
|  
|  
| date of contract
|-
|-
| enservice
| statut
| smallint  
| smallint(6)
|  
| YES
|  
|  
| 0
| 0
|  
|  
|  
| status of contract, 0=draft,1=validated
|-
|-
| mise_en_service
| mise_en_service
| datetime
| datetime
| YES
|  
|  
| NULL
|  
|  
|  
| date of contract activation
|
|
|-
|-
| fin_validate
| fin_validite
| datetime  
| datetime  
| YES
|  
|  
| NULL
|  
|  
|  
| date of end validation
|
|
|-
|-
| date_cloture
| date_cloture
| datetime  
| datetime  
| YES
|  
|  
| NULL
|  
|  
|  
| date of contract close
|
|
|-
|-
| fk_soc
| fk_soc
| int(11)  
| int(11)  
|  
| NO
|
| MUL
|   
|   
|  
|  
| ID of society
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| fk_product
| fk_projet
| int(11)  
| int(11)  
| YES
|  
|  
| NULL
|  
|  
| 
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
|
| ID of product
|-
|-
| fk_facture
| fk_commercial_signature
| int(11)  
| int(11)  
| NO
|  
|  
| 
|  
|  
| 0 
| obsolete
|
| ID of facture
|-
|-
| fk_facturedet
| fk_commercial_suivi
| int(11)  
| int(11)  
| NO
|  
|  
|
| 0 
|  
|  
|  
|  
| obsolete
|-
|-
| fk_user_author
| fk_user_author
| int(11)  
| int(11)  
|  
| NO
|  
| MUL
| 0   
| 0   
|  
|  
|  
| ID creator user ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_mis_en_service
| fk_user_mis_en_service
| int(11)  
| int(11)  
| YES
|  
|  
| NULL
|  
|  
|  
| ID activator user ([[Table llx_user|llx_user]]->rowid)
|
|  
|-
|-
| fk_user_cloture
| fk_user_cloture
| int(11)  
| int(11)  
| YES
|  
|  
| NULL
|
| ID closer user ([[Table llx_user|llx_user]]->rowid)
|-
| note
| text
| YES
|  
|  
| NULL
|  
|  
| comentary
|-
| note_public
| text
| YES
|  
|  
| NULL
|  
|  
|}
| public comentary
{{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
|-
| uk_contrat_ref
| UNIQUE
| ref,entity
|-
| idx_contrat_fk_soc 
| MULTIPLE
| fk_soc 
|-
| idx_contrat_fk_user_author 
| MULTIPLE
| fk_user_author
|}&nbsp;

Latest revision as of 17:56, 23 August 2020


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


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

 

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