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_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
End Date | End date for this vendor price | ||
date_ |
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_ |
varchar2 |
Display Name | |||
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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: