Step 1:    Select ReceivedAmt,EntryDate,EntryBy,Panel_id,PaymentMode ,`Type`,`Bank`,
            ReceiptNo,TDS,WriteOff,Remarks , EntryByName, receivedDate, CreditNote,PayUTransactionNo,IsOnline,
            OnlinePaymentRemark from invoicemaster_onaccount 
 
 Step 2:    select Amount,dtEntry,Panel_id,Panel_Code,PaymentMode,Status,Updatedate 
            ,PaymentNote,paymentId,tracking_id,bank_ref_no,merchantTransactionId from payumoney_integration
	   
-- please add column in exist table add only required column  from abave query
	  
CREATE TABLE `payumoney_integration` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `paymentId` varchar(30) DEFAULT NULL,
  `tracking_id` varchar(500) DEFAULT NULL,
  `bank_ref_no` varchar(500) DEFAULT NULL,
  `merchantTransactionId` varchar(30) DEFAULT '',
  `Amount` decimal(20,2) DEFAULT NULL,
  `Status` varchar(20) DEFAULT '',
  `paymentMode` varchar(20) DEFAULT '',
  `customerEmail` varchar(50) DEFAULT '',
  `customerPhone` varchar(20) DEFAULT '',
  `customerName` varchar(30) DEFAULT '',
  `PaymentNote` varchar(350) DEFAULT '',
  `Panel_Id` varchar(30) DEFAULT '',
  `Panel_Code` varchar(30) DEFAULT '',
  `udf4` varchar(30) DEFAULT '',
  `udf5` varchar(30) DEFAULT '',
  `productInfo` varchar(200) DEFAULT '',
  `additionalCharges` decimal(5,2) DEFAULT NULL,
  `split_info` varchar(200) DEFAULT '',
  `error_message` varchar(300) DEFAULT '',
  `notificationId` varchar(30) DEFAULT '',
  `hash` varchar(300) DEFAULT '',
  `dtEntry` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Updatedate` datetime DEFAULT NULL,
  `LabNumber` varchar(21) DEFAULT '',
  `invoicemaster_onaccount_ID` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `tracking_id` (`tracking_id`(255))
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

CREATE TABLE `invoicemaster_onaccount` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `InvoiceNo` varchar(50) DEFAULT NULL,
  `InvoiceAmount` float(10,2) DEFAULT NULL,
  `ReceivedAmt` float(10,2) DEFAULT NULL,
  `TDS` float(10,2) DEFAULT NULL,
  `WriteOff` float(10,2) DEFAULT NULL,
  `PaymentMode` varchar(50) DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `Bank` varchar(200) DEFAULT NULL,
  `CreditCardNo` varchar(50) DEFAULT NULL,
  `DraftNo` varchar(50) DEFAULT NULL,
  `DraftDate` date DEFAULT NULL,
  `ChequeNo` varchar(50) DEFAULT NULL,
  `ChequeDate` date DEFAULT NULL,
  `EntryDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `EntryBy` varchar(50) DEFAULT NULL,
  `IsCancel` int(2) DEFAULT '0',
  `CancelUserID` varchar(50) DEFAULT NULL,
  `CancelUserName` varchar(200) DEFAULT NULL,
  `CancelDateTime` datetime DEFAULT NULL,
  `CancelReason` varchar(500) DEFAULT NULL,
  `ReceivedDate` date NOT NULL,
  `Remarks` varchar(500) DEFAULT NULL,
  `Panel_id` int(11) DEFAULT NULL,
  `AdvanceAmtDate` datetime DEFAULT NULL,
  `EntryByName` varchar(100) DEFAULT '',
  `ReceiptNo` varchar(50) DEFAULT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `UpdateUserID` varchar(200) DEFAULT NULL,
  `CreditNote` tinyint(2) DEFAULT '0',
  `PayUTransactionID` varchar(20) DEFAULT '',
  `Invoicemaster_Payment_ID` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ReceivedDate` (`ReceivedDate`),
  KEY `Panel_id` (`Panel_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8


CREATE TABLE `panel_paymentprev_details` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) DEFAULT NULL,
  `Panel_id` varchar(10) DEFAULT NULL,
  `Panel_Code` varchar(20) DEFAULT NULL,
  `EntryDate` datetime DEFAULT NULL,
  `LabNumber` varchar(20) DEFAULT NULL,
  `Remark` varchar(150) DEFAULT NULL,
  `Amount` decimal(10,2) DEFAULT NULL,
  `Emailid` varchar(100) DEFAULT NULL,
  `MobileNo` varchar(11) DEFAULT NULL,
  `OrderId` varchar(20) DEFAULT NULL,
  `OrderStatus` varchar(20) DEFAULT 'Pending',
  `IsSuccess` tinyint(2) DEFAULT '0',
  `payUTransactionID` varchar(25) DEFAULT '',
  `payUTracking_id` varchar(25) DEFAULT '',
  `Status` varchar(150) DEFAULT '',
  `payUAmount` float(10,2) DEFAULT '0.00',
  `payUTransactionDate` datetime DEFAULT NULL,
  `payUPaymentMode` varchar(50) DEFAULT '',
  `payUCardName` varchar(50) DEFAULT '',
  `payUstatus_message` varchar(100) DEFAULT '',
  `isScheduleEntry` tinyint(2) DEFAULT '0',
  `ScheduleEntryDate` datetime DEFAULT NULL,
  `ResponseDate` datetime DEFAULT NULL,
  `CreatedByID` varchar(20) DEFAULT '',
  `CreatedBy` varchar(100) DEFAULT '',
  `EntryType` varchar(50) DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `OrderId` (`OrderId`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
	
	
  
	   
DELIMITER $$
USE `dbname`$$
CREATE PROCEDURE `sp_get_AllPendingOrder_json`()
BEGIN
   SELECT IFNULL(OrderId,'0')OrderId FROM panel_paymentprev_details WHERE IsSuccess=0 AND IFNULL(OrderId,'')<>'' and EntryDate<= DATE_ADD(NOW(), INTERVAL -5 MINUTE) ORDER BY ID  ;       
    END$$
DELIMITER ;