Dolibarr ERP CRM Wiki

Changes

Table llx bank (view source)

Revision as of 18:28, 4 August 2020

887 bytes added ,  4 years ago
→‎Table: insert link
Line 1: Line 1: −
[[Catégorie:Stock]][[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}}
−
+----------------+--------------+------+-----+---------+----------------+
+
|-
−
</pre>
+
|datec  
 +
|datetime
 +
|YES
 +
|&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;
Egils
53

edits

Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/1361...48061"