{
	"name": "query/manager/order/order_row/sales/delivery_reliability.json",
	"database": "4d",
	"table": [{
		"record_type": ["sales"],
		"table": "order_row"
	}],
	"parameter": {
		"end_date": "2016-12-31",
		"packing_cost_type": 7,
		"packing_material_type": 6,
		"show_sql": false,
		"start_date": "2016-01-01"
	},
	"query": [
		["ordr.delivery_state", "=", "LT"],
		"and",
		["ordr.actual_delivery_date", ">=", "start_date"],
		"and",
		["ordr.actual_delivery_date", "<=", "end_date"],
		"and",
		["pr.product_type", "<>", "packing_material_type"],
		"and",
		["pr.product_type", "<>", "packing_cost_type"]
	],
	"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",
		"pr.product_type",
		"co.name"
	]
}