invantive documentation
Invantive Support ForumsLog In / Sign Up

pricelist_item: Odoo itgen_odoo_pricelist_item

read only per partition

  • Catalog: Odoo
  • Schema: product
  • Label: itgen_odoo_pricelist_item

Pricelist Rule

Can only retrieve data.

Table Columns

The columns of the table pricelist_item are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
applied_on varchar2 Apply On Pricelist Item applicable on selected option
base varchar2 Based on Base price for computation. Sales Price: The base price will be the Sales Price. Cost Price : The base price will be the cost price. Other Pricelist : Computation of the base price based on another Pricelist.
base_pricelist_id varchar2
base_pricelist_id_label varchar2
categ_id varchar2 Specify a product category if this rule only applies to products belonging to this category or its children categories. Keep empty otherwise.
categ_id_label varchar2 Specify a product category if this rule only applies to products belonging to this category or its children categories. Keep empty otherwise.
company_id varchar2
company_id_label varchar2
compute_price varchar2 Compute Price
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date_end datetime End Date Ending datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences.
date_start datetime Start Date Starting datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences.
display_name varchar2 Display Name
fixed_price numeric Fixed Price
id int32 ID
min_quantity numeric Min. Quantity For the rule to apply, bought/sold quantity must be greater than or equal to the minimum quantity specified in this field. Expressed in the default unit of measure of the product.
name varchar2 Name Explicit rule name for this pricelist line.
percent_price numeric Percentage Price You can apply a mark-up by setting a negative discount.
price varchar2 Price Explicit rule name for this pricelist line.
price_discount numeric Price Discount You can apply a mark-up by setting a negative discount.
price_max_margin numeric Max. Price Margin Specify the maximum amount of margin over the base price.
price_min_margin numeric Min. Price Margin Specify the minimum amount of margin over the base price.
price_round numeric Price Rounding Sets the price so that it is a multiple of this value. Rounding is applied after the discount and before the surcharge. To have prices that end in 9.99, set rounding 10, surcharge -0.01
price_surcharge numeric Price Surcharge Specify the fixed amount to add or substract(if negative) to the amount calculated with the discount.
pricelist_id varchar2
pricelist_id_label varchar2
product_id varchar2 Specify a product if this rule only applies to one product. Keep empty otherwise.
product_id_label varchar2 Specify a product if this rule only applies to one product. Keep empty otherwise.
product_tmpl_id varchar2 Specify a template if this rule only applies to one product template. Keep empty otherwise.
product_tmpl_id_label varchar2 Specify a template if this rule only applies to one product template. Keep empty otherwise.
rule_tip varchar2 Rule Tip
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: