Line 15:
Line 15:
= Structure =
= Structure =
== Table ==
== Table ==
−
'''Version 1.1 2009/10/07'''
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
{| 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>Field</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Type</b>
Line 35:
Line 34:
| fk_commande
| fk_commande
| int(11)
| int(11)
−
| YES
+
| NO
| MUL
| MUL
−
| NULL
+
|
|
|
| ID of order ([[Table llx commande|llx commande]]->rowid)
| ID of order ([[Table llx commande|llx commande]]->rowid)
|-
|-
+
| fk_parent_line
+
| int(11)
+
| YES
+
|
+
| NULL
+
|
+
| Since ?
+
|-
| fk_product
| fk_product
| int(11)
| int(11)
Line 112:
Line 119:
|
|
| price before discount
| price before discount
−
|-
+
{{FieldTotalFields}}
−
| total_ht
−
| double(24,8)
−
| YES
−
|
−
| 0.00000000
−
|
−
| total excluding tax
−
|-
−
| total_tva
−
| double(24,8)
−
| YES
−
|
−
| 0.00000000
−
|
−
| total tax
−
|-
−
| total_ttc
−
| double(24,8)
−
| YES
−
|
−
| 0.00000000
−
|
−
| total with tax
|-
|-
| product_type
| product_type
Line 161:
Line 145:
| end date if service
| end date if service
|-
|-
−
| info_bits
+
{{FieldInfoBits}}
−
| int(11)
−
| YES
−
|
−
| 0
−
|
−
| TVA NPR or not
−
|-
| marge_tx
| marge_tx
| double(6,3)
| double(6,3)
Line 185:
Line 162:
| mark rate (margin on selling price)
| mark rate (margin on selling price)
|-
|-
−
| special_code
+
{{FieldSpecialCode}}
−
| tinyint(4)
−
| YES
−
|
−
| 0
−
|
−
| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
|-
|-
| rang
| rang
Line 201:
Line 172:
| order view
| order view
|-
|-
−
| import_key
+
{{FieldImportKey}}
−
| varchar(14)
−
| YES
−
|
−
| NULL
−
|
−
| import key
|}
|}
== Keys ==
== Keys ==
−
'''Version 1.1 2009/10/07'''
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
{| 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>Key</b>
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Type</b>