{
	"name": "form/nc/report/wip-value/query/order_row-sales.json",

	"table": [
		{
			"record_type": ["sales"],
			"table": "order_row"
		}
	],
	"parameter": {
		"start_date": "form/nc/report/wip-value/rec.json/start_date",
		"end_date": "form/nc/report/wip-value/rec.json/end_date",
		"product_group": "form/nc/report/wip-value/rec.json/product_group",
		"show_sql": true
	},
	"order": ["ordr.delivery_date", ">", "ordr.order_id", ">", "ordr.product_id", ">"],
	"query": [
		["ordr.delivery_date", ">=", "start_date"],
		"and",
		["ordr.delivery_date", "<=", "end_date"],
		"and",
		["pr.product_group", "in", "product_group"]
	]
}
