routing_workcenter |
Work Center Usage
Catalog: Odoo
Schema: mrp
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 routing_workcenter are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
allow_operation_dependencies |
boolean |
Operation Dependencies |
☐ |
Create operation level dependencies that will influence both planning and the status of work orders upon MO confirmation. If this feature is ticked, and nothing is specified, Odoo will assume that all operations can be started simultaneously. |
blocked_by_operation_ids |
string |
|
☐ |
Operations that need to be completed before this operation can start. |
bom_id_label |
string |
|
☐ |
|
bom_id |
string |
|
☐ |
|
bom_product_template_attribute_value_ids |
string |
|
☐ |
BOM Product Variants needed to apply this line. |
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
name |
string |
Operation |
☑ |
|
needed_by_operation_ids |
string |
|
☐ |
Operations that cannot start before this operation is completed. |
note |
string |
Description |
☐ |
|
possible_bom_product_template_attribute_value_ids |
string |
|
☐ |
|
sequence |
int32 |
Sequence |
☐ |
Gives the sequence order when displaying a list of routing Work Centers. |
time_computed_on |
string |
Computed on last |
☐ |
|
time_cycle_manual |
decimal |
Manual Duration |
☐ |
Time in minutes:- In manual mode, time used- In automatic mode, supposed first time when there aren't any work orders yet |
time_cycle |
decimal |
Duration |
☐ |
|
time_mode_batch |
int32 |
Based on |
☐ |
|
time_mode |
string |
Duration Computation |
☐ |
|
workcenter_id_label |
string |
|
☐ |
|
workcenter_id |
string |
|
☐ |
|
workorder_count |
int32 |
# Work Orders |
☐ |
|
workorder_ids |
string |
|
☐ |
|
worksheet_google_slide |
string |
Google Slide |
☐ |
Paste the url of your Google Slide. Make sure the access to the document is public. |
worksheet_type |
string |
Worksheet |
☐ |
|
worksheet |
byte[] |
☐ |
|
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826