public.job_work_orders
iduuidtenant_iduuidjw_numbercharacter varyingvendor_iduuidsource_warehouse_iduuidvendor_warehouse_iduuidprocess_namecharacter varyinginput_item_iduuidoutput_item_iduuidconversion_rationumericrate_basischaracter varyingjob_ratenumericgst_ratenumericloss_tolerance_pctnumericstatuscharacter varyingnotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zoneso_iduuid?work_typetext?challan_notext?challan_datedate?expected_return_datedate?discount_pctnumericround_offnumerictotal_sent_valuenumericwo_iduuid?stage_iduuid?
| id | tenant_id | jw_number | vendor_id | source_warehouse_id | vendor_warehouse_id | process_name | input_item_id | output_item_id | conversion_ratio | rate_basis | job_rate | gst_rate | loss_tolerance_pct | status | notes | created_by | is_active | created_at | updated_at | so_id | work_type | challan_no | challan_date | expected_return_date | discount_pct | round_off | total_sent_value | wo_id | stage_id |