{
  "facility_sql": "SELECT /*FACILITY_TAG*/ \r\n    i.INVOICE_ID,\r\n    i.CUSTOMER_ID,\r\n    CONCAT(c.FIRSTNAME, ' ', c.LASTNAME) AS customer_name,\r\n    c.CURRENT_STATUS,\r\n    i.POSTDATE,\r\n    i.AMOUNT,\r\n    i.SALES_TAX,\r\n    i.INVTYPE,\r\n    i.VOIDEDINVOICE\r\nFROM invoices i\r\nJOIN customers c ON i.CUSTOMER_ID = c.CUSTOMER_ID\r\nWHERE (i.VOIDEDINVOICE = 1 OR i.INVTYPE = 'REVERSE')\r\n  AND i.POSTDATE BETWEEN '/*START_DATE*/' AND '/*END_DATE*/'\r\n\r\nUNION ALL\r\n\r\nSELECT /*FACILITY_TAG*/ \r\n    i.INVOICE_ID,\r\n    i.CUSTOMER_ID,\r\n    CONCAT(c.FIRSTNAME, ' ', c.LASTNAME) AS customer_name,\r\n    c.CURRENT_STATUS,\r\n    i.POSTDATE,\r\n    i.AMOUNT,\r\n    i.SALES_TAX,\r\n    i.INVTYPE,\r\n    i.VOIDEDINVOICE\r\nFROM invoices i\r\nJOIN customers c ON i.CUSTOMER_ID = c.CUSTOMER_ID\r\nLEFT JOIN payments p ON i.PAYMENT_ID = p.PAYMENT_ID\r\nWHERE c.CURRENT_STATUS = 'TERMINATED'\r\n  AND (i.PAYMENT_ID = 0 OR COALESCE(p.Declined, 0) = 1)\r\n  AND i.POSTDATE BETWEEN '/*START_DATE*/' AND '/*END_DATE*/'\r\n\r\nORDER BY customer_name, POSTDATE;",
  "merge_sql": "",
  "json": "{\r\n  \"facility_column_tag\": \"/*FACILITY_TAG*/\",\r\n  \"wants_start_date\": {\r\n    \"tag\": \"/*START_DATE*/\"\r\n  },\r\n  \"wants_end_date\": {\r\n    \"tag\": \"/*END_DATE*/\"\r\n  }\r\n}",
  "name": "Voided, Reversed, Terminated Invoices"
}