Table llx facture fourn det - Revision history

Eldy: /* Table */

2013-09-14T09:00:17Z

Table

@@ Line 104: / Line 104: @@
+|
 | tax
-|-
+{{FieldTotalFields}}
 |-
 | product_type

Eldy: /* Table */

2012-08-08T12:46:15Z

Table

← Older revision		Revision as of 12:46, 8 August 2012
Line 153:		Line 153:
	\| end date if service		\| end date if service
	\|-		\|-
	~~\| import_key~~		{{FieldImportKey}}
	~~\| varchar(14)~~
	~~\| YES~~
	\|
	~~\| NULL~~
	\|
	~~\| Import key~~
	\|}		\|}

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

Simnandez: /* Structure */

2011-07-19T15:22:55Z

Structure

← Older revision		Revision as of 15:22, 19 July 2011
Line 16:		Line 16:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''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>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 163:		Line 162:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''Version 1.2 2010/01/13'''~~		{\| 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 */

2010-01-14T11:39:00Z

Keys

← Older revision		Revision as of 11:39, 14 January 2010
Line 163:		Line 163:
	\|}		\|}
	== Keys ==		== Keys ==
	'''Version 1.~~1 2009~~/10/07'''		'''Version 1.2 2010/01/13'''
	{\| 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>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>

Simnandez: /* Content/Contenu/Contenido */

2009-10-21T08:19:56Z

Content/Contenu/Contenido

← Older revision		Revision as of 08:19, 21 October 2009
Line 9:		Line 9:
	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
	{{Flag en}} Contains the lines of providers invoices. This table is linked to [[Table llx facture fourn]]		{{Flag en}} Contains the lines of providers invoices. This table is linked to [[Table llx facture fourn]]


	{{Flag fr}} Contient les lignes des factures fournisseurs. Cette table est liée avec la [[Table llx facture fourn]]		{{Flag fr}} Contient les lignes des factures fournisseurs. Cette table est liée avec la [[Table llx facture fourn]]

Simnandez: /* Structure */

2009-10-21T07:46:32Z

Structure

← Older revision		Revision as of 07:46, 21 October 2009
Line 16:		Line 16:

	= Structure =		= Structure =
			== Table ==
			'''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"		{\| 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 27:		Line 29:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 35:		Line 37:
	\| fk_facture_fourn		\| fk_facture_fourn
	\| int(11)		\| int(11)
	\| ~~YES~~		\| NO
			\| MUL
	\|		\|
	~~\| NULL~~
	\|		\|
	\| ID of provider invoice ([[Table llx_facture_fourn\|llx_facture_fourn]]->rowid)		\| ID of provider invoice ([[Table llx_facture_fourn\|llx_facture_fourn]]->rowid)
Line 90:		Line 92:
	\|-		\|-
	\| qty		\| qty
	\| ~~smallint(6)~~		\| real
	\| YES		\| YES
	\|		\|
	\| 1		\| NULL
	\|		\|
	\| quantity of product		\| quantity of product
Line 101:		Line 103:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| tax		\| tax
Line 109:		Line 111:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total excluding tax		\| total excluding tax
Line 117:		Line 119:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| vat		\| vat
Line 125:		Line 127:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total with tax		\| total with tax
Line 157:		Line 159:
	\| YES		\| YES
	\|		\|
	\| 0		\| NULL
	\|		\|
	\| Import key		\| Import key
	\|}		\|}
			== 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
			\|-
			\| idx_facture_fourn_det_fk_facture
			\| MULTIPLE
			\| fk_facture_fourn
			\|}

Eldy: /* Structure */

2009-07-06T11:02:28Z

Structure

← Older revision		Revision as of 11:02, 6 July 2009
Line 71:		Line 71:
	\| NULL		\| NULL
	\|		\|
	\| ~~product~~ description		\| description of supplier invoice line
	\|-		\|-
	\| pu_ht		\| pu_ht

Simnandez: /* Structure */

2009-07-04T15:18:30Z

Structure

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

Simnandez: /* Content/Contenu/Contenido */

2009-07-04T14:51:56Z

Content/Contenu/Contenido

← Older revision		Revision as of 14:51, 4 July 2009
Line 11:		Line 11:


	{{Flag fr}} Contient les lignes des factures ~~fourniseurs~~. Cette table est liée avec la [[Table llx facture fourn]]		{{Flag fr}} Contient les lignes des factures fournisseurs. Cette table est liée avec la [[Table llx facture fourn]]

	{{Flag sp}} Contiene las líneas de las facturas de proveedores. Esta tabla está vinculada con la [[Table llx facture fourn]]		{{Flag sp}} Contiene las líneas de las facturas de proveedores. Esta tabla está vinculada con la [[Table llx facture fourn]]

Simnandez: /* Contenu */

2009-07-04T14:51:33Z

Contenu

← Older revision		Revision as of 14:51, 4 July 2009
Line 7:		Line 7:


	= Contenu =		= Content/Contenu/Contenido =
			{{Flag en}} Contains the lines of providers invoices. This table is linked to [[Table llx facture fourn]]


			{{Flag fr}} Contient les lignes des factures fourniseurs. Cette table est liée avec la [[Table llx facture fourn]]

			{{Flag sp}} Contiene las líneas de las facturas de proveedores. Esta tabla está vinculada con la [[Table llx facture fourn]]

	= Structure =		= Structure =