| rowid |
int(11)
|
|
|
|
| ref |
varchar(30)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| doc_date |
date
|
|
|
|
| doc_type |
varchar(30)
|
utf8_unicode_ci
|
|
|
| doc_ref |
varchar(300)
|
utf8_unicode_ci
|
|
|
| fk_doc |
int(11)
|
|
|
|
| fk_docdet |
int(11)
|
|
|
|
| thirdparty_code |
varchar(32)
|
utf8_unicode_ci
|
|
|
| subledger_account |
varchar(32)
|
utf8_unicode_ci
|
|
|
| subledger_label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| numero_compte |
varchar(32)
|
utf8_unicode_ci
|
|
|
| label_compte |
varchar(255)
|
utf8_unicode_ci
|
|
|
| label_operation |
varchar(255)
|
utf8_unicode_ci
|
|
|
| debit |
double(24,8)
|
|
|
|
| credit |
double(24,8)
|
|
|
|
| montant |
double(24,8)
|
|
|
|
| sens |
varchar(1)
|
utf8_unicode_ci
|
|
|
| multicurrency_amount |
double(24,8)
|
|
|
|
| multicurrency_code |
varchar(255)
|
utf8_unicode_ci
|
|
|
| matching_general |
tinyint(4)
|
|
|
|
| lettering_code |
varchar(255)
|
utf8_unicode_ci
|
|
|
| date_lettering |
datetime
|
|
|
|
| date_lim_reglement |
datetime
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| date_creation |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user |
int(11)
|
|
|
|
| code_journal |
varchar(32)
|
utf8_unicode_ci
|
|
|
| journal_label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| piece_num |
int(11)
|
|
|
|
| date_validated |
datetime
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
