Settlement Reconciliation API

An API for querying settlement details based on the scheduled settlement date. When the merchant server calls the Settlement Reconciliation API on the Hecto Financial server, the reconciliation results from Hecto Financial are returned.

Test Key Information


API Information

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

Notes

NOTE

Settlement Reconciliation API Guide

The Settlement Reconciliation API queries settlement details based on the scheduled settlement date. It can be used to reconcile the expected settlement amount against the actual deposit amount.
  • 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, settlement information per transaction is 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 TC: Teencash CP: Point Damoaa PZ: Simple Payment
crtrDtN(8)Numeric, up to 8 bytes*
Scheduled settlement date (yyyyMMdd)
pktHashAN(32)Alphanumeric, up to 32 bytes*SHA-256(실시간 생성)
Hash value generated using SHA256
ezpIncYNAN(1)Alphanumeric, up to 1 bytes
Whether to include Simple Payment (PZ) transactions in the settlement reconciliation results
Y: Include N or not set: Exclude
sttlmntTyAN(3)Alphanumeric, up to 3 bytes
Settlement type
ALL: All settlements TR: Regular settlement DB: Differential settlement NR: Refund settlement
NOTE

Hash Generation Combination

mchtId + crtrDt + 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
2Hecto Financial Transaction No.AN(40)Transaction number generated by Hecto Financial
3Original Transaction No.AN(40)Original transaction number for cancellation transactions
4Payment MethodAN(2)Payment method code
5Approval/Cancellation DateN(8)Transaction date (cancellation date) yyyyMMdd
6Approval/Cancellation FlagN(1)0: Approval, 1: Cancellation
7Financial Institution/Telecom CodeANCredit card: card issuer code, Bank transfer/Virtual account: bank code, Mobile: telecom company code, Simple payment: card issuer code / simple payment company code
8Approval NumberANCredit card approval number
9Installment MonthsAN(2)Credit card transaction installment months
10Order NumberAN(100)Merchant order number
11Orderer NameAN(88)Merchant orderer name
12Product NameAN(200)Merchant product name
13Payment AmountNPayment amount. 0 KRW for differential/refund settlement transactions
14FeeNSupply value
15VATNValue-added tax
16Scheduled Settlement AmountNScheduled settlement amount
17Scheduled Settlement DateAN(8)Scheduled settlement date yyyyMMdd
18Simple 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
19Product CodeAN(3)Value used to distinguish the primary payment method from the secondary payment method in combined payments
20Combined Payment Transaction No.AN(40)Original transaction number for combined payments
21Settlement TypeAN(2)Output additionally when the settlement type (sttlmntTy) is set in the request. TR: Regular settlement, DB: Differential settlement, NR: Refund settlement

Response Example

Successful Response

0000|Successfully processed.|5|
nxca_jt_il|STFP_PGCAnxca_jt_il0260720100000M2000001|STFP_PGCAnxca_jt_il0260720100000M2000001|CA|20260720|0|05|99200001|00|ORDER20260720100001|홍길동|테스트상품|10000|215|21|9764|20260721||CAP||TR
nxca_jt_il|STFP_PGCAnxca_jt_il0260720110000M2000002|STFP_PGCAnxca_jt_il0260720100000M2000001|CA|20260720|1|05|99200001|00|ORDER20260720100001|홍길동|테스트상품|10000|0|0|10000|20260721||CAP||TR
nxca_jt_il|STFP_PGCAnxca_jt_il0260720120000M2000003|STFP_PGCAnxca_jt_il0260720120000M2000003|CA|20260720|0|02|99200003|03|ORDER20260720100003|김철수|테스트상품2|30000|645|64|29291|20260721||CAP||TR
nxca_jt_il|STFP_PGPZnxca_jt_il0260720130000M2000004|STFP_PGPZnxca_jt_il0260720130000M2000004|PZ|20260720|0|KKP||00|ORDER20260720100004||테스트상품3|1000|0|0|1000|20260721|KKP|KKM||TR
nxca_jt_il|STFP_PGCAnxca_jt_il0260720140000M2000005|STFP_PGCAnxca_jt_il0260720140000M2000005|CA|20260720|0|11|99200005|00|ORDER20260720100005|이영희|테스트상품|20000|430|43|19527|20260721||CAP||TR

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

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
TCTeencash
CPPoint Damoaa
PZSimple Payment

Telecom Company Codes

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

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

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?