General Notes

Purpose

The

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

Settlement File aggregates settlement data from various payment schemes as comma separated file in order to accommodate the reconciliation and reporting needs of our clients. Clearing and Settlement information are collected from the respective payment schemes, processors or acquiring organizations and matched with the transaction records on file at

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

.

Please note that

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

Settlement Files are generated in accordance with the frequency of clearing and settlement information made available with the relevant payment scheme(s), processor(s) or acquirer(s).

Please note that new record types can be added any time without previous notice.

Table of Contents

Supported Payment Schemes, Payment Methods and Acquirers

Multiexcerpt

MultiExcerptName	payment_schemes

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633600914692_-1540705053
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

Category / Kategorie	Scheme / Marke	Processor / Acquirer / Gateway
Credit Cards / Kreditkarten	American Express	American Express (EPA & GRRCN)
Credit Cards / Kreditkarten	*Multiple	AIBMS AsiaPay BNP ConCardis Elavon (EU & US) EVO (GICC) FirstData iCard JPMorgan Chase (Salem and Tampa) Lufthansa AirPlus OmniPay (EMS, Global Payments, Paysquare, Payvision) Paynetics Payone RBI SIX Payment Services Vantiv Wirecard Worldline
Bank Transfers / Überweisungen	iDEAL	(DB-Export)
Bank Transfers / Überweisungen	Paydirekt	Paydirekt
Alternatives	AfterPay/PayByBill	AfterPay/arvato
	Alipay	Alipay
	Amazon Pay	Amazon
	Barzahlen	Cash Payment Solutions
	BillPay	BillPay
	ChinaPay	ChinaPay
	Consors Finanz	BNP
	Klarna	Klarna
	Limonetik	Limonetik
	PayPal	PayPal
	SEPA Direct Debit	b4payment/SEPAexpress (and DB-Export)
	Trustly	Trustly
	WeChat	WeChat
	various	PagBrasil
	various	PayU
	various	PPRO Notice: In case of PPRO also failed payments will be reported in the Settlement file. With following characteristics the failed payment can be recognized: Faulty transactions are returned always with Transaction Date = 01.01.1970 01:00:00, Amount Capture = 0 and the fixed_fee designated.

Retrieval

Merchants may collect

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

Settlement Files at their own discretion from a

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

SFTP account. For configuration and account credentials please contact the

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Helpdesk-Name
PageWithExcerpt	Wording

.

File structure

Each Settlement File is structured into a header record, one or multiple detail records and a total record. The encoding for the line breaks is configurable at merchant level. Some fields may contain values of variable length. Where sizes are not given, a field size limitation does not apply.

Notation of data types

Table Filter

default	Beschreibung
isFirstTimeEnter	false
hideColumns	true
sparkName	Sparkline
hidePane	true
datepattern	dd M yy
id	1633600955170_1467821358
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND
separator	Point (.)
order	0

Multiexcerpt

MultiExcerptName	data_types

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633600955173_-623745922
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

Format	Description	Beschreibung
a	Alphabetic characters A-Z, a-z	alphabetische Zeichen A-Z, a-z
n	Numeric digits, 0-9	numerische Ziffern, 0-9
an	Alphanumeric characters A-Z, a-z, 0-9	alphanumerische Zeichen A-Z, a-z, 0-9
ans	Alphanumeric and special characters	alphanumerisch und Sonderzeichen
ns	Numeric and special characters	numerisch und Sonderzeichen
3	Fixed length data element of 3 characters	feste Länge mit 3 Stellen/Zeichen
..17	Variable length data element up to a maximum of 3 characters. The minimum length is defined by the specific requirements of the data element itself, but shall be at least 1 character.	variable Länge mit bis zu maximal 3 Stellen/Zeichen. Die Mindestlänge ist durch die spezifischen Anforderungen des Datenelements selbst vorgegeben, aber sollte mindestens 1 Zeichen betragen.
tstp	Timestamp, format: <DD.MM.YYYY hh:mm:ss>	Zeitstempel im Format: <TT.MM.JJJJ hh:mm:ss>

