Difference between revisions of "Table llx commandedet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
Tag: 2017 source edit
 
(14 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 ([[Table llx_product|llx_product]]->rowid)
−
| Id of product
 
 
|-
 
|-
 
| 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>
−
|  
+
|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;

Latest revision as of 11:18, 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

Fr verysmall.png Contient les détails des commandes clients, cette table est liée avec la Table llx_commande

En verysmall.png Contains details of customer orders. This table is linked to Table llx_commande

Es verysmall.png Contiene los detalles de los pedidos de clientes, esta tabla esta vinculada con Table llx_commande

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
fk_commande int(11) NO MUL ID of order (llx commande->rowid)
fk_parent_line int(11) YES NULL Since ?
fk_product int(11) YES NULL ID of product (llx_product->rowid)
description text YES NULL product or service description
tva_tx double(6,3) YES NULL VAT taxes
qty real YES NULL Quantity of product or service
remise_percent real YES 0 discount percentage
remise real YES 0 discount amount
fk_remise_except int(11) YES NULL ID of discount (llx_societe_remise_except->rowid)
price real YES NULL final price
subprice double(24,8) YES 0.00000000 price before discount
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)
product_type int(11) YES 0 type of prodcut
date_start datetime YES NULL start date if service
date_end datetime YES NULL end date if service
info_bits integer 0 TVA NPR or NOT marge_tx double(6,3) YES 0.000 margin (margin on purchase price)
marque_tx double(6,3) YES 0.000 mark rate (margin on selling price)
special_code integer YES 0 0=default, 1=seems no more used (or may be used to set line as transport/shipping fee), 2=used by WEEE module to define line as a WEEE line, 3=option line (price must not included in total), 4=Sent for cooking (POS modules for restaurant), Module ID (>= 5)=value for a custom need. Value is an additional information and has no effect, except value 3 that means "do not take into account amount, it is an option" (so price must not be included in total, qty in this case should be also 0).
rang int(11) YES 0 order view
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
idx_commandedet_fk_commande MULTIPLE fk_commande

 

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