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.

PositionFieldDescription
1ISO4-Digit ID assigned by TabaPay
2MIDMerchant ID (Identifies a specific program/merchant under the ISO)
3Reference IDreferenceID sent by the merchant in the Create Transaction API request
4Transaction IDtransactionID sent by TabaPay in the Create Transaction API response

transactionID is a unique ID to represent a transaction request within the TabaPay environment

If Type = AVS, this is the avsID returned in the Query Card API response.
5Corresponding IDCorresponding 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
6Approval CodeNetwork Approval Code
7Processed DateDate/Time (GMT) Transaction processed at the Network
8Created DateDate/Time (GMT) Transaction Request was created
9TypeTransaction Type. Values include:
- Purchase
- Disbursement
- Purchase-Void
- Purchase-Reversal
- AVS
10SourceFor Purchases: Network
For Disbursements: Settlement
11DestinationFor Purchases: Settlement
For Disbursements: Network
12Settlement NetworkNetwork Transaction Settled
13Last 4Last 4 of beneficiary card (if the editor strips leading "0"s, left-pad “0s” to reach length 4)
14StatusStatus of Transaction. Values include:
- Complete
- Error
- Unknown-Failed
- Unknown-Complete
15Network RCNetwork Response Code
16Transaction AmountTransaction Amount. Passed in to Create Transaction API
17Settled AmountNet Amount Settled
- Purchases are (+)
- Disbursements are (-)
18TabaPay FeeTabaPay Fee for the Transaction
19Network FeeNetwork Fee for the Transaction
20InterchangeInterchange for the Transaction
21Convenience FeeConvenience Fee Merchant Charged
22First NameCardholder First Name
23Last NameCardholder Last Name
24Memomemo passed in the Create Transaction request.
25Location NameLocation Name passed in the Create Transaction request.
26Location Address 1Location Line 1 passed in the Create Transaction request.
27Location Address 2Location Line 2 passed in the Create Transaction request.
28Location CityLocation City passed in the Create Transaction request.
29Location StateLocation State Code passed in the Create Transaction request.
30Location ZipLocation Zip Code passed in the Create Transaction request.
31AVSAVS Match Code received at the time of transaction.
32CVV2CVV Match Code received at the time of transaction.
33Network IDTransaction Network ID
34Settlement DateDate Transaction Settled
35Card BrandFront of Card Brand
36Card TypeCard Type. Values include:
- Debit
- Credit
- Prepaid
37Interchange CategoryInterchange Category
38Network Fee CodesNetwork Fee Code
39BINFirst 6 of the Payment Card
40Beneficiary AmountBeneficiary amount in beneficiary currency, if disbursement sent in non-settlement currency
41Beneficiary CurrencyBeneficiary currency
42FX Rate AppliedFX Rate Applied, if disbursement sent in non-settlement currency.
43OFAC dateDate OFAC was run (beneficiary)
44OFAC codeOFAC results (beneficiary)
45IssuerNameIssuing Name of Financial Institution
46IssuerCountryISO 3166-1 Alpha-3 Code
47CorrOFAC dateDate OFAC was run (sender)
48CorrOFAC codeOFAC results (sender)
49Corresponding FNSender First Name
50Corresponding LNSender Last Name
51cardEntryIndicates how transaction was sent

Valid values:
1. 3DS: 3DS transactions
2. G: Google Pay,
3. A: Apple Pay, and
4. otherwise the input is what the merchant passed through the API

Can be null
52ARNCard network reference ID used for reconciliation and exceptions tracing

Valid values:
Asterisk followed by 23 characters

Can be null
53Account ID22-character accountID returned in the Create Account API response

Can be null