TYPE=VIEW
query=select `v`.`date` AS `date`,if((`v`.`cr` > 0),concat(`sh1`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\'),concat(`sh2`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\')) AS `cr_ledger`,if((`v`.`dr` = 0),concat(`sh2`.`sub_head`,\' A/C (\',`v`.`Acc_no`,\')\'),concat(`sh1`.`sub_head`,\'A/C (\',`v`.`cash_acc`,\')\')) AS `dr_ledger`,if((`v`.`cr` > 0),`v`.`cr`,`v`.`dr`) AS `amt`,`l2`.`acc_type` AS `acc_type` from (((((`co-operativebank`.`voucher` `v` join `co-operativebank`.`ledger` `l1`) join `co-operativebank`.`ledger` `l2`) join `co-operativebank`.`sub_head` `sh1`) join `co-operativebank`.`sub_head` `sh2`) join `co-operativebank`.`deposit_acc` `da`) where ((`v`.`cash_acc` = `l1`.`acc_no`) and (`v`.`Acc_no` = `l2`.`acc_no`) and (`l1`.`sub_head` = `sh1`.`code`) and (`l2`.`sub_head` = `sh2`.`code`) and (`da`.`acc_no` = `v`.`Acc_no`))
md5=2860247422a20a30895db119608ef1ec
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:55
create-version=1
source=select `v`.`date` AS `date`,if((`v`.`cr` > 0),concat(`sh1`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\'),concat(`sh2`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\')) AS `cr_ledger`,if((`v`.`dr` = 0),concat(`sh2`.`sub_head`,\' A/C (\',`v`.`Acc_no`,\')\'),concat(`sh1`.`sub_head`,\'A/C (\',`v`.`cash_acc`,\')\')) AS `dr_ledger`,if((`v`.`cr` > 0),`v`.`cr`,`v`.`dr`) AS `amt`,`l2`.`acc_type` AS `acc_type` from (((((`voucher` `v` join `ledger` `l1`) join `ledger` `l2`) join `sub_head` `sh1`) join `sub_head` `sh2`) join `deposit_acc` `da`) where ((`v`.`cash_acc` = `l1`.`acc_no`) and (`v`.`Acc_no` = `l2`.`acc_no`) and (`l1`.`sub_head` = `sh1`.`code`) and (`l2`.`sub_head` = `sh2`.`code`) and (`da`.`acc_no` = `v`.`Acc_no`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`date` AS `date`,if((`v`.`cr` > 0),concat(`sh1`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\'),concat(`sh2`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\')) AS `cr_ledger`,if((`v`.`dr` = 0),concat(`sh2`.`sub_head`,\' A/C (\',`v`.`Acc_no`,\')\'),concat(`sh1`.`sub_head`,\'A/C (\',`v`.`cash_acc`,\')\')) AS `dr_ledger`,if((`v`.`cr` > 0),`v`.`cr`,`v`.`dr`) AS `amt`,`l2`.`acc_type` AS `acc_type` from (((((`co-operativebank`.`voucher` `v` join `co-operativebank`.`ledger` `l1`) join `co-operativebank`.`ledger` `l2`) join `co-operativebank`.`sub_head` `sh1`) join `co-operativebank`.`sub_head` `sh2`) join `co-operativebank`.`deposit_acc` `da`) where ((`v`.`cash_acc` = `l1`.`acc_no`) and (`v`.`Acc_no` = `l2`.`acc_no`) and (`l1`.`sub_head` = `sh1`.`code`) and (`l2`.`sub_head` = `sh2`.`code`) and (`da`.`acc_no` = `v`.`Acc_no`))
