| rowid |
int(11)
|
|
|
|
| ref |
varchar(50)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| ref_number_int |
int(11)
|
|
|
|
| ref_ext |
int(11)
|
|
|
|
| total_ht |
double(24,8)
|
|
|
|
| total_tva |
double(24,8)
|
|
|
|
| localtax1 |
double(24,8)
|
|
|
|
| localtax2 |
double(24,8)
|
|
|
|
| total_ttc |
double(24,8)
|
|
|
|
| date_debut |
date
|
|
|
|
| date_fin |
date
|
|
|
|
| date_create |
datetime
|
|
|
|
| date_valid |
datetime
|
|
|
|
| date_approve |
datetime
|
|
|
|
| date_refuse |
datetime
|
|
|
|
| date_cancel |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_creat |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| fk_user_validator |
int(11)
|
|
|
|
| fk_user_approve |
int(11)
|
|
|
|
| fk_user_refuse |
int(11)
|
|
|
|
| fk_user_cancel |
int(11)
|
|
|
|
| fk_statut |
int(11)
|
|
|
|
| fk_c_paiement |
int(11)
|
|
|
|
| paid |
smallint(6)
|
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| detail_refuse |
varchar(255)
|
utf8_unicode_ci
|
|
|
| detail_cancel |
varchar(255)
|
utf8_unicode_ci
|
|
|
| integration_compta |
int(11)
|
|
|
|
| fk_bank_account |
int(11)
|
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| last_main_doc |
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)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
