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:Commande]]
−
The documentation related to other tables is available on the tables list page: [[Liste des tables]]
+
[[Category:Orders]]
+
[[Category:Pedido]]
+
{{ListOfTables}}
−
= Contenu =
+
= Content/Contenu/Contenido =
−
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]]
−
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]]
+
+
{{flag sp}} Contiene los detalles de los pedidos de clientes, esta tabla esta vinculada con [[Table llx_commande]]
= 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
+
|-
+
| fk_commande
+
| int(11)
+
| NO
+
| MUL
+
|
+
|
+
| ID of order ([[Table llx commande|llx commande]]->rowid)
+
|-
+
| fk_parent_line
+
| int(11)
+
| YES
+
|
+
| NULL
+
|
+
| Since ?
+
|-
+
| fk_product
+
| int(11)
+
| YES
+
|
+
| NULL
+
|
+
| ID of product ([[Table llx_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 ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
+
|-
+
| price
+
| real
+
| YES
+
|
+
| NULL
+
|
+
| final price
+
|-
+
| subprice
+
| double(24,8)
+
| YES
+
|
+
| 0.00000000
+
|
+
| price before discount
+
{{FieldTotalFields}}
+
|-
+
| 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
+
|-
+
{{FieldInfoBits}}
+
| 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)
+
|-
+
{{FieldSpecialCode}}
+
|-
+
| rang
+
| int(11)
+
| YES
+
|
+
| 0
+
|
+
| order view
+
|-
+
{{FieldImportKey}}
+
|}
−
<pre>
+
== Keys ==
−
rowid integer AUTO_INCREMENT PRIMARY KEY,
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
fk_commande integer,
+
|style="background-color: #e9e9ef"| <b>Key</b>
−
fk_product integer,
+
|style="background-color: #e9e9ef"| <b>Type</b>
−
description text,
+
|style="background-color: #e9e9ef"| <b>Fields</b>
−
tva_tx real DEFAULT 19.6, -- taux tva
+
|-
−
qty real, -- quantit
+
| PRIMARY
−
remise_percent double DEFAULT 0, -- pourcentage de remise
+
| PRIMARY
−
remise double DEFAULT 0, -- montant de la remise
+
| rowid
−
fk_remise_except int default NULL,
+
|-
−
price double, -- prix final
+
| idx_commandedet_fk_commande
−
subprice double, -- prix avant remise
+
| MULTIPLE
−
total_ht double,
+
| fk_commande
−
total_tva double,
+
|}
−
total_ttc double,
−
info_bits int,
−
coef double,
−
special_code tinyint default 0, -- utilisé pour les frais de port (=1) et les écotaxes (=2). Sinon à 0.
−
rang int
−
</pre>