Difference between revisions of "Table llx prelevement facture"

Latest revision as of 15:38, 19 July 2011

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

List of invoices on a standing order

Liste des factures relative à un bon de prélèvement

Lista de facturas relacionadas con una domiciliación

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_facture	int(11)	NO				ID of invoice (llx_facture->rowid)
fk_prelevement_lignes	int(11)	NO	MUL			ID of standing order line (llx_prelevement_lignes->rowid)

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
idx_prelevement_facture_fk_prelevement_lignes	MULTIPLE	fk_prelevement_lignes

@@ Line 1: / Line 1: @@
-== Presentation ==
+[[Category:Prélèvements bancaires]]
+[[Category:Standing Orders]]
+[[Category:Domiciliaciones]]
+[[Category:Table SQL]]
+{{ListOfTables}}
-Liste des factures relative à un bon de prelevement
+= Content/Contenu/Contenido =
-== Modules ==
+{{flag en}} List of invoices on a standing order
-# [[Module Prélèvements bancaires]]
+{{flag fr}} Liste des factures relative à un bon de prélèvement
-== Structure ==
+{{flag sp}} Lista de facturas relacionadas con una domiciliación
-* rowid            identifiant
+= Structure =
-* fk_facture       identifiant de la facture
+== Table ==
-* fk_prelevement   identifiant du prélèvement
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-* statut           statut de la ligne
+ |style="background-color: #e9e9ef"| <b>Field</b>
-Le champ statut est positionné à 0 par défaut, une fois le prélèvement est crédité sur le compte le champ statut est passé à 1, si le prélèvement a été refusé par la banque le statut passe à 2
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Null</b>
-== Code SQL ==
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Default</b>
-<pre>
+ |style="background-color: #e9e9ef"| <b>Extra</b>
--- ===================================================================
+ |style="background-color: #e9e9ef"| <b>Description</b>
--- Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+|-
---
+| rowid
--- This program is free software; you can redistribute it and/or modify
+| int(11)
--- it under the terms of the GNU General Public License as published by
+| NO
--- the Free Software Foundation; either version 2 of the License, or
+| PRI
--- (at your option) any later version.
+|
---
+| auto_increment
--- This program is distributed in the hope that it will be useful,
+| technical index
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
+|-
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+| fk_facture
--- GNU General Public License for more details.
+| int(11)
---
+| NO
--- You should have received a copy of the GNU General Public License
+|
--- along with this program; if not, write to the Free Software
+|
--- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+|
---
+| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
--- $Id: llx_prelevement_facture.sql,v 1.2 2005/01/07 13:43:42 rodolphe Exp $
+|-
--- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_prelevement_facture.sql,v $
+| fk_prelevement_lignes
--- ===================================================================
+| int(11)
---
+| NO
---
+| MUL
+|
-create table llx_prelevement_facture
+|
-(
+| ID of standing order line ([[Table llx prelevement lignes|llx_prelevement_lignes]]->rowid)
-  rowid            integer AUTO_INCREMENT PRIMARY KEY,
+|}&nbsp;
-  fk_facture       integer NOT NULL,
+== Keys ==
-  fk_prelevement   integer NOT NULL,
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-  statut           smallint DEFAULT 0
+ |style="background-color: #e9e9ef"| <b>Key</b>
-)type=innodb;
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
-</pre>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| idx_prelevement_facture_fk_prelevement_lignes
+| MULTIPLE
+| fk_prelevement_lignes
+|}&nbsp;