---
title: "warehouse_orderpoint (Odoo)"
description: "itgen_odoo_warehouse_orderpoint"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.stock.warehouse_orderpoint
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.stock.warehouse_orderpoint
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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_location_ids` | `varchar2` |  | [ ] |  |  |
| `bom_id` | `varchar2` |  | [ ] |  |  |
| `bom_id_label` | `varchar2` |  | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `days_to_order` | `numeric` | Days To Order | [ ] |  | Numbers of days  in advance that replenishments demands are created. |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `group_id` | `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_id_label` | `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_days_date` | `datetime` | Lead Days Date | [ ] |  |  |
| `location_id` | `varchar2` |  | [ ] |  |  |
| `location_id_label` | `varchar2` |  | [ ] |  |  |
| `manufacturing_visibility_days` | `numeric` | Manufacturing Visibility Days | [ ] |  | Visibility Days applied on the manufacturing routes. |
| `name` | `varchar2` | Name | [x] |  |  |
| `product_category_id` | `varchar2` |  | [ ] |  |  |
| `product_category_id_label` | `varchar2` |  | [ ] |  |  |
| `product_id` | `varchar2` |  | [ ] |  |  |
| `product_id_label` | `varchar2` |  | [ ] |  |  |
| `product_max_qty` | `numeric` | Max Quantity | [x] |  | 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_min_qty` | `numeric` | Min Quantity | [x] |  | 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_tmpl_id` | `varchar2` |  | [ ] |  |  |
| `product_tmpl_id_label` | `varchar2` |  | [ ] |  |  |
| `product_uom` | `varchar2` |  | [ ] |  | Default unit of measure used for all stock operations. |
| `product_uom_label` | `varchar2` |  | [ ] |  | Default unit of measure used for all stock operations. |
| `product_uom_name` | `varchar2` | Product unit of measure label | [ ] |  |  |
| `purchase_visibility_days` | `numeric` | Purchase Visibility Days | [ ] |  | Visibility Days applied on the purchase routes. |
| `qty_forecast` | `numeric` | Forecast | [ ] |  |  |
| `qty_multiple` | `numeric` | Multiple Quantity | [x] |  | The procurement quantity will be rounded up to this multiple.  If it is 0, the exact quantity will be used. |
| `qty_on_hand` | `numeric` | On Hand | [ ] |  |  |
| `qty_to_order` | `numeric` | To Order | [ ] |  |  |
| `route_id` | `varchar2` |  | [ ] |  |  |
| `route_id_label` | `varchar2` |  | [ ] |  |  |
| `rule_ids` | `varchar2` |  | [ ] |  |  |
| `show_bom` | `boolean` | Show BoM column | [ ] |  |  |
| `show_supplier` | `boolean` | Show supplier column | [ ] |  |  |
| `snoozed_until` | `datetime` | Snoozed | [ ] |  | Hidden until next scheduler. |
| `supplier_id` | `varchar2` |  | [ ] |  |  |
| `supplier_id_label` | `varchar2` |  | [ ] |  |  |
| `trigger` | `varchar2` | Trigger | [x] |  |  |
| `vendor_id` | `varchar2` |  | [ ] |  |  |
| `vendor_id_label` | `varchar2` |  | [ ] |  |  |
| `visibility_days` | `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_id` | `varchar2` |  | [ ] |  |  |
| `warehouse_id_label` | `varchar2` |  | [ ] |  |  |
| `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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