Data element directory

All data elements of the

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

Settlement File are listed in alphabetical order in the table below. Some of the elements may contain sub-fields that provide data which are specific to an individual payment method, payment scheme or processor. For further details on these data please refer to the original documentation of the acquirer / processor.

Table Filter

default	Beschreibung
isFirstTimeEnter	false
hideColumns	true
sparkName	Sparkline
hidePane	true
datepattern	dd M yy
id	1633600971794_1788919146
worklog	365\|5\|8\|y w d h m\|y w d h m
isOR	AND
separator	Point (.)
order	0

Multiexcerpt

MultiExcerptName	data_element_directory

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633600971795_910387940
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

Field name

Description

Beschreibung

ACQUIRER_FEE

Charges for the services of Acquirer

Gebühren für die Dienstleistungen des Acquirers

AUTHORIZATION_AMOUNT

Authorized amount in smallest unit of transaction currency (e.g. EUR Cent)

Autorisierter Betrag in der kleinsten Einheit der Transaktionswährung (z.B. EUR Cent)

CAPTURE_DATE

The date and time a transaction has been accepted by the acquirer / payment scheme for settlement, <DD.MM.YYYY hh:mm:ss>. If the time is not given it will be set to ‘00:00:00’.

Datum und Uhrzeit, wann eine Transaktion vom Aqcuirer / Zahlungssystem zum Settlement akzeptiert wurde im Format <DD.MM.YYYY hh:mm:ss>. Wenn die Zeit nicht angegeben ist, wird sie auf ‘00:00:00’ gesetzt.

COUNTER

Enumerator to ensure unique file names (left justified zero filled)

Zähler zur Gewährleistung eindeutiger Dateinamen (linksbündig, mit Nullen aufgefüllt)

CUSTOMER_INFO

Constructed field encompassing specific customer related information depending on the payment method. Sub-fields are divided by ‘#’ (U+0023) (Number Sign).

Konstruiertes Feld mit spezifischen kundenbezogenen Informationen je nach Zahlungsmethode. Unterfelder sind getrennt durch ‘#’ (U+0023) (Doppelkreuz).

EXTENDED_INFO

Constructed field encompassing additional information that is available depending on the payment method. Sub-fields are divided by ‘#’ (U+0023) (Number Sign).

Konstruiertes Feld mit zusätzlichen Informationen, die je nach Zahlungsmethode verfügbar sind. Unterfelder sind getrennt durch ‘#’ (U+0023) (Doppelkreuz).

FILE_CREATION_DATE

Date the

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

Settlement File was created, <DDMMYYYY>

Datum, wann das

Multiexcerpt include

SpaceWithExcerpt	DE
MultiExcerptName	Partner-Name
PageWithExcerpt	DE:Wording

Settlement-File erzeugt wurde, <DDMMYYYY>

INTERCHANGE_FEE

Fees charged by the card issuer

Vom Kartenaussteller berechnete Gebühren

MERCHANT_ID

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Partner-Name
PageWithExcerpt	Wording

merchant identification

Multiexcerpt include

SpaceWithExcerpt	DE
MultiExcerptName	Partner-Name
PageWithExcerpt	DE:Wording

Händleridentifikation

ORDER_DESCRIPTION

A description of the order the payment relates to

Eine Beschreibung der Bestellung, zu der die Zahlung gehört

PAYMENT_CREATION_DATE

Date and time the payment has been created, <DD.MM.YYYY hh:mm:ss>

Datum und Uhrzeit, wann die Zahlung angelegt wurde, <DD.MM.YYYY hh:mm:ss>

PAYOUT_DATE

Payout date by Payment Institution

Auszahlungsdarum des Zahlungsinstituts

PAYOUT_ID

Reference number of payout generated by Payment Institution

Referenznummer der Auszahlung, vom Zahlungsinstitut generiert

PROCESSING_FEE

