product_supplierinfo

-1 rows


Description

Supplier Pricelist

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_supplierinfo_id_seq'::regclass)
product_replenish.supplier_id product_replenish_supplier_id_fkey N
product_supplierinfo_stock_replenishment_info_rel.product_supplierinfo_id product_supplierinfo_stock_repleni_product_supplierinfo_id_fkey C
stock_warehouse_orderpoint.supplier_id stock_warehouse_orderpoint_supplier_id_fkey N
partner_id int4 10 null
res_partner.id product_supplierinfo_partner_id_fkey C

Vendor
sequence int4 10 √ null

Sequence
company_id int4 10 √ null
res_company.id product_supplierinfo_company_id_fkey N

Company
currency_id int4 10 null
res_currency.id product_supplierinfo_currency_id_fkey R

Currency
product_id int4 10 √ null
product_product.id product_supplierinfo_product_id_fkey N

Product Variant
product_tmpl_id int4 10 √ null
product_template.id product_supplierinfo_product_tmpl_id_fkey C

Product Template
delay int4 10 null

Delivery Lead Time
create_uid int4 10 √ null
res_users.id product_supplierinfo_create_uid_fkey N

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

Last Updated by
product_name varchar 2147483647 √ null

Vendor Product Name
product_code varchar 2147483647 √ null

Vendor Product Code
date_start date 13 √ null

Start Date
date_end date 13 √ null

End Date
min_qty numeric 0 null

Quantity
price numeric 0 null

Price
discount numeric 0 √ null

Discount (%)
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
product_supplierinfo_pkey Primary key Asc id
product_supplierinfo__company_id_index Performance Asc company_id
product_supplierinfo__product_tmpl_id_index Performance Asc product_tmpl_id

Relationships

Close relationships within degrees of separation