| rowid | int(11) |
|
|
|
| datec | datetime |
|
|
2026-09-26 23:55:33.000000
|
| tms | timestamp |
|
|
current_timestamp()
|
| ref | varchar(12) |
|
|
|
| label | varchar(30) |
|
|
|
| entity | int(11) |
|
|
1
|
| fk_user_author | int(11) |
|
|
|
| fk_user_modif | int(11) |
|
|
|
| bank | varchar(60) |
|
|
|
| code_banque | varchar(128) |
|
|
|
| code_guichet | varchar(6) |
|
|
|
| number | varchar(255) |
|
|
|
| cle_rib | varchar(5) |
|
|
|
| bic | varchar(11) |
|
|
|
| iban_prefix | varchar(34) |
|
|
|
| country_iban | varchar(2) |
|
|
|
| cle_iban | varchar(2) |
|
|
|
| domiciliation | varchar(255) |
|
|
|
| state_id | int(11) |
|
|
|
| fk_pays | int(11) |
|
|
|
| proprio | varchar(60) |
|
|
|
| owner_address | varchar(255) |
|
|
|
| courant | smallint(6) |
|
|
0
|
| clos | smallint(6) |
|
|
0
|
| rappro | smallint(6) |
|
|
1
|
| url | varchar(128) |
|
|
|
| account_number | varchar(32) |
|
|
|
| fk_accountancy_journal | int(11) |
|
|
|
| currency_code | varchar(3) |
|
|
|
| min_allowed | int(11) |
|
|
0
|
| min_desired | int(11) |
|
|
0
|
| comment | text |
|
|
|
| note_public | text |
|
|
|
| model_pdf | varchar(255) |
|
|
|
| import_key | varchar(14) |
|
|
|
| extraparams | varchar(255) |
|
|
|