{
	"name": "query/manager/order/order_row/purchase/delivery_reliability_selection.json",
	"info": "query/manager/order/order_row/purchase/delivery_reliability_selection.json",
	"database": "4d",
	"table": [{
		"record_type": ["purchase"],
		"table": "order_row"
	}],
	"parameter": {
		"order_type": ["AH", "RA"],
		"selection": [],
		"show_sql": true
	},
	"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"],
	"query": [
		["ordr.delivery_state", "<>", ""], "and", ["ordr.record_id", "in", "selection"], "and", ["ordr.actual_delivery_date", "<>", "0000-00-00"], "and", ["ord.order_type", "in", "order_type"]
	],
	"queryZZ": [
		["ordr.delivery_state", "<>", ""], "and", ["ordr.actual_delivery_date", "<>", "0000-00-00"], "and", ["ord.order_type", "in", "order_type"]
	]
}