product_pricelist_item

-1 rows


Description

Pricelist Rule

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_pricelist_item_id_seq'::regclass)
pricelist_id int4 10 null
product_pricelist.id product_pricelist_item_pricelist_id_fkey C

Pricelist
company_id int4 10 √ null
res_company.id product_pricelist_item_company_id_fkey N

Company
currency_id int4 10 √ null
res_currency.id product_pricelist_item_currency_id_fkey N

Currency
categ_id int4 10 √ null
product_category.id product_pricelist_item_categ_id_fkey C

Product Category
product_tmpl_id int4 10 √ null
product_template.id product_pricelist_item_product_tmpl_id_fkey C

Product
product_id int4 10 √ null
product_product.id product_pricelist_item_product_id_fkey C

Product Variant
base_pricelist_id int4 10 √ null
product_pricelist.id product_pricelist_item_base_pricelist_id_fkey N

Other Pricelist
create_uid int4 10 √ null
res_users.id product_pricelist_item_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id product_pricelist_item_write_uid_fkey N

Last Updated by
applied_on varchar 2147483647 null

Apply On
base varchar 2147483647 null

Based on
compute_price varchar 2147483647 null

Compute Price
min_quantity numeric 0 √ null

Min. Quantity
fixed_price numeric 0 √ null

Fixed Price
price_discount numeric 0 √ null

Price Discount
price_round numeric 0 √ null

Price Rounding
price_surcharge numeric 0 √ null

Price Surcharge
price_min_margin numeric 0 √ null

Min. Price Margin
price_max_margin numeric 0 √ null

Max. Price Margin
date_start timestamp 29,6 √ null

Start Date
date_end timestamp 29,6 √ null

End Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
percent_price float8 17,17 √ null

Percentage Price

Indexes

Constraint Name Type Sort Column(s)
product_pricelist_item_pkey Primary key Asc id
product_pricelist_item__compute_price_index Performance Asc compute_price
product_pricelist_item__pricelist_id_index Performance Asc pricelist_id

Relationships

Close relationships within degrees of separation