Difference between revisions of "Table llx bank"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
(→‎Table: insert link)
 
(13 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
−
= Contenu =
+
= Content/Contenu/Contenido =
  
−
La table '''llx_bank''' stocke les opérations effectuées sur les comptes bancaires.
+
{{flag en}} Contains the transactions operated on bank accounts.
  
−
Contains the transactions operated on bank accounts.
+
{{flag fr}} Contient les opérations effectuées sur les comptes bancaires.
  
−
Contiene las transaccions efectuadas en las cuentas bancarias.
+
{{flag sp}} Contiene las transaccions efectuadas en las cuentas bancarias.
  
 
= Structure =
 
= Structure =
−
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+
== Table ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 
  |style="background-color: #e9e9ef"| <b>Field</b>
 
  |style="background-color: #e9e9ef"| <b>Field</b>
 
  |style="background-color: #e9e9ef"| <b>Type</b>
 
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 23: Line 24:
 
  |style="background-color: #e9e9ef"| <b>Extra</b>
 
  |style="background-color: #e9e9ef"| <b>Extra</b>
 
  |style="background-color: #e9e9ef"| <b>Description</b>
 
  |style="background-color: #e9e9ef"| <b>Description</b>
−
|-
+
{{FieldRowid}}
−
| rowid
 
−
| int(11)
 
−
| &nbsp;
 
−
| PRI
 
−
| NULL
 
−
| auto_increment
 
−
| index technique
 
 
|-  
 
|-  
 
|datec  
 
|datec  
Line 38: Line 32:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|date de creation technique
+
|date of creation technical
 +
{{FieldTms}}
 
|-  
 
|-  
 
|datev  
 
|datev  
 
|date
 
|date
 
|YES
 
|YES
−
|&nbsp;
+
|MUL
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|date de valeur de l'opération
+
|value date of the transaction
 
|-  
 
|-  
 
|dateo  
 
|dateo  
 
|date
 
|date
 
|YES
 
|YES
−
|&nbsp;
+
|MUL
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|date de l'opération
+
|date of the transaction
 
|-  
 
|-  
 
|amount  
 
|amount  
−
|double
+
|double(24,8)
 +
|NO
 
|&nbsp;
 
|&nbsp;
 +
|0.00000000
 
|&nbsp;
 
|&nbsp;
−
|0
+
|amount of the transaction
−
|&nbsp;
 
−
|montant de l'opération
 
 
|-  
 
|-  
 
|label  
 
|label  
Line 70: Line 65:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Libellé
+
|label
 
|-  
 
|-  
 
|fk_account  
 
|fk_account  
 
|int(11)
 
|int(11)
 
|YES
 
|YES
−
|&nbsp;
+
|MUL
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|numéro du compte sur lequel s'est effectué l'opération
+
|account number on which the transaction took place
 
|-  
 
|-  
 
|fk_user_author  
 
|fk_user_author  
Line 86: Line 81:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|auteur de l'information
+
| ID of user author of the information ([[Table llx_user|llx_user]]->rowid)
 
|-  
 
|-  
 
|fk_user_rappro  
 
|fk_user_rappro  
Line 94: Line 89:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|auteur du rapprochement
+
| ID of user author of the rapprochement ([[Table llx_user|llx_user]]->rowid)
 
|-  
 
|-  
 
|fk_type  
 
|fk_type  
Line 102: Line 97:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Type d'opération
+
|[[Transaction_type|transaction type]]
 
|-  
 
|-  
 
|num_releve  
 
|num_releve  
Line 110: Line 105:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Numéro du relevé bancaire sur lequel figure l'opération
+
|number of summary of the bank on which the transaction
 
|-  
 
|-  
 
|num_chq  
 
|num_chq  
Line 118: Line 113:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Numéro du chèque si significatif
+
|number of check if significant
 
|-  
 
|-  
 
|rappro  
 
|rappro  
 
|tinyint(4)
 
|tinyint(4)
 
|YES
 
|YES
−
|&nbsp;
+
|MUL
 
|0
 
|0
 
|&nbsp;
 
|&nbsp;
−
|Indique si la ligne a été rapprochée ou non
+
|indicates whether the line was rapproched or not
 
|-  
 
|-  
 
|note  
 
|note  
Line 134: Line 129:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Note
+
|note
−
|-
 
−
|Author
 
−
|varchar(40)
 
−
|YES
 
−
|&nbsp;
 
−
|NULL
 
−
|&nbsp;
 
−
|&nbsp;
 
 
|-  
 
|-  
 
|fk_bordereau  
 
|fk_bordereau  
Line 158: Line 145:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Nom de la banque du cheque reçu
+
|name of the bank received the check
 
|-  
 
|-  
 
|emetteur  
 
|emetteur  
Line 166: Line 153:
 
|NULL
 
|NULL
 
|&nbsp;
 
|&nbsp;
−
|Nom de l'emetteur du cheque
+
|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"