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_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
Data di fine | End date for this vendor price | ||
date_ |
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_ |
varchar2 |
Nome visualizzato | |||
id |
int32 |
ID | |||
last_ |
datetime |
Last Purchase | |||
min_ |
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_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
price |
numeric |
Price | The price to purchase a product | ||
product_ |
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_ |
varchar2 |
If not set, the vendor price will apply to all variants of this product. | |||
product_ |
varchar2 |
If not set, the vendor price will apply to all variants of this product. | |||
product_ |
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_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Default unit of measure used for purchase orders.It must be in the same category as the default unit of measure. | |||
product_ |
varchar2 |
Default unit of measure used for purchase orders.It must be in the same category as the default unit of measure. | |||
product_ |
int32 |
Variant Count | |||
sequence |
int32 |
Sequence | Assigns the priority to the list of product vendor. | ||
show_ |
boolean |
Show Set Supplier Button | |||
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: