{
  "database_not_in_use": "4d",
  "name": "dialog/workpost_gig/test_data_start.json",
  "query_param": {
    "production_lot_not_in_use": "1504",
    "employee": "AK",
    "production_lot": "08069/01",
    "work_phase": 1,
    "employee_not_in_use": "PM"
  },
  "delete": [
    {
      "table": "wpa",
      "query": [["wpa_production_lot","=","08069/01"]]
    },
    {
      "table": "wos",
      "query": [["wos_production_lot","=","08069/01"]]
    },
    {
      "table": "wo",
      "query": [["wo_production_lot","=","08069/01"]]
    },
    {
      "table": "wpa",
      "query_not_in_use": "wpa/workpost_gig/test_start_delete_wpa",
      "query_param_not_in_use": {}
    }
  ],
  "struct": {
    "wo": [
      {
        "wo_work__position_num_id": "08069",
        "wo_est_finish_week": 0,
        "wo_drawing_number": "B23321",
        "wo_row_number": 1,
        "wo_remaining_amount": 5,
        "wo_info": "Z",
        "wo_state": "KU",
        "wo_critical_date_real": "2015-02-04",
        "wo_est_finish_difference": 0,
        "wo_material_est_arrival_date": "2015-01-25",
        "wo_type_": "",
        "wo_material_act_arrival_date": "0001-01-01",
        "wo_started_amount": 5,
        "wo_production_lot": "08069/01",
        "wo_start_time": "00:00:00",
        "wo_start_date": "0000-00-00",
        "wo_est_finish_date": "0000-00-00",
        "wo_purchase_order_id": "",
        "wo_firm_id": 1,
        "wo_partial_delivery_number": 0,
        "wo_critical_date": "2015-02-04",
        "wo_sales_order_id": "110300",
        "wo_modifier_id": "",
        "wo_sales_price__unit": 125,
        "wo_stock_event_id": "",
        "wo_delivery_date": "2015-02-04",
        "wo_in_report": false,
        "wo_transfer_state": 0,
        "wo_failed_amount": 0,
        "wo_print_date": "0000-00-00",
        "wo_pricing_state": 0,
        "wo_serial_number": "",
        "wo_change_id": "20150323.142933.gg019.wo_  zzy010ddb1b45aa80n",
        "wo_transfer_info": "",
        "wo_critical_start_time": "14:00:00",
        "wo_critical_start_date": "2015-01-23",
        "wo_act_finish_date": "0000-00-00",
        "wo_additional_data": "",
        "wo_work_order_type": 0,
        "wo_parent_production_lot": "08069/01",
        "wo_project_id": "",
        "wo_est_finish_time": "00:00:00",
        "wo_start_week": 0,
        "wo_record_id": "",
        "wo_critical_date_delayed": "2015-02-04",
        "wo_produced_amount": 0,
        "wo_creation_date": "2015-01-21",
        "wo_company_id": "KONEEN VALO",
        "wo_transfer_id": "",
        "wo_creator_id": "",
        "wo_critical_start_difference": 0,
        "wo_work_order_id": "",
        "wo_act_finish_week": 0,
        "wo_track_time_status": 1,
        "wo_finished_work_phase": 0,
        "wo_sales_order_row_id": 2,
        "wos": [
          {
            "wos_transfer_state": 0,
            "wos_firm_id": 0,
            "wos_production_lot": "08069/01",
            "wos_est_setup_salary__hour": 10,
            "wos_critical_date_difference": -56,
            "wos_additional_data": "",
            "wos_type_": 0,
            "wos_link_to_start": false,
            "wos_reclamation_count": 0,
            "wos_failed_amount": 0,
            "wos_work_phase_state": "AL",
            "wos_track_time_status": 1,
            "wos_record_id": "",
            "wos_production_lot__work_ph": "08069/01#01",
            "wos_work_description": "Leikkaus, sahataan sovittuun mittaan",
            "wos_phase_critical_date_delayed": "2014-12-11",
            "wos_est_salary__hour": 10,
            "wos_modifier_id": "",
            "wos_delivery_to_customer": 0,
            "wos_phase_critical_extra_date": "2015-01-31",
            "wos_prod_lot__linked_phase": "",
            "wos_state": 0,
            "wos_customer_project": "",
            "wos_end_time": "00:00:00",
            "wos_creator_id": "",
            "wos_change_id": "20150323.142937.5h034.wos_ zzy010ddb1b45aa80n",
            "wos_previous_phase": "",
            "wos_end_date": "0000-00-00",
            "wos_material_owner": 0,
            "wos_urgency_index": 0,
            "wos_extra_end_time": "00:00:00",
            "wos_produced_amount": 0,
            "wos_transfer_id": "",
            "wos_target_machine_time": 0,
            "wos_remaining_amount": 5,
            "wos_est_machine_setup_cost__hour": 5,
            "wos_est_bonus_work_time__unit": 0,
            "wos_extra_hours": 60,
            "wos_work_phase": 1,
            "wos_delay": 0,
            "wos_work_time": 2.5,
            "wos_subcontract": false,
            "wos_advance": 0,
            "wos_phase_cr_start_date_delayed": "2014-12-10",
            "wos_info": "",
            "wos_measured_track_time": 0,
            "wos_planned_work_time": 2.5,
            "wos_work_load_group_id": "SAH",
            "wos_est_work_time__unit": 0.5,
            "wos_linking_hours": 0,
            "wos_phase_critical_date": "2015-01-27",
            "wos_phase_critical_extra_time": "04:00:00",
            "wos_employee_id": "X",
            "wos_next_phase": "",
            "wos_setup_time": 0.5,
            "wos_link_target": 0,
            "wos_phase_critical_start_date": "2015-01-26",
            "wos_target_time": 0,
            "wos_est_setup_time__lot": 0.5,
            "wos_load_multiplier": 0,
            "wos_est_contract_price__unit": 0,
            "wos_phase_critical_start_time": "22:42:12",
            "wos_project_id": "",
            "wos_phase_critical_time": "02:00:00",
            "wos_start_time": "00:00:00",
            "wos_subtype": "",
            "wos_act_end_date": "2015-03-23",
            "wos_extra_end_date": "0000-00-00",
            "wos_est_machine_work_cost__hour": 7,
            "wos_track_time": 0,
            "wos_start_date": "0000-00-00",
            "wpa": [
              {
                "wpa_unpaid_hours": 0,
                "wpa_user_id": "AK",
                "wpa_work_phase_actual_id": 24791,
                "wpa_night_work_hours": 0,
                "wpa_est_machine_setup_cost__hour": 5,
                "wpa_project_id": "",
                "wpa_cost_center": "",
                "wpa_hourly_salary": false,
                "wpa_est_contract_price__unit": 0,
                "wpa_machine_setup_cost__hour": 5,
                "wpa_work_cost_price__amount": 0,
                "wpa_program_id": "",
                "wpa_subtype": "KE",
                "wpa_employee_id": "",
                "wpa_start_shift_number": 0,
                "wpa_work_time__amount": 1,
                "wpa_track_time": 0,
                "wpa_supplier_id": "",
                "wpa_start_time": "08:00:00",
                "wpa_additional_data": "",
                "wpa_creator_id": "",
                "wpa_setup_time__amount": 0,
                "wpa_transfer_state": -100,
                "wpa_produced_amount": 0,
                "wpa_production_lot": "08069/01",
                "wpa_contract_price__unit": 0,
                "wpa_stock_event_id": "",
                "wpa_type_": "AL",
                "wpa_work_description": "2015.03.23-11:23:47",
                "wpa_firm_id": 0,
                "wpa_work_phase_est_id": 1,
                "wpa_change_id": "20150323.112357.9o00j.wpa_ zzy010ddb1b45aa80d",
                "wpa_target_time": 0,
                "wpa_est_bonus_work_time__unit": 0,
                "wpa_start_date": "2016-02-16",
                "wpa_contract_salary": false,
                "wpa_customer_project": "",
                "wpa_track_time_status": 0,
                "wpa_measured_track_time": 0,
                "wpa_target_machine_time": 0,
                "wpa_parcel_code": "",
                "wpa_setup_salary__hour": 10,
                "wpa_salary_bonus": 0,
                "wpa_machine_hours": 0,
                "wpa_est_machine_work_cost__hour": 7,
                "wpa_machine_work_cost__hour": 7,
                "wpa_est_work_time__unit": 0.5,
                "wpa_start_subtype": "",
                "wpa_est_setup_time__lot": 0.5,
                "wpa_est_salary__hour": 10,
                "wpa_date_": "2016-02-16",
                "wpa_work__position_num_id": "08069",
                "wpa_est_setup_salary__hour": 10,
                "wpa_kind": 1,
                "wpa_started_amount": 0,
                "wpa_contract_multiplier": 0,
                "wpa_start_employee_id": "AK",
                "wpa_transfer_id": "",
                "wpa_social_cost_multiplier": 1.7,
                "wpa_profit_multiplier": 1.4,
                "wpa_modifier_id": "",
                "wpa_work_sales_price__amount": 0,
                "wpa_smelting_num": "",
                "wpa_work_load_group_id": "SAH",
                "wpa_info": "",
                "wpa_end_time": "09:00:00",
                "wpa_work_salary__amount": 0,
                "wpa_evening_work_hours": 0,
                "wpa_subcontract": false,
                "wpa_shift_number": 0,
                "wpa_record_id": "",
                "wpa_failed_amount": 2,
                "wpa_salary__hour": 10
              }
            ]
          }
        ]
      }
    ]
  }
}
