Overview

Evo Payment clearing and settlement system produces an online transaction detail file containing all online transaction records within the previous natural day's daily cut-off cycle according to the customer's specified daily cut-off time point, for the customer to perform automated transaction matching and reconciliation processing.

Note :

The file includes online transactions under all transaction statuses (including failed-status transactions);

If the customer had no online transactions on the previous day, an empty file is produced, retaining only the field names and the end marker ***END***;

After the large file splitting function is enabled, a BatchNum (001–999) suffix is added to the filename.

File location and naming rules

File hierarchy and file codes

Evo Payment can produce detail data at different dimensions based on the different hierarchies configured for the customer in the system. File codes and report names are distinguished by hierarchy as follows:

File hierarchy	File code	Report name template
Acquirer level	A-File-01	`Acquirer_Activity_Detail_(Version No)_(Inscode)_YYYYMMDD`
Group level	G-File-01	`Group_Activity_Detail_(Version No)_(Groupcode)_YYYYMMDD`
Merchant level	M-File-01	`Merchant_Activity_Detail_(Version No)_(Merchantcode)_YYYYMMDD`
Store level	S-File-01	`Store_Activity_Detail_(Version No)_(Storecode)_YYYYMMDD`

Filename field descriptions

Each field is connected using an underscore (_), and the field meanings are as follows:

Field	Description
Fixed value	`Acquirer` / `Group` / `Merchant` / `Store` + `_Activity_Detail`, corresponding to that hierarchy
Version number	The first character is the file identifier: `P` production environment, `T` test environment; the last three characters are a numeric number, starting from `001` up to a maximum of `999` (new versions are compatible with old versions)
Inscode/Groupcode/Merchantcode/Storecode	The customer's Acquirer, Group, Merchant, or Store identifier
Date	`YYYYMMDD`, report generation date
Batch number (optional)	Added when the Acquirer file is configured with the `Batch Generate Threshold` function; value range `001`–`999`

Filename examples

Production environment (Acquirer level)

Acquirer_Activity_Detail_P003_88888888_20230108.csv

Test environment (Acquirer level)

Acquirer_Activity_Detail_T003_88888888_20230108.csv

With batch number (Acquirer level)

Acquirer_Activity_Detail_P003_88888888_20230108_001.csv

Item	Description
SFTP mode	Evo Payment is the SFTP Server
Default directory	`/in/{YYYYMMDD}`
Login method	public/private key
Transfer completion marker	Same-name `.ok` suffix TXT empty file (for example, `Acquirer_Activity_Detail_P003_88888888_20230108.csv.ok`)

Important : Before retrieving and parsing a reconciliation file, the client should first check whether the same-name .ok file exists to confirm that Evo Payment has completed the file transfer.

Report structure

Basic file attributes

Attribute	Value
File format	CSV
File encoding	UTF-8 with BOM
Newline character	`\n` (`0x0A`)
Field delimiter	Double quotation mark + English comma `","`
File content end marker	`*END*` (last line)

File generation time

Generation cycle: natural-day files, produced every Monday through Sunday

Generation time: daily from 10:00–12:00 AM (Evo Payment node system time)

File data elements

This section defines the field elements of the File-01 Activity_Detail file.

Sequence	Field name	Description
1	PSP ID	Payment PSP ID Appears only in Acquirer-level files
2	PSP Name	Payment PSP name Appears only in Acquirer-level files
3	Group ID	Group number Appears only in Acquirer- and Group-level files
4	Group Name	Group name Appears only in Acquirer- and Group-level files
5	Merchant ID	Merchant number Appears only in Acquirer-, Group-, and Merchant-level files
6	Merchant Name	Merchant name Appears only in Acquirer-, Group-, and Merchant-level files
7	Store ID	Store number
8	Store Name	Store name
9	Store MCC	Store MCC
10	Terminal ID	Terminal number
11	Merchant Nation	Merchant country
12	Merchant City	Merchant city
13	Merchant Txn Time	Merchant transaction time
14	System Txn Time	Evo Payment system transaction time
15	Txn Pay Time	PSP transaction time
16	API Type	API category
17	Txn Type	Transaction type
18	Payment Brand	Payment brand
19	Payment Method Variant	Payment method
20	Merchant Txn ID	Merchant transaction ID
21	Merchant Order Reference	Merchant order reference information
22	System Txn ID	Evo Payment transaction ID
23	PSP Txn ID	PSP transaction ID
24	Original Merchant Txn ID	Original transaction Merchant transaction ID
25	Original System Txn ID	Original Evo Payment transaction ID
26	Original PSP Txn ID	Original transaction PSP transaction ID
27	Card Number	Card number (first 6 digits + `******` + last 4 digits)
28	Funding Type	Card debit/credit identifier
29	Product ID	Card product identifier
30	Product Type ID	Card category identifier
31	Issuer Country	Issuer country
32	Merchant Local Amt	Merchant local amount
33	Local Tips Amt	Local tip amount
34	Local Surcharge Fee Amt	Additional service fee local amount
35	Local Capture Amt	Merchant capture local amount
36	Merchant Local Curr	Merchant local currency
37	Rate of Local to Txn	MCP/DCC exchange rate
38	Merchant Txn Amt	Merchant transaction amount
39	Tips Amount	Tip transaction amount
40	Surcharge Fee Amt	Additional service fee amount
41	Merchant Capture Amt	Merchant capture amount
42	Merchant Txn Curr	Merchant transaction currency
43	User Billing Amt	User billing amount
44	User Billing Curr	User billing currency
45	ECI	Authentication identifier
46	Txn Initiation Mode	Transaction initiation method
47	LinkPay Order ID	LinkPay order number
48	Txn Status	Evo Payment system transaction status
49	System Result Code	Evo Payment response code
50	PSP Result Code	PSP response code
51	PSP Authorization Code	PSP authorization code
52	Metadata	Remarks information

Samples

The viewer below shows the content of the sample file. Click Download to get the file.

File-01 Activity_Detail Online Transaction Detail File

Overview#

File location and naming rules#

File hierarchy and file codes#

Filename field descriptions#

Filename examples#

SFTP path and login#

Report structure#

Basic file attributes#

File generation time#

File data elements#

Samples#