Transactions (Daily)
The daily transaction report is available by 9am PT.
This report contains settlement details about activity sent through the Transactions API, including reversals. Transactions originated before network cutoff times are included in this report. If you would like add AVS-only records to this report please reach out to [email protected] to request configuration.
Report Names
If you are configured to receive reports at the ISO level, the file name format will be: ISO_YYYYMMDD_reportname (e.g. 1234_20251017_reportname.csv)
If you are configured to receive reports at the MID level, the file format name will be: ISO_MID_YYYYMMDD_reportname (e.g. e.g. 1234_321_20251017_reportname.csv)
| Position | Field | Description |
|---|---|---|
| 1 | ISO | 4-Digit ID assigned by TabaPay |
| 2 | MID | Merchant ID (Identifies a specific program/merchant under the ISO) |
| 3 | Reference ID | referenceID sent by the merchant in the Create Transaction API request |
| 4 | Transaction ID | transactionID sent by TabaPay in the Create Transaction API responsetransactionID is a unique ID to represent a transaction request within the TabaPay environmentIf Type = AVS, this is the avsID returned in the Query Card API response. |
| 5 | Corresponding ID | Corresponding TransactionID - For a Push Transaction, this would be the associated Pull Transaction ID - For a Pull Transaction, this would be the associated Push Transaction ID |
| 6 | Approval Code | Network Approval Code |
| 7 | Processed Date | Date/Time (GMT) of the network response confirming that the transaction was processed |
| 8 | Created Date | Date/Time (GMT) that TabaPay received the Transaction Request from the client |
| 9 | Type | Transaction Type. Values include: - Purchase-Reversal - Purchase-Void - Disbursement - ACH-Credit - Purchase - ACH-Debit |
| 10 | Source | For Purchases: Network For Disbursements: Settlement |
| 11 | Destination | For Purchases: Settlement For Disbursements: Network |
| 12 | Settlement Network | Network Transaction Settled |
| 13 | Last 4 | Last 4 of beneficiary card (if the editor strips leading "0"s, left-pad “0s” to reach length 4) |
| 14 | Status | Status of Transaction. Values include: - Complete - Error - Unknown-Failed - Unknown-Complete - Authorized |
| 15 | Network RC | Network Response Code |
| 16 | Transaction Amount | Transaction Amount. Passed in to Create Transaction API |
| 17 | Settled Amount | Net Amount Settled - Purchases are (+) - Disbursements are (-) |
| 18 | TabaPay Fee | TabaPay Fee for the Transaction |
| 19 | Network Fee | Network Fee for the Transaction |
| 20 | Interchange | Interchange for the Transaction |
| 21 | Convenience Fee | Convenience Fee Merchant Charged |
| 22 | First Name | Cardholder First Name |
| 23 | Last Name | Cardholder Last Name |
| 24 | Memo | memo passed in the Create Transaction request. |
| 25 | Location Name | Location Name passed in the Create Transaction request. |
| 26 | Location Address 1 | Location Line 1 passed in the Create Transaction request. |
| 27 | Location Address 2 | Location Line 2 passed in the Create Transaction request. |
| 28 | Location City | Location City passed in theCreate Transaction request. |
| 29 | Location State | Location State Code passed in the Create Transaction request. |
| 30 | Location Zip | Location Zip Code passed in the Create Transaction request. |
| 31 | AVS | AVS Match Code received at the time of transaction. |
| 32 | CVV2 | CVV Match Code received at the time of transaction. |
| 33 | Network ID | Transaction Network ID |
| 34 | Settlement Date | Date Transaction Settled |
| 35 | Card Brand | Front of Card Brand |
| 36 | Card Type | Card Type. Values include: - Debit - Credit - Prepaid |
| 37 | Interchange Category | Interchange Category |
| 38 | Network Fee Codes | Network Fee Code |
| 39 | BIN | First 6 of the Payment Card |
| 40 | Beneficiary Amount | Beneficiary amount in beneficiary currency, if disbursement sent in non-settlement currency |
| 41 | Beneficiary Currency | Beneficiary currency |
| 42 | FX Rate Applied | FX Rate Applied, if disbursement sent in non-settlement currency. |
| 43 | OFAC date | Date OFAC was run (beneficiary) |
| 44 | OFAC code | OFAC results (beneficiary) |
| 45 | IssuerName | Issuing Name of Financial Institution |
| 46 | IssuerCountry | ISO 3166-1 Alpha-3 Code |
| 47 | CorrOFAC date | Date OFAC was run (sender) |
| 48 | CorrOFAC code | OFAC results (sender) |
| 49 | Corresponding FN | Sender First Name |
| 50 | Corresponding LN | Sender Last Name |
| 51 | cardEntry | Indicates how transaction was sent Valid values: 1. 3DS: 3DS transactions 2. G: Google Pay, 3. A: Apple Pay, and 4. P: Visa Plus 5. Token: TabaPay Account ID 6. otherwise the input is what the merchant passed through the API Can be null |
| 52 | ARN | Card network reference ID used for reconciliation and exceptions tracing Valid values: Asterisk followed by 23 characters Can be null |
| 53 | Account ID | 22-character accountID returned in the Create Account API response Can be null |
Updated 2 months ago