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	Data Type	Data Format
1	ISO	4-Digit ID assigned by TabaPay	Numeric	4 digits
2	MID	Merchant ID (Identifies a specific program/merchant under the ISO)	Numeric	4+ digits
3	Reference ID	`referenceID` sent by the merchant in the Create Transaction API request	Alphanumeric	1-15 characters
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.	Alphanumeric	22 characters
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	Alphanumeric	22 characters
6	Approval Code	Network Approval Code	Alphanumeric	6 digits
7	Processed Date	Date/Time (GMT) of the network response confirming that the transaction was processed	Date	MM/DD/YYYY HH:MM:SS AM/PM
8	Created Date	Date/Time (GMT) that TabaPay received the Transaction Request from the client	Date	MM/DD/YYYY HH:MM:SS AM/PM
9	Type	Transaction Type. Values include: Purchase-Reversal Purchase-Void Disbursement ACH-Credit Purchase ACH-Debit	Alphanumeric	Text
10	Source	For Purchases: Network For Disbursements: Settlement	Alphanumeric	Text
11	Destination	For Purchases: Settlement For Disbursements: Network	Alphanumeric	Text
12	Settlement Network	Network Transaction Settled	Alphanumeric	Text
13	Last 4	Last 4 of beneficiary card (if the editor strips leading "0"s, left-pad “0s” to reach length 4)	Alphanumeric	4 digits
14	Status	Status of Transaction. Values include: Complete Error Unknown-Failed Unknown-Complete Authorized	Alphanumeric	Text
15	Network RC	Network Response Code	Alphanumeric	2-3 characters
16	Transaction Amount	Transaction Amount. Passed in to Create Transaction API	Decimal	1+ digits
17	Settled Amount	Net Amount Settled Purchases are (+) Disbursements are (-)	Decimal	1+ digits
18	TabaPay Fee	TabaPay Fee for the Transaction	Decimal	1+ digits
19	Network Fee	Network Fee for the Transaction	Decimal	1+ digits
20	Interchange	Interchange for the Transaction	Decimal	1+ digits
21	Convenience Fee	Convenience Fee Merchant Charged	Decimal	1+ digits
22	First Name	Cardholder First Name	Alphanumeric	Text
23	Last Name	Cardholder Last Name	Alphanumeric	Text
24	Memo	`memo` passed in the Create Transaction request.	Alphanumeric	1-32 characters
25	Location Name	Location Name passed in the Create Transaction request.	Alphanumeric	Text
26	Location Address 1	Location Line 1 passed in the Create Transaction request.	Alphanumeric	Text
27	Location Address 2	Location Line 2 passed in the Create Transaction request.	Alphanumeric	Text
28	Location City	Location City passed in theCreate Transaction request.	Alphanumeric	Text
29	Location State	Location State Code passed in the Create Transaction request.	Alphanumeric	Text
30	Location Zip	Location Zip Code passed in the Create Transaction request.	Alphanumeric	Text
31	AVS	AVS Match Code received at the time of transaction.	Alphanumeric	1 character
32	CVV2	CVV Match Code received at the time of transaction.	Numberic	1 character
33	Network ID	Network Transaction ID	Alphanumeric	~15 characters
34	Settlement Date	Date Transaction Settled	Date	MM/DD/YYYY
35	Card Brand	Front of Card Brand	Alphanumeric	Text
36	Card Type	Card Type. Values include: Debit Credit Prepaid	Alphanumeric	Text
37	Interchange Category	Interchange Category	Alphanumeric	Text
38	Network Fee Codes	Network Fee Code	Alphanumeric	Text
39	BIN	First 6 of the Payment Card	Alphanumeric	6 digits
40	Beneficiary Amount	Beneficiary amount in beneficiary currency (Present if `type` is `Disbursement`)	Decimal	1+ digits
41	Beneficiary Currency	Beneficiary Currency Code (ISO 4217 Alpha 3, Present if `type` is `Disbursement`)	Alphanumeric	Text
42	FX Rate Applied	FX Rate Applied (Present if `type` is `Disbursement`)	Decimal	1+ digits
43	OFAC date	OFAC Screening Date of Cardholder	Date	MM/DD/YYYY HH MM
44	OFAC code	Cardholder's OFAC Results	Alphanumeric	Text
45	IssuerName	Issuing Name of Financial Institution	Alphanumeric	Text
46	IssuerCountry	ISO 3166-1 Alpha-3 Code	Alphanumeric	Text
47	CorrOFAC date	OFAC Screening Date of Corresponding Entity If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary	Date	MM/DD/YYYY HH MM
48	CorrOFAC code	OFAC Results of Corresponding Entity If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary	Alphanumeric	Text
49	Corresponding FN	Corresponding Entity First Name If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary	Alphanumeric	Text
50	Corresponding LN	Corresponding Entity Last Name If`type` is `Disbursement` - Sender If `type` is `Purchase` - Beneficiary	Alphanumeric	Text
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	Alphanumeric	Text
52	ARN	Acquirer Reference Number. Used for reconciliation and exceptions tracing Format: Asterisk (*) followed by 23 characters Can be null	Alphanumeric	9-24 characters
53	Account ID	22-character TabaPay `accountID` used in the transaction. Empty if no TabaPay `accountID` was used. Can be null	Alphanumeric	22 characters
54	PAR	29-character Payment Account Reference. See here for more information about PAR. Can be null	Alphanumeric	29 characters
55	MAC	2-character Merchant Advice Code (MAC). Relevant for MasterCard transactions only. See here for more information about MAC Can be null	Numeric	2 characters

Download Example Transaction Detail (Daily) Report

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