ISO20022 Mandate Amendment Request (pain.010)

This dataset provides detailed records of ISO20022 direct debit mandate amendment requests, including account changes, amount limits, frequency adjustments, and comprehensive audit trails for regulatory compliance. It enables financial institutions to track, manage, and analyze mandate modifications with full transparency and traceability.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Automated processing and tracking of direct debit mandate amendments

Sample rows

preview · 8 of 200 rows · all 24 columns
amendment_request_idstringamendment_typestringprevious_amount_limitfloatprevious_frequencystringmandate_idstringrequest_datedatetimerequested_bystringdebtor_namestringdebtor_account_numberstringdebtor_bank_idstringcreditor_namestringcreditor_account_numberstringcreditor_bank_idstringprevious_account_numberstringnew_account_numberstringnew_amount_limitfloatnew_frequencystringeffective_datedatestatusstringaudit_trail_idstringaudit_actionstringaudit_timestampdatetimeaudit_userstringreason_for_amendmentstring
AMREQ-0019FQ3LKZaccount_changeblankmonthlyMANDT-00012023-07-12T09:45:21Zuser_0001Hanna SchneiderDE89370400440532013000DEUTDEFFFrankfurt Utilities GmbHDE45500105175407324931COBADEFFDE89370400440532013001DE89370400440532013000blankblank2023-07-18pendingAUDT-0001created2023-07-12T10:17:08Zadmin_de_1Customer relocated to a new address and updated bank account details.
AMREQ-0022KJ8HPTfrequency_changeblankmonthlyMANDT-00022024-02-19T15:03:55Zuser_0002Sakura TanakaJP892010000001234567890SMBCJPJTTokyo Digital ServicesJP892010000009876543210MIZUJPJTblankblankblankquarterly2024-02-21approvedAUDT-0002approved2024-02-19T15:31:11Ztokyo_ops_2Customer switched to quarterly billing for better budgeting.
AMREQ-0038VZ7EWBamount_limit_change10000monthlyMANDT-00032022-11-05T11:22:43Zuser_0003InnovateNow GmbHDE12500105170648489898BYLADEM1DREGlobal Software SolutionsGB23BARC20201555555555BARCGB22blankblank25000blank2022-11-10completedAUDT-0003approved2022-11-05T13:09:19Zglobal_admin_3Contract expanded to include additional services.
AMREQ-0045YH2SDCfrequency_changeblankmonthlyMANDT-00042021-04-17T08:52:37Zuser_0004José Luis FernándezES7921000813610123456789CAIXESBBXXXBarcelona Fitness ClubES9121000813619876543210BBVAESMMXXXblankblankblankweekly2021-04-20completedAUDT-0004modified2021-04-17T09:00:03Zbcn_ops_4Customer upgraded membership to weekly sessions.
AMREQ-0054BW6MZQamount_limit_change5000monthlyMANDT-00052024-03-02T14:04:19Zuser_0005Sunrise Solutions LLCUS123456789012345678CITIUS33Atlanta Water AuthorityUS987654321098765432WELLSUS6blankblank15000blank2024-03-07pendingAUDT-0005created2024-03-02T15:12:00Zatl_admin_5Annual price adjustment for utility services.
AMREQ-0063RJ4PLTaccount_changeblankmonthlyMANDT-00062023-09-29T10:19:01Zuser_0006Maxime DupontFR7630006000011234567890189BNPAFRPPParis Telecom SAFR7630006000019876543210123SOGEFRPPFR7630006000011234567890188FR7630006000011234567890189blankblank2023-10-02approvedAUDT-0006approved2023-09-29T11:01:45Zparis_ops_6Customer updated account due to new bank merger.
AMREQ-0078FC5TNBfrequency_changeblankquarterlyMANDT-00072023-01-22T17:21:14Zuser_0007Xin LiCN8901234567890123456789ICBKCNBJShanghai GasworksCN8909876543210987654321BOCHCNBJblankblankblankmonthly2023-01-25pendingAUDT-0007created2023-01-22T17:41:55Zshanghai_admin_7Customer switched to monthly payments for convenience.
AMREQ-0082LT3VXDamount_limit_change25000monthlyMANDT-00082022-08-13T12:44:06Zuser_0008Greenfield Ventures LtdGB99WEST12345698765432LOYDGB2LLondon Electric PLCGB99WEST12345612345678NWBKGB2Lblankblank50000blank2022-08-19approvedAUDT-0008approved2022-08-13T13:00:12Zlondon_fin_8Company expanded operations, increasing utility usage.

