ARC Report

To search for ARC transactions, use the ARC Report option.


Step 1: Select the ARC Report item in the Reports menu.

 
Step 2: Choose the appropriate filters. The choices are as follows:

1. Status the results of a transaction: 
» All
» Successful
» Flagged For Review
» Transaction Failed
» Declined
» Internal Error
» Not Processed
» Wait For Response
» Rejected By Policy
» Rejected By User
» Dispute
2. Transaction Type the kind of operation performed: 
» Passenger Sale
» Passenger Refund
» Passenger Void
3. Transaction ID the identification number of a particular transaction.
Users may also search for multiple Transaction ID numbers at once. Separate different ID numbers by comma to pull up multiple transactions. 
4. Operation Source the source of the transaction:
» Undefined – Transaction source could not be traced. This normally should not happen.
» Batch API – From Batch Upload.
» Virtual Terminal – Transaction processed in the payment gateway itself.
» Service API – Transaction has been created as a result of external call to Services API.
» MIMS Service – Transaction has been created as a result of external call to MIMS emulator.  (Merchant Information Management System)
» Billing – Transaction is billed.
» Callback Service
» Payment – Transaction processed in the secure redirect payment page.
» Test – Transaction billed is being tested.
» Email Payment – Transaction has been created as a result of parsing email orders and will appear only for merchants using this functionality.
» Mobile – Transaction comes from mobile device.
» POS – Transaction comes from POS application.
» Data Vault Payment – Tokenized transactions and planed transactions processed by Data Vault clients.
» Checkout – Transaction has been created as a result of a checkout processing.
» ARC File – Transaction has been created as a result of parsing ARC File.
» Wallet API – Transactions processed by Wallet API.
» Gateway UI – Transactions processed in Gateway UI.
» Invoice - Transaction has been created as a result of paying invoice.
» Windows Service.
» Split Funding – Transactions processed using Split Funding.
» 3D Secure – Transactions processed using 3D Secure.
5. Processor the processor through wich the transaction was processed.
6. Account Number any consecutive digits from an account number, usually the first six or last four.
7. Card Type the issuer of the credit card used for the transaction.
8. Merchant Account the account through wich the transaction was processed.
9. Passenger Name
10. External ID
11. Approval Code
12. Agent Code
13. Ticket Number
14. Reference Number
15. Capture Date range of the transaction.  
16. Speed Dates feature is used to quickly choose a commonly used range. 
17. Report Type Determines how the data will be presented in the grid.  Detail produces a list.  Summary includes summaries and totals with drill down capabilities. 
» Detail
» Summary
18. Group By works only with Summary Reports to determine how the result set will be grouped for display:
» Day
» Month
» Year
» Payment Type
» Processor
» Merchant Account
» Transaction Source
» Batch ID
» Card Type
» User Department
» Operation Status
 
Step 3: After entering desired parameters click on Submit button.
 
Tip: Click on Clear button at any time to reset and clear all the search criteria. 
 
Additional features allowed by the Search pages are:
» Saved Reports – The Save icon will save this report for later viewing.  See Saved Reports for details.  
» Set Email Schedule - The Email Schedule icon opens the dialog where user is able to set the schedule for sending emails with report to specified email adresses. This report will appear in Saved Reports.
» Export to Excel – Use the Export to Excel button to transfer data to Microsoft Excel.
» Show Additional Fields – To expand the data view for the transaction, use Show Additional Fields. When doing so, a small popup window will display a list of fields that can be added to the existing grid columns. Additional fields are as follows: 
        » Address Verification Code
        » Agent Code
        » Airline Code 
        » Airport Code 1, 2, 3, 4, 5
        » Approval Code
        » Currency
        » Document Type
        » Glight Date 1, 2, 3, 4
        » Merchant Account
        » Reference Number
        » Stopover Code 1, 2, 3, 4, 5
        » Ticket Number

Export Report Option

Any result set can be exported to Excel by clicking the Export to Excel button.


There are three cases how export works:

1. export of the report less than 10 000.
2. export of the report that exceed 10 000 but less than 300 000.
3. export of the report that exceed 300 000.
 

I. Export of the report less than 10 000
If the list of transaction less than 10 000 rows then the file is exported immediately.


II. Export of the report that exceed 10 000 but less than 300 000
If the list of transactions exceeded 10 000 rows then a popup message will appear: "Your search has exceeded the 10 000 row limit. The system will email you when it is ready to download. Continue?"


If user selects "Yes", the report generation will be put in queue and the report will appear on the Download Reports page in Not Processed state. As soon as the report processing is finished, state will change and will reflect the result of the export operation: Processed or Export Failed. If "No" - the popup will close and the report will not be put in queue.


If the file state is Processed, to download the report the user should click on the Download.


III. Export of the report that exceed 300 000
If the list of transactions exceeded 300 000 rows then a popup message will appear: " Your search has exceeded the 300 000 row limit. The system can not generate such report. Please update filters to narrow the report."


In this case the report will not be unloaded.
Transactions that meet the criteria in the search fields will be displayed in a list/ grid format with following information:
 
 
1. Trans ID – the system generated identification number of a transaction.
2. Transaction Type - the operation used to create transaction (Sale, Refund, etc…). 
3. Status – the current status of the transaction(s). The Status may change in the event of a subsequent operation such as Capture or Refund.
4. Module – the type of module that was utilized for the processing of the transaction.
5. Passenger Name – customer name.
6. Account Number – the number of the account of the certain transaction.
7. Capture Date – the date the transaction took place. 
8. External ID
9. Amount – the amount of the transaction. 
10. Auth Code – the authentication code of the transaction. 
11. Card Issuer – the issuer of the credit card used for the transaction.
12. Operation ID –  the operation code of the transaction
 
Tip: Depending on the number of transactions displayed, a number of page options will appear below the grid. Use the Previous and Next buttons to move through the pages. Click the page numbers to navigate to a specific page.
 
 
 
 
 
 
 
Have more questions? Submit a request

Comments

Powered by Zendesk