Difference between revisions of "Table llx paiementfourn facturefourn"

Latest revision as of 15:36, 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

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

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

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

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_paimentfourn	int(11)	YES	UNI	NULL		(llx_paiementfourn->rowid)
fk_facturefourn	int(11)	YES	UNI	NULL		(llx_facture_fourn->rowid)
amount	double	YES		0		amount of payment

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_paiementfourn_facturefourn	UNIQUE	fk_paiementfourn,fk_facturefourn
idx_paiementfourn_facturefourn_fk_facturefourn	MULTIPLE	fk_facturefourn
idx_paiementfourn_facturefourn_fk_paiementfourn	MULTIPLE	fk_paiementfourn

@@ Line 1: / Line 1: @@
-== Structure ==
+[[Category:Table SQL]]
-<pre>
+[[Category:Supplier]]
--- ============================================================================
+[[Category:Fournisseur]]
--- Copyright (C) 2003 Rodolphe Quiedeville  <rodolphe@quiedeville.org>
+[[Category:Proveedores]]
--- Copyright (C) 2005 Marc Barilley / Océbo <marc@ocebo.com>
+{{ListOfTables}}
---
--- 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` (
+= Content/Contenu/Contenido =
-  `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 ==
+{{flag_en}} Establishes the link between payments isued and the corresponding supplier invoices.
-Etablit le lien entre les paiements émis et les factures fournisseur correspondantes.
+{{flag_fr}} Etablit le lien entre les paiements émis et les factures fournisseur correspondantes.
+{{flag_sp}} Establece el enlace entre los pagos emitidos y las facturas de proveedor correspondientes.
+= 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>
+ |style="background-color: #e9e9ef"| <b>Extra</b>
+ |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| rowid
+| int(11)
+| NO
+| PRI
+|
+| auto_increment
+| technical index
+|-
+| fk_paimentfourn
+| int(11)
+| YES
+| UNI
+| NULL
+|
+| ([[Table llx_paiementfourn|llx_paiementfourn]]->rowid)
+|-
+| fk_facturefourn
+| int(11)
+| YES
+| UNI
+| NULL
+|
+| ([[Table llx_facture_fourn|llx_facture_fourn]]->rowid)
+|-
+| amount
+| double
+| YES
+|
+| 0
+|
+| amount of payment
+|}&nbsp;
+== 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
+|-
+| uk_paiementfourn_facturefourn
+| UNIQUE
+| fk_paiementfourn,fk_facturefourn
+|-
+| idx_paiementfourn_facturefourn_fk_facturefourn
+| MULTIPLE
+| fk_facturefourn
+|-
+| idx_paiementfourn_facturefourn_fk_paiementfourn
+| MULTIPLE
+| fk_paiementfourn
+|}&nbsp;