---
title: "pricelist_item (Odoo)"
description: "itgen_odoo_pricelist_item"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.product.pricelist_item
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.product.pricelist_item
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] |  | Pricelist Item applicable on selected option |
| `base` | `varchar2` | Based on | [x] |  | 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 | [x] |  |  |
| `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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

