Difference between revisions of "Table llx bank"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
(→‎Table: insert link)
 
(22 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
[[Catégorie:Table SQL]]
+
[[Category:Table SQL]]
 +
[[Category:Bank]]
 +
[[Category:Banque]]
 +
[[Category:Banco]]
  
−
La table '''llx_bank''' stocke les opérations effectuées sur les comptes bancaires
+
{{ListOfTables}}
  
−
<pre>
+
= Content/Contenu/Contenido =
−
+----------------+--------------+------+-----+---------+----------------+
+
 
−
| Field          | Type        | Null | Key | Default | Extra          |
+
{{flag en}} Contains the transactions operated on bank accounts.
−
+----------------+--------------+------+-----+---------+----------------+
+
 
−
| rowid          | int(11)      |     | PRI | NULL    | auto_increment | index technique
+
{{flag fr}} Contient les opérations effectuées sur les comptes bancaires.
−
| datec         | datetime     | YES |     | NULL   |               | date de creation technique
+
 
−
| datev         | date         | YES |     | NULL   |               | date de valeur de l'opération
+
{{flag sp}} Contiene las transaccions efectuadas en las cuentas bancarias.
−
| dateo         | date         | YES |     | NULL   |               | date de l'opération
+
 
−
| amount         | double       |     |     | 0       |               | montant de l'opération
+
= Structure =
−
| label         | varchar(255) | YES |     | NULL   |               | Libellé
+
== Table ==
−
| fk_account     | int(11)     | YES |     | NULL   |               | numéro du compte sur lequel s'est effectué l'opération
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
| fk_user_author | int(11)     | YES |     | NULL   |               | auteur de l'information
+
|style="background-color: #e9e9ef"| <b>Field</b>
−
| fk_user_rappro | int(11)     | YES |     | NULL   |               | auteur du rapprochement
+
|style="background-color: #e9e9ef"| <b>Type</b>
−
| fk_type       | varchar(4)   | YES |     | NULL   |               | Type d'opération
+
|style="background-color: #e9e9ef"| <b>Null</b>
−
| num_releve     | varchar(50) | YES |     | NULL   |               | Numéro du relevé bancaire sur lequel figure l'opération
+
|style="background-color: #e9e9ef"| <b>Key</b>
−
| num_chq       | int(11)     | YES |     | NULL   |               | Numéro du chèque si significatif
+
|style="background-color: #e9e9ef"| <b>Default</b>
−
| rappro         | tinyint(4)   | YES |     | 0       |               | Indique si la ligne a été rapprochée ou non
+
|style="background-color: #e9e9ef"| <b>Extra</b>
−
| note           | text         | YES |     | NULL   |               | Note
+
|style="background-color: #e9e9ef"| <b>Description</b>
−
| author        | varchar(40)  | YES  |    | NULL    |                |
+
{{FieldRowid}}
−
| fk_bordereau   | int(11)     | YES |     | 0       |               | Id du bordereau de remise de cheque
+
|-
−
| banque         | varchar(255) | YES |     | NULL   |               | Nom de la banque du cheque reçu
+
|datec  
−
| emetteur       | varchar(255) | YES |     | NULL   |               | Nom de l'emetteur du cheque
+
|datetime
−
+----------------+--------------+------+-----+---------+----------------+
+
|YES
−
</pre>
+
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|date of creation technical
 +
{{FieldTms}}
 +
|-
 +
|datev  
 +
|date
 +
|YES
 +
|MUL
 +
|NULL
 +
|&nbsp;
 +
|value date of the transaction
 +
|-
 +
|dateo  
 +
|date
 +
|YES
 +
|MUL
 +
|NULL
 +
|&nbsp;
 +
|date of the transaction
 +
|-
 +
|amount  
 +
|double(24,8)
 +
|NO
 +
|&nbsp;
 +
|0.00000000
 +
|&nbsp;
 +
|amount of the transaction
 +
|-
 +
|label  
 +
|varchar(255)
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|label
 +
|-
 +
|fk_account  
 +
|int(11)
 +
|YES
 +
|MUL
 +
|NULL
 +
|&nbsp;
 +
|account number on which the transaction took place
 +
|-
 +
|fk_user_author  
 +
|int(11)
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
| ID of user author of the information ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
|fk_user_rappro  
 +
|int(11)
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
| ID of user author of the rapprochement ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
|fk_type  
 +
|varchar(4)  
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|[[Transaction_type|transaction type]]
 +
|-
 +
|num_releve  
 +
|varchar(50)
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|number of summary of the bank on which the transaction
 +
|-
 +
|num_chq  
 +
|int(11)
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|number of check if significant
 +
|-
 +
|rappro  
 +
|tinyint(4)
 +
|YES
 +
|MUL
 +
|0
 +
|&nbsp;
 +
|indicates whether the line was rapproched or not
 +
|-
 +
|note  
 +
|text  
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|note
 +
|-
 +
|fk_bordereau  
 +
|int(11)
 +
|YES
 +
|&nbsp;
 +
|0
 +
|&nbsp;
 +
|Id du bordereau de remise de cheque
 +
|-
 +
|banque  
 +
|varchar(255)  
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|name of the bank received the check
 +
|-
 +
|emetteur  
 +
|varchar(255)  
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|name of the issuer of the check
 +
|-  
 +
|author
 +
|varchar(40)
 +
|YES
 +
|&nbsp;
 +
|NULL
 +
|&nbsp;
 +
|to delete after migration
 +
|}&nbsp;
 +
 
 +
== Keys ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Fields</b>
 +
|-  
 +
| 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
 +
|}&nbsp;

Latest revision as of 18:28, 4 August 2020


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


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

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_bank&oldid=48061"