Table llx bank
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains the transactions operated on bank accounts.
Contient les opérations effectuées sur les comptes bancaires.
Contiene las transaccions efectuadas en las cuentas bancarias.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | integer | NO | PRI | auto_increment | Technical index | |
| datec | datetime | YES | NULL | date of creation technical | ||
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| datev | date | YES | MUL | NULL | value date of the transaction | |
| dateo | date | YES | MUL | NULL | date of the transaction | |
| amount | double(24,8) | NO | 0.00000000 | amount of the transaction | ||
| label | varchar(255) | YES | NULL | label | ||
| fk_account | int(11) | YES | MUL | NULL | account number on which the transaction took place | |
| fk_user_author | int(11) | YES | NULL | ID of user author of the information (llx_user->rowid) | ||
| fk_user_rappro | int(11) | YES | NULL | ID of user author of the rapprochement (llx_user->rowid) | ||
| fk_type | varchar(4) | YES | NULL | transaction type | ||
| num_releve | varchar(50) | YES | NULL | number of summary of the bank on which the transaction | ||
| num_chq | int(11) | YES | NULL | number of check if significant | ||
| rappro | tinyint(4) | YES | MUL | 0 | indicates whether the line was rapproched or not | |
| note | text | YES | NULL | note | ||
| fk_bordereau | int(11) | YES | 0 | Id du bordereau de remise de cheque | ||
| banque | varchar(255) | YES | NULL | name of the bank received the check | ||
| emetteur | varchar(255) | YES | NULL | name of the issuer of the check | ||
| author | varchar(40) | YES | NULL | to delete after migration |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_bank_datev | MULTIPLE | datev |
| idx_bank_dateo | MULTIPLE | dateo |
| idx_bank_fk_account | MULTIPLE | fk_account |
| idx_bank_rappro | MULTIPLE | rappro |