{"iTotalDisplayRecords":"14","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `compliance_id`, `company_id`, `compliance_description`, `category_id`, `subcategory_id`, `occurrence`, `action_date`, `notification_early_period`, `responsible_person`, `penalty_applicable`, `penalty_grace_period`, `penalty_amount`, `status`, `added_by`, `added_on`, `approved_by`, `approved_on`, `stock_company_master_name`, `category_name`, `subcategory_name`, `added_user_name`, `responsible_person_user_name`\r\n    FROM compliance_view\r\n    \r\n    ORDER BY added_on ASC\r\n    \r\n    ","aaData":[{"compliance_id":"54","company_id":"3","compliance_description":"fghjk","category_id":null,"subcategory_id":"7","occurrence":"HalfYear","action_date":"2022-10-10","notification_early_period":"5632","responsible_person":"143841424055011700","penalty_applicable":"Yes","penalty_grace_period":"6","penalty_amount":"9635","status":"Rejected","added_by":"143620071466608200","added_on":"2022-09-20 15:54:07","approved_by":"143620071466608200","approved_on":"2022-09-24 11:21:57","stock_company_master_name":"KNS OVERSEAS PRIVATE LIMITED","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"AJITH ASHOKAN","documentCount":3},{"compliance_id":"55","company_id":"3","compliance_description":"hgvjhbjnkml,","category_id":null,"subcategory_id":"6","occurrence":"HalfYear","action_date":"2022-12-12","notification_early_period":"4632","responsible_person":"14388461769223300","penalty_applicable":"No","penalty_grace_period":"5","penalty_amount":"504","status":"Completed","added_by":"143620071466608200","added_on":"2022-09-20 15:54:44","approved_by":"143620071466608200","approved_on":"2022-09-22 11:44:34","stock_company_master_name":"KNS OVERSEAS PRIVATE LIMITED","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"SHREYAS H R","documentCount":1},{"compliance_id":"56","company_id":"4","compliance_description":"desc","category_id":null,"subcategory_id":"7","occurrence":"OneTime","action_date":"2022-05-05","notification_early_period":"65","responsible_person":"14416185751586300","penalty_applicable":"No","penalty_grace_period":"4","penalty_amount":"654","status":"Rejected","added_by":"143620071466608200","added_on":"2022-09-20 15:56:46","approved_by":"143620071466608200","approved_on":"2022-09-24 11:31:16","stock_company_master_name":"KNS CONCRETE PRODUCTS PRIVATE LIMITED","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"ABHISHEK","documentCount":1},{"compliance_id":"57","company_id":"4","compliance_description":"test","category_id":null,"subcategory_id":"13","occurrence":"Month","action_date":"2022-02-02","notification_early_period":"2","responsible_person":"143884634583343100","penalty_applicable":"Yes","penalty_grace_period":"3","penalty_amount":"5468","status":"Completed","added_by":"143620071466608200","added_on":"2022-09-20 16:02:34","approved_by":"143620071466608200","approved_on":"2022-09-24 11:35:34","stock_company_master_name":"KNS CONCRETE PRODUCTS PRIVATE LIMITED","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":null,"documentCount":0},{"compliance_id":"58","company_id":"2","compliance_description":"test desc","category_id":null,"subcategory_id":"15","occurrence":"Quarterly","action_date":"2022-10-10","notification_early_period":"2","responsible_person":"14384120858785500","penalty_applicable":"No","penalty_grace_period":"2","penalty_amount":"845","status":"Completed","added_by":"143620071466608200","added_on":"2022-09-22 11:47:16","approved_by":"143620071466608200","approved_on":"2022-09-27 17:59:38","stock_company_master_name":"K.N. SURENDRA","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"cpeak","documentCount":0},{"compliance_id":"59","company_id":"2","compliance_description":"Desc","category_id":null,"subcategory_id":"8","occurrence":"OneTime","action_date":"2022-12-12","notification_early_period":"3","responsible_person":"143736679571416700","penalty_applicable":"Yes","penalty_grace_period":"3","penalty_amount":"451","status":"Rejected","added_by":"143620071466608200","added_on":"2022-09-30 18:29:47","approved_by":"143620071466608200","approved_on":"2022-10-14 12:24:46","stock_company_master_name":"K.N. SURENDRA","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":null,"documentCount":0},{"compliance_id":"60","company_id":"1","compliance_description":"TEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GSTTEST YVR HOW IS TO FILE GST","category_id":null,"subcategory_id":"24","occurrence":"OneTime","action_date":"2022-10-08","notification_early_period":"1","responsible_person":"14384120858785500","penalty_applicable":"Yes","penalty_grace_period":"5","penalty_amount":"10","status":"Completed","added_by":"143620071466608200","added_on":"2022-10-06 12:51:46","approved_by":"143620071466608200","approved_on":"2022-10-06 12:52:32","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"cpeak","documentCount":0},{"compliance_id":"61","company_id":"3","compliance_description":"aBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsraBHISH tEST gsr","category_id":null,"subcategory_id":"24","occurrence":"OneTime","action_date":"2022-10-20","notification_early_period":"5","responsible_person":"143620071466608200","penalty_applicable":"Yes","penalty_grace_period":"2","penalty_amount":"100","status":"Completed","added_by":"143620071466608200","added_on":"2022-10-06 12:58:33","approved_by":"143620071466608200","approved_on":"2022-10-14 11:29:57","stock_company_master_name":"KNS OVERSEAS PRIVATE LIMITED","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"NANJEGOWDA","documentCount":0},{"compliance_id":"62","company_id":"2","compliance_description":"test","category_id":null,"subcategory_id":"1","occurrence":"OneTime","action_date":"2022-10-05","notification_early_period":"5","responsible_person":"14384120858785500","penalty_applicable":"Yes","penalty_grace_period":"6","penalty_amount":"6789","status":"Rejected","added_by":"143620071466608200","added_on":"2022-10-14 12:25:27","approved_by":"161457624467680800","approved_on":"2023-05-15 13:02:14","stock_company_master_name":"K.N. SURENDRA","category_name":null,"subcategory_name":null,"added_user_name":"NANJEGOWDA","responsible_person_user_name":"cpeak","documentCount":1},{"compliance_id":"63","company_id":"1","compliance_description":"Every Month ","category_id":"22","subcategory_id":"26","occurrence":"Month","action_date":"2023-05-07","notification_early_period":"4","responsible_person":"162858198033674900","penalty_applicable":"Yes","penalty_grace_period":"0","penalty_amount":"1.5","status":"Pending","added_by":"161457624467680800","added_on":"2023-05-15 12:54:21","approved_by":"","approved_on":"2023-05-15 12:54:21","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","category_name":"TDS","subcategory_name":"TDS PAYMENT","added_user_name":"GOWTHAM.V","responsible_person_user_name":"LOKESHA BILLAVA","documentCount":0},{"compliance_id":"64","company_id":"1","compliance_description":"ok","category_id":"22","subcategory_id":"27","occurrence":"Quarterly","action_date":"2023-07-30","notification_early_period":"20","responsible_person":"162858198033674900","penalty_applicable":"Yes","penalty_grace_period":"0","penalty_amount":"200","status":"Pending","added_by":"161457624467680800","added_on":"2023-05-15 12:57:41","approved_by":"","approved_on":"2023-05-15 12:57:41","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","category_name":"TDS","subcategory_name":"TDS RETURNS","added_user_name":"GOWTHAM.V","responsible_person_user_name":"LOKESHA BILLAVA","documentCount":0},{"compliance_id":"65","company_id":"2","compliance_description":"","category_id":"19","subcategory_id":"20","occurrence":"Month","action_date":"2023-05-20","notification_early_period":"15","responsible_person":"166868877920928700","penalty_applicable":"Yes","penalty_grace_period":"0","penalty_amount":"50","status":"Pending","added_by":"161457624467680800","added_on":"2023-05-15 13:02:01","approved_by":"","approved_on":"2023-05-15 13:02:01","stock_company_master_name":"K.N. SURENDRA","category_name":"GST","subcategory_name":"GSTR 3B","added_user_name":"GOWTHAM.V","responsible_person_user_name":null,"documentCount":0},{"compliance_id":"66","company_id":"2","compliance_description":"","category_id":"19","subcategory_id":"19","occurrence":"Month","action_date":"2023-05-11","notification_early_period":"6","responsible_person":"166868877920928700","penalty_applicable":"Yes","penalty_grace_period":"0","penalty_amount":"0","status":"Pending","added_by":"161457624467680800","added_on":"2023-05-15 13:02:53","approved_by":"","approved_on":"2023-05-15 13:02:53","stock_company_master_name":"K.N. SURENDRA","category_name":"GST","subcategory_name":"GSTR1","added_user_name":"GOWTHAM.V","responsible_person_user_name":null,"documentCount":0},{"compliance_id":"67","company_id":"1","compliance_description":"sdkjfhsdjkf sddfjkhsdfuijsdhdf sdjdfkhsdjkfsdkf","category_id":"19","subcategory_id":"19","occurrence":"Month","action_date":"2023-08-11","notification_early_period":"5","responsible_person":"166868877920928700","penalty_applicable":"Yes","penalty_grace_period":"1","penalty_amount":"20","status":"Completed","added_by":"162520706133487700","added_on":"2023-08-25 17:49:28","approved_by":"162520706133487700","approved_on":"2023-08-25 17:49:42","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","category_name":"GST","subcategory_name":"GSTR1","added_user_name":"PAVAN KUMAR ","responsible_person_user_name":null,"documentCount":0}]}