{
	"name": "report/work_in_progress_cost/query/work_in_progress_work_self_cost.json",
	"organization_id": "4d",
	"table": [
		{
			"record_type": ["actual"],
			"table": "product_work"
		}
	],
	"parameter": {
		"work_phase_type": "plugin/nc-calc-server/constant.json/phase_type.done",
		"start_person_id": "FMS",
		"person_id": "FMS",
		"production_order_state": "plugin/nc-calc-server/constant.json/work_center_phase_not_open_state",
		"show_sql": false
	},
	"option": {
		"main_table_field": "pro.production_order_id"
	},
	"query": [
		["prwo.json_data.work_phase_type", "=", "work_phase_type"],
		"and",
		["prwo.json_data.start_person_id", "<>", "start_person_id"],
		"and",
		["prwo.person_id", "<>", "start_person_id"],
		"and",
		["pro.production_order_state", "not in", "production_order_state"]
	],
	"field": ["prwo.production_order_id", "prwo.cost_price"]
}
