1. Reconciliation Files
Reconciliation Files & Specifications
  • Overview
  • Reconciliation Files
    • File-01 Activity_Detail Online Transaction Detail File
    • File-02 Settlement_Detail Settlement Transaction Detail File
    • File-03 Miscellaneous_Detail Manual Settlement Transaction Detail File
    • File-04 PSP_Reconciliation_Detail PSP Settlement Reconciliation Transaction Detail File
    • File-05 PSP_Miscellaneous_Detail PSP Settlement Exception and Special Transaction Detail File
    • File-06 Interchange_Scheme_Fee_Detail Interchange and Scheme Fee Detail File
    • File-07 PSP_Interchange_Scheme_Fee_Detail PSP Interchange and Scheme Fee Detail File
    • File-08 Network_Token_Cryptogram_Detail Network Token Cryptogram Detail File
  • Card BIN File
    • BIN File
  1. Reconciliation Files

File-06 Interchange_Scheme_Fee_Detail Interchange and Scheme Fee Detail File

Overview#

At the customer-specified daily cut-off time, the Evo Payment clearing and settlement system produces a detail file containing all interchange fees and scheme fees within the previous natural-day cut-off cycle, for customers to perform automated transaction matching and reconciliation.
Note :
The file contains online transactions in all transaction statuses (including transactions with a failed status);
If the customer generated no online transactions on the previous day, an empty file is generated, retaining only the field names and 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 produce details in different dimensions according to the different levels configured for the customer in the system. File codes and report names are distinguished by level as follows:
File levelFile codeReport name template
Acquirer levelA-File-06Acquirer_Interchange_Scheme_Fee_Detail_(Version No)_(Inscode)_YYYYMMDD
Group levelG-File-06Group_Interchange_Scheme_Fee_Detail_(Version No)_(Groupcode)_YYYYMMDD
Merchant levelM-File-06Merchant_Interchange_Scheme_Fee_Detail_(Version No)_(Merchantcode)_YYYYMMDD
Store levelS-File-06Store_Interchange_Scheme_Fee_Detail_(Version No)_(Storecode)_YYYYMMDD

File name field descriptions#

Each field is connected by an underscore (_), and the field meanings are as follows:
FieldDescription
Fixed valueAcquirer_Interchange_Scheme_Fee_Detail / Group_Interchange_Scheme_Fee_Detail / Merchant_Interchange_Scheme_Fee_Detail / Store_Interchange_Scheme_Fee_Detail, corresponding to that level
Version numberThe 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/StorecodeThe customer's Acquirer, Group, Merchant, or Store identifier
DateYYYYMMDD, report generation date
Batch number (optional)Added when the Batch Generate Threshold function is configured for the Acquirer file, with a range of 001–999

File name examples#

Production environment (Acquirer level)
Acquirer_Interchange_Scheme_Fee_Detail_P003_88888888_20230108.csv
Test environment (Acquirer level)
Acquirer_Interchange_Scheme_Fee_Detail_T003_88888888_20230108.csv
With batch number (Acquirer level)
Acquirer_Interchange_Scheme_Fee_Detail_P003_88888888_20230108_001.csv

SFTP path and login#

ItemDescription
SFTP modeEvo Payment is the SFTP Server
Default directory/in/{YYYYMMDD}
Login methodPublic/private key
Transfer completion markerEmpty TXT file with the same-name .ok suffix (e.g., Acquirer_Interchange_Scheme_Fee_Detail_P003_88888888_20230108.csv.ok)
Important : Before pulling and parsing the 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#

AttributeValue
File formatCSV
File encodingUTF-8 with BOM
Line break\n (0x0A)
Field delimiterDouble quotation marks + comma ","
File content end marker***END*** (last line)

File generation time#

Generation cycle: natural-day file, produced Monday through Sunday each week
Generation time: daily 10:00–12:00 AM (Evo Payment node system time)

File data elements#

This section defines the field elements of the File-06 Interchange_Scheme_Fee_Detail file.
No.Field nameDescription
1Acquirer IDAcquirer ID
Appears only in Acquirer-level files
2PSP IDPayment PSP ID
Appears only in Acquirer-level files
3Group IDGroup number
Appears only in Acquirer- and Group-level files
4Merchant IDMerchant number
Appears only in Acquirer-, Group-, and Merchant-level files
5Store IDStore number
6Merchant Txn IDMerchant transaction number
7Merchant Order ReferenceMerchant order reference information
8System Txn IDEvo Payment transaction number
9PSP Txn IDPSP transaction number
10Original Merchant Txn IDOriginal Merchant transaction number
11Original PSP Txn IDOriginal PSP transaction number
12Merchant Txn TimeMerchant transaction time
13Payment BrandPayment brand
14Txn TypeTransaction type
15PSP MCCPSP's MCC, Merchant category
16Txn StatusEvo Payment system transaction status
17Merchant Txn AmtMerchant transaction amount
18Merchant Txn CurrMerchant transaction currency
19Funding TypeCard debit/credit indicator
20Card Program IDCPI identifier. Applicable only to Mastercard; current values include MCC and DMC.
21Product IDCard product ID
22Product Type IDCard category identifier
23Issuer CountryIssuer country/region
24Acquirer NationCountry/region where the Acquirer is located
25Merchant NationCountry/region where the Merchant is registered
26Crossborder FlagCross-region indicator
27Payment ScenarioTransaction scenario: online/offline
28IC FeeInterchange fee identifier, fixed value: Interchange Fee
29IC Fee IndicatorCard scheme Interchange Fee ID
30IC Fee NameInterchange fee name
31IC Fee Rule FlagInterchange fee rule identifier, with values and meanings shown below.
32IC Fee RuleInterchange fee rule
33Scheme FeeScheme fee identifier, fixed value: Scheme Fee
34Scheme Fee Service CodeScheme fee code
35Scheme Fee NameScheme fee item name
36Scheme Fee Rule FlagScheme fee rule identifier
37Scheme Fee RuleScheme fee rule
38Scheme Fee Service Code, Scheme Fee Name, Scheme Fee Rule Flag,Scheme Fee RuleRepeats sequentially as a group

Samples#

The viewer below shows the content of the sample file. Click Download to get the file.
Previous
File-05 PSP_Miscellaneous_Detail PSP Settlement Exception and Special Transaction Detail File
Next
File-07 PSP_Interchange_Scheme_Fee_Detail PSP Interchange and Scheme Fee Detail File
Built with