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
  • Response Path : /output
  • Pickup Time For Request File : Everyday 2.00AM GMT+7
  • Drop Time For Response File : Everyday Before 3.00AM GMT+7

🚧

File Format Specification

  • File name format : refund_YYYYMMDD_fileName.csv
  • Parameter delimiter : semicolon ';'
  • Record delimiter : line break
  • Encryption Method : None

 

How to integrate


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

 

📘

Data Attribute Reference

Data Type

  • A: Alphabet
  • AN: Alphanumeric
  • 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