invantive documentation
Invantive Support ForumsLog In / Sign Up

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 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 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 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
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 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: