Difference between revisions of "Table llx commandedet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 33: Line 33:
 
| fk_commande  
 
| fk_commande  
 
| int(11)  
 
| int(11)  
 +
| YES
 
|  
 
|  
 +
| NULL
 
|  
 
|  
−
|
+
| ID of order ([[Table llx commande|llx commande]]->rowid)
−
|
+
|-  
−
| ID of order
 
−
|-
 
 
| 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
+
| double
−
|
+
| YES
−
|  
 
 
|  
 
|  
 +
| NULL
 
|  
 
|  
−
| Quantity
+
| Quantity of product or service
 
|-
 
|-
−
 
 
| remise_percent
 
| remise_percent
 
| double
 
| double
−
|  
+
| YES
 
|  
 
|  
 
| 0
 
| 0
Line 83: Line 81:
 
| remise
 
| remise
 
| double
 
| double
−
|  
+
| YES
 
|  
 
|  
 
| 0
 
| 0
Line 90: Line 88:
 
|-
 
|-
 
| fk_remise_except
 
| fk_remise_except
−
| int
+
| int(11)
 
|  
 
|  
 
|  
 
|  
 
| NULL
 
| NULL
 
|  
 
|  
−
|  
+
| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
 
|-
 
|-
 
| price
 
| price
 
| double
 
| double
 +
| YES
 
|  
 
|  
−
|  
+
| NULL
−
|
 
 
|  
 
|  
 
| final price
 
| final price
 
|-
 
|-
 
| subprice
 
| subprice
−
| double
+
| double(24,8)
−
|  
+
| YES
−
|
 
 
|  
 
|  
 +
| 0.00
 
|  
 
|  
 
| price before discount
 
| price before discount
 
|-
 
|-
 
| total_ht
 
| total_ht
−
| double
+
| double(24,8)
−
|  
+
| YES
 
|  
 
|  
 +
| 0.00
 
|  
 
|  
 +
| total excluding tax
 +
|-
 +
| total_tva
 +
| double(24,8)
 +
| YES
 
|  
 
|  
 +
| 0.00
 
|  
 
|  
 +
| total tax
 
|-
 
|-
−
| total_tva
+
| total_ttc
−
| double
+
| double(24,8)
−
|  
+
| YES
 
|  
 
|  
 +
| 0.00
 
|  
 
|  
 +
| total with tax
 +
|-
 +
| product_type
 +
| int(11)
 +
| YES
 
|  
 
|  
 +
| 0
 
|  
 
|  
 +
| type of prodcut
 
|-
 
|-
−
| total_ttc
+
| date_start
−
| double
+
| datetime
−
|  
+
| YES
 
|  
 
|  
 +
| NULL
 
|  
 
|  
 +
| start date if service
 +
|-
 +
| date_end
 +
| datetime
 +
| YES
 
|  
 
|  
 +
| NULL
 
|  
 
|  
 +
| end date if service
 
|-
 
|-
 
| info_bits
 
| info_bits
−
| int
+
| int(11)
−
|  
+
| YES
 
|  
 
|  
 +
| 0
 
|  
 
|  
 +
| TVA NPR or not
 +
|-
 +
| marge_tx
 +
| double(6,3)
 +
| YES
 
|  
 
|  
 +
| 0.00
 
|  
 
|  
 +
| margin (margin on purchase price)
 
|-
 
|-
−
| coef
+
| marque_tx
−
| double
+
| double(6,3)
−
|  
+
| YES
−
|
 
−
|
 
 
|  
 
|  
 +
| 0.00
 
|  
 
|  
 +
| mark rate (margin on selling price)
 
|-
 
|-
 
| special_code
 
| special_code
−
| tinyint
+
| tinyint(4)
−
|  
+
| YES
 
|  
 
|  
 
| 0
 
| 0
 
|  
 
|  
−
| used for shipping (=1) and ecotaxes (=2). Otherwise=0
+
| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
 
|-
 
|-
 
| rang
 
| rang
−
| int
+
| int(11)
 +
| YES
 
|  
 
|  
 +
| 0
 
|  
 
|  
 +
| order view
 +
|-
 +
| import_key
 +
| varchar(14)
 +
| YES
 
|  
 
|  
 +
| NULL
 
|  
 
|  
−
| View Order
+
| import key
 
|}
 
|}

Revision as of 15:23, 2 June 2009


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


Contenu

Fr verysmall.png 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

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_commande int(11) YES NULL ID of order (llx commande->rowid)
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 double YES NULL Quantity of product or service
remise_percent double YES 0 discount percentage
remise double YES 0 discount amount
fk_remise_except int(11) NULL ID of discount (llx_societe_remise_except->rowid)
price double YES NULL final price
subprice double(24,8) YES 0.00 price before discount
total_ht double(24,8) YES 0.00 total excluding tax
total_tva double(24,8) YES 0.00 total tax
total_ttc double(24,8) YES 0.00 total with tax
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 int(11) YES 0 TVA NPR or not
marge_tx double(6,3) YES 0.00 margin (margin on purchase price)
marque_tx double(6,3) YES 0.00 mark rate (margin on selling price)
special_code tinyint(4) YES 0 code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
rang int(11) YES 0 order view
import_key varchar(14) YES NULL import key
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_commandedet&oldid=12433"