This section refers to the file interface specifications for completed transactions recorded in Ecentric’s Payment Gateway.

If a merchant requests a Reconciliation (Recon) File from Ecentric (for the purpose of e.g. reconciliation), Ecentric would be able to provide the merchant with a Recon File/Payment Gateway mark off file which includes their transactions of the day.

Fields are delimited by the pipe symbol (vertical bar, |). Records are terminated by carriage return line feed (CR-LF). The file layout consists of a header, detail and trailer sections. The file will contain just a header and trailer sections if there are no detail records. The receiver will therefor always receive a file even if it contains no actual data records to know whether the communication channel is working or not.

Description

The Payment Gateway Recon File contains details of completed transactions. The service provides the merchants with their very own payment gateway mark off file, which the merchant is able to access through SFTP with the aid of a public key.

Method of Integration

The merchant has the option of accessing the mark off file via SFTP (Secure File Transfer Protocol). From Ecentric’s side, a file will be set up for the merchant and by means of a public key, the merchant will be able to access their payment gateway mark off file. Please refer to the SFTP Account Setup section for more information.

Configuration Options

The merchant may specify the following configuration options:

File creation time
- A single file will be created per day at the given time.
- The file will contain all transactions completed within the 24 hours preceding the file creation time.
Include failed transactions
- The file will contain either only successful transactions or successful and failed transactions.

File Structure

A file may contain only 1 batch.

Each batch includes:

A header record
Many detail records
A trailer record

Records are defined as detailed level transactions.

File Name

The file name must contain the date of the file, to ensure uniqueness, and to avoid overwriting existing files.

File Level Rules

A file contains all mark-off entries at the time of processing of transactions.
The total records in the trailer must equal the total count of all detail records in the file.
The amount in the trailer must be the sum of the transaction amount on all detail records.

File Versions

There are currently 2 versions of the Recon File:

Version 2
Version 4 - uses the same format as Version 2 with additional fields at the end of each record

Record Formatting

The file data is encoded using standard ASCII character set.

Record Delimiters: Each record in the file is delimited by the carriage return line feed, ASCII characters: 0D0A ().

Field Delimiters: Fields are delimited by the pipe symbol (vertical bar, |).

Record Details

The file layout consists of a header, detail and trailer sections.

The file will contain just a header and trailer sections if there are no detail records. The receiver will therefore always receive a file even if it contains no actual data records to know whether the communication channel is working or not.

Blanks are allowed for all fields excluding RecordType field in the Header and Detail sections.

IMPORTANT NOTE: placeholder fields have been allocated at the end of each record for future enhancements. Please note that further additional fields may be added at the end of each record in the future.