TYPE=VIEW
query=(select `s`.`sub_head` AS `sub_head`,sum(`v`.`dr`) AS `intbal`,(`s`.`code` + 48000) AS `o_sub_head` from `co-operativebank-198`.`synopsis` `s` join `co-operativebank-198`.`voucher` `v` where (((`s`.`code` + 48000) = `v`.`sub_head`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-03-31\') and (`s`.`sl_no` = 2)) group by `v`.`sub_head`) union (select `s`.`sub_head` AS `sub_head`,sum(`v`.`dr`) AS `intbal`,(`s`.`code` + 48000) AS `o_sub_head` from `co-operativebank-198`.`synopsis` `s` join `co-operativebank-198`.`voucher` `v` where (((`s`.`code` + 48000) = `v`.`sub_head`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-03-31\') and (`s`.`sl_no` = 3)) group by `v`.`sub_head`) union (select `s`.`sub_head` AS `sub_head`,sum(`v`.`cr`) AS `intbal`,`s`.`int_head` AS `o_sub_head` from `co-operativebank-198`.`loanintsubhead` `s` join `co-operativebank-198`.`voucher` `v` where ((`s`.`int_head` = `v`.`sub_head`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-03-31\')) group by `v`.`sub_head`)
md5=e046a4653f0982d87b6d97f198f6b73b
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-06-14 13:30:17
create-version=1
source=(select s.sub_head, sum(dr) as intbal,(s.code+48000) as o_sub_head from `synopsis` s,voucher v  where (s.code+48000)=v.sub_head and date>=\'2024-04-01\' and date<=\'2025-03-31\' and sl_no=2  group by v.sub_head ) union (select s.sub_head, sum(dr) as intbal,(s.code+48000) as o_sub_head from `synopsis` s,voucher v  where (s.code+48000)=v.sub_head and date>=\'2024-04-01\' and date<=\'2025-03-31\' and sl_no=3  group by v.sub_head) union (select s.sub_head, sum(cr) as intbal,int_head as o_sub_head from `loanintsubhead` s,voucher v  where  s.int_head=v.sub_head and date>=\'2024-04-01\' and date<=\'2025-03-31\'  group by v.sub_head)
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select `s`.`sub_head` AS `sub_head`,sum(`v`.`dr`) AS `intbal`,(`s`.`code` + 48000) AS `o_sub_head` from `co-operativebank-198`.`synopsis` `s` join `co-operativebank-198`.`voucher` `v` where (((`s`.`code` + 48000) = `v`.`sub_head`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-03-31\') and (`s`.`sl_no` = 2)) group by `v`.`sub_head`) union (select `s`.`sub_head` AS `sub_head`,sum(`v`.`dr`) AS `intbal`,(`s`.`code` + 48000) AS `o_sub_head` from `co-operativebank-198`.`synopsis` `s` join `co-operativebank-198`.`voucher` `v` where (((`s`.`code` + 48000) = `v`.`sub_head`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-03-31\') and (`s`.`sl_no` = 3)) group by `v`.`sub_head`) union (select `s`.`sub_head` AS `sub_head`,sum(`v`.`cr`) AS `intbal`,`s`.`int_head` AS `o_sub_head` from `co-operativebank-198`.`loanintsubhead` `s` join `co-operativebank-198`.`voucher` `v` where ((`s`.`int_head` = `v`.`sub_head`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-03-31\')) group by `v`.`sub_head`)
