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-purbadekhali`.`balancesheet_ass` `a` group by `a`.`code`
md5=c9493234849f7ac5bc563129a5010425
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-02-16 03:46:26
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-purbadekhali`.`balancesheet_ass` `a` group by `a`.`code`
