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

# workcenter: Odoo itgen_odoo_workcenter

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `mrp`
- Label: itgen_odoo_workcenter

Work Center

Can only retrieve data.

## Table Columns

The columns of the table `workcenter` 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 resource record without removing it. |
| `alternative_workcenter_ids` | `varchar2` |  | [ ] |  | Alternative workcenters that can be substituted to this one in order to dispatch production |
| `blocked_time` | `numeric` | Blocked Time | [ ] |  | Blocked hours over the last month |
| `capacity_ids` | `varchar2` |  | [ ] |  | Specific number of pieces that can be produced in parallel per product. |
| `code` | `varchar2` | Code | [ ] |  |  |
| `color` | `int32` | Color | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `costs_hour` | `numeric` | Cost per hour | [ ] |  | Hourly processing cost. |
| `costs_hour_account_id` | `varchar2` |  | [ ] |  | Posts analytical accounting entries in real time for both component and operational costs. |
| `costs_hour_account_id_label` | `varchar2` |  | [ ] |  | Posts analytical accounting entries in real time for both component and operational costs. |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `default_capacity` | `numeric` | Capacity | [ ] |  | Default number of pieces (in product UoM) that can be produced in parallel (at the same time) at this work center. For example: the capacity is 5 and you need to produce 10 units, then the operation time listed on the BOM will be multiplied by two. However, note that both time before and after production will only be counted once. |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `has_routing_lines` | `boolean` | Has Routing Lines | [ ] |  | Technical field for workcenter views |
| `id` | `int32` | ID | [ ] |  |  |
| `name` | `varchar2` | Work Center | [ ] |  |  |
| `note` | `varchar2` | Description | [ ] |  |  |
| `oee` | `numeric` | Oee | [ ] |  | Overall Equipment Effectiveness, based on the last month |
| `oee_target` | `numeric` | OEE Target | [ ] |  | Overall Effective Efficiency Target in percentage |
| `order_ids` | `varchar2` |  | [ ] |  |  |
| `performance` | `int32` | Performance | [ ] |  | Performance over the last month |
| `productive_time` | `numeric` | Productive Time | [ ] |  | Productive hours over the last month |
| `resource_calendar_id` | `varchar2` |  | [ ] |  |  |
| `resource_calendar_id_label` | `varchar2` |  | [ ] |  |  |
| `resource_id` | `varchar2` |  | [ ] |  |  |
| `resource_id_label` | `varchar2` |  | [ ] |  |  |
| `routing_line_ids` | `varchar2` |  | [ ] |  |  |
| `sequence` | `int32` | Sequence | [x] |  | Gives the sequence order when displaying a list of work centers. |
| `tag_ids` | `varchar2` |  | [ ] |  |  |
| `time_efficiency` | `numeric` | Time Efficiency | [ ] |  | This field is used to calculate the expected duration of a work order at this work center. For example, if a work order takes one hour and the efficiency factor is 100%, then the expected duration will be one hour. If the efficiency factor is 200%, however the expected duration will be 30 minutes. |
| `time_ids` | `varchar2` |  | [ ] |  |  |
| `time_start` | `numeric` | Setup Time | [ ] |  |  |
| `time_stop` | `numeric` | Cleanup Time | [ ] |  |  |
| `tz` | `varchar2` | Timezone | [ ] |  | This field is used in order to define in which timezone the resources will work. |
| `workcenter_load` | `numeric` | Work Center Load | [ ] |  |  |
| `working_state` | `varchar2` | Workcenter Status | [ ] |  |  |
| `workorder_count` | `int32` | # Work Orders | [ ] |  |  |
| `workorder_late_count` | `int32` | Total Late Orders | [ ] |  |  |
| `workorder_pending_count` | `int32` | Total Pending Orders | [ ] |  |  |
| `workorder_progress_count` | `int32` | Total Running Orders | [ ] |  |  |
| `workorder_ready_count` | `int32` | # Read Work Orders | [ ] |  |  |
| `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)

