invantive documentation
Invantive Support ForumsLog In / Sign Up

workorder: Odoo itgen_odoo_workorder

read only per partition

  • Catalog: Odoo
  • Schema: mrp
  • Label: itgen_odoo_workorder

Work Order

Can only retrieve data.

Table Columns

The columns of the table workorder 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
allow_workorder_dependencies boolean Allow Work Order Dependencies
blocked_by_workorder_ids varchar2
company_id varchar2
company_id_label varchar2
consumption varchar2 Consumption
costs_hour numeric Cost per hour
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date_finished datetime End Date
date_planned_finished datetime Scheduled End Date
date_planned_start datetime Scheduled Start Date
date_start datetime Start Date
display_name varchar2 Display Name
duration numeric Real Duration
duration_expected numeric Expected Duration
duration_percent int32 Duration Deviation (%)
duration_unit numeric Duration Per Unit
finished_lot_id varchar2
finished_lot_id_label varchar2
id int32 ID
is_planned boolean Its Operations are Planned
is_produced boolean Has Been Produced
is_user_working boolean Is the Current User Working
json_popover varchar2 Popover Data JSON
last_working_user_id varchar2
leave_id varchar2 Slot into workcenter calendar once planned
leave_id_label varchar2 Slot into workcenter calendar once planned
mo_analytic_account_line_id varchar2
mo_analytic_account_line_id_label varchar2
move_finished_ids varchar2
move_line_ids varchar2 Inventory moves for which you must scan a lot number at this work order
move_raw_ids varchar2
name varchar2 Work Order
needed_by_workorder_ids varchar2
operation_id varchar2
operation_id_label varchar2
operation_note varchar2 Description
product_id varchar2
product_id_label varchar2
product_tracking varchar2 Tracking Ensure the traceability of a storable product in your warehouse.
product_uom_id varchar2
product_uom_id_label varchar2
production_availability varchar2 Stock Availability Manufacturing readiness for this MO, as per bill of material configuration: * Ready: The material is available to start the production. * Waiting: The material is not available to start the production.
production_bom_id varchar2 Bills of Materials, also called recipes, are used to autocomplete components and work order instructions.
production_bom_id_label varchar2 Bills of Materials, also called recipes, are used to autocomplete components and work order instructions.
production_date datetime Production Date Date at which you plan to start the production.
production_id varchar2
production_id_label varchar2
production_state varchar2 Production State * Draft: The MO is not confirmed yet. * Confirmed: The MO is confirmed, the stock rules and the reordering of the components are trigerred. * In Progress: The production has started (on the MO or on the WO). * To Close: The production is done, the MO has to be closed. * Done: The MO is closed, the stock moves are posted. * Cancelled: The MO has been cancelled, can't be confirmed anymore.
progress numeric Progress Done (%)
qty_produced numeric Quantity The number of products already handled by this work order
qty_producing numeric Currently Produced Quantity
qty_production numeric Original Production Quantity
qty_remaining numeric Quantity To Be Produced
qty_reported_from_previous_wo numeric Carried Quantity The quantity already produced awaiting allocation in the backorders chain.
scrap_count int32 Scrap Move
scrap_ids varchar2
show_json_popover boolean Show Popover?
state varchar2 Status
time_ids varchar2
wc_analytic_account_line_id varchar2
wc_analytic_account_line_id_label varchar2
workcenter_id varchar2
workcenter_id_label varchar2
working_state varchar2 Workcenter Status
working_user_ids varchar2
worksheet varbinary Worksheet
worksheet_google_slide varchar2 Worksheet URL Paste the url of your Google Slide. Make sure the access to the document is public.
worksheet_type varchar2 Worksheet Type
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: