Table llx facture fourn det

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 providers invoices. This table is linked to Table llx facture fourn

Fr verysmall.png Contient les lignes des factures fournisseurs. Cette table est liée avec la Table llx facture fourn

Es verysmall.png Contiene las líneas de las facturas de proveedores. Esta tabla está vinculada con la Table llx facture fourn

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
fk_facture_fourn int(11) NO MUL ID of provider invoice (llx_facture_fourn->rowid)
fk_product int(11) YES NULL ID of product (llx_product->rowid)
ref varchar(50) YES NULL supplier ref. of product
label varchar(255) YES NULL label of product
description text YES NULL description of supplier invoice line
pu_ht double(24,8) YES NULL unit price excluding tax
pu_ttc double(24,8) YES NULL unit price with tax
qty real YES NULL quantity of product
tva_taux double(24,8) YES 0.00000000 tax
total_ht double(24,8) YES NULL total excluding taxes
total_tva double(24,8) YES NULL total tax
total_localtax1 double(24,8) YES NULL total local tax 1
total_localtax2 double(24,8) YES NULL total local tax 2
total_ttc double(24,8) YES NULL Total including discount and taxes (vat + localtax1 + localtax2)
product_type int(11) YES 0 type of product
date_start datetime YES NULL start date if service
date_end datetime YES NULL end date if service
import_key varchar(14) YES NULL Code used to save the import id. See page Field Import key.

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
idx_facture_fourn_det_fk_facture MULTIPLE fk_facture_fourn