Format

The « TITRE » record

Pos.	Description	Values
01	Record code	TITRE
02	The shop label, as defined in the Merchant Back Office.	E.g.: DEMO Store
03	UTC dispatch date and time (YY/MM/DD_HH:MM:SS)	20/01/13_01:55:00
04	Version	TABLE_V_CUSTOM

The « ENTETE » (HEADER) and « DETAILS » records

By default, the data listed below are included in the transactions report file:

Pos.	Description
01	ENTETE Type: VARCHAR \| Length: 11 Description: Record code. Value: Always populated with TRANSACTION
02	TRANSACTION_ID Type: VARCHAR \| Length: 6 Description: Transaction identifier. Hosted Payment Form equivalent: vads_trans_id REST API equivalent: cardDetails.legacyTransId E.g.: xrT15p
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_MEANS Type: VARCHAR \| Length: 4 Description: Payment method. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Value: Always set to CARD.
05	CONTRACT Type: VARCHAR \| Length: 255 Description: Merchant ID number. Hosted Payment Form equivalent: vads_contract_used REST API equivalent: transactionDetails.mid E.g.: 0535875
06	TRANSACTION_TYPE Type: VARCHAR \| Length: 255 Description: Transaction type Hosted Payment Form equivalent: vads_operation_type REST API equivalent: operationType Values: CREDIT: for a refund transaction DEBIT: for a debit transaction VERIFICATION: for a transaction of payment method verification E.g.: DEBIT
07	ORIGIN_AMOUNT Type: NUMERIC \| Length: 13 Description: Transaction amount at the moment of payment expressed in the smallest currency unit. Hosted Payment Page equivalent: N/A REST API equivalent: N/A E.g.: 4525 for EUR 45.25
08	AMOUNT Type: NUMERIC \| Length: 13 Description: Transaction balance expressed in the smallest currency unit. Hosted Payment Form equivalent: vads_amount REST API equivalent: amount E.g.: 4525 for EUR 45.25
09	CURRENCY_CODE Type: NUMERIC \| Length: 3 Description: Numeric code of the currency (ISO 4217 standard). Hosted Payment Form equivalent: vads_currency REST API equivalent: currency E.g.: 978 for euro (EUR) (See chapter List of supported currencies).
10	PAYMENT_DATE Type: DATE \| Length: 8 Description: Date of payment in UTC time zone. Hosted Payment Form equivalent: vads_effective_creation_date REST API equivalent: creationDate E.g.: 20200110
11	PAYMENT_TIME Type: TIME \| Length: 6 Description: Time of payment in UTC time zone. Hosted Payment Form equivalent: vads_effective_creation_date REST API equivalent: creationDate E.g.: 142512
12	CARD_VALIDITY Type: NUMERIC \| Length: 6 Description: Payment method validity period. Hosted Payment Page equivalent: vads_expiry_year + vads_expiry_month REST API equivalent: transactionDetails.cardDetails.expiryYear + transactionDetails.cardDetails.expiryMonth E.g.: 202306
13	CARD_TYPE Type: VARCHAR \| Length: 255 Description: Card type. Hosted Payment Form equivalent: vads_card_brand REST API equivalent: transactionDetails.cardDetails.effectiveBrand E.g.: CB,VISA, MASTERCARD, etc.
14	CARD_NUMBER Description: Payment method number in 123456XXXXXX1234 format. Hosted Payment Form equivalent: vads_card_number REST API equivalent: transactionDetails.cardDetails.pan E.g.: 123456XXXXXX1234
15	RESPONSE_CODE Type: NUMERIC \| Length: 2 Description: Return code of the requested operation. Hosted Payment Form equivalent: vads_result REST API equivalent: N/A Values: 00: Accepted authorization. 05: Authorization refused. 34: Suspected fraud. 75: The maximum number of card number entry attempts has been exceeded. 96: Service temporarily unavailable. E.g.: 00
16	COMPLEMENTARY_CODE Type: NUMERIC \| Length: 2 Description: Risk assessment result (specific to shops that have enabled the module). The field is empty if no verifications have been completed. Hosted Payment Form equivalent: vads_extra_result REST API equivalent: N/A Values: 00: Verifications successfully performed. 02: Credit card velocity exceeded. 03: The card is on the Merchant’s greylist. 04: The issuing country of the card is on the greylist or is not on the merchant’s whitelist. 05: The IP address is on the merchant’s greylist. 06: The card is on the merchant’s BIN greylist. 07: E-carte bleue control. 08: Transaction not 3DS guaranteed. 14: Control of a card with unconditional authorization. 20: Verification of the country consistency between the card issuing country, the IP address and country of the customer’s address. 99: Technical issue encountered by the server during a local verification process. E.g.: 00
17	CERTIFICATE Type: VARCHAR \| Length: 255 Description: Transaction certificate. Hosted Payment Form equivalent: vads_payment_certificate REST API equivalent: N/A E.g.: 6ed7b71c023a20adbadf9a2e2c58cd4321f63123
18	AUTORISATION_ID Type: VARCHAR \| Length: 20 Description: Transaction authorization number. Hosted Payment Form equivalent: vads_auth_number REST API equivalent: transactionDetails.cardDetails.authorizationResponse.authorizationNumber E.g.: 3fc116
19	CAPTURE_DATE Type: DATE \| Length: 8 Description: Date of sending to the requested bank. Hosted Payment Form equivalent: vads_presentation_date REST API equivalent: transactionDetails.cardDetails.expectedCaptureDate E.g.: 20200107
20	TRANSACTION_STATUS Type: VARCHAR \| Length: 255 Description: Status of the transaction. Hosted Payment Form equivalent: vads_trans_status REST API equivalent: detailedStatus Values: ACCEPTED: Verification transaction accepted. AUTHORISED: The transaction is waiting for capture AUTHORISED_TO_VALIDATE: The transaction must be validated CANCELLED: The transaction has been canceled CAPTURED: The transaction has been captured CAPTURED_FAILED: Capture failed EXPIRED: The transaction has not been validated and has expired REFUSED: The transaction has been refused. UNDER_VERIFICATION: Control in progress WAITING_AUTHORISATION: The transaction is waiting for an authorization request or a pre-notification WAITING_AUTHORISATION_TO_VALIDATE: The transaction is waiting for an authorization request and must be validated WAITING_FOR_PAYMENT: Waiting for payment
21	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 vads_order_info, vads_order_info2, vads_order_info3 fields of the payment form. Via the attributes orderInfo, orderInfo2, orderInfo3 of the REST API metadata object. 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.
22	AUTORESPONSE_STATUS Type: VARCHAR \| Length: 255 Description: Delivery status of the IPN. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Values: FAILED: Failure of notification to the merchant server. SENT: Notification sent to the merchant server. UNDEFINED: An event has triggered the end of payment notification rule but the URL is not configured. E.g.: SENT
23	ORDER_ID Type: VARCHAR \| Length: 255 Description: Order number generated by the merchant website. Hosted Payment Form equivalent: vads_order_id REST API equivalent: orderDetails.orderId E.g.: CX-1254
24	CUSTOMER_ID Type: VARCHAR \| Length: 255 Description: Customer reference generated by the merchant website. Hosted Payment Form equivalent: vads_cust_id REST API equivalent: customer.reference E.g.: C2383333540
25	CUSTOMER_IP_ADDRESS Type: VARCHAR \| Length: 255 Description: Buyer IP address. Hosted Payment Page equivalent: N/A REST API equivalent: customer.extraDetails.ipAddress E.g.: 185.244.73.2
26	ACCOUNT_SERIAL Description: Token followed by the potential subscription number, separated by a hyphen “-”. Hosted Payment Page equivalent: vads_identifier “-” vads_subscription REST API equivalent: paymentMethodToken "-" subscriptionId E.g.: 5fa8d3dede8f4c219c4652dfabe2bf55-20191106ANav0o
27	TRANSACTION_CONDITION Type: VARCHAR \| Length: 255 Description: 3D Secure authentication result. Hosted Payment Page equivalent: N/A REST API equivalent: N/A Values: 3D_SUCCESS: The merchant and the cardholder have enabled 3D Secure and the card has been successfully authenticated. 3D_FAILURE: The merchant and the buyer have enabled 3D Secure but the authentication has failed. 3D_ERROR: The merchant has enabled 3D Secure but a technical issue has occurred. 3D_NOTENROLLED: The merchant has enabled 3D Secure but the buyer is not enrolled. 3D_ATTEMPT: The merchant and the cardholder have enabled 3D Secure but the cardholder was unable to authenticate. SSL: The cardholder has not authenticated: either the card type is not supported by 3D Secure, or the merchant/cardholder has not enabled 3D Secure E.g.: 3D_SUCCESS
28	CAVV_UCAF Type: VARCHAR \| Length: 255 Description: 3D Secure transaction certificate. Hosted Payment Form equivalent: vads_threeds_cavv REST API equivalent: transactionDetails.cardDetails.authenticationResponse.value.authenticationValue.value E.g.: Q**************************=
29	COMPLEMENTARY_INFO Type: VARCHAR \| Length: 255 Description: Details of the risk assessment result. Option reserved to the merchants who have enabled the Risk management module. Hosted Payment Form equivalent: vads_risk_control REST API equivalent: transactionDetails.fraudManagement.riskControl Values: CARD_COUNTRY=XXX: XXX corresponds to the country code in the ISO 3166 alpha-3 3166 format. MAESTRO=YES\|NO: indicates if the used payment method is a Maestro card. CAS=YES\|NO: indicates if the used payment method is a card with unconditional authorization. ECBL=YES\|NO: indicates if the used payment method is an eCarte-Bleue card. CCC=YES\|NO: indicates if an inconsistency between the country of the buyer, the payment method and the buyer’s IP address has been detected. BDOM: Label of the bank that issued the payment method. PRODUCTCODE: Card product. BANKCODE: Bank code. E.g.: MAESTRO=NO\|ECBL=NO\|PRODUCTCODE=MDS
30	BANK_RESPONSE_CODE Type: VARCHAR \| Length: 255 Description: Response code of the authorization request returned by the issuing bank. Hosted Payment Form equivalent: vads_auth_result REST API equivalent: transactionDetails.cardDetails.authorizationResponse.authorizationResult Values: See chapter List of authorization return codes. E.g.: 00
31	3D_LS Type: VARCHAR \| Length: 255 Description: 3D Secure payment guarantee. Hosted Payment Form equivalent: vads_warranty_result REST API equivalent: transactionDetails.liabilityShift Values: YES: Payment 3D Secure guaranteed. NO: Payment 3D Secure not guaranteed. UNKNOWN: Payment guarantee cannot be determined following a technical error. E.g.: YES
32	INFO_EXTRA Type: VARCHAR \| Length: 255 Description: Populated with customizable fields allowing to add details to the confirmation e-mail sent to the merchant and in the IPN URL (vads_ext_info_). Hosted Payment Form equivalent: vads_ext_info REST API equivalent: metadata E.g.: If vads_ext_info_key1=value1 and vads_ext_info_key2=value2,INFO_EXTRA is populated as follows: key1=value1\|key2 = value2

File sample

Download the sample pack: https://scelliuspaiement.labanquepostale.fr/doc/files/samples/sample-files.zip.

You will find a sample file in the JT folder.

Categories

Tags

Format