Difference between revisions of "Table llx contratdet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
 
Tag: 2017 source edit
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[Catégorie:Table SQL]]
+
[[Category:Table SQL]]
−
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
+
[[Category:Contract]]
−
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
+
[[Category:Contrat]]
 +
[[Category:Contratos]]
  
−
= Contenu =
+
{{ListOfTables}}
  
 +
= Content/Contenu/Contenido =
 +
 +
{{flag en}} Contains the details of contrats. This table is linked to [[Table llx_contrat]]
 +
 +
{{flag fr}} Contient les détails des contrats, cette table est liée avec la [[Table llx_contrat]]
 +
 +
{{flag sp}} Contiene los detalles de los contratos, esta tabla está vinculada con [[Table llx_contrat]]
  
 
= Structure =
 
= Structure =
 +
== 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>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Null</b>
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Default</b>
 +
|style="background-color: #e9e9ef"| <b>Extra</b>
 +
|style="background-color: #e9e9ef"| <b>Description</b>
 +
|-
 +
| rowid
 +
| int(11)
 +
| NO
 +
| PRI
 +
|
 +
| auto_increment
 +
| technical index
 +
{{FieldTms}}
 +
|-
 +
| fk_contrat
 +
| int(11)
 +
| NO
 +
| MUL
 +
|
 +
|
 +
| ID of contrat ([[Table llx_contrat|llx_contrat]]->rowid)
 +
|-
 +
| fk_product
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID of product ([[Table llx_product|llx_product]]->rowid)
 +
|-
 +
| statut
 +
| smallint(6)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| state
 +
|-
 +
| label
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| label of product
 +
|-
 +
| description
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| product or service description
 +
|-
 +
| fk_remise_except
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
 +
|-
 +
| date_commande
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of order
 +
|-
 +
| date_ouverture_prevue
 +
| datetime
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| open service date
 +
|-
 +
| date_ouverture
 +
| datetime
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| client open service date
 +
|-
 +
| date_fin_validite
 +
| datetime
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| end service date
 +
|-
 +
| date_cloture
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| close service date
 +
|-
 +
| tva_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| 0.000
 +
|
 +
| VAT taxes
 +
|-
 +
| qty
 +
| real
 +
| NO
 +
|
 +
|
 +
|
 +
| Quantity of product or service
 +
|-
 +
| remise_percent
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount percentage
 +
|-
 +
| subprice
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00000000
 +
|
 +
| unit price
 +
|-
 +
| price_ht
 +
| real
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| price excluding tax
 +
|-
 +
| remise
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount amount
 +
{{FieldTotalFields}}
 +
{{FieldInfoBits}}
 +
|-
 +
| fk_user_author
 +
| int(11)
 +
|
 +
|
 +
| 0 
 +
|
 +
| ID creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_ouverture
 +
| 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)
 +
|-
 +
| commentaire
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| comment
 +
|}&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
 +
|-
 +
| idx_contratdet_fk_contrat
 +
| MULTIPLE
 +
| fk_contrat
 +
|-
 +
| idx_contratdet_fk_product 
 +
| MULTIPLE
 +
| fk_product
 +
|-
 +
| idx_contratdet_date_ouverture_prevue 
 +
| MULTIPLE
 +
| date_ouverture_prevue
 +
|-
 +
| idx_contratdet_date_ouverture 
 +
| MULTIPLE
 +
| date_ouverture
 +
|-
 +
| idx_contratdet_date_fin_validite 
 +
| MULTIPLE
 +
| date_fin_validite
 +
|}&nbsp;

Latest revision as of 11:20, 25 July 2024


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 details of contrats. This table is linked to Table llx_contrat

Fr verysmall.png Contient les détails des contrats, cette table est liée avec la Table llx_contrat

Es verysmall.png Contiene los detalles de los contratos, esta tabla está vinculada con Table llx_contrat

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
tms timestamp NO Current date Date of last modification. See page Field Tms.
fk_contrat int(11) NO MUL ID of contrat (llx_contrat->rowid)
fk_product int(11) YES MUL NULL ID of product (llx_product->rowid)
statut smallint(6) YES 0 state
label text YES NULL label of product
description text YES NULL product or service description
fk_remise_except int(11) YES NULL ID of discount (llx_societe_remise_except->rowid)
date_commande datetime YES NULL date of order
date_ouverture_prevue datetime YES MUL NULL open service date
date_ouverture datetime YES MUL NULL client open service date
date_fin_validite datetime YES MUL NULL end service date
date_cloture datetime YES NULL close service date
tva_tx double(6,3) YES 0.000 VAT taxes
qty real NO Quantity of product or service
remise_percent real YES 0 discount percentage
subprice double(24,8) YES 0.00000000 unit price
price_ht real YES NULL price excluding tax
remise real YES 0 discount amount
total_ht double(24,8) YES NULL total excluding taxes
total_tva double(24,8) YES NULL total tax
total_localtax1 double(24,8) YES NULL total local tax 1
total_localtax2 double(24,8) YES NULL total local tax 2
total_ttc double(24,8) YES NULL Total including discount and taxes (vat + localtax1 + localtax2)
info_bits integer 0 TVA NPR or NOT
fk_user_author int(11) 0 ID creator user (llx_user->rowid)
fk_user_ouverture int(11) YES NULL ID activator user (llx_user->rowid)
fk_user_cloture int(11) YES NULL ID closer user (llx_user->rowid)
commentaire text YES NULL comment

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
idx_contratdet_fk_contrat MULTIPLE fk_contrat
idx_contratdet_fk_product MULTIPLE fk_product
idx_contratdet_date_ouverture_prevue MULTIPLE date_ouverture_prevue
idx_contratdet_date_ouverture MULTIPLE date_ouverture
idx_contratdet_date_fin_validite MULTIPLE date_fin_validite

 

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