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 10: / Line 10: @@
 = 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 21: / Line 22: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
 |-
-| fk_livrasion
+| fk_livraision
 | int(11)
 | YES
-|
+| UNI
 | 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
@@ Line 41: / Line 42: @@
 | 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
@@ Line 63: / Line 64: @@
 | YES
 |
-|
+| NULL
 |
 | quantity of the product
@@ Line 71: / Line 72: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | price unitaire
@@ Line 79: / Line 80: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | total of line excluding taxes
@@ Line 90: / Line 91: @@
 |
 | 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;