invantive documentation
Forum di supporto InvantiveAccedi / Registrati

workorder: Odoo itgen_odoo_workorder

read only per partition

  • Catalogo: Odoo
  • Schema: mrp
  • Etichetta: itgen_odoo_workorder

Work Order

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella workorder. 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
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 Creato il
create_uid varchar2
create_uid_label varchar2
date_finished datetime Data di fine
date_planned_finished datetime Scheduled End Date
date_planned_start datetime Scheduled Start Date
date_start datetime Data di inizio
display_name varchar2 Nome visualizzato
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 Data di produzione Date at which you plan to start the production.
production_id varchar2
production_id_label varchar2
production_state varchar2 Stato della produzione * 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

Note di rilascio

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