This table describes the request parameters for Report API.
| Variable Name | Description | Required | Expected Value |
|---|---|---|---|
| username | TCB Pay Gateway Username | Y | TCB Pay Gateway Username |
| api_key | TCB Pay Gateway API Key | Y | TCB Pay Gateway API Key |
| start_date | From transaction date | Y | date format YYYY-MM-DD |
| end_date | To transaction date | Y | date format YYYY-MM-DD |
| transaction_type | Type of transaction | N | (default all transaction) SALE,AUTHORIZE,CAPTURE,REFUND,VOID,CREDIT |
| transaction_status | Status of transaction | N | (default all transaction) SUCCESS,FAIL |
| transaction_id | TCBPay ID of the transaction, If we need to know the details of a specific transaction | N | 100000000000001605 |
| page_no | Page number of the entire result set. Each page has a maximum of 100 records listed | N | (default 1) can be up to total page number |
| reference_id | Transaction reference id | N | Reference ID should be unique |
Example
Copied
<html lang="en"> <head> <meta charset="UTF-8"> <title>TCB Pay ACH API Report Test</title> </head> <body> <form name="" action="https://gateway2.tcbpay.com/apis/ach_report.php" method="post"> <input type="text" name="username" value="tcbpayusername"/> <input type="text" name="api_key" value="tcbpayapikey"/> <input type="text" name="start_date" value="2019-04-01"/> <input type="text" name="end_date" value="2019-04-15"/> <br/> <input type="submit" value="submit"/> </form> </body> </html>
Error Codes
| Error Code | Description |
|---|---|
| 01 | Merchant Information is Missing |
| 02 | Transaction Currency is missing |
| 03 | Account Number is missing or Invalid |
| 04 | Routing Number is missing or invalid |
| 05 | Check Number is missing or invalid |
| 06 | Invalid Amount |
| 07 | Account Type is Missing |
| 08 | Proper Zip code is missing |
| 09 | Proper Customer Email Id is missing |
| 10 | Invalid Processor |
| 11 | Requested Currency is not allowed for this merchant |
| 12 | Invalid Merchant Information |
| 13 | Invalid Country Code |
| 14 | Sale Volume exceeded for this Merchant |
| 15 | Monthly Volume exceeded for this Merchant |
| 16 | Transaction limit exceeded for this Merchant |
| 17 | IP-wise transaction limit exceeded for this Merchant |
| 18 | Bank Name is missing |
| 19 | Transaction Start Date is missing or invalid |
| 20 | Transaction End Date is missing or invalid |
| P1 | Invalid page number |
| A1 | Transaction entry failed |
