Difference between revisions of "Table llx product price"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
m
Line 7: Line 7:
  
 
= Content/Contenu/Contenido =
 
= Content/Contenu/Contenido =
{{flag en}} Contains the prices of products  
+
{{flag en}} Contains the current and historical selling prices of products.
  
 
{{flag fr}} Contient les prix rattachés à un produit  
 
{{flag fr}} Contient les prix rattachés à un produit  
Line 47: Line 47:
 
|  
 
|  
 
|  
 
|  
| date of this price
+
| date of this price change
 
|-
 
|-
 
| price_level
 
| price_level
Line 79: Line 79:
 
| NULL
 
| NULL
 
|  
 
|  
| minium price  
+
| minimum price  
 
|-
 
|-
 
| price_min_ttc  
 
| price_min_ttc  
Line 87: Line 87:
 
| NULL
 
| NULL
 
|  
 
|  
| minium price with VAT
+
| minimum price with VAT
 
|-
 
|-
 
| price_base_type  
 
| price_base_type  
Line 95: Line 95:
 
| HT  
 
| HT  
 
|  
 
|  
| type of price (HT or TTC)
+
| type of price (HT/ex.tax or TTC/incl.tax)
 
|-
 
|-
 
| tva_tx  
 
| tva_tx  
Line 103: Line 103:
 
|   
 
|   
 
|  
 
|  
| TVA rate
+
| VAT rate
 
|-
 
|-
 
| fk_user_author  
 
| fk_user_author  

Revision as of 14:28, 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 ready for shell?

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid