Transaction

A transaction query provides summary information related to a specific transaction. Queries are driven by cardholder numbers and transaction dates.

To run a transaction query:

1. Click the Research Query navigation button.

   

   The Research Query page opens.

   

2. Select the Transaction option, and then select one of these transaction type options:
   • All Transactions
   • Chargebacks Only
   • Outgoing Credits
   • Downgrades Only

   The page refreshes to list the appropriate fields for the transaction type selected.

3. Enter your query criteria in the fields.

   Note: Fields marked with a red asterisk (*) are mandatory.

   • Transaction Start Date: Click the Calendar icon and select the appropriate date. This is a required field if the Post Start Date field is blank.
   • Transaction End Date: Click the Calendar icon and select the appropriate date. This field is not required; however, if you do not enter a date, the system will populate the same date as entered in the Transaction Start Date field.
   • Post Start Date: Click the Calendar icon and select the appropriate date. This is a required field if the Transaction Start Date field is blank.
   • Post End Date: Click the Calendar icon and select the appropriate date. This field is not required; however, if you do not enter a date, the system will populate the same date as entered in the Post Start Date field.
   • Bank Number: If you have more than one bank number, select the appropriate bank number from the drop down list. This field will not populate for Downgrades Only.
   • Cardholder Number: Type the 16-digit cardholder number in the text box. This is a required field when All Transactions or Outgoing Credits is selected.  This field will not populate for Downgrades Only.
   • Merchant Number: Type the 15-digit merchant ID number or click Search to perform a merchant lookup. This is a required field when Chargebacks Only or Downgrades Only is selected.

     Note: The merchant names and numbers displayed in the Merchant Lookup scroll box are dependent upon your user role and profile.

   • Acquirer Reference: Type the 23-digit reference number. This field is not available for All Transactions and Outgoing Credits.
   • Amount: From and To: Type the amount range for the transactions.
4. Click Generate Report.

   The Transaction Query page opens.

   The Transaction Query page lists information in these sections:

   • Transaction Search Summary: transaction type, cardholder number, bank number, merchant number, merchant DBA name, acquirer's reference number, transaction start date, transaction end date, post start date, post end date, amount from, and amount to.
   • Transaction Listing: transaction date, transaction amount, transaction id, submitted as, downgrade reason code, downgrade to, and card expiration date.
5. Click the Transaction ID to open the Transaction detail information page.

   The Transaction detail information page lists information in these sections:

   • Transaction: transaction date, transaction amount, transaction id, submitted as, downgrade reason code, downgrade to, cardholder number, and card expiration date.
   • Transaction Details: RPS, AU1, auth date, term entry, total auth, TID/BNR, id method, ref number, merchant DBA name, AC1, AU2, merchant DBA state, Qual, validation code, merchant DBA zip, auth amount, merchant DBA city, MCC, auth response, merchant DBA country, MOTO, incoming trans code.
   • Vital Downgrades: No, P&V code, RPS bump code, and reason.
   • Association Downgrades: downgrade code and reason.
6. Click Report Summary to open the Transaction report summary page.

   The Transaction report summary page lists information in these sections:

   • Merchant Information: merchant number, merchant DBA name, address 1 and address 2, merchant DBA city, merchant DBA state, merchant DBA zip, merchant DBA country, and downgrade reason code.
   • View Authorization, Capture, Clearing and Settlement: element and value.
   • View Qualification Guide Interchange: fields, P&V value, and guide value.
   • View P&V Details: additional clearing and settlement data for a transaction.

     Note: The proof and verification details appear only when you click View P&V Report.

7. Click View P and V Report to open the P and V report page.
8. On any query report page, export the data to Excel or PDF as required.

   On any report page, click Printer Friendly.

   Adobe Reader opens with a PDF version of the report in view.

   

   Use the Adobe Reader functionality to navigate, print, and save the PDF version of the report.

   You can export query report data into a spreadsheet format using Microsoft® Excel.

   To do this, on any query report page, click Excel.

   

9. On any query report page, change the criteria as required.
   1. On any query report page, click Search or Re-search.

      

      The query search page opens with fields populated with the last criteria entered.

   2. Enter your new criteria, and then click Generate Report.

      The query report page opens listing information based on the new criteria you entered.