4,395
edits
Changes
→Structure
Line 33:
Line 33:
| +| +|
|
−|
| 19.6
| +|
|
|
−|
| fk_commande
| fk_commande
| int(11)
| int(11)
+| YES
|
|
+| NULL
|
|
−| ID of order ([[Table llx commande|llx commande]]->rowid)
−|-
−| ID of order
−|-
| fk_product
| fk_product
−| int(11)
+| int(11)
−|
+| YES
−|
|
+| NULL
|
|
−| Id of product
+| ID of product ([[Table llx_product|llx_product]]->rowid)
|-
|-
| description
| description
| text
| text
+| YES
|
|
+| NULL
|
|
−|
+| product or service description
−|-
|-
| tva_tx
| tva_tx
−| real
+| double(6,3)
+| YES
|
|
−|
+| NULL
−|
|
| VAT taxes
| VAT taxes
|-
|-
−| qty
| qty
−| real
+| double
−| YES
−|
|
|
+| NULL
|
|
−| Quantity
+| Quantity of product or service
|-
|-
−| remise_percent
| remise_percent
| double
| double
−|
+| YES
|
|
| 0
| 0
Line 83:
Line 81:
| remise
| remise
| double
| double
−|
+| YES
|
|
| 0
| 0
Line 90:
Line 88:
|-
|-
| fk_remise_except
| fk_remise_except
−| int
+| int(11)
|
|
|
|
| NULL
| NULL
|
|
−|
+| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
|-
|-
| price
| price
| double
| double
+| YES
|
|
−|
+| NULL
−|
|
| final price
| final price
|-
|-
| subprice
| subprice
−| double
+| double(24,8)
−|
+| YES
−|
|
+| 0.00
|
|
| price before discount
| price before discount
|-
|-
| total_ht
| total_ht
−| double
+| double(24,8)
−|
+| YES
|
|
+| 0.00
|
|
+| total excluding tax
+|-
+| total_tva
+| double(24,8)
+| YES
|
|
+| 0.00
|
|
+| total tax
|-
|-
−| total_tva
+| total_ttc
−| double
+| double(24,8)
−|
+| YES
|
|
+| 0.00
|
|
+| total with tax
+|-
+| product_type
+| int(11)
+| YES
|
|
+| 0
|
|
+| type of prodcut
|-
|-
−| total_ttc
+| date_start
−| double
+| datetime
−|
+| YES
|
|
+| NULL
|
|
+| start date if service
+|-
+| date_end
+| datetime
+| YES
|
|
+| NULL
|
|
+| end date if service
|-
|-
| info_bits
| info_bits
−| int
+| int(11)
−|
+| YES
|
|
+| 0
|
|
+| TVA NPR or not
+|-
+| marge_tx
+| double(6,3)
+| YES
|
|
+| 0.00
|
|
+| margin (margin on purchase price)
|-
|-
−| coef
+| marque_tx
−| double
+| double(6,3)
−|
+| YES
−|
|
+| 0.00
|
|
+| mark rate (margin on selling price)
|-
|-
| special_code
| special_code
−| tinyint
+| tinyint(4)
−|
+| YES
|
|
| 0
| 0
|
|
−| used for shipping (=1) and ecotaxes (=2). Otherwise=0
+| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
|-
|-
| rang
| rang
−| int
+| int(11)
+| YES
|
|
+| 0
|
|
+| order view
+|-
+| import_key
+| varchar(14)
+| YES
|
|
+| NULL
|
|
−| View Order
+| import key
|}
|}