{
  "facility_sql": "select /*FACILITY_TAG*/ dt.TaxType, dt.Account, dt.Description, dt.Amount, dt.Tax\r\nfrom (\r\n\r\nselect CONCAT(tt.TAX_NAME, ' - Taxable') AS TaxType, CONCAT(p.REV_CATEGORY,if(LENGTH(REVENUE_SUBCATEGORY)>0,CONCAT(':',p.REVENUE_SUBCATEGORY),'')) as Account, \r\n\tp.description as Description,convert(sum(ii.price),decimal(10,2)) as Amount,\r\n\tconvert(round(((tt.PERCENT100+tt.INCLUSIVERATEHINT100)/100.0)*sum(ii.price)*100)/100,decimal(10,2)) as Tax  \r\nfrom invoices i, invoice_items ii, products p, payments py, tax_types tt\r\nwhere i.invoice_id=ii.invoice_id \r\n\tand ii.product_id=p.product_id  \r\n\tand i.payment_id= py.payment_id  \r\n\tand DATE(py.postdate) >= '/*START_DATE*/'\r\n\tand DATE(py.POSTDATE) <= '/*END_DATE*/'\r\n\tand py.settled=1  \r\n\tand (not ii.IS_TAX_ITEM) \r\n\tand i.payment_id>0 \r\n\tand i.voidedinvoice=0 \r\n\tand py.declined=0 \r\n\tand py.voidedpayment=0 \r\n\tand not ii.tax_exempt\r\n\tand p.tax_type_list like CONCAT('% ', tt.TAXTYPE_ID, ' %')\r\ngroup by tt.TAXTYPE_ID, p.group_id \r\n\r\nUNION ALL\r\n\r\nselect CONCAT(tt.TAX_NAME, ' - NonTaxable') AS TaxType, CONCAT(p.REV_CATEGORY,if(LENGTH(REVENUE_SUBCATEGORY)>0,CONCAT(':',p.REVENUE_SUBCATEGORY),'')) as Account, \r\n\tp.description as Description,convert(sum(ii.price),decimal(10,2)) as Amount, null as Tax \r\nfrom invoices i, invoice_items ii, products p, payments py, tax_types tt\r\nwhere i.invoice_id=ii.invoice_id \r\n\tand ii.product_id=p.product_id  \r\n\tand i.payment_id= py.payment_id  \r\n\tand DATE(py.postdate) >= '/*START_DATE*/'\r\n\tand DATE(py.POSTDATE) <= '/*END_DATE*/'\r\n\tand py.settled=1  \r\n\tand (not ii.IS_TAX_ITEM) \r\n\tand i.payment_id>0 \r\n\tand i.voidedinvoice=0 \r\n\tand py.declined=0 \r\n\tand py.voidedpayment=0 \r\n\tand ((not ii.tax_exempt) \r\n\tand (isnull(p.tax_type_list) or not (p.tax_type_list like CONCAT('% ', tt.TAXTYPE_ID, ' %')))) \r\ngroup by tt.TAXTYPE_ID, p.group_id \r\n) dt\r\norder by TaxType DESC, Account, Description;",
  "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": "Sales Tax Details"
}