warehouse_orderpoint: Odoo itgen_odoo_warehouse_orderpoint
read only per partition
- Catalog:
Odoo - Schema:
stock - Label: itgen_odoo_warehouse_orderpoint
Minimum Inventory Rule
Can only retrieve data.
Summary
Defines Minimum stock rules.
Table Columns
The columns of the table warehouse_orderpoint 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 |
|---|---|---|---|---|---|
active |
boolean |
Active | If the active field is set to False, it will allow you to hide the orderpoint without removing it. | ||
allowed_ |
varchar2 |
||||
bom_id |
varchar2 |
||||
bom_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
days_ |
numeric |
Days To Order | Numbers of days in advance that replenishments demands are created. | ||
display_ |
varchar2 |
Display Name | |||
group_ |
varchar2 |
Moves created through this orderpoint will be put in this procurement group. If none is given, the moves generated by stock rules will be grouped into one big picking. | |||
group_ |
varchar2 |
Moves created through this orderpoint will be put in this procurement group. If none is given, the moves generated by stock rules will be grouped into one big picking. | |||
id |
int32 |
ID | |||
lead_ |
datetime |
Lead Days Date | |||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
manufacturing_ |
numeric |
Manufacturing Visibility Days | Visibility Days applied on the manufacturing routes. | ||
name |
varchar2 |
Name | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Max Quantity | When the virtual stock goes below the Min Quantity, Odoo generates a procurement to bring the forecasted quantity to the Quantity specified as Max Quantity. | ||
product_ |
numeric |
Min Quantity | When the virtual stock goes below the Min Quantity specified for this field, Odoo generates a procurement to bring the forecasted quantity to the Max Quantity. | ||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
product_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
product_ |
varchar2 |
Product unit of measure label | |||
purchase_ |
numeric |
Purchase Visibility Days | Visibility Days applied on the purchase routes. | ||
qty_ |
numeric |
Forecast | |||
qty_ |
numeric |
Multiple Quantity | The procurement quantity will be rounded up to this multiple. If it is 0, the exact quantity will be used. | ||
qty_ |
numeric |
On Hand | |||
qty_ |
numeric |
To Order | |||
route_ |
varchar2 |
||||
route_ |
varchar2 |
||||
rule_ |
varchar2 |
||||
show_ |
boolean |
Show BoM column | |||
show_ |
boolean |
Show supplier column | |||
snoozed_ |
datetime |
Snoozed | Hidden until next scheduler. | ||
supplier_ |
varchar2 |
||||
supplier_ |
varchar2 |
||||
trigger |
varchar2 |
Trigger | |||
vendor_ |
varchar2 |
||||
vendor_ |
varchar2 |
||||
visibility_ |
numeric |
Visibility Days | Consider product forecast these many days in the future upon product replenishment, set to 0 for just-in-time. The value depends on the type of the route (Buy or Manufacture) | ||
warehouse_ |
varchar2 |
||||
warehouse_ |
varchar2 |
||||
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: