Table llx propal - Revision history

Eldy: /* Table */

2012-08-10T12:50:51Z

Table

← Older revision		Revision as of 12:50, 10 August 2012
Line 65:		Line 65:
	\|		\|
	\| ID of project ([[Table llx_projet\|llx_projet]]->rowid)		\| ID of project ([[Table llx_projet\|llx_projet]]->rowid)
			{{FieldTms}}
	\|-		\|-
	\| datec		\| datec

Simnandez: /* Structure */

2011-07-19T15:47:35Z

Structure

← Older revision		Revision as of 15:47, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	{\| 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" cellpadding="1" cellspacing="0" class="dolbox"
	\|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 253:		Line 253:

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

Eldy: /* Table */

2011-07-13T15:37:17Z

Table

← Older revision		Revision as of 15:37, 13 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''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>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 186:		Line 185:
	\|		\|
	\| total VAT		\| total VAT
			{{FieldLocalTaxX}}
	\|-		\|-
	\| total		\| total

Eldy: /* Table */

2011-05-30T07:58:43Z

Table

← Older revision		Revision as of 07:58, 30 May 2011
Line 49:		Line 49:
	\| NULL		\| NULL
	\|		\|
	\| costumer ~~order~~ number		\| costumer proposal number
	\|-		\|-
	\| fk_soc		\| fk_soc
Line 65:		Line 65:
	\| 0		\| 0
	\|		\|
	\| ID of ~~proyect~~ ([[Table llx_projet\|llx_projet]]->rowid)		\| ID of project ([[Table llx_projet\|llx_projet]]->rowid)
	\|-		\|-
	\| datec		\| datec

Eldy: /* Table */

2011-05-30T07:57:14Z

Table

@@ Line 32: / Line 32: @@
 | auto_increment
 | technical index
 |-
 | fk_soc
@@ Line 48: / Line 66: @@
+|
 | ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
 |-
 | datec

Simnandez: /* Table */

2010-01-14T16:29:39Z

Table

← Older revision		Revision as of 16:29, 14 January 2010
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''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>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 257:		Line 257:
	\| ID of delivery address		\| ID of delivery address
	\|}		\|}

	== Keys ==		== Keys ==
	'''Version 1.1 2009/10/07'''		'''Version 1.1 2009/10/07'''

Simnandez: /* Structure */

2009-11-09T08:42:21Z

Structure

← Older revision		Revision as of 08:42, 9 November 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 33:		Line 35:
	\| fk_soc		\| fk_soc
	\| int(11)		\| int(11)
	\| NO		\| YES
	\|		\| MUL
	\|		\| NULL
	\|		\|
	\| ID society ([[Table llx_societe\|llx_societe]]->rowid)		\| ID society ([[Table llx_societe\|llx_societe]]->rowid)
Line 41:		Line 43:
	\| fk_projet		\| fk_projet
	\| int(11)		\| int(11)
	\|		\| YES
	\|		\|
	\| 0		\| 0
Line 50:		Line 52:
	\| varchar(30)		\| varchar(30)
	\| NO		\| NO
	\|		\| UNI
	\|		\|
	\|		\|
Line 57:		Line 59:
	\| entity		\| entity
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\| UNI
	\| 1		\| 1
	\|		\|
Line 137:		Line 139:
	\| fk_statut		\| fk_statut
	\| smallint(6)		\| smallint(6)
	\| ~~YES~~		\| NO
	\|		\|
	\| 0		\| 0
Line 152:		Line 154:
	\|-		\|-
	\| remise_percent		\| remise_percent
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 160:		Line 162:
	\|-		\|-
	\| remise_absolute		\| remise_absolute
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 168:		Line 170:
	\|-		\|-
	\| remise		\| remise
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 179:		Line 181:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| Total without VAT		\| Total without VAT
Line 187:		Line 189:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total VAT		\| total VAT
Line 195:		Line 197:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| Total TTC		\| Total TTC
Line 254:		Line 256:
	\|		\|
	\| ID of delivery address		\| ID of delivery address
	\|}		\|}
			== 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_propal_ref
			\| UNIQUE
			\| ref,entity
			\|-
			\| idx_propal_fk_soc
			\| MULTIPLE
			\| fk_soc
			\|}

Simnandez: /* Structure */

2009-09-03T06:08:48Z

Structure

Show changes

Simnandez: /* Contenu */

2009-09-02T09:37:30Z

Contenu

← Older revision		Revision as of 09:37, 2 September 2009
Line 6:		Line 6:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =
	~~Table principales des propositions commerciales , les détails sont dans la~~ [[Table llx_propaldet]]		{{flag en}} Contains customer proposals. The details are in [[Table llx_propaldet]]

	~~Contains customer proposals. The details are in~~ [[Table llx_propaldet]]		{{flag fr}} Contient des propositions commerciales , les détails sont dans la [[Table llx_propaldet]]

	~~Tabla principal de~~ los presupuestos, los detalles están en [[Table llx_propaldet]]		{{flag sp}} Contiene los presupuestos, los detalles están en la [[Table llx_propaldet]]

	= Structure =		= Structure =

Simnandez: /* Structure */

2009-05-07T06:58:48Z

Structure

← Older revision		Revision as of 06:58, 7 May 2009
Line 29:		Line 29:
	\| NULL		\| NULL
	\| auto_increment		\| auto_increment
	\| index ~~technique~~		\| technical index
	\|}		\|}