Difference between revisions of "Table llx prelevement facture"

Revision as of 16:30, 7 May 2009

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

返回
开发文档

Contenu

Liste des factures relative à un bon de prelevement

List of invoices relative with a standing order

Lista de facturas relacionadas con una domiciliación

Structure

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)		PRI	NULL	auto_increment	technical index
fk_facture	int(11)	YES		NULL
fk_prelevement_lignes	int(11)	YES		NULL

@@ Line 5: / Line 5: @@
 {{ListOfTables}}
-= Presentation =
+= Contenu =
 Liste des factures relative à un bon de prelevement
@@ Line 13: / Line 13: @@
 Lista de facturas relacionadas con una domiciliación
-== Modules ==
+= 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"
-# [[Module Prélèvements bancaires]]
+ |style="background-color: #e9e9ef"| <b>Field</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
-== Structure ==
+ |style="background-color: #e9e9ef"| <b>Null</b>
+ |style="background-color: #e9e9ef"| <b>Key</b>
-; rowid :            identifiant
+ |style="background-color: #e9e9ef"| <b>Default</b>
-; fk_facture  :     identifiant de la facture
+ |style="background-color: #e9e9ef"| <b>Extra</b>
-; fk_prelevement :  identifiant du prélèvement
+ |style="background-color: #e9e9ef"| <b>Description</b>
-; statut : statut de la ligne
+|-
-: 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
+| rowid
+| int(11)
-== Code SQL ==
+| &nbsp;
+| PRI
-<pre>
+| NULL
--- ===================================================================
+| auto_increment
--- Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+| technical index
---
+|-
--- This program is free software; you can redistribute it and/or modify
+| fk_facture
--- it under the terms of the GNU General Public License as published by
+| int(11)
--- the Free Software Foundation; either version 2 of the License, or
+| YES
--- (at your option) any later version.
+|
---
+| NULL
--- This program is distributed in the hope that it will be useful,
+|
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
+|
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+|-
--- GNU General Public License for more details.
+| fk_prelevement_lignes
---
+| int(11)
--- You should have received a copy of the GNU General Public License
+| YES
--- along with this program; if not, write to the Free Software
+|
--- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+| NULL
---
+|
--- $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 $
+|}
--- ===================================================================
---
---
-create table llx_prelevement_facture
-(
-  rowid            integer AUTO_INCREMENT PRIMARY KEY,
-  fk_facture       integer NOT NULL,
-  fk_prelevement   integer NOT NULL,
-  statut           smallint DEFAULT 0
-)type=innodb;
-</pre>

Difference between revisions of "Table llx prelevement facture"

Revision as of 16:30, 7 May 2009

Contenu

Structure

Navigation menu

Search