Table llx commandedet: Difference between revisions

Jump to navigation Jump to search

Table llx commandedet (view source)

Revision as of 11:18, 25 July 2024

677 bytes removed ,  2 years ago
m
→‎Table
VisualWikitext
Tag: 2017 source edit
 
(9 intermediate revisions by 3 users not shown)
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>
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/16444...60991"

Navigation menu