ISO20022 Securities Settlement Transaction Instruction (sese.023)

This dataset provides detailed, standardized records of securities settlement transaction instructions as per ISO20022 sese.023, including trade details, parties involved, settlement accounts, and status tracking. It enables robust reconciliation, regulatory reporting, and operational analysis for financial institutions and market infrastructures.

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

Automated reconciliation and exception management for securities settlements

Sample rows

preview · 8 of 300 rows · all 24 columns
instruction_idstringsecurity_typestringquantityfloatdepository_namestringtransaction_typestringtrade_datedatesettlement_datedatesecurity_isinstringsecurity_namestringcurrencystringsettlement_amountfloatbuyer_party_idstringbuyer_party_namestringseller_party_idstringseller_party_namestringsettlement_account_idstringsettlement_account_namestringdepository_idstringtrade_referencestringsettlement_statusstringinstruction_creation_datetimedatetimelast_update_datetimedatetimecounterparty_bicstringnotesstring
DVP-9Q2X2W5Equity15000Depository Trust Co.DVP2022-02-162022-02-18US5949181045Microsoft CorporationUSD4447500BID00123Citadel SecuritiesSID00987Morgan StanleyACC10001Citadel SettlementsDTC001TRD-20220216-01Settled2022-02-16T09:13:442022-02-20T13:07:19MORGANUS33Regular DVP equity trade
FOP-8T3ZX9G1Bond250000Euroclear FranceFOP2022-10-112022-10-13FR0000131104BNP Paribas SAEURblankBID00456UBS Asset MgmtSID00345CommerzbankACC20012UBS Bond FundEUCLRFRTRD-20221011-04Settled2022-10-11T10:25:392022-10-14T09:42:31COBADEFFFOP bond transfer, Euroclear
SEC-LEND-5S8H2E4Equity250.5Euroclear UK & Intl.Securities Lending2023-01-052023-01-05GB0002634946Barclays PLCGBPblankBID00751HSBC MarketsSID00234BlackRock UKACC30212HSBC Lending AccountCRESTUKTRD-20230105-07Partially Settled2023-01-05T07:55:172023-01-05T15:02:11HBUKGB4BPartial return, recall in progress
COL-MGMT-3Q9Z6T2Bond3000Japan Securities DepositoryCollateral Management2024-03-182024-03-18JP3902900004Mitsubishi UFJ Financial GroupJPYblankBID00088Nomura HoldingsSID00789Goldman Sachs JapanACC50009Nomura CollateralJASDECJPTRD-20240318-02Cancelled2024-03-18T08:18:222024-03-18T18:37:22GSJPJPJTTrade cancelled by counterparty
DVP-1M4G8V7Equity50000Depository Trust Co.DVP2022-07-212022-07-25US0378331005Apple Inc.USD8095000BID00216Bank of AmericaSID00512Fidelity FundsACC10114BofA SettlementsDTC001TRD-20220721-06Settled2022-07-21T15:11:572022-07-27T17:10:29BOFAUS3NLarge cap equity DVP
FOP-7N3B2Q1Bond100000CDS Clearing and DepositoryFOP2023-05-032023-05-09CA135087L981Canadian Imperial Bank of CommerceCADblankBID00543RBC Wealth MgmtSID00117TD SecuritiesACC20803RBC CAD BondsCDSCATRD-20230503-03Pending2023-05-03T11:13:042023-05-09T12:50:00TDOMCATTTORPending FOP, Canadian bond
SEC-LEND-1L4R6X7Equity0.0001Depository Trust Co.Securities Lending2023-09-192023-09-20US92826C8394Visa Inc. Class AUSDblankBID00384State StreetSID00673Northern TrustACC90103State St. LendingDTC001TRD-20230919-09Failed2023-09-19T13:20:112023-09-20T10:02:12CNORUS44Minimum quantity test, failed settlement
COL-MGMT-6F9E7U3Bond1000Clearstream BankingCollateral Management2022-11-292022-11-29DE000A1EWWW0Adidas AG BondEURblankBID00802Deutsche BankSID00791Credit SuisseACC50101DB CollateralCLRCLEARTRD-20221129-01Cancelled2022-11-29T09:40:552022-11-29T14:04:20CRESCHZZ80ACollateral recall, cancelled

