TYPE=VIEW
query=select `a`.`sl_no` AS `sl_no`,`a`.`code` AS `code`,`a`.`head_type` AS `head_type`,(sum(`a`.`cur_bal`) - sum(`a`.`bal`)) AS `cur_bal`,(sum(`a`.`pre_bal`) - sum(`a`.`bal1`)) AS `bal`,`a`.`main_head` AS `main_head` from `co-operativebank`.`balancesheet_ass` `a` group by `a`.`code`
md5=5978130317f6ef12e6eb2a414a2410e2
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-12-09 09:33:43
create-version=1
source=SELECT sl_no, code, head_type, sum(cur_bal)-sum(bal) as cur_bal,sum(pre_bal)-sum(bal1) as bal, main_head FROM balancesheet_ass a  group by code
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `a`.`sl_no` AS `sl_no`,`a`.`code` AS `code`,`a`.`head_type` AS `head_type`,(sum(`a`.`cur_bal`) - sum(`a`.`bal`)) AS `cur_bal`,(sum(`a`.`pre_bal`) - sum(`a`.`bal1`)) AS `bal`,`a`.`main_head` AS `main_head` from `co-operativebank`.`balancesheet_ass` `a` group by `a`.`code`
