Difference between revisions of "Table llx bank"

Latest revision as of 18:28, 4 August 2020

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the transactions operated on bank accounts.

Contient les opérations effectuées sur les comptes bancaires.

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

@@ Line 6: / Line 6: @@
 {{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 =
-{|  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;
+|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" |
-|  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" |
-|  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
-|}
-<pre>
-+----------------+--------------+------+-----+---------+----------------+
-| Field          | Type         | Null | Key | Default | Extra          |
-+----------------+--------------+------+-----+---------+----------------+
-| rowid          | int(11)      |      | PRI | NULL    | auto_increment | index technique
-| datec          | datetime     | YES  |     | NULL    |                | date de creation technique
-| datev          | date         | YES  |     | NULL    |                | date de valeur de l'opération
-| dateo          | date         | YES  |     | NULL    |                | date de l'opération
-| amount         | double       |      |     | 0       |                | montant de l'opération
-| label          | varchar(255) | YES  |     | NULL    |                | Libellé
-| fk_account     | int(11)      | YES  |     | NULL    |                | numéro du compte sur lequel s'est effectué l'opération
-| fk_user_author | int(11)      | YES  |     | NULL    |                | auteur de l'information
-| fk_user_rappro | int(11)      | YES  |     | NULL    |                | auteur du rapprochement
-| fk_type        | varchar(4)   | YES  |     | NULL    |                | Type d'opération
-| num_releve     | varchar(50)  | YES  |     | NULL    |                | Numéro du relevé bancaire sur lequel figure l'opération
-| num_chq        | int(11)      | YES  |     | NULL    |                | Numéro du chèque si significatif
-| rappro         | tinyint(4)   | YES  |     | 0       |                | Indique si la ligne a été rapprochée ou non
-| note           | text         | YES  |     | NULL    |                | Note
-| author         | varchar(40)  | YES  |     | NULL    |                |
-| 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
-| emetteur       | varchar(255) | YES  |     | NULL    |                | Nom de l'emetteur du cheque
-+----------------+--------------+------+-----+---------+----------------+
-</pre>