Charges for the services of Processors (PSP, Gateway, Network Operator)

Gebühren für die Dienstleistungen der Prozessoren (PSP, Gateway, Netzbetreiber)

RECORD_COUNT

Total number of rows in detailed records section

Gesamtzeilenanzahl im Bereich der detaillierten Datensätze

RECORD_TYPE

Header record

Identifies the respective entry as header record, value ‘100’.

Detail record

Identifier that specifies the payment method and type of account ledger entry (e.g. debit and credit). Charges to customers are indicated as debits and payments to customers as credits.

Totals record

Identifies the respective entry as totals record, value ‘900’.

Header-Datensatz

Kennzeichnet den betreffenden Eintrag als Header-Datensatz, Wert ‘100’.

Detail-Datensatz

Bezeichner der bestimmten Zahlungsmethode und Art des Buchungskonteneintrags (z.B. Belastung und Gutschrift). Gebühren der Kunden werden als Belastungen und Zahlungen an Kunden als Gutschriften gekennzeichnet.

Gesamtsummen-Datensatz

Kennzeichnet den betreffenden Eintrag als Gesamt-Datensatz, Wert ‘900’.

REFERENCE

The Reference Number is a unique string submitted by the merchant in order to identify a payment (e.g. invoice number, ticket number etc.). It usually gets forwarded to the payment scheme and is echoed in the clearing records / reports so that it can be matched with submitted transactions.

Die Referenznummer ist eine eindeutige Zeichenkette des Händlers zum Identifizieren einer Zahlung (z.B. Rechnungsnummer, Ticket-Nummer usw.). Sie wird normalerweise an das Zahlungssystem weitergeleitet und in den Abrechnungsdaten / Berichten wiedergegeben, so dass ein Abgleich mit eingereichten Transaktionen möglich ist.

SCHEME_FEE

Fee charged by the card organization

Von der Kartenorganisation berechnete Gebühr

STATUS

The status of the payment, currently always ‘OK’

Der Status der Zahlung, derzeit immer ‘OK’

TOTAL_AMOUNT

Sum of all transaction amounts (credits are also summed up to the total amount) in the detailed record section in the smallest unit of transaction currency (e.g. EUR Cent)

Summe aller Transaktionsbeträge (Gutschriften werden ebenfalls für den Gesamtbetrag summiert) im Bereich der Detail-Datensätze in der kleinsten Einheit der Transaktionswährung (z.B. EUR Cent)

TRANSACTION_AMOUNT

The amount that has been processed by the payment scheme in smallest unit of the transaction currency (e.g. EUR Cent)

Vom Zahlungssystem verarbeiteter Betrag in der kleinsten Einheit der Transaktionswährung (z.B. EUR Cent)

TRANSACTION_CURRENCY

Refers to the three-letter ISO 4217 currency code of the currency in which the transaction was processed

Dreistelliger Währungscode gemäß ISO 4217 für die Währung, in der die Transaktion verarbeitet wurde

TRANSACTION_ID

Unique reference submitted by the merchant in order to recognize a payment for an order. It might be shared across a sequence of related transactions (requests) that constitute a payment (e.g. authorization, capture, credit, etc).

Eindeutige vom Händler übergebene Referenz, um eine Zahlung einer Bestellung zuzuordnen. Sie kann über eine Folge zugehöriger Transaktionen (Anfragen) ausgetauscht werden, die eine Zahlung ausmachen (z.B. Autorisierung, Buchung, Gutschrift usw.).

File names

Naming convention: <MERCHANT_ID>#<FILE_CREATION_DATE>#<COUNTER>.cts

Multiexcerpt

MultiExcerptName	file_names

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633600987987_912998823
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No.	Element	Format	Example / Beispiel
1	MERCHANT_ID	an..20	ACME01
2	FILE_CREATION_DATE	N8	20141014
3	COUNTER	N3	001

File name example: ACME01#20201014#001.ctsf

Records

Header record

Multiexcerpt

