Transaction Reconciliation API

An API for querying transaction history for a specific transaction date. When the merchant server calls the Transaction Reconciliation API on the Hecto Financial server, the reconciliation results from Hecto Financial are returned.

Test Key Information


API Information

POST/api/pg/{merchantId}/transInfo.do
Content-Typeapplication/x-www-form-urlencoded
테스트https://tb-nspay.settlebank.co.kr/api/pg/{merchantId}/transInfo.do
운영https://nspay.settlebank.co.kr/api/pg/{merchantId}/transInfo.do

Notes

NOTE

Transaction Reconciliation API Guide

The Transaction Reconciliation API queries all transaction history that occurred on a specific transaction date. Please be aware that a large volume of data may be returned.
  • The response format is pipe (|) delimited text.
  • The first row contains the result code, result message, and number of records found.
  • On a successful query, transaction details are output from the second row onward.

Request Parameters

타입 표기법
N숫자A영문H한글AN영문+숫자AHN영문+한글+숫자
예: AN(10) = 영문+숫자, 최대 10byte
mchtIdAN(10)Alphanumeric, up to 10 bytes*
Unique merchant ID assigned by Hecto Financial
mchtTyAN(1)Alphanumeric, up to 1 bytes*
Merchant ID type
M: Query by Merchant ID G: Query by Group ID
repMchtIdAN(10)Alphanumeric, up to 10 bytes
Representative merchant ID. Required when mchtTy is G (Group ID). Use the hashKey associated with repMchtId when generating pktHash.
methodAN(2)Alphanumeric, up to 2 bytes*
Payment method
ALL: All payment methods CA: Credit Card VA: Virtual Account RA: Bank Transfer MP: Mobile Payment TM: T-Money CG: Culture Gift Card SG: Smart Munhwa Gift Card BG: Book Culture Gift Card HM: Happy Money TC: Teencash CP: Point Damoaa PZ: Simple Payment
pdTyAN(1)Alphanumeric, up to 1 bytes*
Query period type code
*Fixed value
trdDtStN(8)Numeric, up to 8 bytes*
Transaction date (yyyyMMdd)
ezpIncYNAN(1)Alphanumeric, up to 1 bytes
Whether to include Simple Payment (PZ) transactions in the reconciliation results
Y: Include N or not set: Exclude
pktHashAN(200)Alphanumeric, up to 200 bytes*SHA-256(실시간 생성)
Hash value generated using SHA256
NOTE

Hash Generation Combination

mchtId + trdDtSt + hashKey

Response Format

The response is pipe (|) delimited text.

Query Result (First Row)

No.FieldTypeDescription
1Result CodeAN(4)API response result code
2Result MessageANAPI response result message
3Number of RecordsNNumber of successfully queried transaction records

Transaction Details (From Second Row)

On a successful query (result: 0000), transaction details are output from the second row onward.

No.FieldTypeDescription
1Merchant IDAN(10)Merchant ID
2Payment MethodN(2)Payment method code
3Hecto Financial Transaction No.AN(40)Transaction number generated by Hecto Financial
4Order NumberAN(100)Merchant order number
5Approval TypeAN(1)0: Approval, 1: Cancellation
6Transaction DateN(8)Transaction date (cancellation date) yyyyMMdd
7Transaction TimeN(6)Transaction time (cancellation time) hhmmss
8Transaction AmountN(13)Transaction amount
9Original Transaction No.AN(40)Original transaction number for cancellation transactions
10Original Transaction DateN(8)Original transaction date for cancellation transactions
11Orderer NameAN(88)Merchant orderer name
12Product NameAN(200)Merchant product name
13Approval NumberANCredit card approval number
14Financial Institution CodeANCredit card: card issuer code, Bank transfer/Virtual account: financial institution code, Mobile: telecom company code, Simple payment: card issuer code / simple payment company code
15Installment MonthsN(2)Credit card transaction installment months
16Interest-free InstallmentAN(1)Whether the transaction is a merchant-subsidized interest-free installment (credit card). N: Normal, Y: Interest-free installment transaction
17Simple Payment Company CodeAN(3)Value used to identify the simple payment company when the payment method is Simple Payment (PZ) and the financial institution code is a card issuer code
18Product CodeAN(3)Value used to distinguish the primary payment method from the secondary payment method in combined payments
19Combined Payment Transaction No.AN(40)Original transaction number for combined payments

