Configuring technical data

To select the character encoding of the report:

  1. Select the desired tab: Workspace report settings or Active report settings.
  2. Select the desired encoding from the Character encoding drop-down list.
    • ISO-8859-1 (Latin-1) is the default value
    • UTF-8
  3. Click Save.

To choose the amount format

By default, the amounts are presented in the smallest currency unit.

For technical reasons or for greater convenience, you can change the output format of the individual amounts.

Available formats for currencies with a subdivision Description Example

1,025.99

in the smallest currency unit The amount is written as a positive integer. This is the default value. 102599
in currency unit The amount is written in decimal notation. 1,025.99

For currencies with no subdivision:

Available formats for currencies with no subdivision Description Example

41 025 ¥

in the smallest currency unit The amount is written as a positive integer. This is the default value. 41025
in currency unit The amount is written as a positive integer. 41,025

  1. Select the desired tab: Workspace report settings or Active report settings.
  2. Select the format from the Amount format drop-down list:
    • in currency unit
    • in the smallest currency unit
  3. Click Save.

In order to add/delete the Title record to/from the report:

  1. Select the desired tab: Workspace report settings or Active report settings.
  2. Check or uncheck the checkbox Include the title line in the report.
  3. Click Save.

Note: once saved, the Format and version label of the TITRE (Title) record will be set to TABLE_V_CUSTOM

In order to use the column titles of the Captured transactions tab:

Display columns titles on the Captured transactions tab for better legibility especially in Microsoft Excel.

Examples: TRANSACTION_ID becomes Transaction, COMPLEMENTARY_CODE becomes Risks.

  1. Select the desired tab: Workspace report settings or Active report settings.
  2. Check or uncheck the checkbox Use the name of the columns of the tab "captured transaction".
  3. Click Save.

In order to enclose the report data in quotes:

The addition of quotes allows to delimit data. Example: the value 978 becomes "978".

  1. Select the desired tab: Workspace report settings or Active report settings.
  2. Check or uncheck the checkbox Frame the report data into quotes (").
  3. Click Save.

In order to apply a filter to finalized transactions:

This option is useful for merchants who make deferred payments. It allows to list only those transactions whose status changed to final during the restitution period, in particular when they were captured at the bank.

The final statuses are: CAPTURED (Captured), EXPIRED (Expired), REFUSED (Refused), CANCELLED (Canceled).

Thus, a transaction created with the AUTHORISED status will not be taken into account.

  1. Select the desired tab: Workspace report settings or Active report settings.
  2. Check or uncheck the checkbox Filter by completed transactions.
  3. Click Save.