Table llx facturedet rec

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

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 predefined invoices, this table is linked with Table llx_facture_rec.

Fr verysmall.png Contient les lignes des factures prédéfinies, cette table est liée avec la Table llx_facture_rec.

Es verysmall.png 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