MultiExcerptName	header_record

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601000481_1728622465
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No	Field name / Feldname	Format	Example / Beispiel
1	RECORD_TYPE	N3	100
2	MERCHANT_ID	An..30	ACME01
3	DATE	N8	20200424
4	VERSION	An..4	1.0

Detail record

Version 1.0

Multiexcerpt

MultiExcerptName	detail_record10

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601019793_857706915
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No	Element	Format	Example / Beispiel
1	RECORD_TYPE	N3	510
2	TRANSACTION_ID	An..64	890_XUoqyBWuGw
3	TRANSACTION_CURRENCY	A3	EUR
4	AUTHORIZATION_AMOUNT	N..12	789
5	TRANSACTION_AMOUNT	N..12	700
6	PAYMENT_CREATION_DATE	Tstp	20.04.2020 14:18:23
7	STATUS	An..	OK
8	REFERENCE	An..30	qArxtOE4w3FsSX5
9	CUSTOMER_INFO	Ans..160	4111xxxxxxxx9996#VISA
10	CAPTURE_DATE	Tstp	24.04.2020 00:00:00
11	ORDER_DESCRIPTION	Ans..384	Monthly subscription fee to ACME TV
12	EXTENDED_INFO	Ans..	1.875#EUR

Version 1.1 [1]

Multiexcerpt

MultiExcerptName	detail_record11

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601019794_889469644
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No	Element	Format	Example / Beispiel
1	RECORD_TYPE	N3	510
2	TRANSACTION_ID	An..64	890_XUoqyBWuGw
3	TRANSACTION_CURRENCY	A3	EUR
4	AUTHORIZATION_AMOUNT	N..12	789
5	TRANSACTION_AMOUNT	N..12	700
6	PAYMENT_CREATION_DATE	Tstp	20.04.2020 14:18:23
7	STATUS	An..	OK
8	REFERENCE	An..30	qArxtOE4w3FsSX5
9	CUSTOMER_INFO	Ans..160	4111xxxxxxxx9996#VISA
10	CAPTURE_DATE	Tstp	24.04.2020 00:00:00
11	ORDER_DESCRIPTION	Ans..384	Monthly subscription fee to ACME TV
12	EXTENDED_INFO	Ans..20	1.875#EUR
13	INTERCHANGE_FEE	Ans..20	1.875#13#EUR
14	SCHEME_FEE	Ans..20	1.875#13#EUR
15	ACQUIRER_FEE	Ans..20	1.875#13#EUR
16	PROCESSING_FEE	Ans..20	1.875#13#EUR

Version 1.2 [2]

Multiexcerpt

MultiExcerptName	detail_record12

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601019796_1451128252
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No	Element	Format	Example / Beispiel
1	RECORD_TYPE	N3	510
2	MERCHANT_ID	An..20	ACME01
3	TRANSACTION_ID	An..64	890_XUoqyBWuGw
4	TRANSACTION_CURRENCY	A3	EUR
5	AUTHORIZATION_AMOUNT	N..12	789
6	TRANSACTION_AMOUNT	N..12	700
7	PAYMENT_CREATION_DATE	Tstp	20.04.2020 14:18:23
8	STATUS	An..	OK
9	REFERENCE	An..30	qArxtOE4w3FsSX5
10	CUSTOMER_INFO	Ans..160	4111xxxxxxxx9996#VISA
11	CAPTURE_DATE	Tstp	24.04.2020 00:00:00
12	ORDER_DESCRIPTION	Ans..384	Monthly subscription fee to ACME TV
13	EXTENDED_INFO	Ans..20	1.875#EUR
14	INTERCHANGE_FEE	Ans..20	1.875#13#EUR
15	SCHEME_FEE	Ans..20	1.875#13#EUR
16	ACQUIRER_FEE	Ans..20	1.875#13#EUR
17	PROCESSING_FEE	Ans..20	1.875#13#EUR

Version 1.3 [3]

Multiexcerpt

MultiExcerptName	detail_record13

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601019797_495614313
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No	Element	Format	Example / Beispiel
1	RECORD_TYPE	N3	510
2	TRANSACTION_ID	An..64	890_XUoqyBWuGw
3	TRANSACTION_CURRENCY	A3	EUR
4	AUTHORIZATION_AMOUNT	N..12	789
5	TRANSACTION_AMOUNT	N..12	700
6	PAYMENT_CREATION_DATE	Tstp	20.04.2020 14:18:23
7	STATUS	An..	OK
8	REFERENCE	An..30	qArxtOE4w3FsSX5
9	CUSTOMER_INFO	Ans..160	4111xxxxxxxx9996#VISA
10	CAPTURE_DATE	Tstp	24.04.2020 00:00:00
11	ORDER_DESCRIPTION	Ans..384	Monthly subscription fee to ACME TV
12	EXTENDED_INFO	Ans..20	1.875#EUR
13	PAYOUT_ID	Ans..	1586789310000001
14	PAYOUT_DATE	N8	20.04.2020

PAYOUT elements are available for:

AIBMS
AirPlus
Amex (EPA and GRRCN)
PayOne
Concardis
Elavon
Klarna
PPRO
Wirecard

Version 1.4 [4]

Like V1.0 but with settlement and DCC data added in EXTENDED_INFO:

<EXTENDED_INFO>#
settlementamount=<SETTLEMENT_AMOUNT>#
settlementcurrency=<SETTLEMENT_CURRENCY>#
dccRate=<DCC_RATE>#
dccMargin=<DCC_MARGIN>

Without DCC only settlement information is provided.

[1] IC++ elements are only available if provided by acquiring bank
[2] IC++ elements are only available if provided by acquiring bank
[3] PAYOUT elements are only available if provided by acquiring bank
[4] settlement and DCC elements are only available if provided by acquiring bank

Total record

Multiexcerpt

MultiExcerptName	total_record

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601033048_-701521086
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

No	Element	Format	Example / Beispiel
1	RECORD_TYPE	N3	900
2	RECORD_COUNT	N..5	36
3	TOTAL_AMOUNT	N..12	798960

Additional informations

Field "Customer_Info"

Multiexcerpt

MultiExcerptName	customer_info

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601059282_-276549633
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

Payment method / Zahlungsart	Structure, Comment / Aufbau, Anmerkung	Example / Beispiel
AFTERPAY	[Customer_ID]	8902265613
ALIPAY cross-border	-
ALIPAY domestic	[Customer_ID]	John.doe@gmail.com
AMAZON PAY	[Customer_Name]# [Customer_E-Mail]	John Doe# john.doe@gmail.com
BARZAHLEN	[Customer_E-Mail]# [Shop_URL]	john.doe@gmx.de
BILLPAY	[Merchant_Customer_ID]# [Billpay_Customer_ID]# [Claim_ID]# [Activation_Date]# [Due_Date]# [Customer_Country]	184614# 836758# 1092900# 08.09.2020 00:00:00# 24.09.2020 00:00:00# DEU
CHINAPAY	-
CONSORSFINANZ	[Customer_E-Mail]	john.doe@gmx.de
CREDIT CARD	Masked card number or card token and card brand: [0000xxxxxxxx0000]# [Brand]	4111xxxxxxxx9996# Visa
DIRECT DEBIT	[Account_Holder]# [Account_Number]# [Bank_ Code]# [Bank] or [Account_Holder]# [IBAN]# [BIC]# [Bank] or [IBAN]# [BIC]	John Doe# 10602437# 205950# Barclays or John Doe# GB58BARC20595010602437# BARCGB22# Barclays or GB58BARC20595010602437# BARCGB22
IDEAL	[Account_Holder]# [IBAN]# [BIC]# [Bank]	John Doe# NL12RABO0388375809# RABONL2U# Rabobank
KLARNA	[OCR_No]# [Invoice_No]	1834143680436# 519072450221831988
LIMONETIK	[Customer_E-Mail]	john.doe@gmail.com
PAGBRASIL	[Customer_Name]# [Customer_E-Mail]	John Doe# john.doe@bol.com.br
PAYDIREKT	[Customer_BankID]	eba960e5-dd37-4d82-b479-ae3d28205994
PAYPAL	[Payer_ID]# [Payer]	A59XV256BZ# john.doe@gmx.de
PAYU	[Customer_Name]# [Customer_E-Mail]	MAGDALENA WITKOWSKA# magdalena.witkowska@interia.pl
PPRO	-
SOFORT (KLARNA SOFORT)	see DIRECT DEBIT	see DIRECT DEBIT
TRUSTLY	[Customer_Country]# [Customer_First_Name]# [Customer_Last_Name]#	SE# John# Doe
WECHAT	[Customer_ID]	oi_9HxKIOVS8zYdRxIbV7Ctr5u5U

Field "Extended_Info"

Multiexcerpt

MultiExcerptName	extended_info

Table Transformer

dateFormat	dd M yy
export-word	false
show-source	false
export-csv	false
id	1633601083591_1800223166
transpose	false
worklog	365\|5\|8\|y w d h m\|y w d h m
separator	.
export-pdf	false
sql	SELECT * FROM T*

Payment method / Zahlungsart

Structure, Comment / Aufbau, Anmerkung

Example / Beispiel

AFTERPAY

[Invoice_No]

61075095

ALIPAY cross-border

[Merchant_Discount]

2.25

ALIPAY domestic

[Merchant_Discount_Rate]#
[Merchant_Discount]

0.014#
9.87

AMAZON PAY

[SellerOrderId]#
[SellerReferenceId]#
[AmazonOrderReferenceId]#
[AmazonTransactionId]#
[TotalTransactionFee]

BARZAHLEN

[Merchant_Discount]#
[VAT]

2.469#
0.46911

BILLPAY

[Portal_ID]#
[Merchant_Discount_Type]#
[Merchant_Discount_Rate]#
[Merchant_Discount]

4151#
3#
0.0135#
2.07

CHINAPAY

[Merchant_Discount]#[Currency]

10.00#CNY

CONSORSFINANZ

[Transaction_ID]

20190829151556284574

CREDIT CARD [5]

[Merchant_Discount_Rate]#
[Merchant_Discount]#
[Currency]

CHARGEBACK

[ARN]#
[Reason_Code]#
[Status]

RETRIEVAL REQUEST

[ARN]#
[Reason_Code]#
[Status]

TC40/SAFE

[ARN]#
[Code]#

1.875#
1.95#
EUR

74527646319021051645048#
0350#
MI1

74627546887030655470117#
6

DIRECT DEBIT

[PmtInfId]

or

[Mandate_ID]#[IP address]

Chargeback [6]

[reasonCode]#[trigger]#[token]

reasonCode -

4 digit SEPA reason code

trigger -

“CHB” = Chargeback
“B1”..”B3” = CB after 1st, 2nd or 3rd retry

token -

ACT - CB was initiated by the customer
RFND - CB was initiated by the merchant
FRM - format error
NSF - no sufficient

5e736c2d718843149b71e3439b292dfe

reasonCode=MD17#trigger=CHB#token=NSF

IDEAL

NL#
[IP address]

NL#
82.151.44.149

KLARNA

[Merchant_Discount]

3.97

LIMONETIK

“paytype=“[Brand]#
“PaymentOrderId=”[OrderId]#
“fee=”[Fee]

FEE

“paytype=“[Brand]#
“PaymentOrderId=”[OrderId]#
“type=“[Type]

paytype=FacilyPay 3xCB#
PaymentOrderId=465224938699#
fee=2.64

paytype=FacilyPay 3xCB#
PaymentOrderId=162741148844#
type=Charge

PAGBRASIL

[Pymt_Mthd]#
[Settled_Amount]#
[Merchant_Discount]#
[Pymt_Date]

CHARGEBACK

[Pymt_Mthd]#
[Settled_Amount]#
[CB_Date]#
[Pymt_Date]

