{
  "facility_sql": "select /*FACILITY_TAG*/ replace(ii.EXTRAINFO,'GiftCard-','') as CardNumber, \r\n\tSUM(CASE WHEN ii.PRODUCT_ID = (SELECT max(`VALUE`) from settings WHERE `NAME` = 'GiftCardProductID') THEN ii.PRICE ELSE 0 END) AS Balance\t\r\nfrom invoice_items ii\r\n\tjoin invoices i ON ii.INVOICE_ID = i.INVOICE_ID\t\r\nwhere ii.EXTRAINFO like 'GiftCard%'\r\n\tand i.VOIDEDINVOICE = 0\r\nGROUP BY ii.EXTRAINFO\r\nHAVING Balance > 0",
  "merge_sql": "SELECT    _cgr.CardNumber, COUNT(*) AS FacilityCount\r\nFROM _cgr\r\nGROUP BY _cgr.CardNumber\r\nHAVING COUNT(*) > 1",
  "json": "{\r\n  \"facility_column_tag\": \"/*FACILITY_TAG*/\"\r\n}",
  "name": "Duplicate Gift Card Numbers"
}