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_ |
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_ |
varchar2 |
||||
base_ |
varchar2 |
||||
categ_ |
varchar2 |
Specify a product category if this rule only applies to products belonging to this category or its children categories. Keep empty otherwise. | |||
categ_ |
varchar2 |
Specify a product category if this rule only applies to products belonging to this category or its children categories. Keep empty otherwise. | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
compute_ |
varchar2 |
Compute Price | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
End Date | Ending datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences. | ||
date_ |
datetime |
Start Date | Starting datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences. | ||
display_ |
varchar2 |
Display Name | |||
fixed_ |
numeric |
Fixed Price | |||
id |
int32 |
ID | |||
min_ |
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_ |
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_ |
numeric |
Price Discount | You can apply a mark-up by setting a negative discount. | ||
price_ |
numeric |
Max. Price Margin | Specify the maximum amount of margin over the base price. | ||
price_ |
numeric |
Min. Price Margin | Specify the minimum amount of margin over the base price. | ||
price_ |
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_ |
numeric |
Price Surcharge | Specify the fixed amount to add or substract(if negative) to the amount calculated with the discount. | ||
pricelist_ |
varchar2 |
||||
pricelist_ |
varchar2 |
||||
product_ |
varchar2 |
Specify a product if this rule only applies to one product. Keep empty otherwise. | |||
product_ |
varchar2 |
Specify a product if this rule only applies to one product. Keep empty otherwise. | |||
product_ |
varchar2 |
Specify a template if this rule only applies to one product template. Keep empty otherwise. | |||
product_ |
varchar2 |
Specify a template if this rule only applies to one product template. Keep empty otherwise. | |||
rule_ |
varchar2 |
Rule Tip | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: