invantive documentation
Forum di supporto InvantiveAccedi / Registrati

supplierinfo: Odoo itgen_odoo_supplierinfo

read only per partition

  • Catalogo: Odoo
  • Schema: product
  • Etichetta: itgen_odoo_supplierinfo

Supplier Pricelist

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella supplierinfo. 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
company_id varchar2
company_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date_end datetime Data di fine End date for this vendor price
date_start datetime Data di inizio 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 Nome visualizzato
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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: