{
	"name": "query/manager/product/production_order/work_in_progress.json",
	"table": [
		{
			"record_type": [""],
			"table": "production_order"
		}
	],
	"database": "4d",
	"field": [
		"pro.company_id",
		"pro.production_order_state",
		"pro.json_data.work__position_num_id",
		"pr.product_group",
		"pro.drawing_number",
		"pro.production_lot",
		"pro.row_number",
		"pro.json_data.creation_date",
		"pro.json_data.material_actual_arrival_date",
		"pro.started_amount",
		"pro.remaining_amount",
		"pro.produced_amount",
		"pro.failed_amount",
		"pro.json_data.sales_price__unit",
		"pr.product_id",
		"pr.name",
		"pr.production_control_type",
		"pr.stock_balance"
	],
	"option": {
		"ZZ save_data_file_name": "work_in_progress_cost_data.json"
	},
	"order": [
		"pr.product_group",
		">",
		"pro.production_lot",
		">",
		"pro.row_number",
		">"
	],
	"query": ["pro.production_order_state", "in", ["EK", "KU", "AL", "PY"]],
	"subquery": [
		{
			"name": "qry_work_self_cost",
			"query": "query/manager/product/product_work/actual/work_in_progress_work_self_cost.json"
		},
		{
			"name": "qry_material_self_cost_por",
			"query": "query/manager/order/order_row/purchase/work_in_progress_material_self_cost.json"
		},
		{
			"name": "qry_material_self_cost_wme__unit",
			"query": "query/manager/product/product_material/estimated/work_in_progress_material_self_cost.json"
		},
		{
			"name": "qry_subcontract_self_cost",
			"query": "query/manager/order/order_row/purchase/work_in_progress_subcontract_self_cost.json"
		}
	]
}