{"iTotalDisplayRecords":"20","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `vendor_payment_request_id`, `payment_request_number`, `company_id`, `payment_type`, `payment_status`, `tally_status`, `request_remark`, `added_by`, `added_on`, `stock_company_master_name`, `vendor_payment_requested_user_name`\r\n    FROM vendor_payment_request_view\r\n     Where (`payment_status` = 'Draft' OR `payment_status` = 'Pending') \r\n    ORDER BY added_on DESC\r\n    \r\n    ","aaData":[{"vendor_payment_request_id":"5574","payment_request_number":"PR5574","company_id":"1","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"Payment towards Recruitment Fees","added_by":"174520849012850100","added_on":"2025-05-06 17:55:05","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","vendor_payment_requested_user_name":"Mithun M Shet","requestedAmount":"38924","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5569","payment_request_number":"PR5569","company_id":"2","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"Reinvent","added_by":"151460924842124700","added_on":"2025-05-05 16:17:28","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"AJITHKUMAR.Y.B","requestedAmount":"58800","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5567","payment_request_number":"PR5567","company_id":"2","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"Ganesh industrial corportation","added_by":"151460924842124700","added_on":"2025-05-05 12:41:40","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"AJITHKUMAR.Y.B","requestedAmount":"15812","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5527","payment_request_number":"PR5526","company_id":"9","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"Payments towards staff welfare expenses","added_by":"174520849012850100","added_on":"2025-04-30 12:05:06","stock_company_master_name":"KNS INFRAPROJECTS PRIVATE LIMITED","vendor_payment_requested_user_name":"Mithun M Shet","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5525","payment_request_number":"PR5524","company_id":"1","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"Payment towards Recruitment","added_by":"174520849012850100","added_on":"2025-04-30 11:55:20","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","vendor_payment_requested_user_name":"Mithun M Shet","requestedAmount":"38924","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5507","payment_request_number":"PR5505","company_id":"9","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"Payments Towards Sales Training","added_by":"174520849012850100","added_on":"2025-04-24 10:16:16","stock_company_master_name":"KNS INFRAPROJECTS PRIVATE LIMITED","vendor_payment_requested_user_name":"Mithun M Shet","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5492","payment_request_number":"PR5490","company_id":"9","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"Payment towards Sales training","added_by":"174520849012850100","added_on":"2025-04-24 09:33:23","stock_company_master_name":"KNS INFRAPROJECTS PRIVATE LIMITED","vendor_payment_requested_user_name":"Mithun M Shet","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"5489","payment_request_number":"PR5489","company_id":"1","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"Apna Job portal Payment","added_by":"174520849012850100","added_on":"2025-04-23 17:15:19","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","vendor_payment_requested_user_name":"Mithun M Shet","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"4963","payment_request_number":"PR4962","company_id":"9","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"BRIO TECHNOLOGIES PVT LTD G MAIL 5 USERS","added_by":"167005129534012100","added_on":"2025-01-15 16:43:13","stock_company_master_name":"KNS INFRAPROJECTS PRIVATE LIMITED","vendor_payment_requested_user_name":"SRIDHARA G R","requestedAmount":"11832","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"4351","payment_request_number":"PR4351","company_id":"3","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"ok","added_by":"171464700312440400","added_on":"2024-11-14 12:04:21","stock_company_master_name":"KNS OVERSEAS PRIVATE LIMITED","vendor_payment_requested_user_name":"Admin","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"4325","payment_request_number":"PR4325","company_id":"9","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"OK","added_by":"143841429031701100","added_on":"2024-11-13 15:57:26","stock_company_master_name":"KNS INFRAPROJECTS PRIVATE LIMITED","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"4272","payment_request_number":"PR4272","company_id":"1","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"Towards office decoration expenses on account of Diwali","added_by":"17068555332259700","added_on":"2024-11-05 09:37:14","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","vendor_payment_requested_user_name":"MITHUN M SHET","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"4202","payment_request_number":"PR4202","company_id":"9","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"Payment towards exotel for Tellcalling Integration ","added_by":"161457624467680800","added_on":"2024-10-18 17:08:28","stock_company_master_name":"KNS INFRAPROJECTS PRIVATE LIMITED","vendor_payment_requested_user_name":"GOWTHAM.V","requestedAmount":"58408.82","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3706","payment_request_number":"PR3706","company_id":"2","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"ok","added_by":"143841429031701100","added_on":"2024-08-21 10:00:45","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3427","payment_request_number":"PR3427","company_id":"23","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"ADVANCE ENTERPRISES","added_by":"143841429031701100","added_on":"2024-06-06 12:59:25","stock_company_master_name":"KNS PROPWORTH LLP","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3420","payment_request_number":"PR3420","company_id":"1","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"JBK","added_by":"143841429031701100","added_on":"2024-06-06 12:49:24","stock_company_master_name":"KNS INFRASTRUCTURE PRIVATE LIMITED","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3415","payment_request_number":"PR3415","company_id":"2","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"JAFARI TRADERS","added_by":"143841429031701100","added_on":"2024-06-06 12:25:19","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3411","payment_request_number":"PR3411","company_id":"2","payment_type":"Debit","payment_status":"Draft","tally_status":"Pending","request_remark":"NET POINT","added_by":"143841429031701100","added_on":"2024-06-06 11:55:13","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"0","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3276","payment_request_number":"PR3276","company_id":"2","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"OK","added_by":"143841429031701100","added_on":"2024-05-08 11:58:25","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"500000","approvedAmount":"0","paidAmount":"0"},{"vendor_payment_request_id":"3275","payment_request_number":"PR3274","company_id":"2","payment_type":"Debit","payment_status":"Pending","tally_status":"Pending","request_remark":"OK","added_by":"143841429031701100","added_on":"2024-05-08 11:57:36","stock_company_master_name":"K.N. SURENDRA","vendor_payment_requested_user_name":"GIRISH SHETTY","requestedAmount":"1000000","approvedAmount":"0","paidAmount":"0"}]}