Boleto bancário#
129.9#
22.9#
04/15/2020

Credit card#
0#
16/05/20#
03/09/2020

PAYDIREKT

[correlationId]#
[endToEndReferenceNumber]#
[paymentInformationId]

113811779-00000001#
PD29AC32139C0F40F4B2541287900138D6#
GIMBPROVDR20161201000000021579

PAYPAL

[Merchant_Discount]#
[Currency]#
[Transaction_Type (credit / debit)]

203#
EUR#
CR

PAYU

[Order_ID]#
[Trans_ID]#
[Merchant_Discount]

[P6061489]#
[608365647]#
[1.25]

PPRO

Credit
[Channel]#
[TAG]#
[Country]#
[Selling_Point]#
fixed_fee=[FIXED_FEE_AMOUNT]#
fixed_fee_currency=[FIXED_FEE_CURRENCY]#
external_fee=[EXTERNAL_FEE_AMOUNT]#
external_fee_currency=[EXTERNAL_FEE_CURRENCY]#
minimum_discount_fee=[MINIMUM_DISCOUNT_FEE_AMOUNT]#
discount_rate=[DISCOUNT_RATE]

Channel From payment scheme or provided by merchant. This is individually handled but usually we use the value "testchannel" for test accounts and "livechannel" for live accounts.

TAG Depends on payment scheme provided by

Multiexcerpt include

SpaceWithExcerpt	EN
MultiExcerptName	Platform-Kurz
PageWithExcerpt	Wording

(has to be arranged with PPRO). This is individually handled. The most current list will get distributed during the integration process.

ideal
p24
sepadirectdebit
sofort
yellowpay
…
Country Parameter AddrCountryCode provided in merchant request

SellingPoint Provided by merchant

Chargeback
[Chargeback_ID]#
[Chargeback_Reason_Code]#
[Chargeback_RefNumber]

livechannel#
ideal#
NL#
T63542#
fixed_fee=0.45#
fixed_fee_currency=EUR#
external_fee=0.00#
external_fee_currency=EUR#
minimum_discount_fee=0.00#
discount_rate=0

1055329#
MD06#
15072617000095/OCMT/EUR26,49/CHGS/EUR4,20

SOFORT (KLARNA SOFORT)

[Customer_ID]#
[Country]#
[Mandate_ID]#
[IP address]

9139795844#
DE#
9135762874-203185592#
78.49.133.9

TRUSTLY

[Merchant_Discount]#
[Currency]#
[Value_Date]#
[Order_ID]#
[Acc_Name]#
[Order_Type]

0.05
SEK
2020-01-30 13:28:45#
3209647863#
SWEDENESSE#
User deposit of client funds to SWEDENESSE#

WECHAT

[Fee Rate]#[Fee]

1.00#0.00000

[5] CB, RR and TC40/SAFE elements are only available if provided by acquiring bank
[6] b4payment/SEPAexpress

Field "Record_Type"

Multiexcerpt

MultiExcerptName	record_type

Record / Datensatz	Payment method / Zahlungsart	Transaction type / Transaktionstyp
500	Direct Debit	Debit
501		Credit
502		Chargeback
510	CREDIT CARD [7]	Debit
511		Credit
512		Chargeback
513		Fee
514		Retrieval Request
517		TC40/SAFE
520	PAYPAL	Debit
521		Credit
522		Chargeback
524		Hold for Dispute Investigation
525		Cancellation of Hold for Dispute Resolution
526		General withdrawal from PayPal account
530	BARZAHLEN	Debit
531	BARZAHLEN	Credit
530	AFTERPAY	Debit
531	AFTERPAY	Credit
530	CONSORSFINANZ	Debit
540	LIMONETIK	Debit
541		Credit
543		Fee
550	KLARNA SOFORT	Debit
551	KLARNA SOFORT	Credit
560	BILLPAY	Debit
561	BILLPAY	Credit
570	TRUSTLY	Debit
571	TRUSTLY	Credit
580	iDEAL	Debit
581	iDEAL	Credit
590	ALIPAY	Debit
591	ALIPAY	Credit
600	CHINAPAY	Debit
601	CHINAPAY	Credit
610	PAYU	Debit
611	PAYU	Credit
620	PAYDIREKT	Debit
621	PAYDIREKT	Credit
630	KLARNA	Debit
631	KLARNA	Credit
640	WECHAT	Debit
641	WECHAT	Credit
700	PAGBRASIL	Debit
701		Credit
702		Chargeback
710	PPRO	Debit
711		Credit
712		Chargeback
720	Amazon Pay	Debit
721		Credit
722		Chargeback
723		Authorisation