Response Example

Successful Response

0000|Successfully processed.|6|
nxca_jt_il|CA|STFP_PGCAnxca_jt_il0260720100000M1000001|ORDER20260720100001|0|20260720|100000|10000|||홍길동|테스트상품|99100001|02|00|N|
nxca_jt_il|CA|STFP_PGCAnxca_jt_il0260720103000M1000002|ORDER20260720100002|0|20260720|103000|30000|||김철수|테스트상품2|99100002|05|03|Y|
nxca_jt_il|CA|STFP_PGCAnxca_jt_il0260720110000M1000003|ORDER20260720100001|1|20260720|110000|10000|STFP_PGCAnxca_jt_il0260720100000M1000001|20260720|홍길동|테스트상품|99100001|02|00|N|
nxca_jt_il|PZ|STFP_PGPZnxca_jt_il0260720120000M1000004|ORDER20260720100004|0|20260720|120000|5000||||테스트상품3|||00|N|
nxca_jt_il|PZ|STFP_PGPZnxca_jt_il0260720130000M1000005|ORDER20260720100004|1|20260720|130000|5000|STFP_PGPZnxca_jt_il0260720120000M1000004|20260720||테스트상품3|||00|N|
nxca_jt_il|CA|STFP_PGCAnxca_jt_il0260720140000M1000006|ORDER20260720100006|0|20260720|140000|20000|||이영희|테스트상품|99100006|11|00|N|

Failure Response

ST92|Hash value mismatch.|0|

Result Codes

CodeDescription
0000Successfully processed.
1001No records found
ST09Invalid request message
ST10Internal system error
ST90Unregistered merchant ID
ST91Required parameter error
ST92Hash value mismatch

Card Issuer Codes (Acquiring Company Codes)

CodeCard Issuer
01BC
02Kookmin
03Hana
04Samsung
05Shinhan
08Hyundai
09Lotte
11Woori
15NH

Financial Institution Codes

CodeFinancial Institution
002Korea Development Bank
003Industrial Bank of Korea (IBK)
004KB Kookmin Bank
007Suhyup Bank / National Federation of Fisheries Cooperatives
011NH Bank
012National Agricultural Cooperative Federation
020Woori Bank
023Standard Chartered Bank Korea
027Citibank Korea
031Daegu Bank
032BNK Busan Bank
034Kwangju Bank
035Jeju Bank
037Jeonbuk Bank
039BNK Kyongnam Bank
045National Credit Union Federation of Korea
048National Credit Union Federation
050Mutual Savings Bank
054HSBC Bank
055Deutsche Bank
057JPMorgan Chase Bank
060Bank of America
062Industrial and Commercial Bank of China
064National Forestry Cooperative Federation
071Korea Post
081Hana Bank
088Shinhan Bank
089Kbank
090KakaoBank
092Toss Bank
103SBI Savings Bank
209Yuanta Securities
218KB Securities
238Mirae Asset Daewoo
240Samsung Securities
243Korea Investment & Securities
247NH Investment & Securities
261Kyobo Securities
262Hi Investment & Securities
263Hyundai Motor Securities
264Kiwoom Securities
265eBest Investment & Securities
266SK Securities
267Daishin Securities
269Hanwha Investment & Securities
270Hana Financial Investment
278Shinhan Financial Investment
279Dongbu Securities
280Eugene Investment & Securities
287Meritz Securities
290Bookook Securities
291Shinyoung Securities
292Cape Investment & Securities

Payment Method Codes

CodePayment Method
CACredit Card
VAVirtual Account
RABank Transfer
MPMobile Payment
TMT-Money
CGCulture Gift Card
SGSmart Munhwa Gift Card
BGBook Culture Gift Card
HMHappy Money
TCTeencash
CPPoint Damoaa
PZSimple Payment

Telecom Company Codes

CodeTelecom Company
SKTSK Telecom
KTFKT
LGTLG U+
SKLSK 7 Mobile
CJHCJ Hello Mobile
KCTKorea Cable Telecom

Simple Payment Company Codes

CodeSimple Payment Company
KKPKakaoPay
NVPNaverPay
PACPayco
TOSTossPay

Product Codes

CodeProduct Name
CAPCredit Card
KKMKakao Money
PNTPoints
COUPayco Coupon
TSMToss Money
💬

Need technical support?