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

PSP ID	PSP Name	Group ID	Group Name	Merchant ID	Merchant Name	Store ID	Store Name	Store MCC	Merchant Nation	Merchant City	Merchant Txn Time	System Txn Time	Txn Pay Time	Txn Type	Payment Brand	Payment Method Variant	Merchant Txn ID	Merchant Order Reference	System Txn ID	PSP Txn ID	Original Merchant Txn ID	Original System Txn ID	Original PSP Txn ID	Card Number	Funding Type	Product ID	Product Type ID	Issuer Country	Merchant Txn Amt	Merchant Capture Amt	Merchant Txn Curr	User Billing Amt	User Billing Curr	ECI	Txn Initiation Mode	LinkPay Order ID	Txn Status	System Result Code	PSP Result Code	PSP Authorization Code
678536	PSP3	A482660	Group3	M517887	Merchant6	S722145	Store6	5912	HKG	RedactedCity-9C6867C77D8F	2028-07-28T00:01:35+08:00	2028-07-28T00:01:35+08:00	2028-07-28T08:02:16+08:00	Payment	Mastercard		wsx_9udww3f1ruexn1a27q685g9o2958	SVB4692NN83-490046QP-MX5H	knn-7595509283537879588299792255	ARO237XR22012				498596******2679	Credit	F	Consumer	BGR	4560	4560	JPY	4560	JPY	02	WEB	WIY6074EA81-151336WK-XY0P	Success	S0000	00	569278
678536	PSP3	A482660	Group3	M563769	Merchant7	S977122	Store7	5816	HKG	RedactedCity-062235E8EC8D	2028-07-28T00:01:35+08:00	2028-07-28T00:01:35+08:00		Payment Method	Mastercard	COF	FUGP1340286363721368066194230		drp-1839735299023828451407950994	HHT54O3M24236				023807******4491					0.00		AED	0.00	USD		WAP		Success	S0000	85	328035
evonet	PSP4	A482660	Group3	M58547679728548	Merchant10	S591544	Store10	5816	HKG	RedactedCity-062235E8EC8D	2028-07-28T00:03:26+08:00	2028-07-28T00:03:26+08:00		Payment	Visa	COF	2s2i7j71o72228zd54m913x5251n38qj	541080503883999087	gne-4564058437006224189790850916					513196******6029	Credit	MCS	Consumer	FRA	1490.00		TWD			07	WAP	942370319295211670	Failed	B0028	4001
678536	PSP3	A482660	Group3	M249015	Merchant8	S911250	Store8	5962	HKG	RedactedCity-DEEFD6D64099	2028-07-28T00:26:54+08:00	2028-07-28T00:26:55+08:00		ASI	Mastercard		2k0099oo4ur1m4hzbwx54i77		jkk-5024625105199924679989773187	LAU162HJ03680				627391******1947					0.00		HKD	0.00	USD		WEB		Failed	P0025	79
51147459793433628540038245526Oc77v2Imbt740299637	PSP2	A638521	Group1	M964241	Merchant3	S914168	Store3	7409	HKG	RedactedCity-9C6867C77D8F	2028-07-28T00:47:22+08:00	2028-07-28T00:47:22+08:00		Refund	DANA	DANA	1796980367108195301102304		vhz-3142743769189857373828996207	4158349574999669623608855424851	5471254193437473714019642	gef-0528493146391969972271808463	9159963337255972887221449077054						-599000.00		IDR				APP		Success	S0000	SUCCESS
evonet634e	PSP1	A482660	Group3	M826246	Merchant17	S130148	Store18	5945	HKG	RedactedCity-062235E8EC8D	2028-07-28T01:33:33+08:00	2028-07-28T01:33:33+08:00		Cancel	Toss_Pay		13801828736808482067633		781432992671892775499786432982		ncw_809i5at2cwyqi19sh2284253lg94	855531642899548051649202489954							-10000		KRW				WAP		Processing	S0007

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#