Table llx bank

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

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)		PRI	NULL	auto_increment	technical index
datec	datetime	YES		NULL		date of creation technical
datev	date	YES		NULL		value date of the transaction
dateo	date	YES		NULL		date of the transaction
amount	double			0		amount of the transaction
label	varchar(255)	YES		NULL		label
fk_account	int(11)	YES		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		0		indicates whether the line was rapproched or not
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		name of the bank received the check
emetteur	varchar(255)	YES		NULL		name of the issuer of the check