Difference between revisions of "Table llx product price"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
m
 
Line 119: Line 119:
 
| 1
 
| 1
 
|  
 
|  
| is the product ready for shell?
+
| is the product available for sale?
 
|} 
 
|} 
  

Latest revision as of 14:30, 8 October 2018

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 available for sale?

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid