{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `crm_other_payment_id`, `crm_other_payment_booking_id`, `crm_other_payment_amount`, `crm_other_payment_type`, `crm_other_payment_payment_mode`, `crm_other_payment_instrument_date`, `crm_other_payment_bank`, `crm_other_payment_branch`, `crm_other_payment_receipt_date`, `crm_other_payment_remarks`, `crm_other_payment_added_by`, `crm_other_payment_added_on`, `crm_payment_track_id`, `crm_payment_track_status`, `crm_payment_track_remarks`, `crm_payment_track_added_by`, `crm_payment_track_added_on`, `crm_payment_received_bank`, `booked_project_name`, `booked_project_id`, `booked_site_no`, `enquiry_number`, `booked_customer_name`, `crm_customer_contact_no_one`, `payment_mode_name`, `crm_realized_amount`, `crm_realized_remarks`, `realized_date`, `payment_type`, `crm_booking_status`, `crm_site_status`, `payment_status_name`, `account_bank_id`, `account_branch`, `account_ifsc_code`, `account_nick_name`, `bank_name`\r\n FROM received_other_payment\r\n Where `payment_type` = '1' \r\n ORDER BY crm_other_payment_instrument_date desc\r\n \r\n ","aaData":[]}