Table llx facturedet

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

Fr verysmall.png Contient les lignes des factures clients, cette table est liée avec la Table llx_facture.

Es verysmall.png Contiene las líneas de las facturas a clientes, esta tabla está vinculada con Table llx_facture.

Structure

Table

Field Type Null Key Default Extra Description
rowid integer NO PRI auto_increment technical index
fk_facture integer NO MUL 0 ID of invoice (Table llx_facture->rowid)
fk_product integer YES NULL ID of product (Table llx_product->rowid)
description text YES NULL description of customer invoice line
tva_tx double(24,8) YES NULL line VAT taxes
localtax1_tx double(24,8) YES NULL localtax1_tx
localtax1_type integer YES NULL localtax_type
localtax2_tx double(24,8) YES NULL localtax2_tx
localtax2_type integer YES NULL localtax2_type
qty real YES NULL quantity of the product or service
remise_percent double(24,8) YES 0 discount percentage
remise double(24,8) YES 0 discount amount
fk_remise_except integer YES UNI NULL ID of discount (llx_societe_remise_except->rowid)
subprice double(24,8) YES NULL price before discount
price double(24,8) YES NULL deprecated
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 integer YES 0 Type of product
date_start datetime YES NULL start date if service
date_end datetime YES NULL end date if service
info_bits integer YES 0 TVA NPR or not
buy_price_ht double(24,8) YES 0 TVA NPR or not
fk_code_ventilation integer NO 0
fk_export_compta integer NO 0 ID of acountacy export (llx_export_compta->rowid)
special_code integer YES 0 0=default, 1=seems not used, 2=used by WEEE module to define line as a WEEE line, 3=option line (price not included in total), 4=Sent for cooking (POS modules for restaurant)
rang integer YES 0 Position of line. Lower value are line top, higher value are bottom.
import_key varchar(14) YES NULL Code use to track record import. See page Field Import key.

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
uk_fk_remise_except UNIQUE fk_remise_except
idx_facturedet_fk_facture MULTIPLE fk_facture