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
+
|}