{
	"name": "query/manager/product/product_material/need_calc_material_test.json",
	"table": [
		{
			"record_type": ["estimated"],
			"table": "product_material"
		}
	],
	"database": "4d",
	"parameter": {
		"show_sql": true,
		"work": []
	},
	"field": ["prma.material_id", "prma.product_id", "prma.material_id.pr.name"],
	"fieldX": [
		"prma.product_id.pr.name",
		"prma.product_id",
		"prma.material_id",
		"prma.amount",
		"pr.stock_vs_design_conversion_multiplier",
		"pr.work_number",
		"pr.product_id",
		"pr.product_type",
		"pr.stock_unit",
		"pr.name",
		"pr.stock_balance",
		"prma.material_id.prma.amount",
		"prma.material_id.pr.stock_vs_design_conversion_multiplier",
		"prma.material_id.pr.product_type",
		"prma.material_id.pr.stock_unit",
		"prma.material_id.pr.name",
		"prma.material_id.pr.stock_balance"
	],
	"order": ["prma.material_id", ">"],
	"query": [
		["prma.record_type", "=", "record_type"],
		"and",
		["prma.product_id", "in", "product"],
		"and",
		["prma.product_material_state", ">=", 0]
	]
}
