Table llx commandedet: Difference between revisions

Jump to navigation Jump to search

Table llx commandedet (view source)

Revision as of 11:18, 25 July 2024

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


= Contenu =
= Content/Contenu/Contenido =


{{flag fr}} Détails des commandes clients, cette table est liée avec la [[Table llx_commande]]
{{flag fr}} Contient les détails des commandes clients, cette table est liée avec la [[Table llx_commande]]


{{flag en}} Contains details of customer orders. This table is linked to [[Table llx_commande]]
{{flag en}} Contains details of customer orders. This table is linked to [[Table llx_commande]]
Line 14: Line 14:


= 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 25: Line 26:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
Line 33: Line 34:
| fk_commande  
| fk_commande  
| int(11)  
| int(11)  
| NO
| MUL
|  
|  
|  
|  
| ID of order ([[Table llx commande|llx commande]]->rowid)
|-
| fk_parent_line
| int(11)
| YES
|  
|  
| NULL
|  
|  
| ID of order
| Since ?
|-
|-
| fk_product
| fk_product
| int(11)  
| int(11)
|  
| YES
|
|  
|  
| NULL
|  
|  
| Id of product
| ID of product ([[Table llx_product|llx_product]]->rowid)
|-
|-
| description
| description
| text  
| text  
| YES
|  
|  
| NULL
|  
|  
|  
| product or service description
|
|
|-
|-
| tva_tx
| tva_tx
| real
| double(6,3)
| YES
|  
|  
|  
| NULL
| 19.6
|  
|  
| VAT taxes
| VAT taxes
|-
|-
| qty
| qty
| real
| real
| YES
|  
|  
| NULL
|  
|  
|
| Quantity of product or service
|
| Quantity
|-
|-
| remise_percent
| remise_percent
| double
| real
|  
| YES
|  
|  
| 0
| 0
Line 82: Line 89:
|-
|-
| remise
| remise
| double
| real
|  
| YES
|  
|  
| 0
| 0
Line 90: Line 97:
|-
|-
| fk_remise_except
| fk_remise_except
| int
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
|  
|  
|  
| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
|-
|-
| price
| price
| double
| real
|
| YES
|  
|  
|  
| NULL
|  
|  
| final price
| final price
|-
|-
| subprice
| subprice
| double
| double(24,8)
|  
| YES
|
|  
|  
| 0.00000000
|  
|  
| price before discount
| price before discount
{{FieldTotalFields}}
|-
|-
| total_ht
| product_type
| double
| int(11)
|  
| YES
|  
|  
| 0
|  
|  
| type of prodcut
|-
| date_start
| datetime
| YES
|  
|  
| NULL
|  
|  
| start date if service
|-
|-
| total_tva
| date_end
| double
| datetime
|
| YES
|  
|  
|  
|  
| NULL
|  
|  
| end date if service
|-
|-
| total_ttc
{{FieldInfoBits}}
| double
| marge_tx
|  
| double(6,3)
|
| YES
|
|  
|  
| 0.000
|  
|  
| margin (margin on purchase price)
|-
|-
| info_bits
| marque_tx
| int
| double(6,3)
|
| YES
|  
|  
|  
|  
| 0.000
|  
|  
| mark rate (margin on selling price)
|-
|-
| coef
{{FieldSpecialCode}}
| double
|
|
|
|
|
|-
|-
| special_code
| rang
| tinyint
| int(11)
|  
| YES
|  
|  
| 0
| 0
|  
|  
| used for shipping (=1) and ecotaxes (=2). Otherwise=0
| order view
|-
|-
| rang
{{FieldImportKey}}
| int
|}&nbsp;
|  
 
|  
== Keys ==
|  
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|  
|style="background-color: #e9e9ef"| <b>Key</b>
| View Order
|style="background-color: #e9e9ef"| <b>Type</b>
|}
|style="background-color: #e9e9ef"| <b>Fields</b>
|-
| PRIMARY
| PRIMARY
| rowid
|-
| idx_commandedet_fk_commande
| MULTIPLE
| fk_commande
|}&nbsp;
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/11446...60991"

Navigation menu