Table llx commandedet: Difference between revisions

Table llx commandedet (view source)

Revision as of 15:18, 12 May 2009

747 bytes added , 17 years ago

no edit summary

VisualWikitext

Simnandez

Bureaucrats, Administrators

4,395

edits

@@ Line 7: / Line 7: @@
 = Contenu =
-Détails des commandes clients, cette table est liée avec la [[Table llx_commande]]
+{{flag fr}} 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]]
-Contiene los detalles de los pedidos de clientes, esta tabla esta vinculada con [[Table llx_commande]]
+{{flag sp}} Contiene los detalles de los pedidos de clientes, esta tabla esta vinculada con [[Table llx_commande]]
 = 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"
+ |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)
+| &nbsp;
+| PRI
+| NULL
+| auto_increment
+| technical index
+|-
+| fk_commande
+| int(11)
+|
+|
+|
+|
+| ID of order
+|-
+| fk_product
+| int(11)
+|
+|
+|
+|
+| Id of product
+|-
+| description
+| text
+|
+|
+|
+|
+|
+|-
+| tva_tx
+| real
+|
+|
+| 19.6
+|
+| VAT taxes
+|-
-<pre>
+| qty
-  rowid          integer AUTO_INCREMENT PRIMARY KEY,
+| real
-  fk_commande    integer,
+|
-  fk_product     integer,
+|
-  description    text,
+|
-  tva_tx         real DEFAULT 19.6, -- taux tva
+|
-  qty            real,              -- quantit
+| Quantity
-  remise_percent double DEFAULT 0,    -- pourcentage de remise
+|-
-  remise         double DEFAULT 0,    -- montant de la remise
-  fk_remise_except int default NULL,
+| remise_percent
-  price          double,              -- prix final
+| double
-  subprice       double,              -- prix avant remise
+|
-  total_ht       double,
+|
-  total_tva      double,
+| 0
-  total_ttc      double,
+|
-  info_bits      int,
+| discount percentage
-  coef           double,
+|-
-  special_code   tinyint default 0,   -- utilisé pour les frais de port (=1) et les écotaxes (=2). Sinon à 0.
+| remise
-  rang           int
+| double
-</pre>
+|
+|
+| 0
+|
+| discount amount
+|-
+| fk_remise_except
+| int
+|
+|
+| NULL
+|
+|
+|-
+| price
+| double
+|
+|
+|
+|
+| final price
+|-
+| subprice
+| double
+|
+|
+|
+|
+| price before discount
+|-
+| total_ht
+| double
+|
+|
+|
+|
+|
+|-
+| total_tva
+| double
+|
+|
+|
+|
+|
+|-
+| total_ttc
+| double
+|
+|
+|
+|
+|
+|-
+| info_bits
+| int
+|
+|
+|
+|
+|
+|-
+| coef
+| double
+|
+|
+|
+|
+|
+|-
+| special_code
+| tinyint
+|
+|
+| 0
+|
+| used for shipping (=1) and ecotaxes (=2). Otherwise=0
+|-
+| rang
+| int
+|
+|
+|
+|
+|
+|}