ISO20022 Creditor Payment Deactivation Request (pain.014)
This dataset provides detailed records of ISO20022 creditor payment account deactivation requests, capturing essential information such as request type, reason, account and creditor details, workflow status, and processing dates. It enables financial institutions to track, audit, and analyze account suspension, dormancy, and closure activities for compliance, risk management, and operational efficiency.
Sample rows
preview · 8 of 200 rows · all 26 columns| request_idstring | account_status_beforestring | account_countrystring | account_idstring | creditor_namestring | creditor_idstring | request_typestring | request_reasonstring | request_datedate | effective_datedate | expected_reactivation_datedate | initiator_namestring | initiator_rolestring | contact_emailstring | contact_phonestring | account_status_afterstring | bank_namestring | bank_branch_codestring | account_currencystring | account_street_addressstring | account_citystring | account_statestring | account_postal_codestring | additional_notesstring | processing_statusstring | processing_datedate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REQ-3F7A9D2B | active | US | ACC-10001-US | Joshua Taylor | US-489-53-2198 | temporary_hold | Travel abroad for extended period | 2023-11-02 | 2023-11-05 | 2024-05-07 | Joshua Taylor | account_holder | joshua.taylor@ | +1-917-555-0092 | suspended | First National Bank USA | FNBUS-1001 | USD | 303 W 38th St | New York | NY | 10018 | Temporary hold requested due to international travel. | pending | blank |
| REQ-91C7A-7B2F | active | IN | ACC-10002-IN | Riya Kapoor | IN-PAN-BBTPK2307C | temporary_hold | Medical treatment requirement | 2024-02-15 | 2024-02-18 | 2024-09-20 | Riya Kapoor | account_holder | riya.kapoor@ | +91-22-4030-1023 | suspended | State Bank of India | SBIIN-8302 | INR | 55 Colaba Causeway | Mumbai | MH | 400005 | Customer requested suspension until health improves. | approved | 2024-02-19 |
| REQ-6A4B-8H92 | active | GB | ACC-10003-GB | Harold Smythe | GB-NINO-JA123456C | permanent_closure | Relocating overseas permanently | 2023-12-10 | 2023-12-12 | blank | Harold Smythe | account_holder | harold.smythe@ | +44-20-7451-1122 | closed | Barclays UK | BARUK-4521 | GBP | 88 Bishopsgate | London | London | EC2N4AJ | Permanent closure due to relocation. | completed | 2023-12-14 |
| REQ-17D8A2E9 | active | AU | ACC-10004-AU | James Wong | AU-ABN-75912345678 | dormancy_trigger | No activity for 12 months | 2024-03-20 | 2024-03-22 | blank | Samantha Thorpe | bank_staff | samantha.thorpe@ | +61-3-9602-8741 | dormant | National Australia Bank | NABAU-3402 | AUD | 120 Collins St | Melbourne | VIC | 3000 | Account dormant due to inactivity. | completed | 2024-03-23 |
| REQ-8C9B1A-12F3 | active | SA | ACC-10005-SA | Fatima Al Saud | SA-NID-1012345670 | permanent_closure | Account closed due to death of account holder | 2022-08-11 | 2022-08-15 | blank | Alyan Estate Services | authorized_representative | estate.alyan@ | +966-11-292-8300 | closed | Saudi National Bank | SNBSA-9004 | SAR | 77 King Fahad Rd | Riyadh | Riyadh | 11564 | Closure processed by estate services. | approved | 2022-08-17 |
| REQ-CC3D229B | active | SE | ACC-10006-SE | Erik Larsson | SE-PERS-850314-1234 | dormancy_trigger | Regulatory dormancy for inactivity | 2023-09-10 | 2023-09-13 | blank | Anna Svensson | bank_staff | anna.svensson@ | +46-8-700-1120 | dormant | Swedbank | SWEDSE-8002 | SEK | 22 Kungsgatan | Stockholm | Stockholm | 11135 | Dormancy due to regulatory requirements. | pending | blank |
| REQ-A3B2C1D4 | suspended | GH | ACC-10007-GH | Kwame Boateng | GH-TIN-1200456789 | permanent_closure | Fraudulent activity detected | 2024-01-05 | 2024-01-07 | blank | Compliance Unit GH | other | compliance@ | +233-30-221-1101 | closed | Ecobank Ghana | ECOGH-7001 | GHS | 17 Independence Ave | Accra | Greater Accra | GA121 | Account closed due to confirmed fraudulent activity. | rejected | 2024-01-08 |
| REQ-4E7F-1B56 | active | CN | ACC-10008-CN | Shanghai Trading Ltd. | CN-BUS-91310115056812345J | temporary_hold | Corporate restructuring process | 2024-03-24 | 2024-03-27 | 2024-07-01 | Han Li | authorized_representative | li.han@ | +86-21-5010-3921 | suspended | Bank of China | BOCCN-5102 | CNY | 99 Nanjing Rd | Shanghai | Shanghai | 200003 | Temporary suspension for company restructuring. | completed | 2024-03-29 |
| REQ-8FD1-4C2B | active | IE | ACC-10009-IE | Siobhan Murphy | IE-PPP-1234567A | dormancy_trigger | Manual dormancy by bank staff | 2022-06-19 | 2022-06-22 | blank | John O'Donnell | bank_staff | john.odonnell@ | +353-1-660-1234 | dormant | Allied Irish Banks | AIBIE-2005 | EUR | 12 St Stephen's Green | Dublin | Leinster | D02VR99 | Dormancy triggered by bank staff after review. | completed | 2022-06-23 |
| REQ-5B3A-2F9C | active | MX | ACC-10010-MX | Maria Sanchez | MX-RFC-SASM800101ABC | permanent_closure | Duplicate account closure | 2023-05-14 | 2023-05-16 | blank | Maria Sanchez | account_holder | maria.sanchez@ | +52-55-5312-8012 | closed | Banamex | BANMX-9012 | MXN | 45 Avenida Insurgentes | Mexico City | CDMX | 06760 | Duplicate account identified and closed. | approved | 2023-05-18 |
| REQ-2C9D-7E3B | active | GB | ACC-10011-GB | London Logistics Ltd. | GB-COMP-9827634 | temporary_hold | Legal compliance audit | 2023-07-21 | 2023-07-23 | 2023-11-23 | Charlotte Green | authorized_representative | c.green@ | +44-20-7851-3901 | suspended | HSBC UK | HSBUK-3344 | GBP | 201 Euston Road | London | London | NW12DN | Temporary hold for legal compliance. | pending | blank |
| REQ-5A8B-3C1E | active | CA | ACC-10012-CA | Emma Chen | CA-SIN-123456789 | dormancy_trigger | No deposits or withdrawals for 14 months | 2024-04-01 | 2024-04-04 | blank | Robert Lee | bank_staff | robert.lee@ | +1-416-555-2081 | dormant | Royal Bank of Canada | RBCCA-3012 | CAD | 500 Bay St | Toronto | ON | M5G2C8 | Dormancy due to inactivity over 1 year. | approved | 2024-04-05 |
| REQ-7F2D-6A9E | active | IN | ACC-10013-IN | Anjali Mehra | IN-PAN-CHYPM1356K | permanent_closure | Customer requested closure due to fraud suspicion | 2023-08-10 | 2023-08-12 | blank | Anjali Mehra | account_holder | anjali.mehra@ | +91-22-4125-7924 | closed | HDFC Bank | HDFCI-9912 | INR | 30 Marine Drive | Mumbai | MH | 400002 | Fraud suspected; closure requested. | completed | 2023-08-14 |
| REQ-3A1E-5C2F | active | QA | ACC-10014-QA | Mohammed Al Jassim | QA-QID-23456789012 | dormancy_trigger | No transaction activity since 2022 | 2024-01-17 | 2024-01-20 | blank | Fatima Al Nuaimi | bank_staff | fatima.nuaimi@ | +974-4496-2120 | dormant | Commercial Bank of Qatar | CBQQA-5101 | QAR | 22 Al Corniche St | Doha | Doha | 12345 | Dormancy triggered after review. | pending | blank |
| REQ-6C2B-1E8D | active | US | ACC-10015-US | Olivia Walker | blank | temporary_hold | Extended leave for education abroad | 2023-04-10 | 2023-04-12 | 2023-10-15 | Olivia Walker | account_holder | olivia.walker@ | +1-312-555-1034 | suspended | Bank of America | BOAUS-2301 | USD | 121 S Wacker Dr | Chicago | IL | 60606 | Hold due to university program. | approved | 2023-04-13 |
| REQ-9F6C-2A8B | active | RU | ACC-10016-RU | Ivan Petrov | RU-INN-7707083893 | permanent_closure | Customer emigrated and requested closure | 2022-12-15 | 2022-12-18 | blank | Ivan Petrov | account_holder | ivan.petrov@ | +7-495-123-4455 | closed | Sberbank | SBERU-4007 | RUB | 55 Tverskaya St | Moscow | Moscow | 125009 | Account closed due to emigration. | completed | 2022-12-20 |
| REQ-7E1B-4C6D | active | IN | ACC-10017-IN | Amitabh Joshi | blank | temporary_hold | Sabbatical leave from work | 2024-03-10 | 2024-03-12 | 2024-09-12 | Amitabh Joshi | account_holder | amitabh.joshi@ | +91-22-3091-8772 | suspended | Axis Bank | AXSIN-2110 | INR | 18 Andheri East | Mumbai | MH | 400069 | Temporary hold for sabbatical. | pending | blank |
| REQ-2A3C-9F8E | active | US | ACC-10018-US | Michael Johnson | US-321-44-7852 | dormancy_trigger | Manual dormancy by compliance team | 2023-06-25 | 2023-06-27 | blank | Kimberly Nash | bank_staff | kimberly.nash@ | +1-212-555-3412 | dormant | Chase Bank | CHSUS-1204 | USD | 450 Park Ave | New York | NY | 10022 | Dormancy triggered by compliance department. | approved | 2023-06-28 |
| REQ-6C7D-8A2B | active | AU | ACC-10019-AU | Jessica Turner | AU-ABN-68912345987 | temporary_hold | Extended business trip overseas | 2024-02-05 | 2024-02-08 | 2024-07-08 | Jessica Turner | account_holder | jessica.turner@ | +61-2-9521-3345 | suspended | National Australia Bank | NABAU-3409 | AUD | 42 Pitt St | Sydney | NSW | 2000 | Temporary hold for overseas assignment. | pending | blank |
| REQ-4D2C-6E1F | active | GH | ACC-10020-GH | Kofi Mensah | GH-TIN-1300456789 | permanent_closure | Account holder deceased | 2022-10-04 | 2022-10-07 | blank | Mensah Estate | authorized_representative | estate.mensah@ | +233-30-221-1155 | closed | Ecobank Ghana | ECOGH-7010 | GHS | 20 Ring Road Central | Accra | Greater Accra | GA152 | Closure processed by estate representative. | completed | 2022-10-08 |
What the 200 rows show
from the 200-row sample- 3request types
- 3account status afters
- 4initiator roles
- 4processing statuses
- 18account currencies
- 60account cities
- string 22
- date 4
Columns
26 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 22 columns | |||
request_id | string | Unique identifier for the deactivation requestunique | REQ-3F7A9D2B |
account_id | string | Unique identifier for the payment account being deactivated or suspended | ACC-10001-US |
creditor_name | string | Name of the creditor or account holder | Joshua Taylor |
creditor_id | string | Unique identifier for the creditor (e.g., tax ID, organization number)optional | US-489-53-2198 |
request_type | string | Type of deactivation request (temporary hold, dormancy, permanent closure)temporary_hold · dormancy_trigger · permanent_closure | temporary_hold |
request_reason | string | Reason for the deactivation or suspension request | Legal compliance audit |
initiator_name | string | Name of the person or entity initiating the request | Joshua Taylor |
initiator_role | string | Role of the initiator (e.g., account holder, bank staff, authorized representative)4 values | account_holder |
contact_email | string | Email address for correspondence regarding the requestoptional | riya.kapoor@ |
contact_phone | string | Phone number for correspondence regarding the requestoptional | +1-917-555-0092 |
account_status_before | string | Status of the account before the request (e.g., active, dormant, suspended)active · dormant · suspended · closed | active |
account_status_after | string | Status of the account after the request is processedactive · dormant · suspended · closed | suspended |
bank_name | string | Name of the bank or financial institution holding the account | First National Bank USA |
bank_branch_code | string | Branch code of the bank where the account is heldoptional | FNBUS-1001 |
account_currency | string | Currency code of the account (ISO 4217 format)optional | USD |
account_street_address | string | Street address of the account holder or creditoroptional | 303 W 38th St |
account_city | string | City of the account holder or creditoroptional | New York |
account_state | string | State or province of the account holder or creditoroptional | NY |
account_postal_code | string | Postal code of the account holder or creditoroptional | 10018 |
account_country | string | Country of the account holder or creditor (ISO 3166-1 alpha-2)optional | US |
additional_notes | string | Any additional notes or comments related to the requestoptional | Hold for family leave. |
processing_status | string | Status of the request processing (e.g., pending, approved, rejected, completed)pending · approved · rejected · completed | pending |
| Dates and times 4 columns | |||
request_date | date | Date the deactivation request was submitted | 2023-11-02 |
effective_date | date | Date when the deactivation or suspension becomes effectiveoptional | 2023-11-05 |
expected_reactivation_date | date | Expected date for reactivation (if applicable, e.g., for temporary holds)optional | 2024-05-07 |
processing_date | date | Date when the request was processedoptional | 2024-02-19 |
Use it for
A finance dashboard
A breakdown of account_
country. Excel, Power BI or Tableau. What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Requests200REQ-3F7A9D2BactiveREQ-91C7A-7B2FactiveREQ-6A4B-8H92active
A software demo
Believable requests with account_
id, creditor_ name and creditor_ id to fill a screen in front of a buyer.
blueprint · iso20022-creditor-payment-deactivation-request-pain014
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 26 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.
- Account to be deactivated specified
- Deactivation type: temporary or permanent
- Reason code required
- Outstanding transactions cleared
- Balance transfer instructions if closing
- Notification to account holders
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-creditor-payment-deactivation-request-pain014