{
	"database_not_in_use": "4d",
	"name": "form/manager/workpost_gig/test_data_start.json",
	"query_param": {
		"employee": "AK",
		"prwo.produced_amount": 2,
		"prwo.failed_amount": 1,
		"prwo.work_hours": 1.5,
		"prwo.info": "workpost_gig/test_data_start"
	},
	"delete": [
		{
			"table": "wpa",
			"query": [["prwo.production_lot", "=", "08069/01"]]
		},
		{
			"table": "wos",
			"query": [["prwo.production_lot", "=", "08069/01"]]
		},
		{
			"table": "wo",
			"query": [["pro.production_lot", "=", "08069/01"]]
		},
		{
			"table": "wpa",
			"query_not_in_use": "query/manager/product/product_work/actual/workpost_gig/test_start_delete_wpa.json",
			"query_param_not_in_use": {}
		}
	],
	"struct": {
		"wo": [
			{
				"pro.json_data.work__position_num_id": "08069",
				"wo_est_finish_week": 0,
				"pro.drawing_number": "B23321",
				"pro.row_number": 1,
				"pro.remaining_amount": 5,
				"pro.info": "Z",
				"pro.production_order_state": "KU",
				"pro.json_data.critical_real_end_date": "2015-02-04",
				"pro.json_data.est_finish_difference": 0,
				"pro.json_data.material_estimated_arrival_date": "2015-01-25",
				"pro.json_data.type": "",
				"pro.json_data.material_actual_arrival_date": "0001-01-01",
				"pro.started_amount": 5,
				"pro.production_lot": "08069/01",
				"pro.json_data.start_time": "00:00:00",
				"wo_start_date": "0000-00-00",
				"pro.json_data.est_finish_date": "0000-00-00",
				"pro.json_data.purchase_order_id": "",
				"pro.json_data.firm_id": 1,
				"pro.json_data.partial_delivery_number": 0,
				"pro.json_data.critical_end_date": "2015-02-04",
				"pro.sales_order_id": "110300",
				"pro.json_data.modifier_id": "",
				"pro.json_data.sales_price__unit": 125,
				"pro.json_data.stock_event": "",
				"pro.json_data.delivery_date": "2015-02-04",
				"pro.json_data.in_report": false,
				"pro.json_data.transfer_state": 0,
				"pro.failed_amount": 0,
				"pro.json_data.print_date": "0000-00-00",
				"pro.json_data.pricing_state": 0,
				"pro.json_data.serial_number": "",
				"pro.modify_id": "20150323.142933.gg019.wo_  zzy010ddb1b45aa80n",
				"pro.json_data.transfer_info": "",
				"wo_critical_start_time": "14:00:00",
				"pro.json_data.critical_start_date": "2015-01-23",
				"pro.json_data.actual_end_date": "0000-00-00",
				"pro.json_data": "",
				"pro.json_data.work_order_type": 0,
				"pro.json_data.parent_production_lot": "08069/01",
				"pro.project_id": "",
				"pro.json_data.est_finish_time": "00:00:00",
				"wo_start_week": 0,
				"pro.record_id": "",
				"pro.json_data.critical_delayed_end_date": "2015-02-04",
				"pro.produced_amount": 0,
				"pro.json_data.creation_date": "2015-01-21",
				"pro.company_id": "KONEEN VALO",
				"pro.json_data.transfer_id": "",
				"pro.create_user": "",
				"pro.json_data.critical_start_difference": 0,
				"pro.production_order_id": "",
				"wo_act_finish_week": 0,
				"pro.json_data.track_time_status": 1,
				"pro.json_data.finished_work_phase": 0,
				"pro.sales_order_row": 2,
				"wos": [
					{
						"prwo.json_data.transfer_state": 0,
						"prwo.json_data.firm_id": 0,
						"prwo.production_lot": "08069/01",
						"prwo.json_data.est_setup_salary__hour": 10,
						"prwo.json_data.critical_date_difference": -56,
						"prwo.json_data": "",
						"prwo.work_phase_type": 0,
						"prwo.json_data.link_to_start": false,
						"prwo.json_data.reclamation_count": 0,
						"prwo.failed_amount": 0,
						"prwo.work_phase_state": "AL",
						"prwo.json_data.track_time_status": 1,
						"prwo.record_id": "",
						"prwo.json_data.production_lot__work_ph": "08069/01#01",
						"prwo.description": "Leikkaus, sahataan sovittuun mittaan",
						"prwo.json_data.critical_delayed_end_date": "2014-12-11",
						"prwo.json_data.est_salary__hour": 10,
						"prwo.json_data.modifier_id": "",
						"prwo.json_data.delivery_to_customer": 0,
						"prwo.json_data.critical_extra_end_time": "04:00:00",
						"prwo.json_data.prod_lot__linked_phase": "",
						"prwo.product_work_state": 0,
						"prwo.json_data.customer_project": "",
						"prwo.json_data.end_time": "0000-00-00",
						"prwo.create_user": "",
						"prwo.modify_id": "20150323.142937.5h034.wos_ zzy010ddb1b45aa80n",
						"prwo.json_data.previous_phase": "",
						"prwo.json_data.material_owner": 0,
						"prwo.json_data.urgency_index": 0,
						"prwo.json_data.extra_end_time": "0000-00-00",
						"prwo.produced_amount": 0,
						"prwo.json_data.transfer_id": "",
						"prwo.json_data.target_machine_time": 0,
						"prwo.remaining_amount": 5,
						"prwo.json_data.est_machine_setup_cost__hour": 5,
						"prwo.json_data.est_bonus_work_time__unit": 0,
						"prwo.extra_hours": 60,
						"prwo.work_phase_number": 1,
						"prwo.json_data.delay": 0,
						"prwo.json_data.work_time": 2.5,
						"prwo.json_data.subcontract": false,
						"prwo.json_data.advance": 0,
						"prwo.json_data.critical_delayed_start_date": "2014-12-10",
						"prwo.info": "",
						"prwo.json_data.measured_track_time": 0,
						"prwo.json_data.planned_work_time": 2.5,
						"prwo.resource_id": "SAH",
						"prwo.json_data.est_work_time__unit": 0.5,
						"prwo.json_data.linking_hours": 0,
						"prwo.json_data.critical_end_time": "02:00:00",
						"prwo.json_data.employee_id": "X",
						"prwo.json_data.next_phase": "",
						"prwo.setup_hours": 0.5,
						"prwo.json_data.link_target": 0,
						"prwo.json_data.critical_start_time": "22:42:12",
						"prwo.json_data.target_time": 0,
						"prwo.json_data.setup_hours": 0.5,
						"prwo.json_data.load_multiplier": 0,
						"prwo.json_data.est_contract_price__unit": 0,
						"prwo.json_data.project_id": "",
						"prwo.json_data.start_time": "0000-00-00",
						"prwo.json_data.subtype": "",
						"prwo.json_data.act_end_date": "2015-03-23",
						"prwo.json_data.est_machine_work_cost__hour": 7,
						"prwo.json_data.track_time": 0,
						"wpa": [
							{
								"prwo.json_data.unpaid_hours": 0,
								"prwo.json_data.user_id": "AK",
								"prwo.json_data.work_phase_actual_id": 24791,
								"prwo.json_data.night_work_hours": 0,
								"prwo.json_data.est_machine_setup_cost__hour": 5,
								"prwo.json_data.project_id": "",
								"prwo.json_data.cost_center": "",
								"prwo.json_data.hourly_salary": false,
								"prwo.json_data.est_contract_price__unit": 0,
								"prwo.setup_hourly_self_cost": 5,
								"prwo.cost_price": 0,
								"prwo.json_data.program_id": "",
								"prwo.json_data.subtype": "LT",
								"prwo.person_id": "AK",
								"prwo.json_data.start_work_shift": 0,
								"prwo.work_hours": 0,
								"prwo.json_data.track_time": 0,
								"prwo.json_data.supplier_id": "",
								"prwo.json_data.start_time": "08:00:00",
								"prwo.json_data": "",
								"prwo.create_user": "",
								"prwo.setup_hours": 0.5,
								"prwo.json_data.transfer_state": -100,
								"prwo.produced_amount": 0,
								"prwo.production_lot": "08069/01",
								"prwo.json_data.contract_price__unit": 0,
								"prwo.json_data.stock_event_id": "",
								"prwo.work_phase_type": "LO",
								"prwo.description": "2015.03.23-11:23:47",
								"prwo.json_data.firm_id": 0,
								"prwo.work_phase_number": 1,
								"prwo.modify_id": "20150323.112357.9o00j.wpa_ zzy010ddb1b45aa80d",
								"prwo.json_data.target_time": 0,
								"prwo.json_data.est_bonus_work_time__unit": 0,
								"prwo.json_data.start_date": "2016-02-16",
								"prwo.json_data.contract_salary": false,
								"prwo.json_data.customer_project": "",
								"prwo.json_data.track_time_status": 0,
								"prwo.json_data.measured_track_time": 0,
								"prwo.json_data.target_machine_time": 0,
								"prwo.json_data.parcel_code": "",
								"prwo.setup_hourly_salary": 10,
								"prwo.json_data.salary_bonus": 0,
								"prwo.machine_hours": 0,
								"prwo.json_data.est_machine_work_cost__hour": 7,
								"prwo.work_hourly_self_cost": 7,
								"prwo.json_data.est_work_time__unit": 0.5,
								"prwo.json_data.start_subtype": "",
								"prwo.json_data.est_salary__hour": 10,
								"prwo.json_data.end_date": "2016-02-16",
								"prwo.json_data.work_number": "08069",
								"prwo.json_data.est_setup_salary__hour": 10,
								"prwo.json_data.kind": 1,
								"prwo.started_amount": 0,
								"prwo.json_data.contract_multiplier": 0,
								"prwo.json_data.start_person_id": "AK",
								"prwo.json_data.transfer_id": "",
								"prwo.json_data.social_cost_multiplier": 1.7,
								"prwo.profit_multiplier": 1.4,
								"prwo.json_data.modifier_id": "",
								"prwo.sales_price": 0,
								"prwo.json_data.smelting_num": "",
								"prwo.resource_id": "SAH",
								"prwo.info": "Testing",
								"prwo.json_data.end_time": "09:00:00",
								"prwo.salary": 0,
								"prwo.json_data.evening_work_hours": 0,
								"prwo.json_data.subcontract": false,
								"prwo.json_data.work_shift": 0,
								"prwo.record_id": "",
								"prwo.failed_amount": 0,
								"prwo.work_hourly_salary": 10
							}
						]
					}
				]
			}
		]
	}
}
