{"iTotalDisplayRecords":"13","query":"\r\n  SELECT SQL_CALC_FOUND_ROWS `vendor_advance_id`, `reference_number`, `vendor_id`, `vendor_type`, `company_id`, `project_id`, `payment_category`, `advance_status`, `requested_amount`, `approved_amount`, `paid_amount`, `requested_by`, `requested_on`, `requested_remark`, `stock_vendor_name`, `stock_vendor_code`, `project_manpower_agency_name`, `project_manpower_agency_code`, `project_machine_vendor_master_name`, `project_machine_vendor_master_code`, `project_name`, `company_name`, `vendor_type_name`, `requested_user_name`\r\n  FROM vendor_advance_view\r\n   Where (`advance_status` = 'Requested' OR `advance_status` = 'Approved' )\r\n  ORDER BY requested_on DESC\r\n  \r\n  ","aaData":[{"vendor_advance_id":"4510","reference_number":"VAR4510","vendor_id":"1573","vendor_type":"3","company_id":"2","project_id":"86","payment_category":"Purchase","advance_status":"Requested","requested_amount":"62400","approved_amount":"0","paid_amount":"0","requested_by":"151460924842124700","requested_on":"2025-05-31 09:43:13","requested_remark":"Advance payment for boom barrier","stock_vendor_name":"Arma Tech Future Solutions","stock_vendor_code":"KNS.VEN.1566","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KARIHOBANAHALLI","company_name":"K.N. SURENDRA","vendor_type_name":"Material","requested_user_name":"AJITHKUMAR.Y.B","documentCount":0},{"vendor_advance_id":"4494","reference_number":"VAR4494","vendor_id":"575","vendor_type":"3","company_id":"23","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"997542.5","approved_amount":"997542.5","paid_amount":"0","requested_by":"164369399294647500","requested_on":"2025-04-15 10:38:35","requested_remark":"vibha park light pole","stock_vendor_name":"VIBHA LED LIGHTINGS","stock_vendor_code":"KNS.VEN.573","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"KNS PROPWORTH LLP","vendor_type_name":"Material","requested_user_name":"SHILPA.C.K","documentCount":0},{"vendor_advance_id":"4493","reference_number":"VAR4493","vendor_id":"1232","vendor_type":"3","company_id":"23","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"919559.25","approved_amount":"919559.25","paid_amount":"0","requested_by":"164369399294647500","requested_on":"2025-04-15 10:36:34","requested_remark":"Cable square","stock_vendor_name":"CABLE SQUARE PRIVATE LIMITED","stock_vendor_code":"KNS.VEN.1228","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"KNS PROPWORTH LLP","vendor_type_name":"Material","requested_user_name":"SHILPA.C.K","documentCount":0},{"vendor_advance_id":"4492","reference_number":"VAR4492","vendor_id":"1465","vendor_type":"3","company_id":"23","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"666700","approved_amount":"666700","paid_amount":"0","requested_by":"164369399294647500","requested_on":"2025-04-14 09:18:22","requested_remark":"rmu blueberry","stock_vendor_name":"VD BLUEBERRY PRIVATE LIMITED","stock_vendor_code":"KNS.VEN.1459","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"KNS PROPWORTH LLP","vendor_type_name":"Material","requested_user_name":"SHILPA.C.K","documentCount":0},{"vendor_advance_id":"4491","reference_number":"VAR4491","vendor_id":"29","vendor_type":"3","company_id":"23","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"1050130","approved_amount":"1050130","paid_amount":"0","requested_by":"164369399294647500","requested_on":"2025-04-14 09:17:17","requested_remark":"coyote conductor","stock_vendor_name":"ALUMINIUM CABLES & CONDUCTORS","stock_vendor_code":"KNS.VEN.29","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"KNS PROPWORTH LLP","vendor_type_name":"Material","requested_user_name":"SHILPA.C.K","documentCount":0},{"vendor_advance_id":"4487","reference_number":"VAR4487","vendor_id":"1534","vendor_type":"3","company_id":"25","project_id":"114","payment_category":"Purchase","advance_status":"Approved","requested_amount":"6781","approved_amount":"6781","paid_amount":"0","requested_by":"151460924842124700","requested_on":"2025-03-31 09:41:45","requested_remark":"Tiles materials","stock_vendor_name":"SS ENTERPRISES","stock_vendor_code":"KNS.VEN.1527","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS SAMOOHA 1 and 2","company_name":"KNS VINTAGE INFRA PRIVATE LIMITED","vendor_type_name":"Material","requested_user_name":"AJITHKUMAR.Y.B","documentCount":0},{"vendor_advance_id":"4484","reference_number":"VAR4484","vendor_id":"27","vendor_type":"3","company_id":"2","project_id":"64","payment_category":"Purchase","advance_status":"Approved","requested_amount":"192989","approved_amount":"192989","paid_amount":"0","requested_by":"164369399294647500","requested_on":"2025-03-26 10:23:39","requested_remark":"sobha limited","stock_vendor_name":"SOBHA LIMITED","stock_vendor_code":"KNS.VEN.27","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS VIJAYANAGAR BUILDING","company_name":"K.N. SURENDRA","vendor_type_name":"Material","requested_user_name":"SHILPA.C.K","documentCount":0},{"vendor_advance_id":"4478","reference_number":"VAR4478","vendor_id":"575","vendor_type":"3","company_id":"23","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"250000","approved_amount":"250000","paid_amount":"0","requested_by":"164369399294647500","requested_on":"2025-01-17 14:36:46","requested_remark":"vibha","stock_vendor_name":"VIBHA LED LIGHTINGS","stock_vendor_code":"KNS.VEN.573","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"KNS PROPWORTH LLP","vendor_type_name":"Material","requested_user_name":"SHILPA.C.K","documentCount":0},{"vendor_advance_id":"4443","reference_number":"VAR4443","vendor_id":"112","vendor_type":"3","company_id":"2","project_id":"41","payment_category":"Purchase","advance_status":"Approved","requested_amount":"20449","approved_amount":"20449","paid_amount":"0","requested_by":"151460924842124700","requested_on":"2024-11-27 17:30:42","requested_remark":"Advance payment","stock_vendor_name":"RATNAGIRI IMPEX PVT LTD","stock_vendor_code":"KNS.VEN.110","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS NEOLIVA","company_name":"K.N. SURENDRA","vendor_type_name":"Material","requested_user_name":"AJITHKUMAR.Y.B","documentCount":0},{"vendor_advance_id":"4407","reference_number":"VAR4407","vendor_id":"1388","vendor_type":"3","company_id":"8","project_id":"103","payment_category":"Purchase","advance_status":"Approved","requested_amount":"52447","approved_amount":"52447","paid_amount":"0","requested_by":"151460924842124700","requested_on":"2024-10-07 12:39:06","requested_remark":"Root Barrier","stock_vendor_name":"TERRAPRO TRADEX PRIVATE LIMITED","stock_vendor_code":"KNS.VEN.1383","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS Amora","company_name":"KNS PROJECTS PRIVATE LIMITED","vendor_type_name":"Material","requested_user_name":"AJITHKUMAR.Y.B","documentCount":0},{"vendor_advance_id":"3749","reference_number":"VAR3749","vendor_id":"965","vendor_type":"3","company_id":"2","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"42659","approved_amount":"42659","paid_amount":"0","requested_by":"143841429031701100","requested_on":"2024-06-06 16:20:36","requested_remark":"DATED 05\/12\/2023 PAYMENT ","stock_vendor_name":"G.SHANTILAL ELECTRICALS","stock_vendor_code":"KNS.VEN.961","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"K.N. SURENDRA","vendor_type_name":"Material","requested_user_name":"GIRISH SHETTY","documentCount":0},{"vendor_advance_id":"3748","reference_number":"VAR3748","vendor_id":"969","vendor_type":"3","company_id":"2","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"12390","approved_amount":"12390","paid_amount":"0","requested_by":"143841429031701100","requested_on":"2024-06-06 16:13:50","requested_remark":"20.03.2024 payment missed ","stock_vendor_name":"JAFARI TRADERS","stock_vendor_code":"KNS.VEN.965","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"K.N. SURENDRA","vendor_type_name":"Material","requested_user_name":"GIRISH SHETTY","documentCount":0},{"vendor_advance_id":"3746","reference_number":"VAR3746","vendor_id":"1241","vendor_type":"3","company_id":"23","project_id":"68","payment_category":"Purchase","advance_status":"Approved","requested_amount":"339840","approved_amount":"339840","paid_amount":"0","requested_by":"143841429031701100","requested_on":"2024-06-06 13:02:42","requested_remark":"asper Shilpa given PO Made advance for above ","stock_vendor_name":"ADVANCE ENTERPRISES","stock_vendor_code":"KNS.VEN.1237","project_manpower_agency_name":null,"project_manpower_agency_code":null,"project_machine_vendor_master_name":null,"project_machine_vendor_master_code":null,"project_name":"KNS ANANTHA","company_name":"KNS PROPWORTH LLP","vendor_type_name":"Material","requested_user_name":"GIRISH SHETTY","documentCount":0}]}