| rowid |
int(11)
|
|
|
|
| fk_expensereport |
int(11)
|
|
|
|
| docnumber |
varchar(128)
|
utf8_unicode_ci
|
|
|
| fk_c_type_fees |
int(11)
|
|
|
|
| fk_c_exp_tax_cat |
int(11)
|
|
|
|
| fk_projet |
int(11)
|
|
|
|
| comments |
text
|
utf8_unicode_ci
|
|
|
| product_type |
int(11)
|
|
|
|
| qty |
double
|
|
|
|
| subprice |
double(24,8)
|
|
|
|
| subprice_ttc |
double(24,8)
|
|
|
|
| value_unit |
double(24,8)
|
|
|
|
| remise_percent |
double
|
|
|
|
| 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)
|
|
|
|
| date |
date
|
|
|
|
| info_bits |
int(11)
|
|
|
|
| special_code |
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)
|
|
|
|
| fk_facture |
int(11)
|
|
|
|
| fk_ecm_files |
int(11)
|
|
|
|
| fk_code_ventilation |
int(11)
|
|
|
|
| rang |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| rule_warning_message |
text
|
utf8_unicode_ci
|
|
|
