Downloading the Credit Card Disbursement Balance Statement File

Scenario

Merchants can download their credit card disbursement statement in CSV format.

  • Step 1. Merchant: Transmit the credit card disbursement details and category to ECPay via POST (HTTP Method) for inquiry.
  • Step 2. ECPay : Upon receiving merchant’s credit card disbursement inquiry and checking details, return a CSV file for the merchant to download.

API URLS

  • Production :https://payment.ecPay.com.tw/CreditDetail/FundingReconDetail
  • Stage: This API can not be used because no real authorizations can be provided.

HTTPS Transfer Protocol

  • Content Type :application/x-www-form-urlencoded
  • HTTP Method :POST

Merchant return parameter description

MerchantID String(10)
Required

PayDateType String(10)
Required

Search date category.
The date category to be inquired
  • fund: Check settlement date
  • close: Check capture date
  • enter: Check appropriation date

StartDate String(10)
Required

Query start date.
The start date of the query Date format is “yyyy-MM-dd“.

❗ Special Note:The search date must be after 14:00 on the bank’s working day to find the information.
Ex: 1/16 and 1/17 are bank holidays, data for 1/15~1/17 can only be found after 14:00 on 1/18; the search date must be 1/18.

EndDate String(10)
Required

Query end date.
The end date of the query Date format is “yyyy-MM-dd“.

CheckMacValue String
Required

Checksum.
Please refer to the Appendix Checksum Mechanism.

Response CSV File Format Details

Serial number String
Authorization number String
Authorization code String
Order ID String
Transaction date String

The default format is yyyy/MM/dd hh:mm:ss

Payment requested date String

The default format is yyyy/MM/dd hh:mm:ss

Transaction amount Int
In the case of a refund, this amount will be negative.
Service fee (%) Int
Amount of payment Int

❗ Special Note:Credit card funding information for today’s orders will only be available after 14:00 on the next day. Credit card funding is only available on bank working days, not on holidays or non-working days.

Copyright © Green World FinTech Service Co., Ltd. All rights reserved.

Green World