Table llx bank

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅:Table SQL


Content/Contenu/Contenido

En verysmall.png Contains the transactions operated on bank accounts.

Fr verysmall.png Contient les opérations effectuées sur les comptes bancaires.

Es verysmall.png 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