Difference between revisions of "Table llx bank"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
(→‎Table: insert link)
 
(16 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 =
−
{|  border="1" width="100%"  
+
== Table ==
−
| align="left" | <b>Field</b>
+
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
| align="left" | <b>Type</b>
+
|style="background-color: #e9e9ef"| <b>Field</b>
−
| align="left" | <b>Null</b>
+
|style="background-color: #e9e9ef"| <b>Type</b>
−
| align="left" | <b>Key</b>
+
|style="background-color: #e9e9ef"| <b>Null</b>
−
| align="left" | <b>Default</b>
+
|style="background-color: #e9e9ef"| <b>Key</b>
−
| align="left" | <b>Extra</b>
+
|style="background-color: #e9e9ef"| <b>Default</b>
−
| align="left" | <b>Description</b>
+
|style="background-color: #e9e9ef"| <b>Extra</b>
 +
|style="background-color: #e9e9ef"| <b>Description</b>
 +
{{FieldRowid}}
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" |  
+
|datec
−
rowid
+
|datetime
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" |  
+
|YES
−
int(11)
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|NULL
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" |
+
|&nbsp;
−
PRI
+
|date of creation technical
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" |
+
{{FieldTms}}
−
NULL
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" |
 
−
auto_increment
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium" |
 
−
index technique
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|datev
−
datec
+
|date
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
datetime
+
|MUL
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|value date of the transaction
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
date de creation technique
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|dateo
−
datev
+
|date
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
date
+
|MUL
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|date of the transaction
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
date de valeur de l'opération
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|amount
−
dateo
+
|double(24,8)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NO
−
date
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|0.00000000
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|amount of the transaction
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
date de l'opération
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|label
−
amount
+
|varchar(255)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;double
+
|YES
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|NULL
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|&nbsp;
−
0
+
|label
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
montant de l'opération
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|fk_account
−
label
+
|int(11)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
varchar(255)
+
|MUL
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|account number on which the transaction took place
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Libellé
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|fk_user_author
−
fk_account
+
|int(11)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
int(11)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
| ID of user author of the information ([[Table llx_user|llx_user]]->rowid)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
numéro du compte sur lequel s'est effectué l'opération
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|fk_user_rappro
−
fk_user_author
+
|int(11)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
int(11)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
| ID of user author of the rapprochement ([[Table llx_user|llx_user]]->rowid)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
auteur de l'information
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|fk_type
−
fk_user_rappro
+
|varchar(4)  
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |  
+
|YES
−
int(11)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|[[Transaction_type|transaction type]]
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |  
 
−
auteur du rapprochement
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|num_releve
−
fk_type
+
|varchar(50)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
varchar(4)  
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|number of summary of the bank on which the transaction
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Type d'opération
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|num_chq
−
num_releve
+
|int(11)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
varchar(50)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|number of check if significant
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Numéro du relevé bancaire sur lequel figure l'opération
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|rappro
−
num_chq
+
|tinyint(4)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
int(11)
+
|MUL
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|0
−
YES
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|indicates whether the line was rapproched or not
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Numéro du chèque si significatif
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|note
−
rappro
+
|text
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
tinyint(4)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|note
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
0
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Indique si la ligne a été rapprochée ou non
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|fk_bordereau
−
note
+
|int(11)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
text
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|0
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|Id du bordereau de remise de cheque
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Note
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|banque
−
author
+
|varchar(255)  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
varchar(40)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|name of the bank received the check
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|emetteur
−
fk_bordereau
+
|varchar(255)  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
int(11)
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|name of the issuer of the check
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
0
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
 
−
Id du bordereau de remise de cheque
 
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |  
+
|author
−
banque
+
|varchar(40)
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|YES
−
varchar(255)
+
|&nbsp;
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |
+
|NULL
−
YES
+
|&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
|to delete after migration
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |  
+
|}&nbsp;
−
NULL
+
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" | &nbsp;
+
== Keys ==
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" |  
+
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
Nom de la banque du cheque reçu
+
|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
 
|-  
 
|-  
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" |
+
| idx_bank_rappro
−
emetteur
+
| MULTIPLE
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" |
+
| rappro
−
varchar(255)
+
|}&nbsp;
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" |
 
−
YES
 
−
| style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" | &nbsp;
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" |
 
−
NULL
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" | &nbsp;
 
−
|  style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" |
 
−
Nom de l'emetteur du cheque
 
−
|}
 

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"