What the 300 rows show

from the 300-row sample
  • 9,105median quantity
  • 5settlement statuses
  • 6transaction types
  • 10currencies
  • 45depositories
  • 1,068,552median settlement_amount
security_type300 rows by value
090180172Equity57%111Bond37%10Fund3%6Deriva…2%1Other0%
quantity300 rows, in bands of 1M
015030029900000000105M10Mquantity →

Median 9,105, from 0.00 to 10,000,000.

depository_name300 rows · top 10 of 38 values
  1. Euroclear France31
  2. Depository Trust Company20
  3. SIX Swiss Exchange19
  4. Japan Securities Depository Center18
  5. Euroclear Germany17
  6. Japan Securities Depository16
  7. Depository Trust & Clearing Corp16
  8. Depository Trust Co.15
  9. Strate South Africa13
  10. Canadian Depository for Securities13
24 columns by typefrom the column list below
  • string 18
  • float 2
  • date 2
  • datetime 2

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 18 columns
instruction_idstringUnique identifier for the securities settlement transaction instructionuniqueDVP-9Q2X2W5
transaction_typestringType of securities settlement transaction (e.g., delivery versus payment, free of payment, securities lending)5 valuesDVP
security_isinstringInternational Securities Identification Number (ISIN) of the security being settledUS5949181045
security_namestringName of the security being settledMicrosoft Corporation
security_typestringType of security (e.g., equity, bond, fund, derivative)Equity · Bond · Fund · Derivative · OtherEquity
currencystringCurrency code for the settlement amount (ISO 4217)10 currenciesUSD
buyer_party_idstringUnique identifier for the buyer partyBID00123
buyer_party_namestringName of the buyer partyCitadel Securities
seller_party_idstringUnique identifier for the seller partySID00987
seller_party_namestringName of the seller partyMorgan Stanley
settlement_account_idstringIdentifier for the settlement account usedACC10001
settlement_account_namestringName of the settlement accountCitadel Settlements
depository_idstringIdentifier for the central securities depository (CSD) or custodianDTC001
depository_namestringName of the central securities depository (CSD) or custodianDepository Trust Co.
trade_referencestringReference identifier for the original trade (e.g., trade confirmation number)optionalTRD-20220216-01
settlement_statusstringCurrent status of the settlement instructionPending · Settled · Failed · Cancelled · Partially SettledSettled
counterparty_bicstringBank Identifier Code (BIC) of the counterpartyoptionalMORGANUS33
notesstringAdditional notes or comments about the transactionoptionalRegular DVP equity trade
Numbers 2 columns
quantityfloatQuantity of securities to be settled0 or more15000
settlement_amountfloatTotal monetary amount to be settled0 or more · optional4447500
Dates and times 4 columns
trade_datedateDate the trade was executed2022-02-16
settlement_datedateDate the securities are scheduled to settle2022-02-18
instruction_creation_datetimedatetimeTimestamp when the instruction was created2022-02-16T09:13:44
last_update_datetimedatetimeTimestamp of the last update to the instruction2022-02-20T13:07:19

Use it for

  • median quantity9,105300 rowsmean quantity by secu…16.2kEqui…67kBond12.7kFund38.2kDeri…

    A finance dashboard

    Quantity by security_type and a breakdown of depository_name. Excel, Power BI or Tableau.

  • What pattern can you find in 300 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 300 rows.

  • A software demo

    Believable instructions with transaction_type, trade_date and settlement_date 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 dataset300 rows24 columns
Yours1,000 rows24 columns

blueprint · iso20022-securities-settlement-transaction-instruction-sese023

Behind this dataset

Same schema. As many rows as you need.

These 300 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
  • Trade reference unique per transaction
  • Settlement date T+2 or T+3 standard
  • ISIN code valid for security
  • Quantity and amount specified
  • Delivery versus payment flag
  • Counterparty account details
  • Settlement currency specified
  • Charges and fees itemized
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-securities-settlement-transaction-instruction-sese023

More in Finance

Browse all
Also in FinanceSWIFT MT540 Securities Trade ConfirmationTransaction Categorization DatasetAccounts Receivable and Aging AnalysisAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.