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

# warehouse: Odoo itgen_odoo_warehouse

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `stock`
- Label: itgen_odoo_warehouse

Warehouse

Can only retrieve data.

## Table Columns

The columns of the table `warehouse` 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 | [ ] |  |  |
| `buy_pull_id` | `varchar2` |  | [ ] |  |  |
| `buy_pull_id_label` | `varchar2` |  | [ ] |  |  |
| `buy_to_resupply` | `boolean` | Buy to Resupply | [ ] |  | When products are bought, they can be delivered to this warehouse |
| `code` | `varchar2` | Short Name | [x] |  | Short name used to identify your warehouse |
| `company_id` | `varchar2` |  | [ ] |  | The company is automatically set from your user preferences. |
| `company_id_label` | `varchar2` |  | [ ] |  | The company is automatically set from your user preferences. |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `crossdock_route_id` | `varchar2` |  | [ ] |  |  |
| `crossdock_route_id_label` | `varchar2` |  | [ ] |  |  |
| `delivery_route_id` | `varchar2` |  | [ ] |  |  |
| `delivery_route_id_label` | `varchar2` |  | [ ] |  |  |
| `delivery_steps` | `varchar2` | Outgoing Shipments | [x] |  | Default outgoing route to follow |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `in_type_id` | `varchar2` |  | [ ] |  |  |
| `in_type_id_label` | `varchar2` |  | [ ] |  |  |
| `int_type_id` | `varchar2` |  | [ ] |  |  |
| `int_type_id_label` | `varchar2` |  | [ ] |  |  |
| `lot_stock_id` | `varchar2` |  | [ ] |  |  |
| `lot_stock_id_label` | `varchar2` |  | [ ] |  |  |
| `manu_type_id` | `varchar2` |  | [ ] |  |  |
| `manu_type_id_label` | `varchar2` |  | [ ] |  |  |
| `manufacture_mto_pull_id` | `varchar2` |  | [ ] |  |  |
| `manufacture_mto_pull_id_label` | `varchar2` |  | [ ] |  |  |
| `manufacture_pull_id` | `varchar2` |  | [ ] |  |  |
| `manufacture_pull_id_label` | `varchar2` |  | [ ] |  |  |
| `manufacture_steps` | `varchar2` | Manufacture | [x] |  | Produce : Move the components to the production location        directly and start the manufacturing process. Pick / Produce : Unload        the components from the Stock to Input location first, and then        transfer it to the Production location. |
| `manufacture_to_resupply` | `boolean` | Manufacture to Resupply | [ ] |  | When products are manufactured, they can be manufactured in this warehouse. |
| `mto_pull_id` | `varchar2` |  | [ ] |  |  |
| `mto_pull_id_label` | `varchar2` |  | [ ] |  |  |
| `name` | `varchar2` | Warehouse | [x] |  |  |
| `out_type_id` | `varchar2` |  | [ ] |  |  |
| `out_type_id_label` | `varchar2` |  | [ ] |  |  |
| `pack_type_id` | `varchar2` |  | [ ] |  |  |
| `pack_type_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `pbm_loc_id` | `varchar2` |  | [ ] |  |  |
| `pbm_loc_id_label` | `varchar2` |  | [ ] |  |  |
| `pbm_mto_pull_id` | `varchar2` |  | [ ] |  |  |
| `pbm_mto_pull_id_label` | `varchar2` |  | [ ] |  |  |
| `pbm_route_id` | `varchar2` |  | [ ] |  |  |
| `pbm_route_id_label` | `varchar2` |  | [ ] |  |  |
| `pbm_type_id` | `varchar2` |  | [ ] |  |  |
| `pbm_type_id_label` | `varchar2` |  | [ ] |  |  |
| `pick_type_id` | `varchar2` |  | [ ] |  |  |
| `pick_type_id_label` | `varchar2` |  | [ ] |  |  |
| `pos_type_id` | `varchar2` |  | [ ] |  |  |
| `pos_type_id_label` | `varchar2` |  | [ ] |  |  |
| `reception_route_id` | `varchar2` |  | [ ] |  |  |
| `reception_route_id_label` | `varchar2` |  | [ ] |  |  |
| `reception_steps` | `varchar2` | Incoming Shipments | [x] |  | Default incoming route to follow |
| `resupply_route_ids` | `varchar2` |  | [ ] |  | Routes will be created for these resupply warehouses and you can select them on products and product categories |
| `resupply_wh_ids` | `varchar2` |  | [ ] |  | Routes will be created automatically to resupply this warehouse from the warehouses ticked |
| `return_type_id` | `varchar2` |  | [ ] |  |  |
| `return_type_id_label` | `varchar2` |  | [ ] |  |  |
| `route_ids` | `varchar2` |  | [ ] |  | Defaults routes through the warehouse |
| `sam_loc_id` | `varchar2` |  | [ ] |  |  |
| `sam_loc_id_label` | `varchar2` |  | [ ] |  |  |
| `sam_rule_id` | `varchar2` |  | [ ] |  |  |
| `sam_rule_id_label` | `varchar2` |  | [ ] |  |  |
| `sam_type_id` | `varchar2` |  | [ ] |  |  |
| `sam_type_id_label` | `varchar2` |  | [ ] |  |  |
| `sequence` | `int32` | Sequence | [ ] |  | Gives the sequence of this line when displaying the warehouses. |
| `view_location_id` | `varchar2` |  | [ ] |  |  |
| `view_location_id_label` | `varchar2` |  | [ ] |  |  |
| `wh_input_stock_loc_id` | `varchar2` |  | [ ] |  |  |
| `wh_input_stock_loc_id_label` | `varchar2` |  | [ ] |  |  |
| `wh_output_stock_loc_id` | `varchar2` |  | [ ] |  |  |
| `wh_output_stock_loc_id_label` | `varchar2` |  | [ ] |  |  |
| `wh_pack_stock_loc_id` | `varchar2` |  | [ ] |  |  |
| `wh_pack_stock_loc_id_label` | `varchar2` |  | [ ] |  |  |
| `wh_qc_stock_loc_id` | `varchar2` |  | [ ] |  |  |
| `wh_qc_stock_loc_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)

