Refund batch services allowed merchant to refund a batch of payments using SFTP connection.

👍

Connect using SFTP

  • IP Address : 52.76.184.174
  • Port : 22
  • Username : Merchant required to 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 have to prepare the refund request file. Refer to Refund Request.
  2. Merchant is required to put refund request file into SFTP Server.
  3. 2c2p pickup the refund request file and process the payment.
  4. 2c2p will drop the refund response file in SFTP Server.
  5. Merchant is required to get the refund response file from SFTP Server.
  6. Merchant read the response data as payment acknowledgement. Refer to Refund Response.

 

📘

Data Attribute Reference

Data Type
A - Alphabet, N - Numeric, AN - AlphaNumeric, C - Characters, D - Decimal, B - Boolean

Mandatory
M - Mandatory, C - Conditional, O - Optional

Refund Request


Header Parameter

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

MID 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 Parameter

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 No

refundAmount

N 12

M

"The refund amount will be padded with ‘0’ from the left and include no decimal point.
Example: 1.00 = 000000000100, 1.50 = 000000000150"

note

C 250

O

Refund Note

 

Refund Response


Header Parameter

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

MID 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 Parameter

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 No

refundAmount

N 12

M

"The refund amount will be padded with ‘0’ from the left and include no decimal point.
Example: 1.00 = 000000000100, 1.50 = 000000000150"

note

C 250

M

Refund Note

respCode

N 2

M

"00 = success
other response code represent failure with different reasons."

respDesc

C 100

M

response description

 

Response Code List

respCode

respDesc

00

Success

01

mandantory field is not completed

02

"invalid transactionInvoiceNo
(OR)
Invoice No is blank"

03

Refund amount is not correct format.

04

invalid transaction status

05

Invalid transaction

06

"Refund rejected.
Total refund amount is more than transaction amount.

Cannot retrieve Main Txn. Refund failed."

07

Insufficient balance.

08

Refund amount is over merchant amount.

09

Data Field length is not match

89

DB Error

99

system Error