I'm using Moneris for credit card payments. My treasurer needs a daily report on transactions. Moneris batches each day's transactions, separates them by credit card (Visa or Mastercard), applies it's fees and makes two deposits (one for Visa and one for Mastercard). Within the osmembership database tables there's a payment date, payment type and amount. I also need the credit card type (the first digit defines the type, 5 for Visa and 4 or 2 for Mastercard). Can this be added? Or better yet a separate user defined table for transactions. Then I can define my own fields. In the case of subscriptions there's a date, member name, visa charge, Mastercard charge, batch number (part of the returned transaction id), status (approved or declined). I can always define a table using phpmyadmin. I just need a point where a user defined function is called with an object containing the data I want to log.
On my Moneris account I noticed that the Customer ID is the Joomla User ID and you include all the subscriber information (name, address,...). We use the Customer ID as a brief description containing the member name and invoice number (if applicable). We also do events and nightly rentals which are processed manually.
