| rowid |
int(11)
|
|
|
|
| fk_fichinter |
int(11)
|
|
|
|
| date |
datetime
|
|
|
|
| description |
text
|
utf8_unicode_ci
|
|
|
| duree |
int(11)
|
|
|
|
| rang |
int(11)
|
|
|
|
| total_ht |
double(24,8)
|
|
|
|
| subprice |
double(24,8)
|
|
|
|
| subprice_ttc |
double(24,8)
|
|
|
|
| fk_parent_line |
int(11)
|
|
|
|
| fk_product |
int(11)
|
|
|
|
| label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| tva_tx |
double(6,3)
|
|
|
|
| localtax1_tx |
double(6,3)
|
|
|
|
| localtax1_type |
varchar(1)
|
utf8_unicode_ci
|
|
|
| localtax2_tx |
double(6,3)
|
|
|
|
| localtax2_type |
varchar(1)
|
utf8_unicode_ci
|
|
|
| qty |
double
|
|
|
|
| remise_percent |
double
|
|
|
|
| fk_remise_except |
int(11)
|
|
|
|
| price |
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 |
datetime
|
|
|
|
| date_end |
datetime
|
|
|
|
| info_bits |
int(11)
|
|
|
|
| buy_price_ht |
double(24,8)
|
|
|
|
| fk_product_fournisseur_price |
int(11)
|
|
|
|
| fk_code_ventilation |
int(11)
|
|
|
|
| special_code |
int(10)
|
|
|
|
| fk_unit |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
