{
  "facility_sql": "select /*FACILITY_TAG*/ sum(remaining) as PunchBalance\r\nfrom (\r\n\tselect c.CUSTOMER_ID, sum(p.delta) as Remaining \r\n\tfrom punches p \r\n\t\tjoin customers c on c.customer_id=p.customer_id\r\n                     where p.VOIDED = 0\r\n\tgroup by c.customer_id \r\n\thaving remaining>0\r\n\t) dt",
  "merge_sql": "",
  "json": "{\r\n  \"facility_column_tag\": \"/*FACILITY_TAG*/\"\r\n}",
  "name": "Punch Card Remaining Balances"
}