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