chron/referrals/referrals.class.php:101:					$q="Select `reservation_paymentID` from `reservation_payments` where `reservationID`=$this->aggressor_res and `final_payment_marker`=1";
chron/referrals/index.php:38:		$final_payment_fixer_query=("CREATE TABLE IF NOT EXISTS `fixer_table` AS (SELECT p.`reservation_paymentID` FROM `reservation_payments` p,`reservations` r, `charters` c WHERE r.`reservationID`=p.`reservationID` and r.`charterID`=c.`charterID` and `final_payment_marker`!=1 and c.`start_date`<=20190321 and c.`start_date`>=20150701 group by p.`reservationID`);# Affected rows: 7042
chron/referrals/index.php:40:Update `reservation_payments` p,`fixer_table` set `final_payment_marker`=1 where p.`reservation_paymentID` = `fixer_table`.`reservation_paymentID`;
chron/referrals/index.php:45:		//$q="Select a.* from `reservation_payments` a where not exists (Select * from `referrals` where a.`reservation_paymentID`=`final_payment_id`) and a.`final_payment_marker`=1 and a.`payment_date`>20120101";
chron/referrals/index.php:47:		$q="Select a.* from `reservation_payments` a,`reservations` r where not exists (Select * from `referrals` z where a.`reservation_paymentID`= z.`final_payment_id`) and r.`reservationID`=a.`reservationID` and a.`final_payment_marker`!='' and r.`reservation_date`>=$start_date";
chron/virtual/processor.php:180:	$sql_dupe="Select * from `reservation_payments` where `payment_amount`=".$_POST['x_amount']." and `comment`='$name Payment made via virtual merchant using $_POST[cc_type] $_POST[x_description]'";
chron/virtual/processor.php:200:	               $sql = "INSERT INTO `reservation_payments` (`reservationID`,`payment_amount`,`payment_date`,`payment_type`,`comment`) VALUES
chron/virtual/virtual.php:301:         $result = mysql_query("SELECT * FROM `reservation_payments` WHERE `reservationID` = '$_GET[reservation_id]' and `payment_type` NOT LIKE 'Reseller_3%' and `payment_type` NOT LIKE 'AF Check'", $linkID);
chron/virtual/virtual.php:556:	$sql_dupe="Select * from `reservation_payments` where `payment_amount`=".$_POST['x_amount']." and `comment`='$name Payment made via virtual merchant using $_POST[cc_type] $_POST[x_description]'";
chron/virtual/virtual.php:576:	               $sql = "INSERT INTO `reservation_payments` (`reservationID`,`payment_amount`,`payment_date`,`payment_type`,`comment`) VALUES
chron/virtual/functions_reservations.php:170:		$sum_reservation_payments_comm_subtract = 0;
chron/virtual/functions_reservations.php:171:		$total_cash_from_reservation_payments_only = 0;
chron/virtual/functions_reservations.php:172:		$reservation_payments_reduced_commission = 0;
chron/virtual/functions_reservations.php:175:		$query = "select SUM(`reservation_payments`.`payment_amount`) `total_cash_from_reservation_payments_only`,`reservations`.`cancel_reservationist`,
chron/virtual/functions_reservations.php:176:				  (IF((SUM(`reservation_payments`.`payment_amount` * (CASE `reservation_payments`.`payment_type` WHEN 'Credit Card' THEN -.03 WHEN 'Take Over Booking' THEN 0 ELSE 0 END)) + SUM(`charters`.`add_on_price` * .03)<=0),(SUM(`reservation_payments`.`payment_amount` * (CASE `reservation_payments`.`payment_type` WHEN 'Credit Card' THEN -.03 WHEN 'Take Over Booking' THEN 0 ELSE 0 END)) + SUM(`charters`.`add_on_price` * .03)),(SUM(`reservation_payments`.`payment_amount` * (CASE `reservation_payments`.`payment_type` WHEN 'Credit Card' THEN -.03 WHEN 'Take Over Booking' THEN 0 ELSE 0 END))))) `reservation_payments_reduced_commission`,
chron/virtual/functions_reservations.php:177:				  (SUM(`reservation_payments`.`payment_amount` * (CASE `reservation_payments`.`payment_type` WHEN 'Credit Card' THEN -.03 WHEN 'Take Over Booking' THEN 0 ELSE 0 END))) `sum_reservation_payments_comm_subtract`
chron/virtual/functions_reservations.php:178:				  from `reservation_payments`,`reservations`,`charters` 
chron/virtual/functions_reservations.php:179:				  where `reservation_payments`.`reservationID` = `reservations`.`reservationID` 
chron/virtual/functions_reservations.php:204:				  ((SUM((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`)) - (`reservations`.`nonrefundable_deposit` + `reservations`.`nine_month_payment` + (IF(((((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33) / 2) - `reservations`.`nonrefundable_deposit` - `reservations`.`nine_month_payment`) <= (((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.3333) / 2),0,((((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33) / 2) - `reservations`.`nonrefundable_deposit` - `reservations`.`nine_month_payment`))) + (GREATEST(0,(((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * .33) - `reservations`.`nonrefundable_deposit` - `reservations`.`nine_month_payment` - (IF(((((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33) / 2) - `reservations`.`nonrefundable_deposit` - `reservations`.`nine_month_payment`) <= (((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.3333) / 2),0,((((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33) / 2) - `reservations`.`nonrefundable_deposit` - `reservations`.`nine_month_payment`))))))) - (IF(((SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (IF(".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03) <= 0,".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03),".$sum_reservation_payments_comm_subtract."))) <= 0 , 0 , (SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (IF(".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03) <= 0,".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03),".$sum_reservation_payments_comm_subtract.")) - `reservations`.`manual_commission_adjustment`)) - (SUM(`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) `two_month_payment`,
chron/virtual/functions_reservations.php:211:				  ((SUM((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`)) - ".$total_cash_from_reservation_payments_only." - (SUM(`inventory`.`DWC_discount` + `inventory`.`voucher` + ((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100)))) `reserv_balance_post_payments_pre_comm`, 
chron/virtual/functions_reservations.php:213:				  ((SUM((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`)) - ".$total_cash_from_reservation_payments_only." - (SUM(`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100)))) - (If(((SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (SUM(0 - ((`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))) * (`inventory`.`commission_at_time_of_booking` / 100)))) + ".$reservation_payments_reduced_commission.") <= 0 , 0 ,(SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (SUM(0 - ((`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))) * (`inventory`.`commission_at_time_of_booking` / 100)))) + ".$reservation_payments_reduced_commission." - `reservations`.`manual_commission_adjustment`))) `final_balance_on_reservation`,
chron/virtual/functions_reservations.php:214:				  (IF(".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03) <= 0,".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03),".$sum_reservation_payments_comm_subtract.")) `reservation_payments_reduced_commission`,
chron/virtual/functions_reservations.php:215:				  (If(((SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (SUM(0 - ((`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))) * (`inventory`.`commission_at_time_of_booking` / 100)))) + ".$reservation_payments_reduced_commission.") <= 0 , 0 ,(SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (SUM(0 - ((`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))) * (`inventory`.`commission_at_time_of_booking` / 100)))) + ".$reservation_payments_reduced_commission." - `reservations`.`manual_commission_adjustment`)) `final_commission_balance`,
chron/virtual/functions_reservations.php:217:				  If(((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33) - ".$total_cash_from_reservation_payments_only." >0, ((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33)- ".$total_cash_from_reservation_payments_only.",0) `single_deposit`,
chron/virtual/functions_reservations.php:218:				  ((SUM(`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable` - `inventory`.`manual_discount`))-$total_cash_from_reservation_payments_only-(SUM(`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100)))) -  (If(((SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (SUM(0 - ((`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))) * (`inventory`.`commission_at_time_of_booking` / 100)))) + ".$reservation_payments_reduced_commission.") <= 0 , 0 ,(SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (SUM(0 - ((`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))) * (`inventory`.`commission_at_time_of_booking` / 100)))) + ".$reservation_payments_reduced_commission." - `reservations`.`manual_commission_adjustment`))) `reservation_balance_for_invoice`,
chron/virtual/functions_reservations.php:219:				  '".$total_cash_from_reservation_payments_only."' `total_cash_from_reservation_payments_only`,
chron/virtual/functions_reservations.php:243:		// Old formula for reservation_for_balance_invoice :  (((SUM((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`)) - ".$total_cash_from_reservation_payments_only." - (SUM(`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100)))) - (IF(((SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (IF(".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03) <= 0,".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03),".$sum_reservation_payments_comm_subtract."))) <= 0 , 0 , (SUM((`inventory`.`commission_at_time_of_booking` / 100) * ((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - (`inventory`.`manual_discount` + `charters`.`add_on_price`)))) + (IF(".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03) <= 0,".$sum_reservation_payments_comm_subtract." + SUM(`charters`.`add_on_price` * .03),".$sum_reservation_payments_comm_subtract.")) - `reservations`.`manual_commission_adjustment`))) - (IF(((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33) - ".$total_cash_from_reservation_payments_only." >0, ((SUM(((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - (`inventory`.`DWC_discount` + `inventory`.`voucher` + (((((`inventory`.`bunk_price` + `charters`.`add_on_price` + `charters`.`add_on_price_commissionable`) - `inventory`.`manual_discount`) - `inventory`.`DWC_discount` - `inventory`.`voucher`) - `charters`.`add_on_price`) * (`inventory`.`passenger_discount` / 100))))) * 0.33)- ".$total_cash_from_reservation_payments_only.",0))) `reservation_balance_for_invoice`,
chron/virtual/functions_reservations.php:331:		$query = "delete from `reservation_payments` where `reservationID` = '".$reservationID."'";
chron/virtual/functions_reservations.php:982:		$query = "update `reservation_payments` set `final_payment_marker`='' where `reservationID`='".$reservationID."'";
chron/virtual/functions_reservations.php:986:		$query = "insert into `reservation_payments` (`reservationID`,`payment_type`,`payment_date`,`payment_amount`,`comment`,`final_payment_marker`)
chron/virtual/functions_reservations.php:1019:		$query = "update `reservation_payments` set `final_payment_marker`='' where `reservationID`='".$reservationID."'";
chron/virtual/functions_reservations.php:1028:		$query = "update `reservation_payments` set `payment_type`='".$payment_type."',`payment_date`='".$payment_date_year.$payment_date_month.$payment_date_date."',`payment_amount`=".$payment_amount.",`comment`='".$comment."',`final_payment_marker`='".$final_payment_marker."' where `reservation_paymentID`='".$reservation_paymentID."'";
chron/virtual/functions_reservations.php:1041:		$query = "delete from `reservation_payments` where `reservation_paymentID` = '".$reservation_paymentID."'";
chron/virtual/functions_reservations.php:1044:		$sql = "SELECT * FROM `reservation_payments` WHERE `reservation_paymentID` = '$reservation_paymentID'";
chron/virtual/functions_reservations.php:1071:				  from `reservation_payments` 
chron/virtual/functions_reservations.php:1089:		$query = "select * from `reservation_payments` where `reservation_paymentID`='".$reservation_paymentID."' limit 0,1";
chron/virtual/functions_reservations.php:1259:				  `reservations`.`reservationID`,`reservation_payments`.`payment_date`,`reservation_payments`.`payment_amount` 
chron/virtual/functions_reservations.php:1260:				  from `boats`,`charters`,`resellers`,`reseller_agents`,`reservations`,`reservation_payments` 
chron/virtual/functions_reservations.php:1265:				  and `reservations`.`reservationID` = `reservation_payments`.`reservationID` 
chron/virtual/functions_reservations.php:1267:				  ".(strlen($customer_reconciliation_report_payment_date) == 8 ? "and `reservation_payments`.`payment_date` < ".$customer_reconciliation_report_payment_date:"")." 
chron/virtual/functions_reservations.php:1268:				  ".(strlen($payment_type) > 0 ? "and `reservation_payments`.`payment_type` = '".$payment_type."'":"")." 
chron/virtual/functions_reservations.php:1269:				  ".(strlen($payment_amount) > 0 ? "and `reservation_payments`.`payment_amount` = ".$payment_amount:"")." 
chron/virtual/functions_reservations.php:1270:				  and not (`reservation_payments`.`payment_amount` = 0) 
chron/virtual/functions_reservations.php:1271:				  order by `boats`.`name`,`charters`.`start_date`,`resellers`.`company`,`reservation_payments`.`payment_date`";
chron/virtual/functions_reservations.php:1300:						$cc_query="Select sum(`payment_amount`)*.03 from `reservation_payments` where `payment_type`='Credit Card' and `reservationID`= $reservationID";
chron/virtual/functions_reservations.php:1724:				    FROM `reservation_payments` 
chron/virtual/functions_reservations.php:1801:				    FROM `reservation_payments`