29,279
edits
Changes
m
→Table
Line 5:
Line 5:
|-+| 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
| info_bits+| int(11)
−| YES
−|
−| 0
−|
−| TVA NPR or not
−|-
| special_code+| tinyint(4)
−| YES
−|
−| 0
−|
−| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
−
{{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)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
|-
|-
| fk_commande
| fk_commande
+| int(11)
+| NO
+| MUL
+|
+|
+| ID of order ([[Table llx commande|llx commande]]->rowid)
+|-
+| fk_parent_line
| int(11)
| int(11)
| YES
| YES
Line 37:
Line 46:
| NULL
| NULL
|
|
−| ID of order ([[Table llx commande|llx commande]]->rowid)
+| Since ?
−|-
+|-
| fk_product
| fk_product
| int(11)
| int(11)
Line 64:
Line 73:
|-
|-
| qty
| qty
−| double
+| real
| YES
| YES
|
|
Line 72:
Line 81:
|-
|-
| remise_percent
| remise_percent
−| double
+| real
| YES
| YES
|
|
Line 80:
Line 89:
|-
|-
| remise
| remise
−| double
+| real
| YES
| YES
|
|
Line 89:
Line 98:
| fk_remise_except
| fk_remise_except
| int(11)
| int(11)
−|
+| YES
|
|
| NULL
| NULL
Line 96:
Line 105:
|-
|-
| price
| price
−| double
+| real
| YES
| YES
|
|
Line 107:
Line 116:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| price before discount
| price before discount
−{{FieldTotalFields}}
−|-
|-
| product_type
| product_type
Line 159:
Line 145:
| end date if service
| end date if service
|-
|-
−{{FieldInfoBits}}
−| marge_tx
| marge_tx
| double(6,3)
| double(6,3)
| YES
| YES
|
|
−| 0.00
+| 0.000
|
|
| margin (margin on purchase price)
| margin (margin on purchase price)
Line 179:
Line 158:
| YES
| YES
|
|
−| 0.00
+| 0.000
|
|
| mark rate (margin on selling price)
| mark rate (margin on selling price)
|-
|-
−{{FieldSpecialCode}}
−|-
|-
| rang
| rang
Line 199:
Line 172:
| order view
| order view
|-
|-
−| import_key
+{{FieldImportKey}}
−| varchar(14)
+|}
−| YES
+|
+== Keys ==
−| NULL
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−|
+ |style="background-color: #e9e9ef"| <b>Key</b>
−| import key
+ |style="background-color: #e9e9ef"| <b>Type</b>
−|}
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| idx_commandedet_fk_commande
+| MULTIPLE
+| fk_commande
+|}