Appendix 3 - AdE output file specifications
The following specification is referred to the latest version.
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
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
[nn]
Alphanumeric - 2 char
Chunk number starting from 01 to 99 depending on the file output size
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
Last updated