route |
Inventory Routes
Catalog: Odoo
Schema: stock
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table route are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
If the active field is set to False, it will allow you to hide the route without removing it. |
categ_ids |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
Leave this field empty if this route is shared between all companies |
company_id |
string |
|
☐ |
Leave this field empty if this route is shared between all companies |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
name |
string |
Route |
☑ |
|
packaging_ids |
string |
|
☐ |
|
packaging_selectable |
boolean |
Applicable on Packaging |
☐ |
When checked, the route will be selectable on the Product Packaging. |
product_categ_selectable |
boolean |
Applicable on Product Category |
☐ |
When checked, the route will be selectable on the Product Category. |
product_ids |
string |
|
☐ |
|
product_selectable |
boolean |
Applicable on Product |
☐ |
When checked, the route will be selectable in the Inventory tab of the Product form. |
rule_ids |
string |
|
☐ |
|
sale_selectable |
boolean |
Selectable on Sales Order Line |
☐ |
|
sequence |
int32 |
Sequence |
☐ |
|
supplied_wh_id_label |
string |
|
☐ |
|
supplied_wh_id |
string |
|
☐ |
|
supplier_wh_id_label |
string |
|
☐ |
|
supplier_wh_id |
string |
|
☐ |
|
warehouse_domain_ids |
string |
|
☐ |
|
warehouse_ids |
string |
|
☐ |
|
warehouse_selectable |
boolean |
Applicable on Warehouse |
☐ |
When a warehouse is selected for this route, this route should be seen as the default route when products pass through this warehouse. |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826