Refund

Refund batch services allow merchants to refund a batch of payments using SFTP connection.

👍
Connect using SFTP

IP Address : 52.76.184.174

Port : 22

Username : The merchant must fill in the SFTP setup form and send the request to support team. An account will be created for merchant to access 2c2p SFTP in demo and production environment.

Request Path : /input ( For File Pickup )

Response Path : /output ( For File Drop )

File Information Time
Reconciliation report file drop Before 4:00AM GMT+7
SimpleAuthorization file pickup 5:00AM GMT+7
SimpleAuthorization file drop Before 6:00AM GMT+7
OfflineAuthorization file pickup 2:00PM GMT+7
OfflineAuthorization file drop Before 6:00AM GMT+7 (next day)
Tokenization/Refund file pickup 2:00AM GMT+7
Tokenization/Refund file drop Before 3:00AM GMT+7
Quickpay/Promocode file pickup Every hour
Quickpay/Promocode file drop Within the next hour

File Information	Time
Reconciliation report file drop	Before 4:00AM GMT+7
SimpleAuthorization file pickup	5:00AM GMT+7
SimpleAuthorization file drop	Before 6:00AM GMT+7
OfflineAuthorization file pickup	2:00PM GMT+7
OfflineAuthorization file drop	Before 6:00AM GMT+7 (next day)
Tokenization/Refund file pickup	2:00AM GMT+7
Tokenization/Refund file drop	Before 3:00AM GMT+7
Quickpay/Promocode file pickup	Every hour
Quickpay/Promocode file drop	Within the next hour

🚧
File Format Specification

File name format : refund_YYYYMMDD_fileName.csv

Parameter delimiter : semicolon ';'

Record delimiter : line break

Encryption Method : None

How to integrate

Merchants must prepare the refund request file. Refer to Refund Request.
Upload the refund request file into the SFTP Server.
2C2P will pick up the refund request file and process the payment.
2C2P will drop the refund response file in the SFTP Server.
Merchants must get the refund response file from SFTP Server.
Merchants read the response data as payment acknowledgement. Refer to Refund Response.

📘
Data Attribute Reference
Data Type

A: Alphabet

AN: Alphanumeric

NT: NText

C: Characters

B: Boolean

D: Decimal

N: Numeric

Mandatory attributes

M: Mandatory

C: Conditional

O: Optional

Refund Request

Header Parameters

H;1.1;JT;[email protected];2015-01-01 00:00:01;2015-01-01 00:00:02;2

Parameter	Data Type	Mandatory	Description
recordType	C 1	M	Header = H
version	C 5	M	Current version is 1.1
merchantID	C 25	M	Merchant ID provided by 2C2P
requestorID	C 50	M	Merchant User Login ID
createDateTime	C 19	M	YYYY-MM-DD HH:mm:ss (24 hours format)
processDateTime	C 19	M	yyyy-MM-dd HH:mm:ss (24 hours format)
totalRecord	N 5	M	Total number of transactions

Detail Parameters

D;1;Test120116161653531;000000000005;test for refund upload (SGD)
D;2;Test120116160448782;000000000010;

Parameter	Data type	Mandatory	Description
recordType	C 1	M	Details = D
recordNo	N 5	M	running no 1 - 99999
transactionInvoiceNo	C 50	M	Invoice number
refundAmount	N 12	M	Note: The refund amount will be padded with ‘0’ from the left and include no decimal point Examples: 1.00 = 000000000100 1.50 = 000000000150
note	C 250	O	Refund note

Refund Response

Header Parameters

H;1.1;JT;[email protected];2015-01-02 00:00:02;4

Parameter	Data type	Mandatory	Description
recordType	C 1	M	Header = H
version	C 5	M	Current version 1.1
merchantID	C 15	M	Merchant ID provided by 2C2P
requestorID	C 50	M	Merchant User Login ID
completeDateTime	C 19	M	YYYY-MM-DD hh:mm:ss
totalRecords	N 5	M	Total number of transactions

Detail Parameters

D;1;123,Test120116161653531;000000000005;test for refund upload (SGD);00;Success

Parameter	Data type	Mandatory	Description
recordType	C 1	M	Details = D
recordNo	N 5	M	running no 1 - 99999
tranRef	C 28	M	Routing trace reference number
transactionInvoiceNo	C 50	M	Invoice number
refundAmount	N 12	M	Note: The refund amount will be padded with ‘0’ from the left and include no decimal point Examples: 1.00 = 000000000100 1.50 = 000000000150
note	C 250	M	Refund note
respCode	N 2	M	00 = success Other response codes represent failure; please check the response code list below for specific failure details
respDesc	C 100	M	Response description

Response Code List

respCode	respDesc
00	Success
01	Mandatory field is not completed
02	Invalid transactionInvoiceNo or Invoice number is blank
03	Refund amount is not correct format
04	invalid transaction status
05	Invalid transaction
06	Refund rejected or Total refund amount is more than transaction amount. or Cannot retrieve main transaction. Refund failed.
07	Insufficient balance.
08	Refund amount is over merchant amount.
09	Data field length is not matched
89	Database error
99	System error