Table llx paiementfourn facturefourn - Revision history

Simnandez: /* Structure */

2011-07-19T15:36:54Z

Structure

← Older revision		Revision as of 15:36, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.2 2009/10/24'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| 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~~"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 58:		Line 57:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| 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~~"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

Simnandez: /* Keys */

2009-10-27T10:56:13Z

Keys

← Older revision		Revision as of 10:56, 27 October 2009
Line 79:		Line 79:
	\| MULTIPLE		\| MULTIPLE
	\| fk_paiementfourn		\| fk_paiementfourn

	\|}		\|}

Simnandez: /* Structure */

2009-10-27T10:54:32Z

Structure

← Older revision		Revision as of 10:54, 27 October 2009
Line 74:		Line 74:
	\| idx_paiementfourn_facturefourn_fk_facturefourn		\| idx_paiementfourn_facturefourn_fk_facturefourn
	\| MULTIPLE		\| MULTIPLE
	\| ~~fk_facture~~		\| fk_facturefourn
	\|-		\|-
	\| idx_paiementfourn_facturefourn_fk_paiementfourn		\| idx_paiementfourn_facturefourn_fk_paiementfourn
	\| MULTIPLE		\| MULTIPLE
	\| ~~fk_facture~~		\| fk_paiementfourn

	\|}		\|}

Simnandez: /* Structure */

2009-10-27T09:47:10Z

Structure

← Older revision		Revision as of 09:47, 27 October 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			== Table ==
			'''Version 1.2 2009/10/24'''
	{\| 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"		{\| 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"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 25:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 34:		Line 36:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| UNI
	\| NULL		\| NULL
	\|		\|
Line 42:		Line 44:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| UNI
	\| NULL		\| NULL
	\|		\|
Line 54:		Line 56:
	\|		\|
	\| amount of payment		\| amount of payment
	\|}		\|}
			== Keys ==
			'''Version 1.1 2009/10/07'''
			{\| 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"
			\|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_facture
			\|-
			\| idx_paiementfourn_facturefourn_fk_paiementfourn
			\| MULTIPLE
			\| fk_facture

			\|}

Simnandez: /* Structure */

2009-08-11T08:33:20Z

Structure

← Older revision		Revision as of 08:33, 11 August 2009
Line 37:		Line 37:
	\| NULL		\| NULL
	\|		\|
	\|		\| ([[Table llx_paiementfourn\|llx_paiementfourn]]->rowid)
	\|-		\|-
	\| fk_facturefourn		\| fk_facturefourn
Line 45:		Line 45:
	\| NULL		\| NULL
	\|		\|
	\|		\| ([[Table llx_facture_fourn\|llx_facture_fourn]]->rowid)
	\|-		\|-
	\| amount		\| amount
	\| double		\| double
	\| YES		\| YES
	\|		\|
	\| 0		\| 0
	\|		\|
	\|		\| amount of payment
	\|}		\|}

Simnandez: /* Contenu */

2009-08-11T08:29:19Z

Contenu

← Older revision		Revision as of 08:29, 11 August 2009
Line 5:		Line 5:
	{{ListOfTables}}		{{ListOfTables}}

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

Simnandez at 17:00, 7 May 2009

2009-05-07T17:00:23Z

← Older revision		Revision as of 17:00, 7 May 2009
Line 1:		Line 1:
	[[Category:Table SQL]]		[[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]]
			{{ListOfTables}}

	= Contenu =		= Contenu =

Simnandez: /* Structure */

2009-05-07T16:56:33Z

Structure

@@ Line 27: / Line 27: @@
 | auto_increment
 | technical index
 |}

Simnandez: /* Contenu */

2009-05-07T16:51:16Z

Contenu

← Older revision		Revision as of 16:51, 7 May 2009
Line 4:		Line 4:

	= Contenu =		= 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 =		= Structure =

Simnandez: /* Structure */

2009-05-07T16:49:05Z

Structure

← Older revision		Revision as of 16:49, 7 May 2009
Line 7:		Line 7:

	= Structure =		= 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"
			\|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)
			\|
			\| PRI
			\| NULL
			\| auto_increment
			\| technical index
			\|}

	<pre>		<pre>