V1 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 Sent on (YY/MM/DD) 1/20/2014
04 Version V1
05 File description LES IMPAYÉS RAPPROCHÉS DU JOUR

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

Pos. Description
01 ENTETE

Type: VARCHAR | Length: 6

Description: Record code.

Value: DETAIL

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.: FR for 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 CONTRACT

Type: VARCHAR | Length: 255

Description: Merchant ID number.

Hosted Payment Page equivalent: vads_contract_used

REST API equivalent: transactionDetails.mid

E.g.: 0535875

05 PAYMENT_DATE

Type: DATE | Length: 8

Description: Date and time of the payment.

Hosted Payment Page equivalent: vads_effective_creation_date

REST API equivalent: creationDate

E.g.: 20200107

06 TRANSACTION_ID

Type: VARCHAR | Length: 6

Description: Transaction identifier.

Hosted Payment Page equivalent: vads_trans_id

REST API equivalent: cardDetails.legacyTransId

E.g.: xrT15p

07 OPERATION_TYPE

Type: VARCHAR | Length: 1

Description: Type of operation.

Hosted Payment Page equivalent: vads_operation_type

REST API equivalent: operationType

Values:
  • D : Debit (purchase receipt)
  • C : Credit (credit receipt)

E.g.: D

08 SOURCE_AMOUNT

Type: NUMERIC | Length: 13

Description: Gross amount of the receipt.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

09 SIRET

Type: VARCHAR | Length: 255

Description: Legal identifier of the company.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Value:

SIRET (Système d'Identification du Répertoire des Etablissements)

E.g.: 045251785700028

10 UNPAID_NB

Type: NUMERIC | Length: 11

Description: Number of the chargeback file.

Always empty for transactions made within the GATECONEX network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 00000645948

11 UNPAID_CODE

Description: Code of the chargeback reason.

Always empty for transactions made within the GATECONEX network.

Always set to 45 for transactions made within the CB network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 45 (See Table of reasons for chargeback

12 CURRENCY_CODE

Type: NUMERIC | Length: 3

Description: Numeric code of the currency (ISO 4217 standard).

Hosted Payment Page equivalent: vads_currency

REST API equivalent: currency

E.g.: 978 for euro (EUR) (See chapter List of supported currencies).

13 CONTRACT_TYPE

Description: MID type.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Values:
  • 3 : payment made on one of the following networks: CB, AMEX, GATECONEX.
  • empty: payment made within the network PAYPAL

E.g.: 3

14 POS_NB

Type: NUMERIC | Length: 8

Description: Number of the point of sale.

Hosted Payment Page equivalent: vads_site_id

REST API equivalent: shopId

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

E.g.: 12345678

15 REMITTANCE_DATE

Description: Capture date.

Hosted Payment Page equivalent: N/A

REST API equivalent: transactionDetails.cardDetails.captureResponse.captureDate

E.g.: 20200107

16 EXCHANGE_AMOUNT

Type: NUMERIC | Length: 13

Description: Amount of the invoice in counter currency. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

17 VALUE_DATE

Description: Value date. Empty field if not provided by acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 20200114

18 UNPAID_AMOUNT

Type: NUMERIC | Length: 13

Description: Chargeback amount.

Always empty for transactions made within the GATECONEX network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

19 EXCHANGE_UNPAID_AMOUNT

Type: NUMERIC | Length: 13

Description: Amount of the non-payment in counter currency. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

20 EXCHANGE_CURRENCY_CODE

Type: NUMERIC | Length: 3

Description: Numeric code of the counter currency (ISO 4217 standard). Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 978 for euro (EUR) (See chapter List of supported currencies).

21 CHARGED_BANK_CODE

Type: NUMERIC | Length: 5

Description: Bank code to apply. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 14707

22 CHARGED_COUNTER

Type: NUMERIC | Length: 5

Description: Original counter code. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 00070

23 CHARGED_ACCOUNT

Description: Account number. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 01234567890

24 CHARGED_ADMIN_ACCOUNT

Type: NUMERIC | Length: 5

Description: Administrator account. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 00070

25 PBA_REMIT_NB

Type: NUMERIC | Length: 6

Description: PBA capture number. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 123456

26 MATCH_STATUS

Description: Chargeback reconciliation status.

Values:
  • MATCH_OK : Reconciliation made
  • MATCH_ANALYSE : To be analyzed

Always set to MATCH_OK for transactions made within the AMEXGLOBAL network.

Always set to MATCH_OK for transactions made within the PAYPAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: MATCH_OK

27 CUSTOMER_ID

Description: Customer reference generated by the merchant website.

Hosted Payment Page equivalent: vads_cust_id

REST API equivalent: customer.reference

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

E.g.: C2383333540

28 ORDER_ID

Description: Order number generated by the merchant website.

Hosted Payment Page equivalent: vads_order_id

REST API equivalent: orderDetails.orderId

E.g.: CX-1254

29 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.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

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.
30 TRANSACTION_STATUS

Description: Status of the transaction.

Hosted Payment Page equivalent: vads_trans_status

REST API equivalent: detailedStatus

Values:
  • REFUSED : The transaction has been declined
  • 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.: CAPTURED

31 CURRENT_AMOUNT

Type: NUMERIC | Length: 13

Description: Current transaction amount. Corresponds to the captured amount minus the refunded amount or the amount waiting for refund.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

32 ORIGIN_AMOUNT

Type: NUMERIC | Length: 13

Description: Initial transaction amount

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

33 CARD_TYPE

Description: Card type.

Hosted Payment Page equivalent: vads_card_brand

REST API equivalent: transactionDetails.cardDetails.effectiveBrand

E.g.:
  • CB : Payment by CB card.
  • AMEX : Payment by American Express card.
  • PAYPAL : Payment via a PayPal account.
34 CHARGED_CARD_TYPE

Description: Type of chargeback.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Value: always empty.

35 UNPAID_SETTLE_DATE

Description: Non-payment settlement date. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 20200114

36 UNPAID_DOC_REASON

Description: Motive of document request. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.:

37 UNPAID_DOC_DATE

Description: Date of the initial documentation request. Empty field if not provided by acquirer.

Always empty for PayPal transactions.

Always empty for transactions made within the GATECONEX network.

Always empty for transactions made within the AMEXGLOBAL network.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 20200114

The “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 JRI folder.