public.work_orders
iduuidtenant_iduuidwo_numbercharacter varyingitem_iduuidbom_iduuidwarehouse_iduuidplanned_qtynumericproduced_qtynumericmaterial_costnumericstatuscharacter varyingnotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonelabour_costnumericoverhead_costnumericscrap_qtynumericbyproduct_valuenumericrejected_qtynumericauto_complete_errortext?so_iduuid?so_line_iduuid?responsible_person_iduuid?variant_iduuid?parent_work_order_iduuid?root_work_order_iduuid?wo_levelintegertree_pathARRAYparent_bom_line_iduuid?is_mandatory_for_parentbooleanexplosion_sourcetextplanned_startdate?planned_enddate?due_datedate?prioritytextorder_reftext?
| id | tenant_id | wo_number | item_id | bom_id | warehouse_id | planned_qty | produced_qty | material_cost | status | notes | created_by | is_active | created_at | updated_at | labour_cost | overhead_cost | scrap_qty | byproduct_value | rejected_qty | auto_complete_error | so_id | so_line_id | responsible_person_id | variant_id | parent_work_order_id | root_work_order_id | wo_level | tree_path | parent_bom_line_id | is_mandatory_for_parent | explosion_source | planned_start | planned_end | due_date | priority | order_ref |