Changes

m
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}}
 +
|}&nbsp;
   −
<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,
+
|}&nbsp;
  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>