Table llx bank account
Jump to navigation
Jump to search
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 | | +-----------------+--------------+------+-----+-------------------+----------------+