Table llx commande: Difference between revisions

Line 14: Line 14:


= Structure =
= Structure =
'''Version 1.19 2009/04/29'''
{|  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"
{|  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>
Line 25: Line 27:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
| NULL
Line 49: Line 51:
| fk_projet
| fk_projet
| int(11)
| int(11)
|  
| YES
|  
|  
| 0
| 0
Line 65: Line 67:
| entity
| entity
| int(11)  
| int(11)  
| &nbsp;
| NO
|  
|  
| 1
| 1
Line 149: Line 151:
| 0
| 0
|  
|  
|  
| ID of status
|-
|-
| amount_ht
| amount_ht
| double
| real
| YES
| YES
|  
|  
| 0
| 0
|  
|  
|  
| amount without tax
|-
|-
| remise_percent
| remise_percent
| double
| real
| YES
| YES
|  
|  
| 0
| 0
|  
|  
|  
| discount percentage
|-
|-
| remise
| remise
| double
| real
| YES
| YES
|  
|  
| 0
| 0
|  
|  
|  
| discount amount
|-
|-
| tva
| tva
Line 179: Line 181:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|
|  
|  
| VAT
|-
|-
| total_ht
| total_ht
Line 187: Line 189:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|
|  
|  
| total without tax
|-
|-
| total_ttc
| total_ttc
Line 195: Line 197:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|
|  
|  
| total
|-
|-
| note
| note
Line 270: Line 272:
|  
|  
| import key
| import key
|}
|}&nbsp;