| rowid |
int(11)
|
|
|
|
| titre |
varchar(200)
|
utf8_unicode_ci
|
|
|
| ref_supplier |
varchar(180)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| subtype |
smallint(6)
|
|
|
|
| fk_soc |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| suspended |
int(11)
|
|
|
|
| libelle |
varchar(255)
|
utf8_unicode_ci
|
|
|
| amount |
double(24,8)
|
|
|
|
| remise |
double
|
|
|
|
| vat_src_code |
varchar(10)
|
utf8_unicode_ci
|
|
|
| localtax1 |
double(24,8)
|
|
|
|
| localtax2 |
double(24,8)
|
|
|
|
| total_ht |
double(24,8)
|
|
|
|
| total_tva |
double(24,8)
|
|
|
|
| total_ttc |
double(24,8)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_projet |
int(11)
|
|
|
 Fremdschlüsselwerte ansehen
|
| fk_account |
int(11)
|
|
|
|
| fk_cond_reglement |
int(11)
|
|
|
|
| fk_mode_reglement |
int(11)
|
|
|
|
| date_lim_reglement |
date
|
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| modelpdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_multicurrency |
int(11)
|
|
|
|
| multicurrency_code |
varchar(3)
|
utf8_unicode_ci
|
|
|
| multicurrency_tx |
double(24,8)
|
|
|
|
| multicurrency_total_ht |
double(24,8)
|
|
|
|
| multicurrency_total_tva |
double(24,8)
|
|
|
|
| multicurrency_total_ttc |
double(24,8)
|
|
|
|
| usenewprice |
int(11)
|
|
|
|
| usenewcurrencyrate |
int(11)
|
|
|
|
| frequency |
int(11)
|
|
|
|
| unit_frequency |
varchar(2)
|
utf8_unicode_ci
|
|
|
| date_when |
datetime
|
|
|
|
| date_last_gen |
datetime
|
|
|
|
| nb_gen_done |
int(11)
|
|
|
|
| nb_gen_max |
int(11)
|
|
|
|
| auto_validate |
int(11)
|
|
|
|
| generate_pdf |
int(11)
|
|
|
|
