1 General Notes

1.1 Purpose

The First Cash Solution 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 First Cash Solution.

Please note that First Cash Solution 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.

1.2 Supported Payment Schemes, Payment Methods and Acquirers

CategorySchemeProcessor / Acquirer / Gateway
Credit CardsAmerican ExpressAmerican Express (German & PANEUROP)
*MultipleConCardis Elavon EVO (GICC) iCard JPMorgan Chase (Salem and Tampa) Lufthansa AirPlus OmniPay (EMS, Global Payments, Paysquare) Payone SIX Payment Services Vantiv Wirecard Worldline
Bank TransfersiDEAL*
PaydirektPaydirekt
Klarna Sofort*
AlternativesAfterPay/PayByBillAfterPay/arvato
AlipayAlipay
Amazon PayAmazon
BarzahlenCash Payment Solutions
BillPayBillPay
ChinaPayChinaPay
KlarnaKlarna
LimonetikLimonetik
PayPalPayPal
SEPA Direct Debit*
TrustlyTrustly
WeChatWeChat
*MultiplePagBrasil
*MultiplePayU
*MultiplePPRO

1.3 Retrieval

Merchants may collect First Cash Solution Settlement Files at their own discretion from a First Cash Solution SFTP account. For configuration and account credentials please contact the First Cash Solution helpdesk: support@1cs.de.

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

1.5 Notation of data types

FormatDescription
aAlphabetic characters A-Z, a-z
nNumeric digits, 0-9
anAlphanumeric characters A-Z, a-z, 0-9
ansAlphanumeric and special characters
nsNumeric and special characters
3Fixed length data element of 3 characters
..17Variable 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.
tstpTimestamp, format: <DD.MM.YYYY hh:mm:ss>

1.6 Data element directory

All data elements of the First Cash Solution 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.

Field nameDescription
ACQUIRER_FEECharges for the services of Acquirer.
AUTHORIZATION_AMOUNTAuthorized amount in smallest unit of transaction currency (e.g. EUR Cent)
CAPTURE_DATEThe 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’
COUNTEREnumerator to ensure unique file names (left justified zero filled).
CUSTOMER_INFOConstructed field encompassing specific customer related information depending on the payment method. Sub-fields are divided by ‘#’ (U+0023) (Number Sign).
EXTENDED_INFOConstructed field encompassing additional information that is available depending on the payment method. Sub-fields are divided by ‘#’ (U+0023) (Number Sign).
FILE_CREATION_DATEDate the First Cash Solution Settlement File was created, <DDMMYYYY>.
INTERCHANGE_FEEFees charged by the card issuer.
MERCHANT_IDFirst Cash Solution merchant identification
ORDER_DESCRIPTIONA description of the order the payment relates to.
PAYMENT_CREATION_DATEDate and time the payment has been created, <DD.MM.YYYY hh:mm:ss>.
PAYOUT_DATEPayout date by Payment Institution.
PAYOUT_IDReference number of payout generated by Payment Institution.
PROCESSING_FEECharges for the services of Processors (PSP, Gateway, Network Operator).
RECORD_COUNTTotal number of rows in detailed records section.
RECORD_TYPEHeader 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’.
REFERENCE_NUMBERThe 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.
SCHEME_FEEFee charged by the card organization.
STATUSThe status of the payment, currently always ‘OK’.
TOTAL_AMOUNTSum 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)
TRANSACTION_AMOUNTThe amount that has been processed by the payment scheme in smallest unit of the transaction currency (e.g. EUR Cent)
TRANSACTION_CURRENCYRefers to the three-letter ISO 4217 currency code of the currency in which the transaction was processed.
TRANSACTION_IDUnique 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).

1.7 File names

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

No.ElementFormatExample
1MERCHANT_IDan..20ACME01
2FILE_CREATION_DATEN820141014
3COUNTERN3001

File name example:            ACME01#20201014#001.ctsf

2 Records

2.1 Header record

NoField nameFormatExample
1RECORD_TYPEN3100
2MERCHANT_IDAn..30ACME01
3DATEN820200424
4VERSIONAn..41.0

