ISO20022 Trade Confirmation Status (tsmt.014)

This dataset provides comprehensive, time-stamped status updates for trade finance transactions, including letters of credit, documentary collections, and guarantees. It captures transaction details, involved parties, monetary amounts, document references, and standardized status codes, making it ideal for operational tracking, compliance reporting, and process optimization in international trade finance.

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

Real-time monitoring and auditing of trade finance transactions

Sample rows

preview · 8 of 250 rows · all 17 columns
confirmation_status_idstringdocument_typestringamountfloatcurrency_codestringtransaction_idstringtransaction_typestringstatus_codestringstatus_datetimedatetimeinitiating_party_idstringinitiating_party_namestringcounterparty_idstringcounterparty_namestringreference_numberstringdocument_numberstringdocument_issue_datedatestatus_descriptionstringremarksstring
TSMT-00001Invoice125000.55USDTXN-10001Letter of CreditCONFIRMED2023-02-06T14:23:31BANK-1001First National BankCORP-2001Pacific Exporters Ltd.LC-2023-10001INV-CORP-2001-20232023-02-03Letter of Credit confirmed by issuing bankLC confirmed for shipment of electronic goods
TSMT-00002Invoice135000USDTXN-10001Letter of CreditAMENDED2023-02-14T10:45:02BANK-1001First National BankCORP-2001Pacific Exporters Ltd.LC-2023-10001-AMENDINV-CORP-2001-2023-AMEND2023-02-03LC amount amended after beneficiary requestAmount increased due to additional shipment
TSMT-00003Guarantee Document7000000EURTXN-10002GuaranteeCONFIRMED2023-06-28T15:17:59BANK-1012Union Euro BankCORP-2015Nordic Construction GmbHGUAR-2023-10002GD-CORP-2015-20232023-06-21Guarantee issued for performance contractPerformance guarantee for contract #8652
TSMT-00004Guarantee Document7000000EURTXN-10003GuaranteeAMENDED2023-07-15T09:20:12BANK-1012Union Euro BankCORP-2015Nordic Construction GmbHGUAR-2023-10002-EXTGD-CORP-2015-2023-EXT2023-06-21Guarantee extended for additional 3 monthsGuarantee extended per project needs
TSMT-00005Bill of Lading9500.75CHFTXN-10004Documentary CollectionPENDING2022-11-21T11:10:05CORP-2030Global Trading Inc.BANK-1025West Africa Commercial BankDC-2022-10004BL-CORP-2030-20222022-11-15Documentary collection submitted, pending reviewAwaiting buyer acceptance for cocoa shipment
TSMT-00006blank0CHFTXN-10005Documentary CollectionCANCELLED2022-11-29T16:56:31BANK-1025West Africa Commercial BankCORP-2030Global Trading Inc.DC-2022-10005blankblankDocumentary collection cancelled by buyer requestCancelled due to withdrawal of purchase order
TSMT-00007Invoice25000GBPTXN-10006Letter of CreditPENDING2023-04-12T13:05:23BANK-1003North Atlantic BankCORP-2012Mosaic Textiles Pvt Ltd.LC-2023-10006INV-CORP-2012-20232023-04-09Letter of Credit application pending approvalPending compliance check for textile shipment
TSMT-00008blank0GBPTXN-10007Letter of CreditREJECTED2023-04-17T17:44:08BANK-1003North Atlantic BankCORP-2012Mosaic Textiles Pvt Ltd.LC-2023-10007blankblankLC rejected due to missing documentationRejected: Invoice and proof of origin not submitted

What the 250 rows show

from the 250-row sample

Guarantee Document (document type) stands out: mean amount is 12,841,528, against 100,817 for the rest.

  • 96,000median amount
  • 3transaction types
  • 5status codes
Mean amount by document_type195 rows
010M20M105.8kInvoice70 rows148.8kBill of …33 rows12.8MGuarante…72 rows4,079Other20 rows
amount250 rows, in bands of 10M
0125250244200000013050M100Mamount →

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

currency_code250 rows · 9 values
  1. USD92
  2. CHF26
  3. AUD23
  4. GBP22
  5. INR22
  6. EUR19
  7. ZAR17
  8. JPY15
  9. NOK14
17 columns by typefrom the column list below
  • string 14
  • float 1
  • date 1
  • datetime 1

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 14 columns
confirmation_status_idstringUnique identifier for each trade confirmation status updateuniqueTSMT-00001
transaction_idstringUnique identifier for the trade finance transactionTXN-10001
transaction_typestringType of trade finance transaction (e.g., Letter of Credit, Documentary Collection, Guarantee)Letter of Credit · Documentary Collection · GuaranteeLetter of Credit
status_codestringStandardized code representing the status of the transaction (e.g., CONFIRMED, PENDING, REJECTED)CONFIRMED · PENDING · REJECTED · CANCELLED · AMENDEDCONFIRMED
status_descriptionstringDetailed description of the current statusoptionalLC expiry date amended
initiating_party_idstringIdentifier for the party initiating the transaction (e.g., bank, corporate)BANK-1001
initiating_party_namestringName of the party initiating the transactionoptionalFirst National Bank
counterparty_idstringIdentifier for the counterparty involved in the transactionCORP-2001
counterparty_namestringName of the counterparty involved in the transactionoptionalPacific Exporters Ltd.
currency_codestringISO 4217 currency code for the transaction amount9 codesUSD
reference_numberstringExternal reference number for the transaction (e.g., bank reference)optionalLC-2023-10001
document_typestringType of document associated with the transaction (e.g., Invoice, Bill of Lading, Guarantee Document)Invoice · Bill of Lading · Guarantee Document · Other · optionalInvoice
document_numberstringIdentifier for the associated documentoptionalINV-CORP-2001-2023
remarksstringAdditional remarks or comments related to the status updateoptionalLC confirmed for shipment…
Numbers 1 column
amountfloatMonetary amount involved in the transaction0 or more125000.55
Dates and times 2 columns
status_datetimedatetimeDate and time when the status was updated2023-02-06T14:23:31
document_issue_datedateDate when the associated document was issuedoptional2023-02-03

Use it for

  • median amount96,000250 rowsmean amount by docume…105.8kInvo…148.8kBill…12.8MGuar…4.1kOther

    A finance dashboard

    Amount by document_type and a breakdown of currency_code. Excel, Power BI or Tableau.

  • Why do the 72 Guarantee Document rows have a mean amount of 12,841,528?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable confirmation statuses with transaction_id, transaction_type and status_code to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 dataset250 rows17 columns
Yours1,000 rows17 columns

blueprint · iso20022-trade-confirmation-status-tsmt014

Behind this dataset

Same schema. As many rows as you need.

These 250 rows came out of a blueprint — 17 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
  • Transaction reference unique
  • Trade status: pending, accepted, rejected, completed
  • Document compliance checked
  • Expiry date monitored
  • Amount and currency specified
  • Beneficiary and applicant identified
  • Issuing and advising bank details
  • Terms and conditions referenced
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-trade-confirmation-status-tsmt014

More in Finance

Browse all
Also in FinanceSWIFT MT700 Issue of Documentary CreditBank Transaction Category ClassificationBank Transaction Categorization SampleAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.