Difference between revisions of "Table llx livraisondet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Line 26: Line 26:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_livrasion
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of related delivery note ([[Table llx_livraison|llx_livrasion]]->rowid)
 +
|-
 +
| fk_origin_line
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of document origen line (any table_of_doc->rowid)
 +
|-
 +
| fk_product
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of product ([[Table llx_product|llx_product]]->rowid)
 +
|-
 +
| description
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| description
 +
|-
 +
| qty
 +
| real
 +
| YES
 +
|
 +
 +
|
 +
| quantity of the product
 +
|-
 +
| subprice
 +
| double (24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| price unitaire
 +
|-
 +
| total_ht
 +
| double (24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total of line excluding taxes
 +
|-
 +
| rang
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| view order
 
|}
 
|}

Revision as of 10:00, 27 July 2009


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


Content/Contenu/Contenido

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

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

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

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_livrasion int(11) YES NULL ID of related delivery note (llx_livrasion->rowid)
fk_origin_line int(11) YES NULL ID of document origen line (any table_of_doc->rowid)
fk_product int(11) YES NULL ID of product (llx_product->rowid)
description text YES NULL description
qty real YES quantity of the product
subprice double (24,8) YES 0.00 price unitaire
total_ht double (24,8) YES 0.00 total of line excluding taxes
rang int(11) YES 0 view order