General Notes

Purpose

The Pay-Jet 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 Pay-Jet.

Please note that Pay-Jet 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.


Supported Payment Schemes, Payment Methods and Acquirers

Category / Kategorie

Scheme / Marke

Processor / Acquirer / Gateway

Credit Cards / Kreditkarten

American Express

American Express (EPA & GRRCN)

*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 / ÜberweisungeniDEAL(DB-Export)
PaydirektPaydirekt

Alternatives

AfterPay/PayByBill

AfterPay/arvato

AlipayAlipay
Amazon PayAmazon
BarzahlenCash Payment Solutions
BillPayBillPay
ChinaPayChinaPay
Consors FinanzBNP
KlarnaKlarna
LimonetikLimonetik

PayPal

PayPal

SEPA Direct Debitb4payment/SEPAexpress (and DB-Export)
TrustlyTrustly
WeChatWeChat
variousPagBrasil
variousPayU
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 Pay-Jet Settlement Files at their own discretion from a Pay-Jet SFTP account. For configuration and account credentials please contact the Pay-Jet Support.


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

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

FormatDescriptionBeschreibung

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 Pay-Jet 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.


Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

Field nameDescriptionBeschreibung

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 Pay-Jet Settlement File was created, <DDMMYYYY>

Datum, wann das Pay-Jet Settlement-File erzeugt wurde, <DDMMYYYY>

INTERCHANGE_FEE

Fees charged by the card issuer

Vom Kartenaussteller berechnete Gebühren

MERCHANT_ID

Pay-Jet merchant identification

Pay-Jet 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_DATEPayout date by Payment InstitutionAuszahlungsdarum des Zahlungsinstituts
PAYOUT_IDReference number of payout generated by Payment InstitutionReferenznummer 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

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

NoField name / FeldnameFormatExample / 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

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]

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]

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]

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

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"

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"

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


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 Cockpit (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"

Record / Datensatz

Payment method / Zahlungsart

Transaction type / Transaktionstyp

500Direct DebitDebit
501Credit
502Chargeback

510

CREDIT CARD [7]

Debit

511

Credit

512

Chargeback

513Fee

514

Retrieval Request

517

TC40/SAFE

520

PAYPAL





Debit

521

Credit

522

Chargeback

524Hold for Dispute Investigation
525Cancellation of Hold for Dispute Resolution
526General withdrawal from PayPal account
530BARZAHLENDebit
531Credit
530AFTERPAYDebit
531Credit
530CONSORSFINANZDebit
540LIMONETIKDebit
541Credit
543Fee
550KLARNA SOFORTDebit
551Credit
560BILLPAYDebit
561Credit
570TRUSTLYDebit
571Credit
580iDEALDebit
581Credit
590ALIPAYDebit
591Credit
600CHINAPAYDebit
601Credit
610PAYUDebit
611Credit
620PAYDIREKTDebit
621Credit
630KLARNADebit
631Credit
640WECHATDebit
641Credit
700PAGBRASILDebit
701Credit
702Chargeback

710

PPRO

Debit

711

Credit

712

Chargeback

720Amazon Pay Debit
721Credit
722Chargeback
723Authorisation

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


Example

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



  • No labels