invantive documentation
Invantive Support ForumsLog In / Sign Up

supplierinfo: Odoo itgen_odoo_supplierinfo

read only per partition

  • Catalog: Odoo
  • Schema: product
  • Label: itgen_odoo_supplierinfo

Supplier Pricelist

Can only retrieve data.

Table Columns

The columns of the table supplierinfo 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
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date_end datetime End Date End date for this vendor price
date_start datetime Start Date Start date for this vendor price
delay int32 Delivery Lead Time Lead time in days between the confirmation of the purchase order and the receipt of the products in your warehouse. Used by the scheduler for automatic computation of the purchase order planning.
display_name varchar2 Display Name
id int32 ID
last_purchase_date datetime Last Purchase
min_qty numeric Quantity The quantity to purchase from this vendor to benefit from the price, expressed in the vendor Product Unit of Measure if not any, in the default unit of measure of the product otherwise.
partner_id varchar2
partner_id_label varchar2
price numeric Price The price to purchase a product
product_code varchar2 Vendor Product Code This vendor's product code will be used when printing a request for quotation. Keep empty to use the internal one.
product_id varchar2 If not set, the vendor price will apply to all variants of this product.
product_id_label varchar2 If not set, the vendor price will apply to all variants of this product.
product_name varchar2 Vendor Product Name This vendor's product name will be used when printing a request for quotation. Keep empty to use the internal one.
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom varchar2 Default unit of measure used for purchase orders. It must be in the same category as the default unit of measure.
product_uom_label varchar2 Default unit of measure used for purchase orders. It must be in the same category as the default unit of measure.
product_variant_count int32 Variant Count
sequence int32 Sequence Assigns the priority to the list of product vendor.
show_set_supplier_button boolean Show Set Supplier Button
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: