Overview

The Evo Payment clearing and settlement system generates a detailed file of all settlement manual transaction records from the previous natural-day cut-off cycle according to the cut-off time specified by the customer, for the customer to perform automated transaction matching and reconciliation processing.

Note :

The file contains online transactions in all transaction statuses (including failed transactions);

If the customer did not generate any online transactions on the previous day, an empty file is generated, 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 file name.

File Location and Naming Rules

File Levels and File Codes

Evo Payment can generate details in different dimensions based on the different levels configured for the customer in the system. The file codes and report names are distinguished by level as follows:

File Level	File Code	Report Name Template
Acquirer level	A-File-03	`Acquirer_Miscellaneous_Detail_(Version No)_(Inscode)_YYYYMMDD`
Group level	G-File-03	`Group_Miscellaneous_Detail_(Version No)_(Groupcode)_YYYYMMDD`
Merchant level	M-File-03	`Merchant_Miscellaneous_Detail_(Version No)_(Merchantcode)_YYYYMMDD`
Store level	S-File-03	`Store_Miscellaneous_Detail_(Version No)_(Storecode)_YYYYMMDD`

File Name Field Descriptions

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

Field	Description
Fixed value	`Acquirer_Miscellaneous_Detail` / `Group_Miscellaneous_Detail` / `Merchant_Miscellaneous_Detail` / `Store_Miscellaneous_Detail`, corresponding to that level
Version number	The first character is the file identifier: `P` for the production environment and `T` for the test environment; the last three characters are a numeric number, starting from `001` up to `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 `Batch Generate Threshold` function is configured for the Acquirer file, with a value range of `001`–`999`

File Name Examples

Production environment (Acquirer level)

Acquirer_Miscellaneous_Detail_P003_88888888_20230108.csv

Test environment (Acquirer level)

Acquirer_Miscellaneous_Detail_T003_88888888_20230108.csv

With batch number (Acquirer level)

Acquirer_Miscellaneous_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	Empty TXT file with the same name and a `.ok` suffix (for example, `Acquirer_Miscellaneous_Detail_P003_88888888_20230108.csv.ok`)

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

Report structure

Basic File Properties

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

File Generation Time

Generation cycle: natural-day file, generated every Monday to Friday

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-03 Miscellaneous_Detail file.

No.	Field Name	Description
1	Record Date	Record date
2	Record Type	Record type
3	Record Reference Number	Record reference number
4	Record Reason Code	Record reason code
5	Record Reference Information	Record reference information
6	PSP ID	Payment PSP ID Appears only in Acquirer-level files
7	PSP Name	Payment PSP name Appears only in Acquirer-level files
8	Group ID	Group number Appears only in Acquirer- and Group-level files
9	Group Name	Group name Appears only in Acquirer- and Group-level files
10	Merchant ID	Merchant number Appears only in Acquirer-, Group-, and Merchant-level files
11	Merchant Name	Merchant name Appears only in Acquirer-, Group-, and Merchant-level files
12	Store ID	Store number
13	Store Name	Store name
14	Store MCC	Store MCC
15	Terminal ID	Terminal number
16	Merchant Nation	Merchant country
17	Merchant City	Merchant city
18	Merchant Txn Time	Merchant transaction time
19	System Txn Time	Evo Payment system transaction time
20	Txn Pay Time	PSP transaction time
21	API Type	API category
22	Txn Type	Transaction type
23	Payment Brand	Payment brand
24	Payment Method Variant	Payment method
25	Merchant Txn ID	Merchant transaction number
26	Merchant Order Reference	Merchant order reference information
27	System Txn ID	Evo Payment transaction number
28	PSP Txn ID	PSP transaction number
29	Original Merchant Txn ID	Original transaction merchant transaction number
30	Original System Txn ID	Original transaction Evo Payment transaction number
31	Original PSP Txn ID	Original transaction PSP transaction number
32	Card Number	Card number (first 6******last 4)
33	Funding Type	Card debit/credit indicator
34	Product ID	Card product identifier
35	Product Type ID	Card type identifier
36	Issuer Country	Issuer country
37	Merchant Local Amt	Merchant local amount
38	Local Tips Amt	Local tip amount
39	Local Surcharge Fee Amt	Local additional service fee amount
40	Local Capture Amt	Merchant confirmed local amount
41	Merchant Local Curr	Merchant local currency
42	Rate of Local to Txn	MCP/DCC exchange rate
43	Merchant Txn Amt	Merchant transaction amount
44	Tips Amount	Tip transaction amount
45	Surcharge Fee Amt	Additional service fee amount
46	Merchant Capture Amt	Merchant confirmed amount
47	Merchant Txn Curr	Merchant transaction currency
48	User Billing Amt	User billing amount
49	User Billing Curr	User billing currency
50	ECI	Authentication indicator
51	Txn Initiation Mode	Transaction initiation mode
52	LinkPay Order ID	LinkPay order number
53	Txn Status	Evo Payment system transaction status
54	System Result Code	Evo Payment response code
55	PSP Result Code	PSP response code
56	PSP Authorization Code	PSP authorization code
57	Crossborder Flag	Cross-border indicator
58	Merchant Sttl Amt	Merchant settlement amount
59	Merchant Discount Amt	Merchant discount amount
60	Merchant Sttl Curr	Merchant settlement currency
61	Rate from Merchant Txn to Sttl	Merchant settlement exchange rate
62	MDR Rules	Merchant fee billing rule
63	MDR Amount	Merchant settlement fee
64	PSP Interchange Fee	Interchange fee (IC)
65	PSP Scheme Fee	Scheme fee (+)
66	Acquirer Service Fee	Acquirer service fee (+)
67	Txn Service Fee	Merchant transaction fee
68	VAT Amount	VAT amount
69	WHT Amount	Withholding tax amount
70	Net Merchant Sttl Amt	Net merchant settlement amount
71	Metadata	Remarks

Samples

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

File-03 Miscellaneous_Detail Manual Settlement Transaction Detail File

Overview#

File Location and Naming Rules#

File Levels and File Codes#

File Name Field Descriptions#

File Name Examples#

SFTP Path and Login#

Report structure#

Basic File Properties#

File Generation Time#

File data elements#

Samples#