Table llx product price

From Dolibarr ERP CRM Wiki
Revision as of 14:28, 8 October 2018 by Ssherratt (talk | contribs)
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 current and historical selling prices of products.

Fr verysmall.png Contient les prix rattachés à un produit

Es verysmall.png Contiene los precios relacionados con un producto

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
tms timestamp NO Current date Date of last modification. See page Field Tms.
fk_product int(11) NO ID of product (llx_product->rowid)
date_price datetime NO date of this price change
price_level tinyint(4) NO 1 price level
price double(24,8) YES NULL price unitary
price_ttc double(34,8) YES NULL price with VAT
price_min double(24,8) YES NULL minimum price
price_min_ttc double(24,8) YES NULL minimum price with VAT
price_base_type varchar(3) YES HT type of price (HT/ex.tax or TTC/incl.tax)
tva_tx double(6,3) NO VAT rate
fk_user_author int(11) YES NULL ID of creator user (llx_user->rowid)
envente tinyint(4) YES 1 is the product ready for shell?

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid