Finance
19 columns
250 rows
8 formats

ISO20022 Request for Payment Status (pacs.028)

This dataset provides detailed records of ISO20022 payment status inquiries (pacs.028) exchanged between financial institutions, enabling tracking of transaction processing and status updates throughout the clearing chain. It includes message identifiers, timestamps, institution codes, transaction details, standardized status and reason codes, and supplementary information, making it ideal for payment monitoring, reconciliation, and regulatory compliance analysis.

last updated 29 Oct 2025
by GoMask

The brief that made it

Payment transaction monitoring and reconciliation

Sample rows

preview · 8 of 250 rows · all 19 columns

message_idstring	status_codestring	original_amountfloat	reason_codestring	original_transaction_idstring	inquiry_datetimedatetime	inquiry_institution_idstring	responding_institution_idstring	status_datetimedatetime	original_currencystring	debtor_namestring	debtor_accountstring	creditor_namestring	creditor_accountstring	clearing_chain_positioninteger	reason_descriptionstring	additional_informationstring	response_reference_idstring	status_descriptionstring
MSG10001	ACCP	3421.25	blank	TXN20001	2021-03-12T09:21:32Z	DEUTDEFFXXX	BNPAFRPP	2021-03-12T09:26:41Z	EUR	Helena Schumacher	DE89370400440532013000	Apex Trading Corp	FR1420041010050500013M02606	2	blank	Processed via SEPA network.	RSP10001	Payment accepted and processed successfully.
MS-G10002	RJCT	2950	AM04	TXN20002	2022-07-30T15:17:05Z	HSBCGB2L	CHASUS33	2022-07-30T15:24:19Z	USD	Thomas Whitmore	US12345678901234567890	Global Electronics Inc	US98765432109876543210	1	Insufficient funds in debtor account.	Customer notified of rejection.	RSP10002	Payment rejected due to insufficient funds.
msg10003	PDNG	1200.5	RC01	TXN20003	2020-01-15T11:04:22Z	BNPAFRPP	KRWBNK01	2020-01-15T11:42:30Z	KRW	Park Minseo	KR700123456789012345678	Microcell Ltd	KR700987654321098765432	3	Regulatory review required.	Expected resolution in 48 hours.	RSP10003	Payment pending regulatory review.
MSG10004EDGE	ACCP	0	blank	TXN20004OUT	2023-12-31T23:58:49Z	MIZUJPJT	HSBCGB2L	2024-01-01T00:01:15Z	JPY	Taro Yamada	JP89370400440532013000	Azuma Technologies	GB29NWBK60161331926819	1	blank	Processed during end-of-year batch.	RSP10004	Payment accepted, processed after hours.
MSG10005	ACCP	678.99	blank	TXN20005	2022-09-23T10:13:17Z	CHASUS33	BNPAFRPP	2022-09-23T10:14:24Z	EUR	Martin Keller	DE75512108001245126199	Nouveau Retail GmbH	FR7630006000011234567890189	2	blank	Processed via SEPA.	RSP10005	Payment accepted and credited to beneficiary.
MSG10006	PART	1200000	blank	TXN20006	2020-05-05T14:37:50Z	HSBCGB2L	BOFAUS3N	2020-05-05T14:55:51Z	USD	Rosalie Chen	US99887766554433221100	Westpoint Holdings LLC	US11003322114455667788	2	blank	Limit exceeded, partial transfer only.	RSP10006	Payment partially processed due to transfer limits.
MS-G10007	PDNG	15500	MD01	TXN20007	2024-02-14T08:09:44Z	CITICNSH	BNPAFRPP	2024-02-14T08:55:31Z	CNY	Wang Jun	CN1234567890123456789012	SinoPower Ltd	CN0987654321098765432109	1	Manual decision required.	Confirmation email sent to client.	RSP10007	Payment pending manual decision.
MSG10008	ACCP	4894.99	blank	TXN20008	2019-06-13T16:35:22Z	BNPAFRPP	HSBCGB2L	2019-06-13T16:40:22Z	EUR	Claire Dubois	FR7630006000011234567890189	Zeta Holdings PLC	GB56BARC20201530093459	2	blank	Processed via SEPA.	RSP10008	Payment accepted and settled.
MSG10009	RJCT	1850	AC04	TXN20009	2023-04-22T13:19:11Z	BOFAUS3N	HSBCGB2L	2023-04-22T13:34:25Z	USD	Linda McAllister	US22334455667788990011	BluePeak Advisors	US00112233445566778899	3	Invalid account number.	Check IBAN format and retry.	RSP10009	Payment rejected due to invalid account.
MSG10010	CANC	0	blank	TXN20010	2021-11-18T19:24:44Z	DEUTDEFFXXX	HSBCGB2L	2021-11-18T19:28:01Z	EUR	Klara Weiss	DE75512108001245126199	Sunrise Holdings	GB29NWBK60161331926819	1	blank	Cancellation confirmed via mobile app.	blank	Payment cancelled per customer request.
MSG10011	ACCP	4200.5	blank	TXN20011	2020-10-03T07:42:16Z	HSBCGB2L	DEUTDEFFXXX	2020-10-03T07:45:50Z	GBP	James O'Connor	GB56BARC20201530093459	Alpine Tech Ltd	GB29NWBK60161331926819	2	blank	Processed via Faster Payments.	RSP10011	Payment accepted, credited to beneficiary.
MSG10012	RJCT	3000	BE01	TXN20012	2022-02-27T23:58:05Z	KRWBNK01	CITICNSH	2022-02-28T00:14:32Z	KRW	Kim Jisoo	KR700123456789012345678	Seoul Trading Co	KR700987654321098765432	1	Sanction screening failure.	Regulatory review triggered.	RSP10012	Payment rejected due to sanction screening.
MSG10013	ACCP	432.8	blank	TXN20013	2023-07-10T17:38:23Z	BNPAFRPP	HSBCGB2L	2023-07-10T17:42:32Z	EUR	Elodie Bernard	FR7630006000011234567890189	Grunwald AG	DE89370400440532013000	2	blank	Processed via SEPA.	blank	Payment accepted and settled.
MSG10014	ACCP	1287.65	blank	TXN20014	2021-08-11T14:03:56Z	BOFAUS3N	HSBCGB2L	2021-08-11T14:06:41Z	USD	Shawn Evans	US55667788990011223344	Omega Services LLC	US44332211009876543210	2	blank	Processed via ACH.	RSP10014	Payment accepted, credited to beneficiary.
MSG10015	PDNG	5000	MS03	TXN20015	2024-04-01T07:02:03Z	DEUTDEFFXXX	HSBCGB2L	2024-04-01T07:22:19Z	EUR	Gabriel Fischer	DE75512108001245126199	Sapphire Tech	FR7630006000011234567890189	3	Compliance review required.	Expected completion in 24 hours.	blank	Payment pending due to compliance review.
MSG10016	RJCT	1620	AC06	TXN20016	2022-06-17T12:35:44Z	BNPAFRPP	DEUTDEFFXXX	2022-06-17T12:49:10Z	EUR	Sophie Lefevre	FR7630006000011234567890189	Vega Pharmaceuticals	DE89370400440532013000	3	Account closed.	Customer advised to contact branch.	RSP10016	Payment rejected due to account closed.
MSG10017	ACCP	3548	blank	TXN20017	2023-01-19T18:29:08Z	MIZUJPJT	HSBCGB2L	2023-01-19T18:32:17Z	JPY	Yuki Sato	JP89370400440532013000	Envision Group	GB29NWBK60161331926819	2	blank	Processed via SWIFT.	RSP10017	Payment accepted and credited to beneficiary.
MSG10018	ACCP	1650	blank	TXN20018	2021-05-28T09:50:31Z	HSBCGB2L	CHASUS33	2021-05-28T09:54:13Z	USD	Emily Carter	US99887766554433221100	Aurora Dynamics LLC	US11003322114455667788	2	blank	Processed via Fedwire.	blank	Payment accepted and credited to beneficiary.
MSG10019	CANC	0	blank	TXN20019	2020-03-08T22:19:12Z	BNPAFRPP	HSBCGB2L	2020-03-08T22:20:29Z	GBP	Holly Bennett	GB56BARC20201530093459	Lakeside Ventures Ltd	GB29NWBK60161331926819	1	blank	Cancellation confirmed via mobile app.	blank	Payment cancelled prior to processing.
MSG10020	RJCT	990	RC99	TXN20020	2021-12-15T16:25:14Z	CHASUS33	BOFAUS3N	2021-12-15T16:34:21Z	USD	Michael Johnson	US55667788990011223344	Neptune Shipping	US44332211009876543210	1	Invalid IBAN format.	Customer notified to update account.	RSP10020	Payment rejected due to invalid IBAN.

