Changes

Line 32: Line 32:  
| technical index
 
| technical index
 
|-
 
|-
 +
| fk_commande
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of order ([[Table llx commande|llx commande]]->rowid)
 +
|-
 +
| fk_product
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of product ([[Table llx_product|llx_product]]->rowid)
 +
|-
 +
| ref
 +
| varchar(50)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ref. of product
 +
|-
 +
| label
 +
| varchar(255)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| label of product
 +
|-
 +
| description
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| product description
 +
|-
 +
| tva_tx
 +
| double(6,3)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| VAT taxes
 +
|-
 +
| qty
 +
| double
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| Quantity of product
 +
|-
 +
| remise_percent
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount percentage
 +
|-
 +
| remise
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| discount amount
 +
|-
 +
| subprice
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| unit price before
 +
|-
 +
| 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
 +
|-
 +
| product_type
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| type of product
 +
|-
 +
| date_start
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| start date if service
 +
|-
 +
| date_end
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| end date if service
 +
|-
 +
| info_bits
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| TVA NPR or not
 +
|}