{"iTotalDisplayRecords":"28","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `project_budget_authority_id`, `project_budget_authority_project`, `budget_authority_id`, `project_budget_authority_user`, `project_budget_authority_status`, `project_budget_authority_remark`, `project_budget_authority_added_by`, `project_budget_authority_added_on`, `budget_authority_name`, `budget_authority_percentage`, `project_master_name`, `project_budget_authority_added_user_name`, `project_budget_authority_user_name`\r\n    FROM project_budget_authority_view\r\n    \r\n    ORDER BY project_budget_authority_project ASC , budget_authority_percentage DESC\r\n    \r\n    ","aaData":[{"project_budget_authority_id":"29","project_budget_authority_project":"2","budget_authority_id":"13","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"For old project approval","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 15:44:33","budget_authority_name":"General Manager Approval","budget_authority_percentage":"100.00","project_master_name":"KNS OASIS","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"23","project_budget_authority_project":"2","budget_authority_id":"12","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"For Old Projects ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 14:41:40","budget_authority_name":"General Manager Approval","budget_authority_percentage":"25.00","project_master_name":"KNS OASIS","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"11","project_budget_authority_project":"3","budget_authority_id":"6","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-09-30 15:33:06","budget_authority_name":"2000%","budget_authority_percentage":"2000000.00","project_master_name":"AGS - SANGAMITRA","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"10","project_budget_authority_project":"3","budget_authority_id":"3","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-09-30 15:26:34","budget_authority_name":"General Manager Level","budget_authority_percentage":"5.00","project_master_name":"AGS - SANGAMITRA","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"32","project_budget_authority_project":"60","budget_authority_id":"13","project_budget_authority_user":"161457624467680800","project_budget_authority_status":"Active","project_budget_authority_remark":"for use only","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2022-09-17 12:43:22","budget_authority_name":"General Manager Approval","budget_authority_percentage":"100.00","project_master_name":"KNS OFFICE","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"27","project_budget_authority_project":"62","budget_authority_id":"12","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"For old projects ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 14:43:45","budget_authority_name":"General Manager Approval","budget_authority_percentage":"25.00","project_master_name":"KNS NESTER","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"25","project_budget_authority_project":"63","budget_authority_id":"12","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"For Old projects ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 14:42:37","budget_authority_name":"General Manager Approval","budget_authority_percentage":"25.00","project_master_name":"KNS ETHOS","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"1","project_budget_authority_project":"63","budget_authority_id":"1","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"testdddd","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-08-11 14:03:23","budget_authority_name":"Manager Level","budget_authority_percentage":"3.00","project_master_name":"KNS ETHOS","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"24","project_budget_authority_project":"64","budget_authority_id":"12","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"For Old Projects ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 14:42:09","budget_authority_name":"General Manager Approval","budget_authority_percentage":"25.00","project_master_name":"KNS CARICA","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"28","project_budget_authority_project":"69","budget_authority_id":"12","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"For old Projects Approval ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 14:44:42","budget_authority_name":"General Manager Approval","budget_authority_percentage":"25.00","project_master_name":"KNS ATHENA","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"15","project_budget_authority_project":"70","budget_authority_id":"9","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"InActive","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-10-19 13:16:41","budget_authority_name":"Management - 100%","budget_authority_percentage":"100.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"16","project_budget_authority_project":"70","budget_authority_id":"9","project_budget_authority_user":"161457624467680800","project_budget_authority_status":"Active","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-10-19 13:17:05","budget_authority_name":"Management - 100%","budget_authority_percentage":"100.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"17","project_budget_authority_project":"70","budget_authority_id":"9","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"100% approvals","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-10-26 11:46:28","budget_authority_name":"Management - 100%","budget_authority_percentage":"100.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"18","project_budget_authority_project":"70","budget_authority_id":"9","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"Active","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-10-26 11:46:49","budget_authority_name":"Management - 100%","budget_authority_percentage":"100.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"8","project_budget_authority_project":"70","budget_authority_id":"3","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"InActive","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-09-20 11:29:24","budget_authority_name":"General Manager Level","budget_authority_percentage":"5.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"9","project_budget_authority_project":"70","budget_authority_id":"3","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"Active","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-09-20 11:30:13","budget_authority_name":"General Manager Level","budget_authority_percentage":"5.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"7","project_budget_authority_project":"70","budget_authority_id":"1","project_budget_authority_user":"159168131497374500","project_budget_authority_status":"Active","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-09-20 11:29:06","budget_authority_name":"Manager Level","budget_authority_percentage":"3.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"6","project_budget_authority_project":"70","budget_authority_id":"1","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-09-20 11:25:28","budget_authority_name":"Manager Level","budget_authority_percentage":"3.00","project_master_name":"KNS Alora","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"26","project_budget_authority_project":"71","budget_authority_id":"12","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"for old projects approval ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-11-18 14:43:04","budget_authority_name":"General Manager Approval","budget_authority_percentage":"25.00","project_master_name":"KNS ETHOS II","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"30","project_budget_authority_project":"83","budget_authority_id":"9","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"Active","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-12-27 13:01:05","budget_authority_name":"Management - 100%","budget_authority_percentage":"100.00","project_master_name":"KNS CALISTO","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"20","project_budget_authority_project":"83","budget_authority_id":"11","project_budget_authority_user":"161457624467680800","project_budget_authority_status":"Active","project_budget_authority_remark":"Approval  Authority on behalf of MD with the prior approval from MD.   ","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-10-30 08:53:24","budget_authority_name":"Managing Director approval","budget_authority_percentage":"100.00","project_master_name":"KNS CALISTO","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"31","project_budget_authority_project":"83","budget_authority_id":"13","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"ok","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-12-28 14:04:28","budget_authority_name":"General Manager Approval","budget_authority_percentage":"100.00","project_master_name":"KNS CALISTO","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"19","project_budget_authority_project":"83","budget_authority_id":"10","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"Manager Approval","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-10-30 08:49:58","budget_authority_name":"General Manager Approval","budget_authority_percentage":"3.00","project_master_name":"KNS CALISTO","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"21","project_budget_authority_project":"93","budget_authority_id":"11","project_budget_authority_user":"161457624467680800","project_budget_authority_status":"Active","project_budget_authority_remark":"Approval Authority in ERP on Behalf of MD with prior approval for the change in budget.","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-10-30 08:54:24","budget_authority_name":"Managing Director approval","budget_authority_percentage":"100.00","project_master_name":"KNS FRESCO","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"22","project_budget_authority_project":"93","budget_authority_id":"10","project_budget_authority_user":"144134636241439400","project_budget_authority_status":"Active","project_budget_authority_remark":"Approval Authority for GM Projects.","project_budget_authority_added_by":"161457624467680800","project_budget_authority_added_on":"2021-10-30 08:57:35","budget_authority_name":"General Manager Approval","budget_authority_percentage":"3.00","project_master_name":"KNS FRESCO","project_budget_authority_added_user_name":"GOWTHAM.V","project_budget_authority_user_name":"GOWTHAM.V","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"4","project_budget_authority_project":"97","budget_authority_id":"4","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"testing","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-08-25 14:24:07","budget_authority_name":"Test","budget_authority_percentage":"10.00","project_master_name":"MOM20-08-2021","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"3","project_budget_authority_project":"97","budget_authority_id":"1","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"testing","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-08-25 14:23:15","budget_authority_name":"Manager Level","budget_authority_percentage":"3.00","project_master_name":"MOM20-08-2021","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0},{"project_budget_authority_id":"2","project_budget_authority_project":"97","budget_authority_id":"5","project_budget_authority_user":"143620071466608200","project_budget_authority_status":"InActive","project_budget_authority_remark":"testing","project_budget_authority_added_by":"143620071466608200","project_budget_authority_added_on":"2021-08-25 14:16:53","budget_authority_name":"Test Level","budget_authority_percentage":"1.00","project_master_name":"MOM20-08-2021","project_budget_authority_added_user_name":"NANJEGOWDA","project_budget_authority_user_name":"NANJEGOWDA","woItemCount":0,"woTermCount":0}]}