What the 250 rows show

from the 250-row sample

1,997median original_amount
6original currencies
25inquiry institutions
27responding institutions
30reason descriptions
2median clearing_chain_position

status_code250 rows by value

original_amount250 rows, in bands of 1B

Median 1,997, from 0.0 to 10,000,000,000.

reason_code103 rows with a value · 147 left blank

MD0119
AC0418
RC0117
AM0414
AC0612
MS0311
RC998
BE014

19 columns by typefrom the column list below

string 15
integer 1
float 1
datetime 2

Columns

19 columns in three groups

blueprint · 19 columns
column	type	description	example
Text 15 columns
`message_id`	string	Unique identifier for the payment status inquiry message (pacs.028)unique	MSG10001
`original_transaction_id`	string	Identifier of the original payment transaction being inquired about	TXN20001
`inquiry_institution_id`	string	Identifier (e.g., BIC or bank code) of the financial institution sending the inquiry	DEUTDEFFXXX
`responding_institution_id`	string	Identifier (e.g., BIC or bank code) of the financial institution responding to the inquiry	BNPAFRPP
`status_code`	string	Standardized code indicating the current status of the payment transaction (e.g., 'ACCP', 'RJCT', 'PDNG')ACCP · RJCT · PDNG · CANC · PART	ACCP
`status_description`	string	Human-readable explanation of the payment statusup to 255 · optional	Payment accepted.
`original_currency`	string	ISO 4217 currency code for the original transaction amount6 currencies	EUR
`debtor_name`	string	Name of the party initiating the original paymentup to 100 · optional	Helena Schumacher
`debtor_account`	string	Account number or IBAN of the debtorup to 34 · optional	DE89370400440532013000
`creditor_name`	string	Name of the party receiving the original paymentup to 100 · optional	Apex Trading Corp
`creditor_account`	string	Account number or IBAN of the creditorup to 34 · optional	US98765432109876543210
`reason_code`	string	Standardized code for the reason of rejection or pending status, if applicableup to 10 · 8 codes · optional	AM04
`reason_description`	string	Human-readable explanation for the reason codeup to 255 · optional	Invalid account number.
`additional_information`	string	Any supplementary information provided by the responding institutionoptional	Processed via SEPA.
`response_reference_id`	string	Unique identifier for the response message, if different from message_idoptional	RSP10001
Numbers 2 columns
`original_amount`	float	Amount of the original payment transaction0 or more	3421.25
`clearing_chain_position`	integer	Sequence number indicating the position of the responding institution in the clearing chain1 or more · optional	2
Dates and times 2 columns
`inquiry_datetime`	datetime	Timestamp when the payment status inquiry was sent	2021-03-12T09:21:32Z
`status_datetime`	datetime	Timestamp when the status was determined by the responding institution	2021-03-12T09:26:41Z

Use it for

A finance dashboard
Original_amount by status_code and a breakdown of reason_code. Excel, Power BI or Tableau.
What pattern can you find in 250 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 250 rows.
Messages250
MSG100013421.25ACCP
MS-G100022950RJCT
msg100031200.5PDNG
A software demo
Believable messages with original_transaction_id, inquiry_datetime and inquiry_institution_id to fill a screen in front of a buyer.

This dataset250 rows19 columns

Yours1,000 rows19 columns

blueprint · iso20022-request-for-payment-status-pacs028

Behind this dataset

Same schema. As many rows as you need.

These 250 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Original payment transaction ID
Inquiry reference unique
Instructing agent identification
Instructed agent identification
Original message type referenced
Response deadline specified

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: iso20022-request-for-payment-status-pacs028

What should your data show?

No signup. No card.

Sample rows

What the 250 rows show

Columns

Use it for

A finance dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Finance

What should your data show?