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

3,062 bytes added ,  2 years ago
m
→‎Table
VisualWikitext
No edit summary
 
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;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/4598...60994"

Navigation menu