4,395
edits
Table llx livraisondet: Difference between revisions
Jump to navigation
Jump to search
→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 | |||
|} | |} | ||