SELECT * FROM #Request.prefix_db_lookup#.cron_835 WHERE Agency_ID = '#session.agencyid#' AND status = 0 AND Remit_No = '#url.Remit_No#' AND CLP_ID = '#url.CLP_ID#' AND payment_pushed = 0 ORDER BY Remit_No ASC
Uploaded Payment Claims details
Patient Name Date Deposit Deposit_Type Date Check/ Status Remit_No Internal Control_number Pay Name Payer type Visit Date Revenue Code Net Total Paid Amount Adjustment
Amount		 Adjustment
Group code		 Adjustment
code		 Adjustment
Amount2		 Adjustment
Group code2		 Adjustment
code2		 Seq
Amount		 Seq
Code
#Patient_Name# #dateformat(Date_Deposit,"yyyy-mm-dd")# #Deposit_Type# #dateformat(Date_Check,"yyyy-mm-dd")# #Remit_No# #ICN# #Left(Pay_Name,30)#.. #Payer_Type# #Visit_Date# #Revenue_Code# #Net_Total# #Paid_Amount# #Adjustment_Amount# #Adjustment_Group_Code# #Adjustment_Code# #Adjustment_Amount_2# #Adjustment_Group_Code_2# #Adjustment_Code_2# #Seq_Amount# #Seq_code#