{
	"name": "form/manager/erp-sync/query/order.json",
	"table": [
		{
			"record_type": ["sales"],
			"table": "order"
		},
		{
			"record_type": ["customer"],
			"table": "customer"
		}
	],
	"parameter": {
		"company_id": "1057",
		"closed_order_state": ["LO", "PE"],
		"show_sql": true
	},
	"query": [["ord.company_id", "=", "company_id"], "and", ["ord.order_state", "not in", "closed_order_state"]],
	"order": ["ord.order_id", ">"],
	"orderX": ["ordr.order_id", ">", "ordr.row_number", ">", "ordr.json_data.partial_delivery_number", ">"]
}
