| rowid |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| datev |
date
|
|
|
|
| dateo |
date
|
|
|
|
| amount |
double(24,8)
|
|
|
|
| amount_main_currency |
double(24,8)
|
|
|
|
| label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_account |
int(11)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_rappro |
int(11)
|
|
|
|
| fk_type |
varchar(6)
|
utf8_unicode_ci
|
|
|
| num_releve |
varchar(50)
|
utf8_unicode_ci
|
|
|
| num_chq |
varchar(50)
|
utf8_unicode_ci
|
|
|
| numero_compte |
varchar(32)
|
utf8_unicode_ci
|
|
|
| rappro |
tinyint(4)
|
|
|
|
| note |
text
|
utf8_unicode_ci
|
|
|
| fk_bordereau |
int(11)
|
|
|
|
| position |
int(11)
|
|
|
|
| banque |
varchar(255)
|
utf8_unicode_ci
|
|
|
| emetteur |
varchar(255)
|
utf8_unicode_ci
|
|
|
| author |
varchar(40)
|
utf8_unicode_ci
|
|
|
| origin_id |
int(11)
|
|
|
|
| origin_type |
varchar(64)
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
