{
	"name": "form/nc/erp-sync/query/company.json",
	"table": [
		{
			"table": "company",
			"record_type": ["customer"]
		},
		{
			"table": "order",
			"record_type": ["invoice"]
		}
	],
	"parameter": {
		"show_sql": false,
		"subquery": "SELECT DISTINCT company_id from invoice"
	},
	"query": ["co.company_id", "in", "subquery"],
	"order": ["co.company_id", ">"],
	"query-not-in-use": [["co.json_data.transfer_id", "<>", ""]]
}
