Recurring - Processed Plan CSV Format

Created by Richard Moore, Modified on Wed, 19 Apr, 2023 at 10:14 AM by Richard Moore

Details of processed plans can be downloaded as a CSV file. This document outlines the information included in this CSV file.


ColumnField NameDescription
ACustomer No

Internal account number identifier


BAccount NameName of the account under which the Plan was processed
CMerchant CodeInternal merchant account identifier
DMerchant NameName of the merchant-level record under which the Plan was processed
ETerminal TypeThe terminal type that was used to process the Plan (Active/Demo/Test)
FTerminal CodeTerminal number used to process the Plan
GTerminal NameName of the terminal used to process the Plan
HGatewayGateway ID of the terminal used to process the Plan
ITimeTime the transaction was processed
JTagUnique identifier for the processed transaction
KAuth NoAuthorization number returned for the transaction
LStatusStatus code of the transaction (1 - approved, 2 - declined, 3 - error)
MStatus NameStatus of the transaction (Approved/Declined/Error)
NTransaction CodeTransaction code used
OTransaction NameType of transaction (Purchase, Pre-authorization, Refund, etc.)
PCurrency

Currency of the transaction


QAmountDollar amount of the transaction
RNameCardholder name
SCard TypeCard type used for the transaction
TCard NoMasked credit card number
UExpiry DateExpiry date used for the transaction
VReference NoReference number supplied by the merchant for the transaction
WCustomer RefCustomer reference number supplied by the merchant for the transaction
XReference 3Additional reference number supplied by the merchant for the transaction
YBatch NoInternal value

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article