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.

📄
File name: YYYYMMDD_txndetail.csv

Note: Transaction Details Report differs from the Transactions (Daily) Report.

⚠️
Single vs Dual Message Cutoff Times May Impact Reporting
Single Message and Dual Message rails have varying cutoff times. If you use both, some daily reports generated at 9 AM PT may not reflect your expected total amounts. Remaining amounts will appear in the following day's report. For help, contact TabaPay Support, or email [email protected].

Key Fields

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 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.
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 May be null
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	Network Transaction 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 (Present if `type` is `Disbursement`)
41	Beneficiary Currency	Beneficiary Currency Code (ISO 4217 Alpha 3, Present if `type` is `Disbursement`)
42	FX Rate Applied	FX Rate Applied (Present if `type` is `Disbursement`)
43	OFAC date	OFAC Screening Date of Cardholder
44	OFAC code	Cardholder's OFAC Results
45	IssuerName	Issuing Name of Financial Institution
46	IssuerCountry	ISO 3166-1 Alpha-3 Code
47	CorrOFAC date	OFAC Screening Date of Corresponding Entity If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary
48	CorrOFAC code	OFAC Results of Corresponding Entity If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary
49	Corresponding FN	Corresponding Entity First Name If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary
50	Corresponding LN	Corresponding Entity Last Name If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary
51	cardEntry	Indicates how transaction was sent Valid values: 3DS: 3DS transactions G: Google Pay, A: Apple Pay, and P: Visa Plus Token: TabaPay Account ID otherwise the input is what the merchant passed through the API Can be null
52	ARN	Acquirer Reference Number. Used for reconciliation and exceptions tracing Format: Asterisk (*) followed by 23 characters Can be null
53	Account ID	22-character TabaPay `accountID` used in the transaction. Empty if no TabaPay `accountID` was used. Can be null
54	PAR	29-character Payment Account Reference. See here for more information about PAR. Can be null
55	MAC	2-character Merchant Advice Code (MAC). Relevant for MasterCard transactions only. See here for more information about MAC Can be null

File name: YYYYMMDD_txndetail.csv

Single vs Dual Message Cutoff Times May Impact Reporting

Key Fields

ISO

MID

Reference ID

Transaction ID

Corresponding ID

Approval Code

Processed Date

Created Date

Type

Source

Destination

Settlement Network

Last 4

Status

Network RC

Transaction Amount

Settled Amount

TabaPay Fee

Network Fee

Interchange

Convenience Fee

First Name

Last Name

Memo

Location Name

Location Address 1

Location Address 2

Location City

Location State

Location Zip

AVS

CVV2

Network ID

Settlement Date

Card Brand

Card Type

Interchange Category

Network Fee Codes

BIN

Beneficiary Amount

Beneficiary Currency

FX Rate Applied

OFAC date

OFAC code

IssuerName

IssuerCountry

CorrOFAC date

CorrOFAC code

Corresponding FN

Corresponding LN

cardEntry

ARN

Account ID

PAR

MAC