Dolibarr ERP CRM Wiki

Changes

Table llx livraisondet (view source)

Revision as of 10:00, 27 July 2009

666 bytes added ,  15 years ago
→‎Structure
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
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/13241"