{
	"name": "form/manager/project-material/query/purchase_project_material.json",
	"table": [
		{
			"record_type": ["purchase"],
			"table": "order_row"
		}
	],
	"database": "4d",
	"parameter": {
		"cancel_state": ["PE"],
		"order_type": "RA"
	},
	"field": [
		"ordr.product_id",
		"ordr.delivery_state",
		"ordr.order_amount",
		"ordr.delivery_amount",
		"pr.work_number",
		"pr.stock_unit",
		"pr.name",
		"pr.stock_balance",
		"pr.minimum_order_amount",
		"pr.default_supplier_id",
		"pr.product_type",
		"pr.storable",
		"pr.json_data.free_amount",
		"pr.json_data.coming_amount",
		"pr.json_data.going_amount"
	],
	"query": [
		["ord.project_id", "=", "project"],
		"and",
		["ord.order_state", "not in", "cancel_state"],
		"and",
		["ord.order_type", "=", "order_type"]
	]
}
