| rowid |
int(11)
|
|
|
|
| fk_facture_fourn |
int(11)
|
|
|
|
| fk_parent_line |
int(11)
|
|
|
|
| fk_product |
int(11)
|
|
|
|
| ref |
varchar(50)
|
utf8_unicode_ci
|
|
|
| label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| description |
text
|
utf8_unicode_ci
|
|
|
| pu_ht |
double(24,8)
|
|
|
|
| pu_ttc |
double(24,8)
|
|
|
|
| qty |
double
|
|
|
|
| remise_percent |
double
|
|
|
|
| fk_remise_except |
int(11)
|
|
|
|
| vat_src_code |
varchar(10)
|
utf8_unicode_ci
|
|
|
| tva_tx |
double(7,4)
|
|
|
|
| localtax1_tx |
double(7,4)
|
|
|
|
| localtax1_type |
varchar(10)
|
utf8_unicode_ci
|
|
|
| localtax2_tx |
double(7,4)
|
|
|
|
| localtax2_type |
varchar(10)
|
utf8_unicode_ci
|
|
|
| total_ht |
double(24,8)
|
|
|
|
| total_tva |
double(24,8)
|
|
|
|
| total_localtax1 |
double(24,8)
|
|
|
|
| total_localtax2 |
double(24,8)
|
|
|
|
| total_ttc |
double(24,8)
|
|
|
|
| product_type |
int(11)
|
|
|
|
| date_start |
int(11)
|
|
|
|
| date_end |
int(11)
|
|
|
|
| info_bits |
int(11)
|
|
|
|
| special_code |
int(10)
|
|
|
|
| rang |
int(11)
|
|
|
|
| fk_unit |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_multicurrency |
int(11)
|
|
|
|
| multicurrency_code |
varchar(3)
|
utf8_unicode_ci
|
|
|
| multicurrency_subprice |
double(24,8)
|
|
|
|
| multicurrency_subprice_ttc |
double(24,8)
|
|
|
|
| multicurrency_total_ht |
double(24,8)
|
|
|
|
| multicurrency_total_tva |
double(24,8)
|
|
|
|
| multicurrency_total_ttc |
double(24,8)
|
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
