Table llx contrat: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
No edit summary
mNo edit summary
Tag: 2017 source edit
 
(10 intermediate revisions by 3 users not shown)
Line 6: Line 6:
{{ListOfTables}}
{{ListOfTables}}


= Contenu =
= Content/Contenu/Contenido =


{{flag en}} Contains the contrats. The contrats details are in [[Table llx_contratdet]]


= Structure =
{{flag fr}} Contient des contrats, les détails du contrat sont dans la [[Table llx_contratdet]]


{{flag sp}} Contiene los contratos, los detalles de los contratos están en [[Table llx_contratdet]]


<pre>
= Structure =
-- ============================================================================
== Table ==
-- Copyright (C) 2002-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-- Copyright (C) 2004      Laurent Destailleur  <eldy@users.sourceforge.net>
|style="background-color: #e9e9ef"| <b>Field</b>
--
|style="background-color: #e9e9ef"| <b>Type</b>
-- This program is free software; you can redistribute it and/or modify
|style="background-color: #e9e9ef"| <b>Null</b>
-- it under the terms of the GNU General Public License as published by
|style="background-color: #e9e9ef"| <b>Key</b>
-- the Free Software Foundation; either version 2 of the License, or
|style="background-color: #e9e9ef"| <b>Default</b>
-- (at your option) any later version.
|style="background-color: #e9e9ef"| <b>Extra</b>
--
|style="background-color: #e9e9ef"| <b>Description</b>
-- This program is distributed in the hope that it will be useful,
|-  
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
| rowid
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
| int(11)
-- GNU General Public License for more details.
| NO
--
| PRI
-- You should have received a copy of the GNU General Public License
|
-- along with this program; if not, write to the Free Software
| auto_increment
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
| technical index
--
|-
-- $Id: llx_contrat.sql,v 1.5 2004/10/09 10:47:16 opensides Exp $
| ref
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_contrat.sql,v $
| 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
|-
| 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 ([[Table llx_societe|llx_societe]]->rowid)
|-
| fk_projet
| int(11)
| YES
|
| NULL
|
| ID of proyect ([[Table llx_projet|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 ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_mis_en_service
| int(11)
| YES
|
| NULL
|
| ID activator user ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_cloture
| 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;


create table llx_contrat
== Keys ==
(
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  rowid          integer AUTO_INCREMENT PRIMARY KEY,
|style="background-color: #e9e9ef"| <b>Key</b>
  tms            timestamp,
|style="background-color: #e9e9ef"| <b>Type</b>
  enservice      smallint DEFAULT 0,
|style="background-color: #e9e9ef"| <b>Fields</b>
  mise_en_service datetime,
|-
  fin_validite    datetime,
| PRIMARY
  date_cloture    datetime,
| PRIMARY
  fk_soc          integer NOT NULL,
| rowid
  fk_product      integer NOT NULL,
|-
  fk_facture      integer NOT NULL default 0,
| uk_contrat_ref
  fk_facturedet  integer NOT NULL default 0,
| UNIQUE
  fk_user_author integer NOT NULL default 0,
| ref,entity
   fk_user_mise_en_service integer,
|-
  fk_user_cloture integer
| idx_contrat_fk_soc 
)type=innodb;
| MULTIPLE
</pre>
| 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"