pricelist_item: Odoo itgen_odoo_pricelist_item
read only per partition
- Catalogo:
Odoo - Schema:
product - Etichetta: itgen_odoo_pricelist_item
Pricelist Rule
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella pricelist_item. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
Data di fine | Ending datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences. | ||
date_ |
datetime |
Data di inizio | Starting datetime for the pricelist item validation The displayed value depends on the timezone set in your preferences. | ||
display_ |
varchar2 |
Nome visualizzato | |||
fixed_ |
numeric |
Prezzo fisso | |||
id |
int32 |
ID | |||
min_ |
numeric |
Min.Quantità | 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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: