Understanding the structure of a chargebacks reconciliation report

The "Titre" (Title) record

The Title record provides information about the file characteristics for a better identification. It is populated as follows:

Pos. Description Values
01 Record code TITRE
02 Shop name
03 Delivery date and time (YY/MM/DD_hh:mm:ss)
04 Version V1
05 File description CHARGEBACK RECONCILIATIONS OF THE DAY

The "Entête" (Header) and "Details" records

The Header lists the various labels to be populated in the report. The information in Details populates the labels of the Header record for each transaction. The possible labels and values are presented in the following table:

Pos. "Entête" (Header) record "Details" record
Label Description Possible value Meaning
01 ENTETE Record code DETAIL  
02 MERCHANT_COUNTRY Merchant's country   Example: FR for France
03 MERCHANT_ID Merchant ID   Examples:

0+SIRET (Business Directory Identification System) in France.

0+CRN (Company Registration Number) in United-Kingdom

0+NIF (Numero de Identificación Fiscal) in Spain

04 CONTRACT Merchant ID number    
05 PAYMENT_DATE Payment date YYYYMMDD format
06 TRANSACTION_ID Transaction identifier equivalent to vads_trans_id  
07 OPERATION_TYPE Type of operation DT Debit
CT Credit
08 SOURCE_AMOUNT Gross amount of the invoice    
09 SIRET Examples:

SIRET (Business Directory Identification System) in France.

CRN (Company Registration Number) in United-Kingdom

NIF (Numero de Identificación Fiscal) in Spain

   
10 UNPAID_NB Number of the non-payment folder    
11 UNPAID_CODE Code of the non-payment    
12 CURRENCY_CODE Code of the transaction currency  

See table vads_currency for more examples.

13 CONTRACT_TYPE Type of contract    
14 POS_NB Number of the point of sale    
15 REMITTANCE_DATE Capture date   YYYYMMDD format
16 EXCHANGE_AMOUNT Amount of the invoice in counter currency    
17 VALUE_DATE Date of the value   YYYYMMDD format
18 UNPAID_AMOUNT      
19 EXCHANGE_UNPAID_AMOUNT Amount of the non-payment in counter currency    
20 EXCHANGE_CURRENCY_CODE Currency code of the counter currency    
21 CHARGED_BANK_CODE Bank code to apply    
22 CHARGED_COUNTER Original counter code    
23 CHARGED_ACCOUNT Account number    
24 CHARGED_ADMIN_ACCOUNT Administrator account    
25 PBA_REMIT_NB PBA capture number    
26 MATCH_STATUS Reconciliation status MATCH_OK Reconciliation made
MATCH_ANALYSE To be analyzed
R_CHARGEBACK SEPA chargeback
27 CUSTOMER_ID Buyer ID   The value depends on the merchant's request
28 ORDER_ID Order reference  
29 RETURN_CONTEXT Context of a buyer's purchase  
30 TRANSACTION_STATUS Current transaction status    
31 CURRENT_AMOUNT Current transaction amount   The value is: the captured amount minus the refunded amount or the amount waiting for refund
32 ORIGIN_AMOUNT Initial transaction amount    
33 CARD_TYPE Card type   Example: CB, VISA, etc.
34 CHARGED_CARD_TYPE Type of non-payment  
35 UNPAID_SETTLE_DATE Non-payment settlement date   YYYYMMDD format
36 UNPAID_DOC_REASON Motive of the document request    
37 UNPAID_DOC_DATE Date of request for documentation   YYYYMMDD format

The "Fin" (End) record

Pos. Description Values
01 Record code FIN

Example of a file

This extract from the chargeback reconciliations report (JRI) shows:

  • a line of the Title record,
  • a line of the Header record,
  • two lines from the Details record each beginning with DETAIL,
  • a Fin (End) record line that marks the end of the document.
TITRE;PayZen;16/04/08_14:53:25;V1;LES IMPAYES RAPPROCHES DU JOUR;
ENTETE;MERCHANT_COUNTRY;MERCHANT_ID;CONTRACT;PAYMENT_DATE;TRANSACTION_ID;OPERATION_TYPE;
SOURCE_AMOUNT;SIRET;UNPAID_NB;UNPAID_CODE;CURRENCY_CODE;CONTRACT_TYPE;POS_NB;
REMITTANCE_DATE;EXCHANGE_AMOUNT;VALUE_DATE;UNPAID_AMOUNT;EXCHANGE_UNPAID_AMOUNT;
EXCHANGE_CURRENCY_CODE;CHARGED_BANK_CODE;CHARGED_COUNTER;CHARGED_ACCOUNT;
CHARGED_ADMIN_ACCOUNT;PBA_REMIT_NB;MATCH_STATUS;CUSTOMER_ID;ORDER_ID;RETURN_CONTEXT;
TRANSACTION_STATUS;CURRENT_AMOUNT;ORIGIN_AMOUNT;CARD_TYPE;CHARGED_CARD_TYPE;
UNPAID_SETTLE_DATE;UNPAID_DOC_REASON;UNPAID_DOC_DATE
DETAIL;FR;4,11111E+13;5555555;20141004;148413;D;1859;4,29423E+13;651380;45;EUR;3;58000502;
20141005;0;;1854;1854;;10107;175;524111114;175;833971;MATCH_OK;147581;148413;;CAPTURED;
1859;1859;CB;; ;;
DETAIL;FR;4,22222E+13;5444444;20140917;140331;D;719;4,29423E+13;651382;45;EUR;3;5800002;
20140918;0; ;718;718;;10107;175;524222224;175;733001;MATCH_OK;168357;140331;;CAPTURED;
719;719;CB;;  ;;
FIN;