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 15: / Line 15: @@
 = Structure =
-'''Version 1.1 2009/10/07'''
+== Table ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-{|  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"
   |style="background-color: #e9e9ef"| <b>Field</b>
   |style="background-color: #e9e9ef"| <b>Type</b>
@@ Line 25: / Line 24: @@
   |style="background-color: #e9e9ef"| <b>Extra</b>
   |style="background-color: #e9e9ef"| <b>Description</b>
-|-
+{{FieldRowid}}
-| rowid
-| int(11)
-| NO
-| PRI
-|
-| auto_increment
-| technical index
 |-
 |datec
@@ Line 41: / Line 33: @@
 |&nbsp;
 |date of creation technical
+{{FieldTms}}
 |-
 |datev
@@ Line 104: / Line 97: @@
 |NULL
 |&nbsp;
-|transaction type
+|[[Transaction_type|transaction type]]
 |-
 |num_releve
@@ Line 169: / Line 162: @@
 |&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;