| rowid |
int(11)
|
|
|
|
| fk_facture |
int(11)
|
|
|
 Fremdschlüsselwerte ansehen
|
| fk_parent_line |
int(11)
|
|
|
|
| fk_product |
int(11)
|
|
|
|
| label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| description |
text
|
utf8_unicode_ci
|
|
|
| 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
|
|
|
| qty |
double
|
|
|
|
| remise_percent |
double
|
|
|
|
| remise |
double
|
|
|
|
| fk_remise_except |
int(11)
|
|
|
|
| subprice |
double(24,8)
|
|
|
|
| subprice_ttc |
double(24,8)
|
|
|
|
| price |
double(24,8)
|
|
|
|
| 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 |
datetime
|
|
|
|
| date_end |
datetime
|
|
|
|
| info_bits |
int(11)
|
|
|
|
| buy_price_ht |
double(24,8)
|
|
|
|
| fk_product_fournisseur_price |
int(11)
|
|
|
|
| batch |
varchar(128)
|
utf8_unicode_ci
|
|
|
| fk_warehouse |
int(11)
|
|
|
|
| special_code |
int(11)
|
|
|
|
| rang |
int(11)
|
|
|
|
| fk_contract_line |
int(11)
|
|
|
|
| fk_unit |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| fk_code_ventilation |
int(11)
|
|
|
|
| situation_percent |
double
|
|
|
|
| fk_prev_id |
int(11)
|
|
|
|
| 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)
|
|
|
|
| ref_ext |
varchar(255)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
