Index: openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-oracle.xql,v
diff -u -r1.3 -r1.3.12.1
--- openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-oracle.xql	26 May 2002 04:36:49 -0000	1.3
+++ openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-oracle.xql	13 Sep 2005 05:55:29 -0000	1.3.12.1
@@ -187,7 +187,7 @@
 	  a.line1 as billing_address, 
 	  a.city as billing_city, 
           coalesce(a.usps_abbrev, a.full_state_name) as billing_state, 
-          a.country_code as billing_country
+          a.country_code as billing_country, f.refunded_transaction_id
       from ec_financial_transactions f, ec_creditcards c, persons p, ec_addresses a 
       where transaction_type='refund'
       and sysdate-to_be_captured_date > 1/48
Index: openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql,v
diff -u -r1.7 -r1.7.6.1
--- openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql	8 Mar 2004 19:46:11 -0000	1.7
+++ openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql	13 Sep 2005 05:55:29 -0000	1.7.6.1
@@ -186,7 +186,7 @@
 	  a.line1 as billing_address, 
 	  a.city as billing_city, 
           coalesce(a.usps_abbrev, a.full_state_name) as billing_state, 
-          a.country_code as billing_country
+          a.country_code as billing_country, f.refunded_transaction_id
       from ec_financial_transactions f, ec_creditcards c, persons p, ec_addresses a 
       where transaction_type = 'refund'
       and f.refunded_date is null
Index: openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl,v
diff -u -r1.13 -r1.13.2.1
--- openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl	13 Jan 2005 13:57:56 -0000	1.13
+++ openacs-4/packages/ecommerce/tcl/ecommerce-scheduled-procs.tcl	13 Sep 2005 05:55:29 -0000	1.13.2.1
@@ -1018,7 +1018,7 @@
 	    a.line1 as billing_address, 
 	    a.city as billing_city, 
             nsvl(a.usps_abbrev, a.full_state_name) as billing_state, 
-            a.country_code as billing_country
+            a.country_code as billing_country, f.refunded_transaction_id
         from ec_financial_transactions f, ec_creditcards c, persons p, ec_addresses a 
 	where transaction_type = 'refund'
 	and f.refunded_date is null
@@ -1038,7 +1038,7 @@
 	# Connect to the payment gateway to authorize the transaction.
 
 	array set response [acs_sc_call "PaymentGateway" "Return" \
-				[list $transaction_id \
+				[list $refunded_transaction_id \
 				     $transaction_amount \
 				     $card_type \
 				     $card_number \