Table llx facturedet rec
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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
Content/Contenu/Contenido
Contains the lines of predefined invoices, this table is linked with Table llx_facture_rec.
Contient les lignes des factures prédéfinies, cette table est liée avec la Table llx_facture_rec.
Contiene las líneas de las facturas predefinidas, esta tabla está vinculada con Table llx_facture_rec.
Structure
Table
Field | Type | Null | Key | Default | Extra | Description |
rowid | int(11) | NO | PRI | auto_increment | technical index | |
fk_facture | int(11) | NO | ID of related facture (llx_facture_rec->rowid) | |||
fk_product | int(11) | YES | NULL | ID of related product (llx_product->rowid) | ||
product_type | int(11) | YES | 0 | type of product | ||
description | text | YES | NULL | description of product | ||
datec | datetime | YES | NULL | creation date | ||
tva_taux | real | YES | 19.6 | VAT tax | ||
qty | real | YES | NULL | quantity | ||
remise | real | YES | 0 | discount | ||
remise_percent | real | YES | 0 | percent discount | ||
price | real | YES | NULL | final price | ||
subprice | real | YES | NULL | price before discount | ||
total_ttc | real | YES | NULL | total with tax | ||
total_ht | ral | YES | NULL | total excluding tax | ||
total_tva | real | YES | NULL | total tax | ||
total_ttc | real | YES | NULL | total with tax |
Keys
Key | Type | Fields |
PRIMARY | PRIMARY | rowid |