Changes

1,055 bytes removed , 13 years ago

→‎Structure

Line 1: Line 1:

[[Category:Table SQL]]

−

~~La documentation relative aux autres tables est disponible sur la page~~ [[~~Liste des tables~~]]

+

[[Category:Supplier]]

−

~~The documentation related to other tables is available on the tables list page~~: [[~~Liste des tables~~]]

+

[[Category:Fournisseur]]

+

[[Category:Proveedores]]

+

−

= Contenu =

+

= Content/Contenu/Contenido =

−

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

−

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

+

{{flag_en}} Establishes the link between payments isued and the corresponding supplier invoices.

−

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

+

{{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 =

−

{| 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~~"

+

== Table ==

+

{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"

|style="background-color: #e9e9ef"| Field

|style="background-color: #e9e9ef"| Type

Line 22: Line 26:

| rowid

| int(11)

−

| ~~ ~~

+

| NO

| PRI

−

| ~~NULL~~

+

|

| auto_increment

| technical index

−

|}

+

|-

−

+

| fk_paimentfourn

−

~~<pre>~~

+

| int(11)

−

~~-- ============================================================================~~

+

| YES

−

+

| UNI

−

+

| NULL

−

--

+

|

−

-~~- This program is free software; you can redistribute it and/or modify~~

+

| ([[Table llx_paiementfourn|llx_paiementfourn]]->rowid)

−

-~~- it under the terms of the GNU General Public License as published by~~

+

|-

−

~~-- the Free Software Foundation; either version 2 of the License, or~~

+

| fk_facturefourn

−

-- (~~at your option~~) ~~any later version.~~

+

| int(11)

−

--

+

| YES

−

~~-- This program is distributed in the hope that it will be useful,~~

+

| UNI

−

~~-- but WITHOUT ANY WARRANTY; without even the implied warranty of~~

+

| NULL

−

-~~- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the~~

+

|

−

-~~- GNU General Public License for more details.~~

+

| ([[Table llx_facture_fourn|llx_facture_fourn]]->rowid)

−

--

+

|-

−

~~-- You should have received a copy of the GNU General Public License~~

+

| amount

−

~~-- along with this program; if not, write to the Free Software~~

+

| double

−

~~-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.~~

+

| YES

−

--

+

|

−

~~-- $Id: llx_paiementfourn_facturefourn.sql,v 1.1 2005/11/03 16:23:13 marc_ocebo Exp $~~

+

| 0

−

~~-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_paiementfourn_facturefourn.sql,v $~~

+

|

−

--

+

| amount of payment

−

~~-- ==============================================================~~=============

+

|} 

−

+

== Keys ==

−

~~CREATE TABLE `llx_paiementfourn_facturefourn` (~~

+

{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"

−

`rowid~~` int(11) NOT NULL auto_increment,~~

+

|style="background-color: #e9e9ef"| Key

−

`fk_paiementfourn~~` int(11) default NULL~~, ~~-- paiement fournisseur~~

+

|style="background-color: #e9e9ef"| Type

−

~~`fk_facturefourn` int(11) default NULL, -~~- ~~facture fournisseur~~

+

|style="background-color: #e9e9ef"| Fields

−

~~`amount` double default '0',~~

+

|-

−

~~PRIMARY KEY (`rowid`),~~

+

| PRIMARY

−

~~KEY `idx_fk_facture` (`~~fk_facturefourn~~`),~~

+

| PRIMARY

−

~~KEY `idx_fk_paiement` (`fk_paiementfourn`)~~

+

| rowid

−

~~) TYPE=innodb;~~

+

|-

−

~~</pre>~~

+

| uk_paiementfourn_facturefourn

−

+

| UNIQUE

−

~~== Rôle ==~~

+

| fk_paiementfourn,fk_facturefourn

−

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

+

|-

+

| idx_paiementfourn_facturefourn_fk_facturefourn

+

| MULTIPLE

+

| fk_facturefourn

+

|-

+

| idx_paiementfourn_facturefourn_fk_paiementfourn

+

| MULTIPLE

+

| fk_paiementfourn

+

|} 

Simnandez

Bureaucrats, Administrators

4,395

edits

Changes

Table llx paiementfourn facturefourn (view source)

Revision as of 15:36, 19 July 2011