53
edits
Changes
→Table: insert link
Line 6:
Line 6:
La table '''llx_bank''' stocke les opérations effectuées sur les comptes bancaires.+Contains the transactions operated on bank accounts.+|- +| rowid
−| int(11)
−|
−| PRI
−| NULL
−| auto_increment
−| index technique
|
−|montant de l'opération
|-
−|Author
−|varchar(40)
−|YES
−|
−|NULL
−|
−|
+
{{ListOfTables}}
{{ListOfTables}}
−= Contenu =
+= Content/Contenu/Contenido =
−{{flag en}} 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}}
−|-
|-
|datec
|datec
Line 38:
Line 32:
|NULL
|NULL
|
|
−|date de creation technique
+|date of creation technical
+{{FieldTms}}
|-
|-
|datev
|datev
|date
|date
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
−|date de valeur de l'opération
+|value date of the transaction
|-
|-
|dateo
|dateo
|date
|date
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
−|date de l'opération
+|date of the transaction
|-
|-
|amount
|amount
−| double
+|double(24,8)
+|NO
|
|
+|0.00000000
|
|
−|0
+|amount of the transaction
−|-
|-
|label
|label
Line 70:
Line 65:
|NULL
|NULL
|
|
−|Libellé
+|label
|-
|-
|fk_account
|fk_account
|int(11)
|int(11)
|YES
|YES
−|
+|MUL
|NULL
|NULL
|
|
−|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
|
|
−|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
|
|
−|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
|
|
−|Type d'opération
+|[[Transaction_type|transaction type]]
|-
|-
|num_releve
|num_releve
Line 110:
Line 105:
|NULL
|NULL
|
|
−|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
|
|
−|Numéro du chèque si significatif
+|number of check if significant
|-
|-
|rappro
|rappro
|tinyint(4)
|tinyint(4)
|YES
|YES
−|
+|MUL
|0
|0
|
|
−|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
|
|
−|Note
+|note
−|-
|-
|fk_bordereau
|fk_bordereau
Line 158:
Line 145:
|NULL
|NULL
|
|
−|Nom de la banque du cheque reçu
+|name of the bank received the check
|-
|-
|emetteur
|emetteur
Line 166:
Line 153:
|NULL
|NULL
|
|
−|Nom de l'emetteur du cheque
+|name of the issuer of the check
−|}
+|-
+|author
+|varchar(40)
+|YES
+|
+|NULL
+|
+|to delete after migration
+|}
+== 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
+|}