Format V1

The « TITRE » record

The TITRE record contains the wire transfer details. It is populated as follows:

Pos. Description
01 RECORD_CODE

Type: VARCHAR | Length: 5

Description: Record code.

Value: TITRE

02 RECORD_DATE

Type: TIMESTAMP | Length: 17

Description: UTC date and time of dispatch in the ISO 8601 format.

E.g.: 2020-01-15T16:53Z

03 Version

Type: VARCHAR | Length: 255

Description: Version of the reconciliation report.

E.g.: TABLE_JRFI_V1

04 ENTITY_CODE

Type: VARCHAR| Length: 255

Description: Lyra Collect Customer Code.

E.g.: CLXXXXXX

05 ACTIVITY

Type: VARCHAR | Length: 255

Description: The shop name in capital letters, as defined in the Expert Back Office.

Potential space characters are replaced by the “_” character

E.g.: DEMO_STORE

06 CURRENCY

Type: VARCHAR | Length: 3

Description: Currency code.

Value: EUR

07 WIRE_IBAN

Type: VARCHAR | Length: 255

Description: IBAN that received the wire transfer.

E.g.: FR76XXXXXXXXXXXXXXXXXXX3739

08 WIRE_REFERENCE

Type: VARCHAR | Length: 255

Description: Wire transfer reference.

E.g.: LYRA COLLECT 19100253200018

09 WIRE_AMOUNT

Type: NUMERIC | Length: 13

Description: Wire transfer amount.

E.g.: 3000 for 30,00 EUR

10 WIRE_EXECUTION_DATE

Type: DATE | Length: 10

Description: Date of the wire transfer.

E.g.: 2019-10-23

The « ENTETE » and « DETAILS » records

Pos. Description
01 RECORD_CODE

Type: VARCHAR | Length: 6

Description: Record code.

Value: DETAIL

02 TYPE_OPERATION

Type: VARCHAR | Length: 255

Description: Operation reference.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Values:
  • DEBIT: Payment
  • REFUND: Refund
  • CHARGEBACK: Chargeback
  • TRANSFERT_INT: Internal transfer between a sub-merchant and a MarketPlace agent
  • OTHER_OPERATIONS: Other operations (chargeback dispute, chargeback refund etc.)

E.g.: DEBIT

03 OPERATION_TYPE

Type: VARCHAR | Length: 2

Description: Operation code.

Hosted Payment Page equivalent: vads_operation_type

REST API equivalent: operationType

Values:
  • DT: Debit
  • CT: Credit

E.g.: DT

04 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

05 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

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

  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.: 3000 for 30,00 EUR

08 ORIGIN_CURRENCY_CODE

Type: VARCHAR | Length: 3

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

Hosted Payment Page equivalent: vads_currency

REST API equivalent: currency

E.g.: EUR

09 MERCHANT_ID

Type: VARCHAR | Length: 255

Description: Legal identifier of the company.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Value:

0+Legal Identifier

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

E.g.: 045251785700028

10 CONTRACT

Type: VARCHAR | Length: 255

Description: Merchant ID number.

Hosted Payment Page equivalent: vads_contract_used

REST API equivalent: transactionDetails.mid

E.g.: 0535875

11 PAYMENT_DATE

Type: TIMESTAMP | Length: 17

Description: Date and time of the payment (ISO 8601 standard), in UTC time zone.

Hosted Payment Page equivalent: vads_effective_creation_date

REST API equivalent: creationDate

E.g.: 2020-01-07T13:33Z

12 TRANSACTION_ID

Type: VARCHAR | Length: 255

Description: Transaction identifier.

Hosted Payment Page equivalent: vads_trans_id

REST API equivalent: cardDetails.legacyTransId

E.g.: xrT15p

13 OPERATION_NUMBER

Type: VARCHAR | Length: 255

Description: Number of the transaction sequence for payments in installments or split payments.

Empty for single payments.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 2

14 TRANSACTION_UUID

Type: VARCHAR | Length: 255

Description: Unique transaction ID.

Hosted Payment Page equivalent: vads_trans_uuid

REST API equivalent: uuid

E.g.: e078b7a6a01c494eae6afd52c4ea2bee

15 PAYMENT_METHOD

Type:VARCHAR | Length: 255

Description: Payment method.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.:
  • MANDATE: Payment by SEPA direct debit
  • CARD: Payment by credit card
  • ELECTRONIC_MONEY: Payment by wallet (PayPal, Alipay, etc.)
  • CREDIT_TRANSFERT: Wire transfer (Sofort, iDeal, etc.)
16 CARD_SCHEME

Type: VARCHAR | Length: 1

Description: Card scheme. The field is empty if it is not transmitted by the acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Values:
  • 1: CB
  • 2: VISA
  • 3: MCI
  • 4: ECI
  • 9: Undetermined (CB or VISA)

E.g.: 1

17 CARD_NATURE

Type: VARCHAR | Length: 1

Description: Nature of the card. Empty field if not provided by acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Values:
  • P : Consumer Card
  • E : Commercial Card

E.g.: P

18 CARD_PRODUCT_CATEGORY

Type: VARCHAR | Length: 1

Description: Card product category.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Values:
  • C: CREDIT
  • D: DEBIT
  • P: PREPAID

E.g.: D

19 CARD_HOLDER_COUNTRY_CODE

Type: VARCHAR | Length: 3

Description: Country code (ISO 3166 alpha-3 standard) of the card. Empty field if not provided by acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: FRA for France

20 TRANSACTION_REGIONALITY

Type: VARCHAR | Length: 255

Description: Geographic area of the payment. Empty field if not provided by acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

Values:
  • FRA: Domestic
  • UE: Inside EU
  • HUE: Outside EU

E.g.: FRA

21 REMITTANCE_DATE

Type: TIMESTAMP | Length: 17

Description: Date and time (ISO 8601 standard) of the capture in UTC time zone.

Hosted Payment Page equivalent: N/A

REST API equivalent: transactionDetails.cardDetails.captureResponse.captureDate

E.g.: 2020-01-07T23:05Z

22 REMITTANCE_NB

Type: VARCHAR | Length: 255

Description: Capture number.

Hosted Payment Page equivalent: N/A

REST API equivalent: transactionDetails.cardDetails.captureResponse.captureFileNumber

E.g.: 22

23 CAPTURE_DATE

Type:TIMESTAMP | Length: 17

Description: Date and time (ISO 8601 standard) of dispatch at the requested bank.

Hosted Payment Page equivalent: vads_presentation_date

REST API equivalent: transactionDetails.cardDetails.expectedCaptureDate

E.g.: 2020-01-07T23:05Z

24 BRUT_AMOUNT

Type: NUMERIC | Length: 13

Description: Gross amount of a captured transaction (expressed in the smallest currency unit).

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

25 NET_AMOUNT

Type: NUMERIC | Length: 13

Description: Net amount (expressed in the smallest currency unit) credited to the merchant account.

Specified only if the reconciliation is performed automatically and if the acquirer transmits the information.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

26 SETTLEMENT_CURRENCY

Type:VARCHAR | Length: 3

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

Hosted Payment Page equivalent: vads_currency

REST API equivalent: currency

E.g.: EUR

27 VALUE_DATE

Type: DATE | Length: 10

Description: Value date in YYYY-MM-DD format.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 2020-01-14

28 COMMISSION_AMOUNT

Type:NUMERIC | Length: 13

Description: Pre-tax amount of the acquirer’s commission.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

29 INTERCHANGE_CHARGE_AMOUNT

Type: NUMERIC | Length: 13

Description: Amount of the exchange fees. Empty field if not provided by acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

30 SCHEME_CHARGE_AMOUNT

Type: NUMERIC | Length: 13

Description: Amount of the network commission. Empty field if not provided by acquirer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

31 BANK_CHARGE_AMOUNT

Type:NUMERIC | Length: 13

Description: Amount of acquirer’s fees.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

32 WIRE_REFERENCE

Type:VARCHAR | Length: 255

Description: Wire transfer reference.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: LYRA_COLLECT_xxxxx

33 WIRE_IBAN

Type: VARCHAR | Length: 255

Description: IBAN that received the wire transfer.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: FR76XXXXXXXXXXXXXXXXXXX3739

34 WIRE_EXECUTION_DATE

Type: DATE | Length: 10

Description: Date of wire transfer execution in YYYY-MM-DD format.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 2020-01-16

35 ORIGINAL_TRANSACTION_UUID

Type: VARCHAR | Length: 255

Description: Unique ID of the initial transaction.

UUID of the initial transaction in case of refund.

Hosted Payment Page equivalent: N/A

REST API equivalent: transactionDetails.parentTransactionUuid

E.g.: 31c1d62734ef479f87cfd30bef8c7e01

36 CHARGEBACK_REASON

Type:VARCHAR | Length: 255

Description: Reasons for chargeback.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

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

37 MKP_OPERATOR_SALES_AMOUNT

Type: NUMERIC | Length: 13

Description: Amount of sales by the operator.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

38 MKP_OPERATOR_FEE_AMOUNT

Type: NUMERIC | Length: 13

