TYPE=VIEW
query=select `v`.`Acc_no` AS `acc_no`,`v`.`cr` AS `cr`,`v`.`dr` AS `dr`,`v`.`date` AS `date`,`h`.`shcode` AS `shcode`,`h`.`sub_head` AS `sub_head`,`h`.`hcode` AS `hcode`,`h`.`type` AS `type`,`h`.`head` AS `head`,`h`.`htcode` AS `htcode`,`h`.`head_type` AS `head_type`,`h`.`main_head` AS `main_head` from (`co-operativebank-246`.`voucher` `v` join `co-operativebank-246`.`heads` `h`) where (`h`.`shcode` = `v`.`sub_head`)
md5=2185d2790497598d2904fc0030e278aa
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-12-29 05:45:49
create-version=1
source=select  `v`.`Acc_no`  AS  `acc_no` ,\n `v`.`cr`  AS  `cr` ,\n `v`.`dr`  AS  `dr` ,\n `v`.`date`  AS  `date` ,\n `h`.`shcode`  AS  `shcode` ,\n `h`.`sub_head`  AS  `sub_head` ,\n `h`.`hcode`  AS  `hcode` ,\n `h`.`type`  AS  `type` ,\n `h`.`head`  AS  `head` ,\n `h`.`htcode`  AS  `htcode` ,\n `h`.`head_type`  AS  `head_type` ,\n `h`.`main_head`  AS  `main_head`  from (  `co-operativebank-246`.`voucher`  `v`  join  `co-operativebank-246`.`heads`  `h`  ) where (  `h`.`shcode`  =  `v`.`sub_head`  )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`Acc_no` AS `acc_no`,`v`.`cr` AS `cr`,`v`.`dr` AS `dr`,`v`.`date` AS `date`,`h`.`shcode` AS `shcode`,`h`.`sub_head` AS `sub_head`,`h`.`hcode` AS `hcode`,`h`.`type` AS `type`,`h`.`head` AS `head`,`h`.`htcode` AS `htcode`,`h`.`head_type` AS `head_type`,`h`.`main_head` AS `main_head` from (`co-operativebank-246`.`voucher` `v` join `co-operativebank-246`.`heads` `h`) where (`h`.`shcode` = `v`.`sub_head`)
