4,395
edits
Changes
→Structure
Line 1:
Line 1:
+La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
−Liste des factures relative à un bon de prelevement+== Modules ==+# [[Module Prélèvements bancaires]]+== Structure ==+ +; rowid : identifiant+; fk_facture : identifiant de la facture+; fk_prelevement : identifiant du prélèvement+; 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+ + +<pre>+-- ===================================================================+-- the Free Software Foundation; either version 2 of the License, or+-- (at your option) any later version.+--+-- This program is distributed in the hope that it will be useful,+-- GNU General Public License for more details.+--+-- 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.+--+-- $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>+
[[Category:Prélèvements bancaires]]
[[Category:Prélèvements bancaires]]
+[[Category:Standing Orders]]
+[[Category:Domiciliaciones]]
[[Category:Table SQL]]
[[Category:Table SQL]]
−{{ListOfTables}}
−== Presentation ==
+= Content/Contenu/Contenido =
−{{flag en}} List of invoices on a standing order
−{{flag fr}} Liste des factures relative à un bon de prélèvement
−{{flag sp}} Lista de facturas relacionadas con una domiciliación
−= Structure =
−== Table ==
−{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
− |style="background-color: #e9e9ef"| <b>Field</b>
− |style="background-color: #e9e9ef"| <b>Type</b>
− |style="background-color: #e9e9ef"| <b>Null</b>
− |style="background-color: #e9e9ef"| <b>Key</b>
− |style="background-color: #e9e9ef"| <b>Default</b>
−== Code SQL ==
+ |style="background-color: #e9e9ef"| <b>Extra</b>
− |style="background-color: #e9e9ef"| <b>Description</b>
−|-
−| rowid
−-- Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+| int(11)
−--
+| NO
−-- This program is free software; you can redistribute it and/or modify
+| PRI
−-- it under the terms of the GNU General Public License as published by
+|
−| auto_increment
−| technical index
−|-
−| fk_facture
−-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+| int(11)
−-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+| NO
−|
−|
−|
−| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
−|-
−| fk_prelevement_lignes
−-- $Id: llx_prelevement_facture.sql,v 1.2 2005/01/07 13:43:42 rodolphe Exp $
+| int(11)
−| NO
−| MUL
−|
−|
−| ID of standing order line ([[Table llx prelevement lignes|llx_prelevement_lignes]]->rowid)
−|}
−== 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_prelevement_facture_fk_prelevement_lignes
+| MULTIPLE
+| fk_prelevement_lignes
+|}