File-04 PSP_Reconciliation_Detail PSP Settlement Reconciliation Transaction Detail File
Overview
BatchNum (001–999) suffix is added to the file name.File Location and Naming Rules
File Level and File Code
| File Level | File Code | Report Name Template |
|---|---|---|
| Acquirer Level | A-File-04 | Acquirer_PSP_Reconciliation_Detail_(Version No)_(Inscode)_YYYYMMDD |
File Name Field Description
_), and the field meanings are as follows:| Field | Description |
|---|---|
| Fixed Value | Acquirer_PSP_Reconciliation_Detail, corresponding to this level |
| Version No | 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 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, with values ranging from 001–999 |
File Name Examples
Acquirer_PSP_Reconciliation_Detail_P003_88888888_20230108.csvAcquirer_PSP_Reconciliation_Detail_T003_88888888_20230108.csvAcquirer_PSP_Reconciliation_Detail_P003_88888888_20230108_001.csvSFTP Path and Login
| Item | Description |
|---|---|
| SFTP Mode | Evo Payment is the SFTP Server |
| Default Directory | /in/{YYYYMMDD} |
| Login Method | Public and private keys |
| Transfer Completion Marker | An empty TXT file with the same name and .ok suffix (e.g., Acquirer_PSP_Reconciliation_Detail_P003_88888888_20230108.csv.ok) |
.ok file exists to confirm that Evo Payment has completed the file transfer.Report structure
File Basic Properties
| Property | Value |
|---|---|
| File Format | CSV |
| File Encoding | UTF-8 with BOM |
| Line Break | \n (0x0A) |
| Field Delimiter | Double quotation marks + English comma "," |
| File Content Ending Marker | ***END*** (last line) |
File Generation Time
File data elements
| No. | Field Name | Description |
|---|---|---|
| 1 | Acquirer ID | Acquirer ID Appears only in Acquirer-level files |
| 2 | Acquirer Name | Acquirer name Appears only in Acquirer-level files |
| 3 | PSP ID | Payment PSP ID Appears only in Acquirer-level files |
| 4 | PSP Name | Payment PSP name Appears only in Acquirer-level files |
| 5 | Group ID | Group number Appears only in Acquirer-level files |
| 6 | Group Name | Group name Appears only in Acquirer-level files |
| 7 | Merchant ID | Merchant number Appears only in Acquirer-level files |
| 8 | Merchant Name | Merchant name Appears only in Acquirer-level files |
| 9 | Store ID | Store number Appears only in Acquirer-level files |
| 10 | Store Name | Store name Appears only in Acquirer-level files |
| 11 | Store MCC | Store MCC Appears only in Acquirer-level files |
| 12 | Terminal ID | Terminal number Appears only in Acquirer-level files |
| 13 | Merchant Nation | Merchant country Appears only in Acquirer-level files |
| 14 | Merchant City | Merchant city Appears only in Acquirer-level files |
| 15 | Merchant Txn Time | Merchant transaction time Appears only in Acquirer-level files |
| 16 | System Txn Time | Evo Payment system transaction time Appears only in Acquirer-level files |
| 17 | Txn Pay Time | PSP transaction time Appears only in Acquirer-level files |
| 18 | API Type | API category Appears only in Acquirer-level files |
| 19 | Txn Type | Transaction type Appears only in Acquirer-level files |
| 20 | Payment Brand | Payment brand Appears only in Acquirer-level files |
| 21 | Payment Method Variant | Payment method Appears only in Acquirer-level files |
| 22 | Merchant Txn ID | Merchant transaction ID Appears only in Acquirer-level files |
| 23 | Merchant Order Reference | Merchant order reference information Appears only in Acquirer-level files |
| 24 | System Txn ID | Evo Payment transaction ID Appears only in Acquirer-level files |
| 25 | PSP Txn ID | PSP transaction ID Appears only in Acquirer-level files |
| 26 | Original Merchant Txn ID | Original transaction Merchant transaction ID Appears only in Acquirer-level files |
| 27 | Original System Txn ID | Original Evo Payment transaction ID Appears only in Acquirer-level files |
| 28 | Original PSP Txn ID | Original transaction PSP transaction ID Appears only in Acquirer-level files |
| 29 | Card Number | Card number (first 6******last 4) Appears only in Acquirer-level files |
| 30 | Funding Type | Card debit/credit indicator Appears only in Acquirer-level files |
| 31 | Product ID | Card product identifier Appears only in Acquirer-level files |
| 32 | Product Type ID | Card category identifier Appears only in Acquirer-level files |
| 33 | Issuer Country | Issuing country Appears only in Acquirer-level files |
| 34 | Merchant Local Amt | Merchant local amount Appears only in Acquirer-level files |
| 35 | Local Tips Amt | Tip local amount Appears only in Acquirer-level files |
| 36 | Local Surcharge Fee Amt | Additional service fee local amount Appears only in Acquirer-level files |
| 37 | Local Capture Amt | Merchant confirmed local amount Appears only in Acquirer-level files |
| 38 | Merchant Local Curr | Merchant local currency Appears only in Acquirer-level files |
| 39 | Rate of Local to Txn | MCP/DCC exchange rate Appears only in Acquirer-level files |
| 40 | Merchant Txn Amt | Merchant transaction amount Appears only in Acquirer-level files |
| 41 | Tips Amount | Tip transaction amount Appears only in Acquirer-level files |
| 42 | Surcharge Fee Amt | Additional service fee amount Appears only in Acquirer-level files |
| 43 | Merchant Capture Amt | Merchant confirmed amount Appears only in Acquirer-level files |
| 44 | Merchant Txn Curr | Merchant transaction currency Appears only in Acquirer-level files |
| 45 | User Billing Amt | User billing amount Appears only in Acquirer-level files |
| 46 | User Billing Curr | User billing currency Appears only in Acquirer-level files |
| 47 | ECI | Authentication indicator Appears only in Acquirer-level files |
| 48 | Txn Initiation Mode | Transaction initiation method Appears only in Acquirer-level files |
| 49 | LinkPay Order ID | LinkPay order ID Appears only in Acquirer-level files |
| 50 | Txn Status | Evo Payment system transaction status Appears only in Acquirer-level files |
| 51 | System Result Code | Evo Payment response code Appears only in Acquirer-level files |
| 52 | PSP Result Code | PSP response code Appears only in Acquirer-level files |
| 53 | PSP Authorization Code | PSP authorization code Appears only in Acquirer-level files |
| 54 | Crossborder Flag | Cross-border indicator Appears only in Acquirer-level files |
| 55 | PSP ARN | Dual-message presentment settlement number Appears only in Acquirer-level files |
| 56 | PSP Settlement Date | PSP settlement date Appears only in Acquirer-level files |
| 57 | PSP Txn Amt | PSP transaction amount Appears only in Acquirer-level files |
| 58 | PSP Txn Curr | PSP transaction currency Appears only in Acquirer-level files |
| 59 | Direct FX Rate | PSP transaction exchange rate Appears only in Acquirer-level files |
| 60 | PSP Sttl Amt | PSP settlement amount Appears only in Acquirer-level files |
| 61 | PSP Discount Amt | PSP discount amount Appears only in Acquirer-level files |
| 62 | Acquirer Discount Amt | PSP Merchant discount amount Appears only in Acquirer-level files |
| 63 | PSP Sttl Curr | PSP settlement currency Appears only in Acquirer-level files |
| 64 | Rate for PSP TXN to Sttl | PSP settlement exchange rate Appears only in Acquirer-level files |
| 65 | PSP Interchange Fee | PSP IC fee Appears only in Acquirer-level files |
| 66 | PSP VAT Amount | PSP value-added tax Appears only in Acquirer-level files |
| 67 | PSP WHT Amount | PSP withholding tax Appears only in Acquirer-level files |
| 68 | PSP Net Sttl Amt | PSP net settlement amount Appears only in Acquirer-level files |
| 69 | PSP Batch | Settlement batch number Appears only in Acquirer-level files |