| rowid |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| ref |
varchar(12)
|
utf8_unicode_ci
|
|
|
| label |
varchar(50)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| bank |
varchar(60)
|
utf8_unicode_ci
|
|
|
| code_banque |
varchar(128)
|
utf8_unicode_ci
|
|
|
| code_guichet |
varchar(6)
|
utf8_unicode_ci
|
|
|
| number |
varchar(255)
|
utf8_unicode_ci
|
|
|
| cle_rib |
varchar(5)
|
utf8_unicode_ci
|
|
|
| bic |
varchar(11)
|
utf8_unicode_ci
|
|
|
| bic_intermediate |
varchar(11)
|
utf8_unicode_ci
|
|
|
| iban_prefix |
varchar(100)
|
utf8_unicode_ci
|
|
|
| country_iban |
varchar(2)
|
utf8_unicode_ci
|
|
|
| cle_iban |
varchar(2)
|
utf8_unicode_ci
|
|
|
| domiciliation |
varchar(255)
|
utf8_unicode_ci
|
|
|
| pti_in_ctti |
smallint(6)
|
|
|
|
| state_id |
int(11)
|
|
|
|
| fk_pays |
int(11)
|
|
|
|
| proprio |
varchar(60)
|
utf8_unicode_ci
|
|
|
| owner_address |
varchar(255)
|
utf8_unicode_ci
|
|
|
| owner_zip |
varchar(25)
|
utf8_unicode_ci
|
|
|
| owner_town |
varchar(50)
|
utf8_unicode_ci
|
|
|
| owner_country_id |
int(11)
|
|
|
|
| courant |
smallint(6)
|
|
|
|
| clos |
smallint(6)
|
|
|
|
| rappro |
smallint(6)
|
|
|
|
| url |
varchar(128)
|
utf8_unicode_ci
|
|
|
| account_number |
varchar(32)
|
utf8_unicode_ci
|
|
|
| fk_accountancy_journal |
int(11)
|
|
|
|
| currency_code |
varchar(3)
|
utf8_unicode_ci
|
|
|
| min_allowed |
int(11)
|
|
|
|
| min_desired |
int(11)
|
|
|
|
| comment |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ics |
varchar(32)
|
utf8_unicode_ci
|
|
|
| ics_transfer |
varchar(32)
|
utf8_unicode_ci
|
|
|
