Table llx bank account

 La documentation relative aux autres tables est disponible sur la page Liste des tables
 The documentation related to other tables is available on the tables list page: Liste des tables

Contenu

La table llx_bank_account stocke les informations sur les comptes bancaires. Contains bank accounts definitions.

Structure

+-----------------+--------------+------+-----+-------------------+----------------+
| Field           | Type         | Null | Key | Default           | Extra          |
+-----------------+--------------+------+-----+-------------------+----------------+
| rowid           | int(11)      |      | PRI | NULL              | auto_increment |
| datec           | datetime     | YES  |     | NULL              |                |
| tms             | timestamp    | YES  |     | CURRENT_TIMESTAMP |                |
| ref             | varchar(12)  |      |     |                   |                |
| label           | varchar(30)  |      | UNI |                   |                |
| bank            | varchar(60)  | YES  |     | NULL              |                |
| code_banque     | varchar(7)   | YES  |     | NULL              |                |
| code_guichet    | varchar(6)   | YES  |     | NULL              |                |
| number          | varchar(255) | YES  |     | NULL              |                |
| cle_rib         | varchar(5)   | YES  |     | NULL              |                |
| bic             | varchar(11)  | YES  |     | NULL              |                |
| iban_prefix     | varchar(5)   | YES  |     | NULL              |                |
| domiciliation   | varchar(255) | YES  |     | NULL              |                |
| proprio         | varchar(60)  | YES  |     | NULL              |                |
| adresse_proprio | varchar(255) | YES  |     | NULL              |                |
| courant         | smallint(6)  |      |     | 0                 |                |
| clos            | smallint(6)  |      |     | 0                 |                |
| rappro          | smallint(6)  | YES  |     | 1                 |                |
| url             | varchar(128) | YES  |     | NULL              |                |
| account_number  | varchar(8)   | YES  |     | NULL              |                |
| currency_code   | char(2)      |      |     |                   |                |
| min_allowed     | int(11)      | YES  |     | 0                 |                |
| min_desired     | int(11)      | YES  |     | 0                 |                |
| comment         | varchar(254) | YES  |     | NULL              |                |
+-----------------+--------------+------+-----+-------------------+----------------+