[7] CB, RR and TC40/SAFE records are only available if provided by acquiring bank

Example

Multiexcerpt

MultiExcerptName	example_code

Code Block

language	xml

100,MID,20140911,1.0
510,9dc67059361dbe07,EUR,7595,7595,02.09.2020 00:16:44,OK,90459a6a15b281664263,531001xxxxxx3570#MasterCard,02.09.2020 00:19:01,Order Description,1.875#EUR
511,9dc67059361dbe07,EUR,7595,2000,02.09.2020 00:16:44,OK,90459a6a15b281664263,531001xxxxxx3570#MasterCard,02.09.2020 02:02:36,Order Description,1.875#EUR
512,n/a,EUR,,100,10.09.2020 15:20,OK,,,10.09.2020 15:20,,
520,333246c1b46eafeb3,EUR,1490,1490,02.09.2020 11:37:03,OK,b0b4dcd7a263fc4a0327,BXV7N2GVX3TEY#john_doe@web.de,02.09.2020 11:37:33,PAYPAL . . .,53#EUR#DR
521,333246c1b46eafeb3,EUR,1490,620,02.09.2020 11:37:03,OK,b0b4dcd7a263fc4a0327,BXV7N2GVX3TEY#john_doe@web.de,02.09.2020 11:40:50,PAYPAL . . .,22#EUR#CR
522,n/a,EUR,,7090,06.09.2020 13:33,OK,593-151-678,NJW7HRTXBU3P4,06.09.2020 13:33,,
610,P6437554,PLN,18598,18598,19.01.2020 18:06:43,OK,,PayU Customer#payucust@interia.eu,09.02.2020 08:28:37,Transaction placed,P6437554#660545423#1.40
611,P6337819,PLN,4087,11999,24.01.2020 12:46:26,OK,,PayU Customer#payucust@wp.pl,09.02.2020 23:54:44,Refund P6337819,P6337819#649697804#0.00
700,20200130-105459-867,BRL,100,100,02.09.2020 10:55:33,OK,11ID68VS84EFP8NZ,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Credit Card#1.0#0.33#09/03/2020
701,20200127-152555-373,BRL,100,100,02.09.2020 15:27:41,OK,SBC55VKFI482ZUR7,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Credit Card#1.0#0.68#09/03/2020
702,20200228-162237-848,BRL,100,100,02.09.2020 16:24:28,OK,,,02.09.2020 00:00:00,,Credit Card#0#16/05/14#03/09/2020
900,20,50692

Page tree

Versions Compared

Old Version 1

New Version Current

Key

General Notes

Purpose

Supported Payment Schemes, Payment Methods and Acquirers

Retrieval

File structure

Notation of data types

Data element directory

File names

Records

Header record

Detail record

Total record

Additional informations

Field "Customer_Info"

Field "Extended_Info"

Field "Record_Type"

Example

About Pay-Jet

Help

Intranet Tools

Page tree

Page History

Versions Compared

Old Version 1

New Version Current

Key

General Notes

Purpose

Supported Payment Schemes, Payment Methods and Acquirers

Retrieval

File structure

Notation of data types

Data element directory

File names

Records

Header record

Detail record

Total record

Additional informations

Field "Customer_Info"

Field "Extended_Info"

Field "Record_Type"

Example