invantive documentation
Forum di supporto InvantiveAccedi / Registrati

workcenter: Odoo itgen_odoo_workcenter

read only per partition

  • Catalogo: Odoo
  • Schema: mrp
  • Etichetta: itgen_odoo_workcenter

Work Center

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella workcenter. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Creato il
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 Nome visualizzato
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 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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: