> For the complete documentation index, see [llms.txt](https://docs.pagopa.it/centrostella-1/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pagopa.it/centrostella-1/centro-stella/instructions-for-agenzia-delle-entrate-mandate/appendixes/appendix-3-ade-output-file-specifications.md).

# Appendix 3 - AdE output file specifications

{% hint style="info" %}
The following specification is referred to the latest version.
{% endhint %}

This chapter describes the structure of the output file, i.e. the file that contains the aggregates.

The naming convention of the file is as follows:

* \[service].\[ABI].\[filetype].\[date].\[time].\[nnn].\[nn].csv<br>

In particular:&#x20;

| **Field**       | **format**            | **notes**                                                             |
| --------------- | --------------------- | --------------------------------------------------------------------- |
| \[service]      | Alphanumeric - 5 char | fixed value ADE                                                       |
| \[ABI]          | Alphanumeric - 5 char | sender ABI code or PagoPA 5 char assigned code (if ABI not available) |
| \[filetype]     | Alphanumeric - 6 char | fixed value TRNLOG                                                    |
| \[date].\[time] | YYYYMMDD.HHMISS       | file creation timestamp                                               |
| \[nnn]          | Alphanumeric - 3 char | <p>Progressive value of the file (e.g. 001) in the same day<br></p>   |
| \[nn]           | Alphanumeric - 2 char | Chunk number starting from 01 to 99 depending on the file output size |

{% hint style="info" %}
Please note that:&#x20;

* the file is in .csv type, with separator “;”
* the csv produced by PagoPA will be encrypted with a PGP public key
* the contents of the file do not include head and tail rows
  {% endhint %}

### Fields in the output file

<table data-header-hidden><thead><tr><th width="150" align="center">Field number</th><th width="150">Field name</th><th width="150">Type</th><th width="150" align="center">Mandatory</th><th>Note</th></tr></thead><tbody><tr><td align="center"><strong>Field number</strong></td><td><strong>Field name</strong></td><td><strong>Type</strong></td><td align="center"><strong>Mandatory</strong></td><td><strong>Note</strong></td></tr><tr><td align="center">2</td><td><strong>Sender_Code</strong></td><td>Alphanumeric - max 5 char</td><td align="center">YES</td><td>ABI code of the transmitting subject or a unique code assigned to the transmitting subject by PagoPA</td></tr><tr><td align="center">3</td><td><strong>Operation_type</strong></td><td>Alphanumeric - regexp [0-9]{2}</td><td align="center">YES</td><td><p>Operation type:</p><ul><li>00 - payment</li><li>01 - payment reversal</li></ul></td></tr><tr><td align="center">4</td><td><strong>Transmission_date</strong></td><td>FORMAT ISO8601 yyyy-MM-dd</td><td align="center">YES</td><td>Date of transmission of the transactions by the acquirer</td></tr><tr><td align="center">5</td><td><strong>Operation_date</strong></td><td>FORMAT ISO8601 yyyy-MM-dd</td><td align="center">YES</td><td>Accounting date of operations</td></tr><tr><td align="center">6</td><td><strong>Transaction number</strong></td><td>Entire</td><td align="center">YES</td><td>Number of transactions</td></tr><tr><td align="center">7</td><td><strong>Total_amount</strong></td><td>Entire</td><td align="center">YES</td><td>Valued in euro cents (eg: € 10 = 1000) and expressed as an absolute value: the sign is deducted from the type of operation "00-payment, 01-reversal"</td></tr><tr><td align="center">8</td><td><strong>Currency</strong></td><td>Alphanumeric - max 3 char</td><td align="center">YES</td><td>Fixed value 978 = EUR. ISO 4217 alpha-3: 201 international encoding is used.</td></tr><tr><td align="center">9</td><td><strong>Acquirer_id</strong></td><td>Alphanumeric - max 255 char</td><td align="center">YES</td><td>ABI code of the subject obliged or Tax Code of the subject obliged in the case of subjects without ABI</td></tr><tr><td align="center">10</td><td><strong>Merchant_id</strong></td><td>Alphanumeric - max 255 char</td><td align="center">YES</td><td>Agreement code of the merchant with the acquirer</td></tr><tr><td align="center">11</td><td><strong>Terminal_id</strong></td><td>Alphanumeric - max 255 char</td><td align="center">YES</td><td><p>Terminal / POS (Point of Sale) identifier used by the person who collects the payments with POS.</p><p>Technical identification code of the terminal at the payment gateway.</p></td></tr><tr><td align="center">12</td><td><strong>Fiscal_code</strong></td><td>Alphanumeric - min 11 max16 char</td><td align="center">YES</td><td>Tax code of the person using the POS</td></tr><tr><td align="center">13</td><td><strong>VAT</strong></td><td>Alphanumeric of 11 char</td><td align="center">NO </td><td>VAT number of the person using the POS</td></tr><tr><td align="center">14</td><td><strong>Pos_type</strong></td><td>Alphanumeric - regexp [0-9]{2}</td><td align="center">YES</td><td><p>POS tyoe:</p><ul><li>00 – fisical pos</li><li>01 - ecommerce</li></ul></td></tr></tbody></table>