Changes

m
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
   
|}&nbsp;
 
|}&nbsp;
    
== 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>