{
	"name": "query/manager/order/order_row/purchase/delivery_reliability2.json",
	"database": "4d",
	"table": [{
		"record_type": ["purchase"],
		"table": "order_row"
	}],
	"parameter": {
		"end_date": "2016-12-31",
		"order_type": [],
		"show_sql": true,
		"start_date": "2016-01-01"
	},
	"field": ["ordr.confirmed_delivery_date", "ordr.json_data.first_confirmed_delivery_date", "ordr.delivery_date", "ordr.actual_delivery_date", "ordr.order_id", "ordr.row_number", "ord.company_id", "co.name"],
	"optional_parameter": ["supplier_id", "order_type"],
	"query": [
		["ordr.delivery_state", "=", "LT"], "and", ["ordr.actual_delivery_date", ">=", "start_date"], "and", ["ordr.actual_delivery_date", "<=", "end_date"], "and", ["ordr.json_data.order_type", "in", "order_type"]
	]
}