Difference between revisions of "Table llx livraisondet"

Latest revision as of 19:30, 3 November 2012

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the lines of delivery notes. This table is linked to Table llx_livraison

Contient les lignes des bons de livraison. Cette table est liée avec la Table llx_livraison

Contiene las líneas de las notas de entrega. Esta tabla está vinculada con la Table llx_livraison

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_livraision	int(11)	YES	UNI	NULL		ID of related delivery note (llx_livraision->rowid)
fk_origin_line	int(11)	YES		NULL		ID of document origin line (any tabledet->rowid). For the moment always llx_commandedet->rowid.
fk_product	int(11)	YES		NULL		ID of product (llx_product->rowid)
description	text	YES		NULL		description
qty	real	YES		NULL		quantity of the product
subprice	double (24,8)	YES		0.00000000		price unitaire
total_ht	double (24,8)	YES		0.00000000		total of line excluding taxes
rang	int(11)	YES		0		view order

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
idx_livraisondet_fk_expedition	UNIQUE	fk_livrasion

@@ Line 2: / Line 2: @@
 {{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 =
-{|  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"
+== Table ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
   |style="background-color: #e9e9ef"| <b>Field</b>
   |style="background-color: #e9e9ef"| <b>Type</b>
@@ Line 17: / Line 22: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
-|}
+|-
+| fk_livraision
+| int(11)
+| YES
+| UNI
+| NULL
+|
+| ID of related delivery note ([[Table llx_livraison|llx_livraision]]->rowid)
+|-
+| fk_origin_line
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of document origin line (any tabledet->rowid). For the moment always llx_commandedet->rowid.
+|-
+| fk_product
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of product ([[Table llx_product|llx_product]]->rowid)
+|-
+| description
+| text
+| YES
+|
+| NULL
+|
+| description
+|-
+| qty
+| real
+| YES
+|
+| NULL
+|
+| quantity of the product
+|-
+| subprice
+| double (24,8)
+| YES
+|
+| 0.00000000
+|
+| price unitaire
+|-
+| total_ht
+| double (24,8)
+| YES
+|
+| 0.00000000
+|
+| total of line excluding taxes
+|-
+| rang
+| int(11)
+| YES
+|
+| 0
+|
+| view order
+|}&nbsp;
+== Keys ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |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
+|}&nbsp;