Difference between revisions of "Table llx paiementfourn facturefourn"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 27: Line 27:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_paimentfourn
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
|
 +
|-
 +
| fk_facturefourn
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
|
 +
|-
 +
| amount
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
|
 
|}
 
|}
−
 
−
<pre>
 
−
-- ============================================================================
 
−
-- Copyright (C) 2003 Rodolphe Quiedeville  <rodolphe@quiedeville.org>
 
−
-- Copyright (C) 2005 Marc Barilley / Océbo <marc@ocebo.com>
 
−
--
 
−
-- This program is free software; you can redistribute it and/or modify
 
−
-- it under the terms of the GNU General Public License as published by
 
−
-- 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,
 
−
-- 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.
 
−
--
 
−
-- 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: llx_paiementfourn_facturefourn.sql,v 1.1 2005/11/03 16:23:13 marc_ocebo Exp $
 
−
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_paiementfourn_facturefourn.sql,v $
 
−
--
 
−
-- ===========================================================================
 
−
 
−
CREATE TABLE `llx_paiementfourn_facturefourn` (
 
−
  `rowid` int(11) NOT NULL auto_increment,
 
−
  `fk_paiementfourn` int(11) default NULL,    -- paiement fournisseur
 
−
  `fk_facturefourn` int(11) default NULL,    -- facture fournisseur
 
−
  `amount` double default '0',
 
−
  PRIMARY KEY  (`rowid`),
 
−
  KEY `idx_fk_facture` (`fk_facturefourn`),
 
−
  KEY `idx_fk_paiement` (`fk_paiementfourn`)
 
−
) TYPE=innodb;
 
−
</pre>
 
−
 
−
== Rôle ==
 
−
Etablit le lien entre les paiements émis et les factures fournisseur correspondantes.
 

Revision as of 16:56, 7 May 2009

 La documentation relative aux autres tables est disponible sur la page Liste des tables
 The documentation related to other tables is available on the tables list page: Liste des tables

Contenu

Etablit le lien entre les paiements émis et les factures fournisseur correspondantes.

Establishes the link between payments isued and the corresponding supplier invoices.

Establece el enlace entre los pagos emitidos y las facturas de proveedor correspondientes.

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_paimentfourn int(11) YES NULL
fk_facturefourn int(11) YES NULL
amount double YES 0
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_paiementfourn_facturefourn&oldid=10897"