Table llx bank account

Revision as of 01:45, 6 August 2007 by Ywarnier (talk | contribs)

Catégorie:Table SQL

 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              |                |
+-----------------+--------------+------+-----+-------------------+----------------+