{"iTotalDisplayRecords":"0","query":"\r\nSELECT SQL_CALC_FOUND_ROWS `crm_payment_id`, `crm_payment_booking_id`, `crm_payment_receipt_no`, `crm_payment_amount`, `crm_payment_milestone`, `crm_payment_tds_amount`, `crm_payment_payment_mode`, `crm_payment_instrument_date`, `crm_payment_bank`, `crm_payment_branch`, `crm_payment_receipt_date`, `crm_payment_remarks`, `crm_payment_added_by`, `crm_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\nFROM received_payment\r\n Where `payment_type` = '0' \r\nORDER BY crm_payment_instrument_date desc\r\n\r\n","aaData":[]}