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-08 Network_Token_Cryptogram_Detail Network Token Cryptogram Detail File

Overview#

The Evo Payment clearing and settlement system generates a detail file containing all network token cryptograms from the previous calendar day's daily cutoff cycle according to the customer's specified daily cutoff time, for customers to perform automated transaction matching and reconciliation.
Note :
The file includes online transactions in all transaction statuses (including failed transactions);
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 feature is enabled, the file name will include a BatchNum (001–999) suffix.

File location and naming rules#

File levels and file codes#

Evo Payment can generate details at different dimensions based on 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-08Acquirer_Network_Token_Cryptogram_Detail_(Version No)_(Inscode)_YYYYMMDD
Group levelG-File-08Group_Network_Token_Cryptogram_Detail_(Version No)_(Groupcode)_YYYYMMDD
Merchant levelM-File-08Merchant_Network_Token_Cryptogram_Detail_(Version No)_(Merchantcode)_YYYYMMDD
Store levelS-File-08Store_Network_Token_Cryptogram_Detail_(Version No)_(Storecode)_YYYYMMDD

File name field descriptions#

Each field is joined with an underscore (_), and the field meanings are as follows:
FieldDescription
Fixed valueAcquirer_Network_Token_Cryptogram_Detail / Group_Network_Token_Cryptogram_Detail / Merchant_Network_Token_Cryptogram_Detail / Store_Network_Token_Cryptogram_Detail, corresponding to that level
Version numberThe 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, from 001 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, the report generation date
Batch number (optional)Added when the Acquirer file is configured with the Batch Generate Threshold feature, with a value range of 001–999

File name examples#

Production environment (Acquirer level)
Acquirer_Network_Token_Cryptogram_Detail_P003_88888888_20230108.csv
Test environment (Acquirer level)
Acquirer_Network_Token_Cryptogram_Detail_T003_88888888_20230108.csv
With batch number (Acquirer level)
Acquirer_Network_Token_Cryptogram_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_Network_Token_Cryptogram_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 properties#

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

File generation time#

Generation cycle: calendar-day file, generated every Monday through Sunday
Generation time: daily 10:00–12:00 AM (Evo Payment node system time)

File data elements#

This section defines the data elements of the File-08 Network_Token_Cryptogram_Detail file.
No.Field nameDescription
1Group IDGroup number
Appears only in Acquirer-level files
2Group NameGroup name
Appears only in Acquirer-level files
3Merchant IDMerchant number
Appears only in Acquirer- and Group-level files
4Merchant NameMerchant name
Appears only in Acquirer- and Group-level files
5Store IDStore number
Appears only in Acquirer-, Group-, and Merchant-level files
6Store NameStore name
Appears only in Acquirer-, Group-, and Merchant-level files
7Merchant Txn TimeMerchant transaction time
8API TypeAPI category
9Txn TypeTransaction type
10Payment BrandPayment brand
11Merchant Txn IDMerchant transaction number
12Merchant Order ReferenceMerchant order reference information
13Card NumberCard number (first 6******last 4)
14Merchant Txn CurrMerchant local currency
15Merchant Txn AmtMerchant transaction amount
16Authentication TypeAuthentication type
17ECIAuthentication indicator
18Txn StatusTransaction status
19Token IDToken number
20Token Reference IDUnique token reference number
21TokenToken (first 6******last 4)
22Payment Account ReferencePayment account reference
23MetadataRemarks

Samples#

Group IDGroup NameMerchant IDMerchant NameStore IDStore NameMerchant Txn TimeAPI TypeTxn TypePayment BrandMerchant Txn IDMerchant Order ReferenceCard NumberMerchant Txn CurrMerchant Txn AmtAuthentication TypeECITxn StatusToken IDToken Reference IDTokenPayment Account ReferenceMetadata
A679882Group9M228718Merchant31S819947Store492028-07-07T10:48:03+08:00CryptogramVISgxt_hxerfqoj5z94794_RA_56q1444i903207******2875Success6013yoa37533e41g8424939hi859b119DNITHE260349868657627826104717******7873V1188181795690816544729077347
Previous
File-07 PSP_Interchange_Scheme_Fee_Detail PSP Interchange and Scheme Fee Detail File
Next
BIN File
Built with