TYPE=VIEW
query=select `ledger_actual_balance`.`ledger` AS `ledger`,if((`ledger_actual_balance`.`amt` < 0),(`ledger_actual_balance`.`amt` * -(1)),`ledger_actual_balance`.`amt`) AS `amt` from `co-operativebank-221`.`ledger_actual_balance`
md5=c7dbbd748a6d043f31fe40021d0cec74
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2023-08-31 12:31:40
create-version=1
source=select  `ledger_actual_balance`.`ledger`  AS  `ledger` ,\nif( (  `ledger_actual_balance`.`amt`  <0 ), (  `ledger_actual_balance`.`amt`  *  - ( 1  )  ) ,\n `ledger_actual_balance`.`amt`  ) AS  `amt`  from  `co-operativebank-221`.`ledger_actual_balance`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `ledger_actual_balance`.`ledger` AS `ledger`,if((`ledger_actual_balance`.`amt` < 0),(`ledger_actual_balance`.`amt` * -(1)),`ledger_actual_balance`.`amt`) AS `amt` from `co-operativebank-221`.`ledger_actual_balance`
