V2 Format

The record« TITRE »

Pos.	Description	Values
01	Record code	TITRE
02	The shop label, as defined in the Merchant Back Office.	E.g.: DEMO Store
03	UTC date and time of dispatch (YYMMDD_HH:MM:SS)	200113_02:05:00
04	Version	TABLE_V4

The record « ENTETE » and « DETAILS »

Pos.	Description
01	ENTETE Type: VARCHAR \| Length: 9 Description: Record code. Value: always populated with OPERATION
02	MERCHANT_COUNTRY Type: VARCHAR \| Length: 2 Description: Country code of the company (ISO 3166-1 alpha-2 standard). Hosted Payment Page equivalent: N/A REST API equivalent: N/A E.g.: FRfor France.
03	MERCHANT_ID Type: VARCHAR \| Length: 255 Description: Legal identifier of the company. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Values: 0+ Legal Identifier (Legal Identifier = SIRET (Système d'Identification du Répertoire des Etablissements)) E.g.: 045251785700028
04	PAYMENT_DATE Type: DATE \| Length: 8 Description: Date of payment in UTC time zone. Hosted Payment Page equivalent: vads_effective_creation_date REST API equivalent: creationDate E.g.: 20200110
05	TRANSACTION_ID Type: VARCHAR \| Length: 255 Description: Transaction identifier. Hosted Payment Page equivalent: vads_trans_id REST API equivalent: cardDetails.legacyTransId E.g.: xrT15p
06	OPERATION_SEQUENCE Type: NUMERIC \| Length: 1 Description: Operation number. This field is always set to “1”. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Value: 1
07	OPERATION_NAME Type: VARCHAR \| Length: 255 Description: Type of the performed action. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Values: AUTHOR : Transaction authorization (in case of deferred payments) CANCEL : Transaction cancellation CREDIT_CAPTURE : Capture of a refund transaction at the bank DEBIT_CAPTURE : Capture of a debit transaction at the bank DUPLICATE : Transaction duplication CREDIT : Transaction refund EXPIRED : Transaction expiration MODIFICATION : Transaction update TRANSACTION : Registration of a manual payment TRANSACTION_WITH_MANUAL_VALIDATION : Registration of a manual payment with manual validation VALIDATE : Transaction validation RAPPROCHEMENT : Transaction reconciliation VERIFICATION_REQUEST : Request to verify the payment method E.g.: CREDIT
08	OPERATION_AMOUNT Type: NUMERIC \| Length: 13 Description: Transaction amount expressed in the smallest currency unit. Hosted Payment Page equivalent: N/A REST API equivalent: N/A E.g.: 4525 for EUR 45.25
09	OPERATION_CURRENCY Type: NUMERIC \| Length: 3 Description: Operation currency. Hosted Payment Page equivalent: N/A REST API equivalent: N/A E.g.: 978 (See chapter List of supported currencies)
10	OPERATION_DATE Type: DATE \| Length: 6 Description: UTC date of the operation in the YYMMDD format. Hosted Payment Page equivalent: N/A REST API equivalent: N/A E.g.: 200112
11	OPERATION_TIME Type: TIME \| Length: 6 Description: Time of the operation in UTC format. Hosted Payment Page equivalent: N/A REST API equivalent: N/A E.g.: 121327
12	OPERATION_ORIGIN Type: VARCHAR \| Length: 255 Description: ID of the user who performed the action. Set to “BATCH” if the operation was processed automatically. E.g.: BATCH
13	RESPONSE_CODE Type: NUMERIC \| Length: 2 Description: Return code of the requested operation. For more information, please see parameter BANK_RESPONSE_CODE Values: 00 : Operation accepted 05 : Operation refused. 34 : Operation refused on suspicion of fraud. 75 : Transaction refused because number of attempts has been exceeded. 96 : Operation refused due to technical error. E.g.: 00
14	BANK_RESPONSE_CODE Type: VARCHAR\| Length: 255 Description: Response code of the authorization request returned by the issuing bank. Hosted Payment Page equivalent: vads_auth_result REST API equivalent: transactionDetails.cardDetails.authorizationResponse.authorizationResult Values: List of authorization return codes E.g.: 00
15	CVV_RESPONSE_CODE Type: VARCHAR \| Length: 255 Description: CVV2/CVC2 response code. Value: Always valued when empty.
16	NEW_STATUS Type: VARCHAR \| Length: 255 Description: New transaction status. This field can be empty if the transaction status does not match one of the statuses below. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Values: REFUSED : The transaction has been refused. TO_VALIDATE : The transaction must be validated TO_CAPTURE : The transaction is waiting for capture TO_CREDIT : Credit transaction (refund) waiting for capture CANCELLED : The transaction has been canceled CAPTURED : The transaction has been captured EXPIRED : The transaction has not been validated and has expired TO_VALIDATE_AND_AUTHORIZE : The transaction is waiting for an authorization request and must be validated TO_AUTHORIZE : The transaction is waiting for an authorization request TO_PRENOTIFY : Transaction awaiting pre-notification ACCEPTED : Verification transaction accepted REFUSED_CAPTURED : Capture failed E.g.:TO_CAPTURE
17	ORDER_ID Type: VARCHAR \| Length: 255 Description: Order number generated by the merchant website. Hosted Payment Page equivalent: vads_order_id REST API equivalent: orderDetails.orderId E.g.: CX-1254
18	RETURN_CONTEXT Type: VARCHAR\| Length: 500 Description: Context of buyer’s purchase. Concatenation of “additional information”, separated by the \| character”. Additional information can be transmitted through the merchant website: via the field vads_order_info, vads_order_info2, vads_order_info3 payment form, via attributes orderInfo, orderInfo2, orderInfo3 of the object metadata of the REST API Beyond 500 characters, the string is truncated. Empty field if no additional information is transmitted. Hosted Payment Page equivalent: vads_order_info \| vads_order_info2 \| vads_order_info3 \| REST API equivalent: orderInfo \| orderInfo2 \| orderInfo3 E.g.: info1\|info2\|info3 if the 3 pieces of additional information are transmitted. info1\|\|info3: if only the 1st and 3rd pieces of additional information are transmitted.
19	CUSTOMER_ID Type: VARCHAR \| Length: 255 Description: Customer reference generated by the merchant website. Hosted Payment Page equivalent: vads_cust_id REST API equivalent: customer.reference E.g.: C2383333540

The “END” (FIN) record

Pos.	Description	Values
01	Record code	FIN

File sample

Download the sample pack: https://paiement.systempay.fr/doc/files/samples/sample-files.zip.

You will find a sample file in the folderReporting/JO.