Warning

Error while accessing the database Table 'perphexagon.vchd' doesn't exist select count(*) from (SELECT * FROM ( ( SELECT COUNT(*) AS cnt, SUM(a.InvAmt) AS total, a.SlDivCd, b.LocCd, b.SubLdCd, 0 AS sort_order, 'DETAIL' AS grp FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN perphexagon.vchd c ON c.VchId = b.VchId JOIN perphexagon.custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = 'OR01' AND b.VchDate >= '2025-05-14' AND b.VchDate <= '2025-05-30' GROUP BY a.SlDivCd, b.LocCd, b.SubLdCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, b.LocCd, NULL, 1, 'LOC_TOTAL' FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN perphexagon.vchd c ON c.VchId = b.VchId JOIN perphexagon.custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = 'OR01' AND b.VchDate >= '2025-05-14' AND b.VchDate <= '2025-05-30' GROUP BY a.SlDivCd, b.LocCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 2, 'MONTH_START_TO_FROMDATE' FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN perphexagon.vchd c ON c.VchId = b.VchId JOIN perphexagon.custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = 'OR01' AND b.VchDate >= DATE_FORMAT('2025-05-14', '%Y-%m-01') AND b.VchDate <= '2025-05-30' GROUP BY a.SlDivCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 3, 'FROMDATE_TO_TODATE' FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN perphexagon.vchd c ON c.VchId = b.VchId JOIN perphexagon.custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = 'OR01' AND b.VchDate >= '2025-05-14' AND b.VchDate <= '2025-05-30' GROUP BY a.SlDivCd ) UNION ALL ( SELECT COUNT(*), SUM(a.InvAmt), a.SlDivCd, 'ZZZ' AS LocCd, NULL, 3, 'GRAND_TOTAL' FROM cbvinvdetails a JOIN cbvvoucher b ON a.cbvvoucherid = b.cbvvoucherid JOIN perphexagon.vchd c ON c.VchId = b.VchId JOIN perphexagon.custmst d ON d.CustCd = b.SubLdCd WHERE a.SlDivCd = 'OR01' AND b.VchDate >= '2025-05-14' AND b.VchDate <= '2025-05-30' GROUP BY a.SlDivCd ) ) AS summary_data ORDER BY SlDivCd, LocCd, FIELD(grp, 'DETAIL', 'LOC_TOTAL', 'MONTH_START_TO_FROMDATE', 'FROMDATE_TO_TODATE', 'GRAND_TOTAL') ) nm_sel_esp