Table llx facturedet rec - Revision history

Simnandez: /* Structure */

2011-07-19T15:24:05Z

Structure

← Older revision		Revision as of 15:24, 19 July 2011
Line 15:		Line 15:
	= 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 154:		Line 153:
	\|}		\|}
	== 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: /* Structure */

2009-10-21T09:42:03Z

Structure

← Older revision		Revision as of 09:42, 21 October 2009
Line 14:		Line 14:

	= 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 25:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 49:		Line 51:
	\| product_type		\| product_type
	\| int(11)		\| int(11)
	\| NO		\| YES
	\|		\|
	\| 0		\| 0
Line 59:		Line 61:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| description of product		\| description of product
Line 72:		Line 74:
	\|-		\|-
	\| tva_taux		\| tva_taux
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 80:		Line 82:
	\|-		\|-
	\| qty		\| qty
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 88:		Line 90:
	\|-		\|-
	\| remise		\| remise
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 96:		Line 98:
	\|-		\|-
	\| remise_percent		\| remise_percent
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 104:		Line 106:
	\|-		\|-
	\| price		\| price
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 112:		Line 114:
	\|-		\|-
	\| subprice		\| subprice
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 120:		Line 122:
	\|-		\|-
	\| total_ttc		\| total_ttc
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 128:		Line 130:
	\|-		\|-
	\| total_ht		\| total_ht
	\| ~~double~~		\| ral
	\| YES		\| YES
	\|		\|
Line 136:		Line 138:
	\|-		\|-
	\| total_tva		\| total_tva
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 144:		Line 146:
	\|-		\|-
	\| total_ttc		\| total_ttc
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 150:		Line 152:
	\|		\|
	\| total with tax		\| total with tax
	\|}		\|}
			== 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
			\|}

Eldy: /* Structure */

2009-07-09T17:08:14Z

Structure

← Older revision		Revision as of 17:08, 9 July 2009
Line 37:		Line 37:
	\|		\|
	\|		\|
	\| ID of related facture ([[Table ~~llx_facture~~\|~~llx_facture~~]]->rowid)		\| ID of related facture ([[Table llx_facture_rec\|llx_facture_rec]]->rowid)
	\|-		\|-
	\| fk_product		\| fk_product

Simnandez: /* Content/Contenu/Contenido */

2009-07-08T19:01:44Z

Content/Contenu/Contenido

← Older revision		Revision as of 19:01, 8 July 2009
Line 7:		Line 7:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
			{{Flag en}} Contains the lines of predefined invoices, this table is linked with [[Table llx_facture_rec]].

			{{Flag fr}} Contient les lignes des factures prédéfinies, cette table est liée avec la [[Table llx_facture_rec]].

			{{Flag sp}} Contiene las líneas de las facturas predefinidas, esta tabla está vinculada con [[Table llx_facture_rec]].

	= Structure =		= Structure =

Simnandez: /* Structure */

2009-07-08T09:41:54Z

Structure

← Older revision		Revision as of 09:41, 8 July 2009
Line 29:		Line 29:
	\| int(11)		\| int(11)
	\| NO		\| NO
	\| ~~MUL~~		\|
	\|		\|
	\|		\|
Line 36:		Line 36:
	\| fk_product		\| fk_product
	\| int(11)		\| int(11)
	\| NO		\| YES
	~~\| MUL~~
	\|		\|
			\| NULL
	\|		\|
	\| ID of related product ([[Table llx_product\|llx_product]]->rowid)		\| ID of related product ([[Table llx_product\|llx_product]]->rowid)
Line 52:		Line 52:
	\| description		\| description
	\| text		\| text
	\| NO		\| YES
	\|		\|
	\|		\|
Line 68:		Line 68:
	\| tva_taux		\| tva_taux
	\| double		\| double
	\| NO		\| YES
	\|		\|
	\| 19.6		\| 19.6
Line 76:		Line 76:
	\| qty		\| qty
	\| double		\| double
	\| NO		\| YES
	\|
	\|		\|
			\| NULL
	\|		\|
	\| quantity		\| quantity
Line 110:		Line 110:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| price before discount		\| price before discount
Line 118:		Line 118:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| total with tax		\| total with tax
Line 126:		Line 126:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| total excluding tax		\| total excluding tax
Line 134:		Line 134:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| total tax		\| total tax
Line 142:		Line 142:
	\| YES		\| YES
	\|		\|
	\| ~~0.00~~		\| NULL
	\|		\|
	\| total with tax		\| total with tax
	\|}		\|}

Simnandez at 09:33, 8 July 2009

2009-07-08T09:33:56Z

← Older revision		Revision as of 09:33, 8 July 2009
Line 1:		Line 1:
	[[Category:Facture]]		[[Category:Facture]]
	[[Category:Facturas]]		[[Category:Facturas]]
			[[Category:Invoices]]
	[[Category:Table SQL]]		[[Category:Table SQL]]

Simnandez: /* Content/Contenu */

2009-07-08T09:32:53Z

Content/Contenu

← Older revision		Revision as of 09:32, 8 July 2009
Line 5:		Line 5:
	{{ListOfTables}}		{{ListOfTables}}

	= Content/Contenu =		= Content/Contenu/Contenido =


	= Structure =		= Structure =

Simnandez: /* Structure */

2009-07-08T09:32:33Z

Structure

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

Eldy: moved Facturedet rec (Table SQL) to Table llx facturedet rec

2009-05-23T16:01:58Z

moved Facturedet rec (Table SQL) to Table llx facturedet rec

← Older revision

Revision as of 16:01, 23 May 2009

Eldy at 16:01, 23 May 2009

2009-05-23T16:01:46Z

← Older revision		Revision as of 16:01, 23 May 2009
Line 5:		Line 5:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu =