{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `purchase_invoice_id`, `purchase_invoice_number`, `purchase_invoice_date`, `purchase_invoice_number_vendor`, `purchase_invoice_amount_vendor`, `purchase_invoice_tax_vendor`, `purchase_invoice_discount_vendor`, `purchase_invoice_purchase_order`, `purchase_invoice_status`, `purchase_invoice_remark`, `purchase_invoice_added_by`, `purchase_invoice_added_on`, `purchase_order_number`, `purchase_order_date`, `purchase_order_status`, `purchase_order_vendor`, `purchase_order_location`, `purchase_order_project`, `purchase_order_company`, `purchase_invoice_vendor_name`, `purchase_invoice_vendor_code`, `stock_vendor_address`, `stock_vendor_contact_person`, `stock_vendor_contact_number`, `purchase_order_project_name`, `stock_company_master_name`, `stock_company_master_address`, `stock_company_master_contact_person`, `stock_company_master_gst_no`, `stock_location_name`, `stock_location_address`\r\n FROM purchase_invoice_view\r\n Where `purchase_invoice_status` != 'Waiting'\r\n ORDER BY purchase_invoice_added_on DESC\r\n \r\n ","aaData":[]}