What the 200 rows show

from the 200-row sample
  • 12,000median previous_amount_limit
  • 4statuses
  • 4audit actions
  • 6new frequencies
  • 40,000median new_amount_limit
amendment_type200 rows by value
0408046account_…23%65amount_l…33%72frequenc…36%17other9%
previous_amount_limit65 rows, in bands of 10M
0357063000000002050M100Mprevious_amount_limit →

Median 12,000, from 0.0 to 100,000,000.

previous_frequency183 rows with a value · 17 left blank
  1. monthly153
  2. quarterly17
  3. annually6
  4. weekly5
  5. daily2
24 columns by typefrom the column list below
  • string 19
  • float 2
  • date 1
  • datetime 2

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 19 columns
amendment_request_idstringUnique identifier for the mandate amendment requestuniqueAMREQ-0019FQ3LKZ
mandate_idstringUnique identifier for the original direct debit mandate being amendedMANDT-0001
requested_bystringName or identifier of the party requesting the amendmentuser_0001
debtor_namestringName of the account holder (debtor) for the mandateHanna Schneider
debtor_account_numberstringAccount number of the debtorDE89370400440532013000
debtor_bank_idstringBank identifier (e.g., BIC, routing number) for the debtor's bankDEUTDEFF
creditor_namestringName of the creditor (entity receiving the direct debit)Frankfurt Utilities GmbH
creditor_account_numberstringAccount number of the creditorDE45500105175407324931
creditor_bank_idstringBank identifier for the creditor's bankCOBADEFF
amendment_typestringType of amendment requested (e.g., account_change, amount_limit_change, frequency_change)4 valuesaccount_change
previous_account_numberstringPrevious debtor account number before amendment (if applicable)optionalDE89370400440532013001
new_account_numberstringNew debtor account number after amendment (if applicable)optionalDE89370400440532013000
previous_frequencystringPrevious frequency of direct debit (e.g., monthly, quarterly, annually) before amendment6 values · optionalmonthly
new_frequencystringNew frequency of direct debit after amendment6 values · optionalquarterly
statusstringCurrent status of the amendment request (e.g., pending, approved, rejected, completed)pending · approved · rejected · completedpending
audit_trail_idstringIdentifier for the audit trail record associated with this amendment requestAUDT-0001
audit_actionstringAction performed in the audit trail (e.g., created, modified, approved, rejected)created · modified · approved · rejectedcreated
audit_userstringUser or system who performed the audit actionadmin_de_1
reason_for_amendmentstringDetailed reason for the mandate amendment requestoptionalContract renewal.
Numbers 2 columns
previous_amount_limitfloatPrevious maximum amount allowed per debit before amendment (if applicable)0 or more · optional10000
new_amount_limitfloatNew maximum amount allowed per debit after amendment (if applicable)0 or more · optional25000
Dates and times 3 columns
request_datedatetimeTimestamp when the amendment request was submitted2023-07-12T09:45:21Z
effective_datedateDate when the amendment becomes effective2023-07-18
audit_timestampdatetimeTimestamp of the audit action2023-07-12T10:17:08Z

Use it for

  • median previou…12,00065 rowsrows by amendment type46acco…65amou…72freq…17other

    A finance dashboard

    Previous_amount_limit by amendment_type and a breakdown of previous_frequency. 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.

  • A software demo

    Believable amendment requests with mandate_id, request_date and requested_by to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows24 columns
Yours1,000 rows24 columns

blueprint · iso20022-mandate-amendment-request-pain010

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 24 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 mandate reference required
  • Amendment effective date specified
  • Change reason code documented
  • Debtor consent for material changes
  • Previous and new values tracked
  • Amendment sequence number increments
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
iso20022-mandate-amendment-request-pain010

More in Finance

Browse all
Also in FinanceISO20022 Mandate Initiation Request (pain.009)Loan Default Prediction DatasetBank Transaction Categorization SampleAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.