2.2 Detail record

Version 1.0

NoElementFormatExample
1RECORD_TYPEN3510
2TRANSACTION_IDAn..64890_XUoqyBWuGw
3TRANSACTION_CURRENCYA3EUR
4AUTHORIZATION_AMOUNTN..12789
5TRANSACTION_AMOUNTN..12700
6PAYMENT_CREATION_DATETstp20.04.2020 14:18:23
7STATUSAn..OK
8REFERENCEAn..30qArxtOE4w3FsSX5
9CUSTOMER_INFOAns..1604111xxxxxxxx9996#VISA
10CAPTURE_DATETstp24.04.2020 00:00:00
11ORDER_DESCRIPTIONAns..384Monthly subscription fee to ACME TV
12EXTENDED_INFOAns..1.875#EUR

Version 1.1 [1]

NoElementFormatExample
1RECORD_TYPEN3510
2TRANSACTION_IDAn..64890_XUoqyBWuGw
3TRANSACTION_CURRENCYA3EUR
4AUTHORIZATION_AMOUNTN..12789
5TRANSACTION_AMOUNTN..12700
6PAYMENT_CREATION_DATETstp20.04.2020 14:18:23
7STATUSAn..OK
8REFERENCEAn..30qArxtOE4w3FsSX5
9CUSTOMER_INFOAns..1604111xxxxxxxx9996#VISA
10CAPTURE_DATETstp24.04.2020 00:00:00
11ORDER_DESCRIPTIONAns..384Monthly subscription fee to ACME TV
12EXTENDED_INFOAns..201.875#EUR
13INTERCHANGE_FEEAns..201.875#13#EUR
14SCHEME_FEEAns..201.875#13#EUR
15ACQUIRER_FEEAns..201.875#13#EUR
16PROCESSING_FEEAns..201.875#13#EUR

Version 1.2 [2]

NoElementFormatExample
1RECORD_TYPEN3510
2MERCHANT_IDAn..20ACME01
3TRANSACTION_IDAn..64890_XUoqyBWuGw
4TRANSACTION_CURRENCYA3EUR
5AUTHORIZATION_AMOUNTN..12789
6TRANSACTION_AMOUNTN..12700
7PAYMENT_CREATION_DATETstp20.04.2020 14:18:23
8STATUSAn..OK
9REFERENCEAn..30qArxtOE4w3FsSX5
10CUSTOMER_INFOAns..1604111xxxxxxxx9996#VISA
11CAPTURE_DATETstp24.04.2020 00:00:00
12ORDER_DESCRIPTIONAns..384Monthly subscription fee to ACME TV
13EXTENDED_INFOAns..201.875#EUR
14INTERCHANGE_FEEAns..201.875#13#EUR
15SCHEME_FEEAns..201.875#13#EUR
16ACQUIRER_FEEAns..201.875#13#EUR
17PROCESSING_FEEAns..201.875#13#EUR

Version 1.3 [3]

NoElementFormatExample
1RECORD_TYPEN3510
2TRANSACTION_IDAn..64890_XUoqyBWuGw
3TRANSACTION_CURRENCYA3EUR
4AUTHORIZATION_AMOUNTN..12789
5TRANSACTION_AMOUNTN..12700
6PAYMENT_CREATION_DATETstp20.04.2020 14:18:23
7STATUSAn..OK
8REFERENCEAn..30qArxtOE4w3FsSX5
9CUSTOMER_INFOAns..1604111xxxxxxxx9996#VISA
10CAPTURE_DATETstp24.04.2020 00:00:00
11ORDER_DESCRIPTIONAns..384Monthly subscription fee to ACME TV
12EXTENDED_INFOAns..201.875#EUR
13PAYOUT_IDAns..1586789310000001
14PAYOUT_DATEN820.04.2020

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

3 Additional information

3.1 Field “Customer_Info”

Payment methodStructure / CommentExample
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 CARDMasked card number or card token and card brand: [0000xxxxxxxx0000]#
[Brand]
4111xxxxxxxx9996#
Visa
DIRECT DEBIT/GIROCARD[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
PAYBYBILL[Customer_ID]8902265613
PAYDIREKT[Customer_BankID]eba960e5-dd37-4d82-b479-ae3d28205994
PAYPAL[Payer_ID]#
[Payer]
A59XV256BZ#
john.doe@gmx.de
PAYSAFECARD[VoucherNumber(s)]9120084431|9120084432
PAYU[Customer_Name]#
[Customer_E-Mail]
MAGDALENA WITKOWSKA#
magdalena.witkowska@interia.pl
PPRO 
SOFORT (KLARNA SOFORT)see DIRECT DEBITsee DIRECT DEBIT
TRUSTLY[Customer_Country]#
[Customer_First_Name]#
[Customer_Last_Name]#
SE#
John#
Doe
WECHAT[Customer_ID]oi_9HxKIOVS8zYdRxIbV7Ctr5u5U

3.2 Field “Extended_Info”

Payment methodStructure / CommentExample
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
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 sufficient5e736c2d718843149b71e3439b292dfe       reasonCode=MD17#trigger=CHB#token=NSF
IDEALNL#
[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]
PPROCredit
[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 paygate (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

3.3 Field “Record_Type”

RecordPayment methodTransaction type
500Direct DebitDebit
501Credit
502Chargeback
510CREDIT CARD [7]Debit
511Credit
512Chargeback
513Fee
514Retrieval Request
517TC40/SAFE
520PAYPAL        Debit
521Credit
522Chargeback
524Hold for Dispute Investigation
525Cancellation of Hold for Dispute Resolution
526General withdrawal from PayPal account
530BARZAHLENDebit
531Credit
530AFTERPAYDebit
531Credit
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
710PPRODebit
711Credit
712Chargeback
720Amazon Pay Debit
721Credit
722Chargeback
723Authorisation

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

3.4 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,20200206-133103-673,BRL,100,100,02.09.2020 13:31:27,OK,XHVHGE6N71KA2BQ3,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Banricompras#1.0#09/04/14#09/02/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

700,20200206-104248-837,BRL,100,100,02.09.2020 11:44:21,OK,WNADUW08HRWM4MG8,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Banco do Brasil Comércio Eletrônico#1.0#0.32#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

700,20200228-162237-849,BRL,100,100,02.09.2020 00:00:00,OK,SHVTLZVTC43KLQET,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Debit Card#1.0#0.68#09/03/2020

700,20200130-105459-867,BRL,100,100,04.09.2020 10:55:33,OK,NYLUB2TNYMPDU0WL,John Doe#john.doe@bol.com.br,04.09.2020 00:00:00,Order Desc,Credit Card#1.0#0.33#09/03/2020

700,20200128-170102-000,BRL,100,100,02.09.2020 17:05:20,OK,U8OCHXW2SEQZJRJR,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Boleto Bancário#1.0#0.18#09/03/2020

700,20200228-162237-848,BRL,100,100,02.09.2020 16:37:25,OK,PM805LIHFDVOU0MV,John Doe#john.doe@bol.com.br,02.09.2020 00:00:00,Order Desc,Debit Card#1.0#0.68#09/03/2020

701,20200127-152746-365,BRL,100,100,01.09.2020 15:32:36,OK,CDQVHYQHECI7NUGX,John Doe#john.doe@bol.com.br,01.09.2020 00:00:00,Order Desc,Credit Card#1.0#0.5#09/02/2020

700,20200130-135801-194,BRL,100,100,05.09.2020 08:27:00,OK,06H9UGSIC8TTALLG,John Doe#john.doe@bol.com.br,05.09.2020 00:00:00,Order Desc,Boleto Bancário#1.0#0.22#09/07/2020

700,20200205-163338-333,BRL,100,100,02.09.2020 13:07:12,OK,7I62X0RXHDCN8D0N,John Doe#john.doe@bol.com.br,20.08.2020 00:00:00,Order Desc,Bradesco Comércio Eletrônico#1.0#03/09/14#20/08/2020

900,20,50692