Appendix 3 - AdE output file specifications v1.2.5

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].csv

In particular:

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	Progressive value of the file (e.g. 001) in the same day

Please note that:

• 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

Fields in the output file

Field number	Field name	Type	Mandatory	Note
2	Sender_Code	Alphanumeric - max 5 char	YES	ABI code of the transmitting subject or a unique code assigned to the transmitting subject by PagoPA
3	Operation_type	Alphanumeric - regexp [0-9]{2}	YES	Operation type: 00 - payment 01 - payment reversal
4	Transmission_date	FORMAT ISO8601 yyyy-MM-dd	YES	Date of transmission of the transactions by the acquirer
5	Operation_date	FORMAT ISO8601 yyyy-MM-dd	YES	Accounting date of operations
6	Transaction number	Entire	YES	Number of transactions
7	Total_amount	Entire	YES	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"
8	Currency	Alphanumeric - max 3 char	YES	Fixed value 978 = EUR. ISO 4217 alpha-3: 201 international encoding is used.
9	Acquirer_id	Alphanumeric - max 255 char	YES	ABI code of the subject obliged or Tax Code of the subject obliged in the case of subjects without ABI
10	Merchant_id	Alphanumeric - max 255 char	YES	Agreement code of the merchant with the acquirer
11	Terminal_id	Alphanumeric - max 255 char	YES	Terminal / POS (Point of Sale) identifier used by the person who collects the payments with POS. Technical identification code of the terminal at the payment gateway.
12	Fiscal_code	Alphanumeric - min 11 max16 char	YES	Tax code of the person using the POS
13	VAT	Alphanumeric of 11 char	NO	VAT number of the person using the POS
14	Pos_type	Alphanumeric - regexp [0-9]{2}	YES	POS tyoe: 00 – fisical pos 01 - ecommerce