Description: Amount of operator’s commission.

Hosted Payment Page equivalent: N/A

REST API equivalent: N/A

E.g.: 3000 for 30,00 EUR

39 DATA_COMP_1

Type: VARCHAR | Length: 255

Description: Reserved for future use

40 DATA_COMP_2

Type: VARCHAR | Length: 255

Description: Reserved for future use

41 DATA_COMP_3

Type: VARCHAR | Length: 255

Description: Reserved for future use

42 DATA_COMP_4

Type: VARCHAR | Length: 255

Description: Reserved for future use

43 DATA_COMP_5

Type: VARCHAR | Length: 255

Description: Reserved for future use

44 DATA_COMP_6

Type: VARCHAR | Length: 255

Description: Reserved for future use

45 DATA_COMP_7

Type: VARCHAR | Length: 255

Description: Reserved for future use

46 DATA_COMP_8

Type: VARCHAR | Length: 255

Description: Reserved for future use

47 DATA_COMP_9

Type: VARCHAR | Length: 255

Description: Reserved for future use

48 DATA_COMP_10

Type: VARCHAR | Length: 255

Description: Reserved for future use

49 DATA_COMP_11

Type: VARCHAR | Length: 255

Description: Reserved for future use

50 DATA_COMP_12

Type: VARCHAR | Length: 255

Description: Reserved for future use

51 DATA_COMP_13

Type: VARCHAR | Length: 255

Description: Reserved for future use

52 DATA_COMP_14

Type: VARCHAR | Length: 255

Description: Reserved for future use

53 DATA_COMP_15

Type: VARCHAR | Length: 255

Description: Reserved for future use

54 DATA_COMP_16

Type: VARCHAR | Length: 255

Description: Reserved for future use

55 DATA_COMP_17

Type: VARCHAR | Length: 255

Description: Reserved for future use

56 DATA_COMP_18

Type: VARCHAR | Length: 255

Description: Reserved for future use

57 DATA_COMP_19

Type: VARCHAR | Length: 255

Description: Reserved for future use

58 DATA_COMP_20

Type: VARCHAR | Length: 255

Description: Reserved for future use

The “FIN” record

Indicates the number of the DETAIL record lines and specifies the different totals that allow to justify the amount of the wire transfer.

Pos. Description
01 RECORD_CODE

Type: VARCHAR | Length: 3

Description: Record code

Value: FIN

02

LINES_NUMBER

Type: VARCHAR | Length: 255

Description: Number of the detail record lines.

E.g.: 5

03 SALES_AMOUNT

Type: NUMERIC | Length: 13

Description: Sales amount.

E.g.: 3000 for 30,00 EUR

04 CHARGEBACK_AMOUNT

Type:NUMERIC | Length: 13

Description: Chargeback amount.

E.g.: 3000 for 30,00 EUR

05 REFUND_AMOUNT

Type:NUMERIC | Length: 13

Description: Refund amount.

E.g.: 3000 for 30,00 EUR
06 FEES_TTC_AMOUNT

Type:NUMERIC | Length: 13

Description: Post-tax amount of Lyra Collect commissions.

E.g.: 3000 for 30,00 EUR

07 FEES_HT_AMOUNT

Type:NUMERIC | Length: 13

Description: Pre-tax amount of Lyra Collect commissions.

E.g.: 3000 for 30,00 EUR

08 FEES_VAT_AMOUNT

Type:NUMERIC | Length: 13

Description: VAT amount of Lyra Collect commissions.

E.g.: 3000 for 30,00 EUR

09 LITIGATION_AMOUNT

Type:NUMERIC | Length: 13

Description: Amount of disputes.

E.g.: 3000 for 30,00 EUR

10 HOLDBACK_AMOUNT

Type:NUMERIC | Length: 13

Description: Amount of security deposits.

E.g.: 3000 for 30,00 EUR

11 MISC_OPERATIONS_AMOUNT

Type: NUMERIC | Length: 13

Amount of miscellaneous operations (chargeback refund or new chargeback presentation).

E.g.: 3000 for 30,00 EUR

12 MKP_OPERATOR_SALES_AMOUNT

Type: NUMERIC | Length: 13

Description: Operator’s own sales amount (for MarketPlace agents).

E.g.: 3000 for 30,00 EUR

13 MKP_OPERATOR_FEE_AMOUNT

Type: NUMERIC | Length: 13

Description: Operator’s own commission amount (for MarketPlace agents).

E.g.: 3000 for 30,00 EUR

Example of a file

Download the pack of examples: https://lyra.com/doc/files/samples/sample-files.zip.

You will find a sample file in the JRFI folder.