| rowid |
int(11)
|
|
|
|
| ref |
varchar(16)
|
utf8_unicode_ci
|
|
|
| date_ech |
datetime
|
|
|
|
| libelle |
varchar(80)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| tms |
timestamp
|
|
|
|
| date_creation |
datetime
|
|
|
|
| date_valid |
datetime
|
|
|
|
| fk_user |
int(11)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| fk_type |
int(11)
|
|
|
|
| fk_account |
int(11)
|
|
|
|
| fk_mode_reglement |
int(11)
|
|
|
|
| amount |
double(24,8)
|
|
|
|
| paye |
smallint(6)
|
|
|
|
| periode |
date
|
|
|
|
| fk_projet |
int(11)
|
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
