Table llx livraison - Revision history

Eldy: /* Table */

2012-08-10T12:43:41Z

Table

← Older revision		Revision as of 12:43, 10 August 2012
Line 27:		Line 27:
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| ref		\| ref

Simnandez: /* Structure */

2011-07-19T15:27:31Z

Structure

← Older revision		Revision as of 15:27, 19 July 2011
Line 11:		Line 11:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.2 2010/03/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>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 151:		Line 150:

	== 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: /* Table */

2010-03-22T08:16:23Z

Table

← Older revision		Revision as of 08:16, 22 March 2010
Line 11:		Line 11:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''Version 1.2 ~~2009~~/03/13'''		'''Version 1.2 2010/03/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>

Simnandez: /* Table */

2010-03-22T08:12:20Z

Table

← Older revision		Revision as of 08:12, 22 March 2010
Line 11:		Line 11:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''Version 1.1 2009/10/07'''		'''Version 1.2 2009/03/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 53:		Line 53:
	\| multi company id		\| multi company id
	\|-		\|-
	\| ~~ref_client~~		\| ref_costumer
	\| varchar(30)		\| varchar(30)
	\| YES		\| YES
Line 68:		Line 68:
	\|		\|
	\| ID of society affected ([[Table llx_societe\|llx_societe]]->rowid)		\| ID of society affected ([[Table llx_societe\|llx_societe]]->rowid)
	\|-
	~~\| fk_expedition~~
	~~\| int(11)~~
	~~\| YES~~
	\|
	~~\| NULL~~
	\|
	~~\| ID of related expedition([[Table llx_expedition\|llx_expedition]]->rowid)~~
	\|-		\|-
	\| date_creation		\| date_creation
Line 101:		Line 93:
	\| ID of validator user of delivery ([[Table llx_user\|llx_user]]->rowid)		\| ID of validator user of delivery ([[Table llx_user\|llx_user]]->rowid)
	\|-		\|-
	\| ~~date_livraison~~		\| date_delivery
	\| date		\| date
	\| YES		\| YES
Line 157:		Line 149:
	\| Model PDF to print		\| Model PDF to print
	\|}		\|}

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

Simnandez at 16:12, 14 December 2009

2009-12-14T16:12:54Z

← Older revision		Revision as of 16:12, 14 December 2009
Line 5:		Line 5:
	{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]		{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]

	{{flag fr}} Contient les bons de livraison. Les lignes de détails des bons de livraison sont ~~[http://www.poker-rooms-review.org online hold em]~~ dans la [[Table llx_livraisondet]]		{{flag fr}} Contient les bons de livraison. Les lignes de détails des bons de livraison sont dans la [[Table llx_livraisondet]]

	{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]		{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]

Ronny at 13:37, 14 December 2009

2009-12-14T13:37:10Z

← Older revision		Revision as of 13:37, 14 December 2009
Line 5:		Line 5:
	{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]		{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]

	{{flag fr}} Contient les bons de livraison. Les lignes de détails des bons de livraison sont dans la [[Table llx_livraisondet]]		{{flag fr}} Contient les bons de livraison. Les lignes de détails des bons de livraison sont [http://www.poker-rooms-review.org online hold em] dans la [[Table llx_livraisondet]]

	{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]		{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]

Simnandez: /* Structure */

2009-10-22T12:55:06Z

Structure

← Older revision		Revision as of 12:55, 22 October 2009
Line 10:		Line 10:

	= 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 21:		Line 23:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 29:		Line 31:
	\| tms		\| tms
	\| timestamp		\| timestamp
	\|		\| NO
	\|		\|
	\| CURRENT_TIMESTAMP		\| CURRENT_TIMESTAMP
Line 38:		Line 40:
	\| varchar(30)		\| varchar(30)
	\| NO		\| NO
	\|		\| UNI
	\| NULL		\| NULL
	\|		\|
Line 45:		Line 47:
	\| entity		\| entity
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\| UNI
	\| 1		\| 1
	\|		\|
Line 62:		Line 64:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| MUL
	\| NULL		\| NULL
	\|		\|
Line 74:		Line 76:
	\|		\|
	\| ID of related expedition([[Table llx_expedition\|llx_expedition]]->rowid)		\| ID of related expedition([[Table llx_expedition\|llx_expedition]]->rowid)


	\|-		\|-
	\| date_creation		\| date_creation
Line 87:		Line 87:
	\| fk_user_author		\| fk_user_author
	\| int(11)		\| int(11)
	\|		\| YES
	\|		\| MUL
	\|		\| NULL
	\|		\|
	\| ID of user made the delivery ([[Table llx_user\|llx_user]]->rowid)		\| ID of user made the delivery ([[Table llx_user\|llx_user]]->rowid)
Line 96:		Line 96:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| MUL
	\| NULL		\| NULL
	\|		\|
Line 112:		Line 112:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| MUL
	\| NULL		\| NULL
	\|		\|
Line 129:		Line 129:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total excluding tax		\| total excluding tax
Line 156:		Line 156:
	\|		\|
	\| Model PDF to print		\| Model PDF to print
	\|}		\|}
			== 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_livraison_uk_ref
			\| UNIQUE
			\| ref,entity
			\|-
			\| idx_livraison_fk_soc
			\| MULTIPLE
			\| fk_soc
			\|-
			\| idx_livraison_fk_user_author
			\| MULTIPLE
			\| fk_user_author
			\|-
			\| idx_livraison_fk_user_valid
			\| MULTIPLE
			\| fk_user_valid
			\|-
			\| idx_livraison_fk_adresse_livraison
			\| MULTIPLE
			\| fk_adresse_livraison
			\|}

Eldy: /* Content/Contenu/Contenido */

2009-07-21T10:01:48Z

Content/Contenu/Contenido

← Older revision		Revision as of 10:01, 21 July 2009
Line 5:		Line 5:
	{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]		{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]

	{{flag fr}} Contient les bons de livraison. ~~les~~ détails ~~de les~~ bons de livraison sont dans la [[Table llx_livraisondet]]		{{flag fr}} Contient les bons de livraison. Les lignes de détails des bons de livraison sont dans la [[Table llx_livraisondet]]

	{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]		{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]

Simnandez at 09:54, 21 July 2009

2009-07-21T09:54:22Z

Show changes

Eldy: moved Livraison (Table SQL) to Table llx livraison

2009-05-23T15:59:46Z

moved Livraison (Table SQL) to Table llx livraison

← Older revision

Revision as of 15:59, 23 May 2009