1. Home
2. Get started
3. Generate Reports
4. Reporting

1. Configuration

Go to "Electronic reporting" in your ePDQ Account:

• On account (PSPID) level: Select "Operations" and choose "Electronic reporting" in the sub-menu.
• On user (USERID) level:
  1. Select "Advanced" and choose "Users" in the sub-menu.
  2. Click "Edit" for the specific user.
  3. Select "Electronic Reporting for this User" at the bottom of the page in the User's Data overview.

You can select your preferred file structure and file format for the reports.

You can define the file structure and format for each user. When you configure the electronic reporting parameters for a user, this configuration will be applied to all reports set up by this user.

Specific fields will be returned in your report, depending on the file structure.

You can choose one of the following file structures:

• Standard
• Extended
• Dynamic
• File Management

You can also choose between the following return formats:

• XML
• Fixed-length
• Delimited

2. Steps

Execute the following steps to download formatted files with transaction information:

1. Define the file format and structure on the Electronic reporting page.
2. Use the Financial history, View transactions and View files options to select the required information.
3. Click on the "Download" button.

Customise the output of your downloaded files with the following criteria:

• The structure defines the data and the position of the various selected payments.
• The format defines the output data format.
• The "Sort by" specifications allow you to group your data according to certain values.
• The Additional options help you to adapt the payment records' display.

3. Structure

Obtain the data by using one of the following structures:

• Standard
• Extended
• Dynamic
• File Management

Each structure has a different number (and position) of fields in the selected payments.
These fields are described in the data dictionary which includes the XML tag name, size, format and description.

3.1 Common Fields

3.2 Standard

Financial history, View transactions:

Financial history (Download Summary):

View files (selection page):

3.3 Extended

For the View files (selection page) and the Financial history (summary), please refer to the Standard structure.

Financial history, View transactions:

3.4 Dynamic (new extended format)

This structure contains optional fields. A detailed level is available for Purchasing, Merchant Assistant or Travel.

For the "Dynamic" structure, these fields can be added at the end of the structure.

List of available fields on the "Electronic reporting" page:

The "WithDetail" flag can be selected on the "Electronic reporting" page.

3.4.1 Travel details

3.4.2 Merchant Assistant details

3.5 File Management

For the View files (selection page) and the Financial history (summary), please refer to the Standard structure.

Financial history, View transactions:

3.6 Format

Each record corresponds to a payment. The output formats are:

• XML: Each field describing the payment is available as a property of the <PAYMENT> tag;
• Fixed Length: each field has a fixed size as described in the various structures above.
• Delimited along with a separator: Each field of a payment record is separated by the specified separator (T for tab-delimited). If a value contains the separator, it will be replaced with a space in the download field, in order to avoid mismatches.

3.7 Sort by

After selecting the structure and format, you can also group your payments according to the value of the selected fields. You can choose up to 3 fields to create groups and sub-groups on 3 levels.

3.8 Name and Format of Downloaded File

You can specify the name and the extension of the downloaded file. In the file name, you cannot use specials characters like [/ . \ : * ? | < > "]

You can include dynamic parameters in the filename:

• [DATE] for the previous date of the processed file
• [FILEDATE] for the date of the processed file
• [TIME] for the time of the processed file

Example: File[DATE]_[TIME] will be converted to File20111025_16134.

In the extension field, you can use any file extension with 3 characters. Specifying * in this field means that the extension will be derived from the file format:

• '.xml' for XML
• '.csv' for semicolon delimited values
• '.txt' for Fixed-length or tab-delimited

3.9 Additional options

• Header box: to make your data more readable or 'no headers' to keep only the relevant data.
• Decimal Separator: to use in the download format [, or .].
• With column header: to have the name (i.e. the XML Tag name) of each field on the line before the first payment (only applicable for FIX and DEL formats).
• With Details: for merchants with Travel, Merchant Assistant or Purchasing details (only applicable for DYN format).

4. Data dictionary

Fields are sorted in ascending XML tags; for the field position; refer to Structure.