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-07 PSP_Interchange_Scheme_Fee_Detail PSP 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 PSP 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-07Acquirer_PSP_Interchange_Scheme_Fee_Detail_(Version No)_(Inscode)_YYYYMMDD

File name field descriptions#

Each field is connected by an underscore (_), and the field meanings are as follows:
FieldDescription
Fixed valueAcquirer_PSP_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_PSP_Interchange_Scheme_Fee_Detail_P003_88888888_20230108.csv
Test environment (Acquirer level)
Acquirer_PSP_Interchange_Scheme_Fee_Detail_T003_88888888_20230108.csv
With batch number (Acquirer level)
Acquirer_PSP_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_PSP_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-07 PSP_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-level files
4Merchant IDMerchant number
Appears only in Acquirer-level files
5Store IDStore number
Appears only in Acquirer-level files
6Merchant Txn IDMerchant transaction number
Appears only in Acquirer-level files
7Merchant Order ReferenceMerchant order reference information
Appears only in Acquirer-level files
8System Txn IDEvo Payment transaction number
Appears only in Acquirer-level files
9PSP Txn IDPSP transaction number
Appears only in Acquirer-level files
10Original Merchant Txn IDOriginal Merchant transaction number
Appears only in Acquirer-level files
11Original PSP Txn IDOriginal PSP transaction number
Appears only in Acquirer-level files
12Merchant Txn TimeMerchant transaction time
Appears only in Acquirer-level files
13Payment BrandPayment brand
Appears only in Acquirer-level files
14Txn TypeTransaction type
Appears only in Acquirer-level files
15PSP MCCPSP's MCC, Merchant category
Appears only in Acquirer-level files
16Txn StatusEvo Payment system transaction status
Appears only in Acquirer-level files
17Merchant Txn AmtMerchant transaction amount
Appears only in Acquirer-level files
18Merchant Txn CurrMerchant transaction currency
Appears only in Acquirer-level files
19Funding TypeCard debit/credit indicator
Appears only in Acquirer-level files
20Card Program IDCPI identifier. Applicable only to Mastercard; current values include MCC and DMC.
Appears only in Acquirer-level files
21Product IDCard product ID
Appears only in Acquirer-level files
22Product Type IDCard category identifier
Appears only in Acquirer-level files
23Issuer CountryIssuer country/region
Appears only in Acquirer-level files
24Acquirer NationCountry/region where the Acquirer is located
Appears only in Acquirer-level files
25Merchant NationCountry/region where the Merchant is registered
Appears only in Acquirer-level files
26Crossborder FlagCross-region indicator
Appears only in Acquirer-level files
27Payment ScenarioTransaction scenario: online/offline
Appears only in Acquirer-level files
28IC FeeInterchange fee identifier, fixed value: Interchange Fee
Appears only in Acquirer-level files
29IC Fee IndicatorCard scheme Interchange Fee ID
Appears only in Acquirer-level files
30IC Fee NameInterchange fee name
Appears only in Acquirer-level files
31IC Fee Rule FlagInterchange fee rule identifier, with values and meanings shown below.
Appears only in Acquirer-level files
32IC Fee RuleInterchange fee rule
Appears only in Acquirer-level files
33Scheme FeeScheme fee identifier, fixed value: Scheme Fee
Appears only in Acquirer-level files
34Scheme Fee Service CodeScheme fee code
Appears only in Acquirer-level files
35Scheme Fee NameScheme fee item name
Appears only in Acquirer-level files
36Scheme Fee Rule FlagScheme fee rule identifier
Appears only in Acquirer-level files
37Scheme Fee RuleScheme fee rule
Appears only in Acquirer-level files
38Scheme Fee Service Code, Scheme Fee Name, Scheme Fee Rule Flag,Scheme Fee RuleRepeats sequentially as a group
Appears only in Acquirer-level files

Samples#

The viewer below shows the content of the sample file. Click Download to get the file.
Previous
File-06 Interchange_Scheme_Fee_Detail Interchange and Scheme Fee Detail File
Next
File-08 Network_Token_Cryptogram_Detail Network Token Cryptogram Detail File
Built with