Table llx contratdet: Difference between revisions

Jump to navigation Jump to search

Table llx contratdet (view source)

Revision as of 11:20, 25 July 2024

2,519 bytes added ,  2 years ago
m
→‎Table
VisualWikitext
Tag: 2017 source edit
 
(9 intermediate revisions by 2 users not shown)
Line 6: Line 6:
{{ListOfTables}}
{{ListOfTables}}


= Contenu =
= 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 =
{|  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 21: Line 27:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| 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;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/11421...60994"

Navigation menu