{
	"name": "query/manager/product/product_material/estimated/work_in_progress_material_self_cost_ak.json",
	"table": [
		{
			"record_type": ["estimated"],
			"table": "product_material"
		}
	],
	"field": [
		{
			"aggregate": "sum",
			"name": "wme_cost_price__unit_sum",
			"parameter": ["prma.cost_price"]
		}
	],
	"fieldZ": [
		"prma.product_id",
		"prma.material_id",
		"prma.cost_price",
		"pro.production_order_state"
	],
	"query": [
		["prma.cost_price", "<>", 0],
		"and",
		["pro.production_order_state", "in", ["AL"]],
		"and",
		["pr.product_type", "in", [3, 4]],
		"and",
		["pr.production_control_type", "=", 1]
	]
}