Table llx livraisondet - Revision history

Eldy: /* Table */

2012-11-03T19:30:25Z

Table

← Older revision		Revision as of 19:30, 3 November 2012
Line 28:		Line 28:
	\| technical index		\| technical index
	\|-		\|-
	\| ~~fk_livrasion~~		\| fk_livraision
	\| int(11)		\| int(11)
	\| YES		\| YES

Eldy: /* Table */

2012-11-03T19:30:15Z

Table

← Older revision		Revision as of 19:30, 3 November 2012
Line 34:		Line 34:
	\| NULL		\| NULL
	\|		\|
	\| ID of related delivery note ([[Table llx_livraison\|~~llx_livrasion~~]]->rowid)		\| ID of related delivery note ([[Table llx_livraison\|llx_livraision]]->rowid)
	\|-		\|-
	\| fk_origin_line		\| fk_origin_line

Eldy: /* Table */

2012-11-03T19:30:03Z

Table

← Older revision		Revision as of 19:30, 3 November 2012
Line 42:		Line 42:
	\| NULL		\| NULL
	\|		\|
	\| ID of document ~~origen~~ line (any ~~table_of_doc~~->rowid)		\| ID of document origin line (any tabledet->rowid). For the moment always llx_commandedet->rowid.
	\|-		\|-
	\| fk_product		\| fk_product
Line 92:		Line 92:
	\| view order		\| view order
	\|}		\|}

	== 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:31:46Z

Structure

← Older revision		Revision as of 15:31, 19 July 2011
Line 11:		Line 11:
	= 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 94:		Line 93:
	\|}		\|}
	== 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-22T13:08:31Z

Structure

← Older revision		Revision as of 13:08, 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 30:		Line 32:
	\| int(11)		\| int(11)
	\| YES		\| YES
	\|		\| UNI
	\| NULL		\| NULL
	\|		\|
Line 63:		Line 65:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| quantity of the product		\| quantity of the product
Line 71:		Line 73:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| price unitaire		\| price unitaire
Line 79:		Line 81:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total of line excluding taxes		\| total of line excluding taxes
Line 90:		Line 92:
	\|		\|
	\| view order		\| view order
	\|}		\|}
			== 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_livraisondet_fk_expedition
			\| UNIQUE
			\| fk_livrasion
			\|}

Simnandez: /* Structure */

2009-07-27T10:00:34Z

Structure

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

Simnandez: /* Contenu */

2009-07-27T09:50:31Z

Contenu

← Older revision		Revision as of 09:50, 27 July 2009
Line 2:		Line 2:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =
			{{flag en}} Contains the lines of delivery notes. This table is linked to [[Table llx_livraison]]

			{{flag fr}} Contient les lignes des bons de livraison. Cette table est liée avec la [[Table llx_livraison]]

			{{flag sp}} Contiene las líneas de las notas de entrega. Esta tabla está vinculada con la [[Table llx_livraison]]

	= Structure =		= Structure =

Simnandez: Created page with 'Category:Table SQL {{ListOfTables}} = Contenu = = Structure = {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px ...'

2009-07-21T09:57:30Z

Created page with 'Category:Table SQL {{ListOfTables}} = Contenu = = Structure = {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px ...'

New page

[[Category:Table SQL]]
{{ListOfTables}}

= Contenu =

= 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"| Field
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Null
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Default
|style="background-color: #e9e9ef"| Extra
|style="background-color: #e9e9ef"| Description
|-
| rowid
| int(11)
|  
| PRI
| NULL
| auto_increment
| technical index
|}