SWIFT MT707 Amendment to Documentary Credit
This dataset provides comprehensive records of amendments to documentary credits (letters of credit) processed via SWIFT MT707 messages, including changes to amount, expiry, required documents, and shipment terms. It enables detailed tracking of amendment history, involved banks, and status for compliance, audit, and operational analysis in international trade finance.
Sample rows
preview · 8 of 250 rows · all 22 columns| amendment_idstring | amendment_statusstring | amended_amountfloat | is_confirmedboolean | currencystring | original_credit_idstring | amendment_datedate | issuing_bank_namestring | issuing_bank_swift_codestring | beneficiary_namestring | beneficiary_account_numberstring | amendment_typestring | amended_expiry_datedate | amended_documents_requiredstring | effective_datedate | applicant_namestring | applicant_account_numberstring | advising_bank_namestring | advising_bank_swift_codestring | previous_amendment_idstring | amended_shipment_detailsstring | amendment_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AMD00001 | approved | 250000 | true | GBP | CRD10001 | 2023-02-15 | HSBC Bank PLC | HBUKGB4B | Winchester Textiles Ltd | GB42HSBC12345678901234 | amount | blank | blank | 2023-02-16 | Edinburgh Imports Ltd | GB29BARC12345678901222 | Barclays Bank | BARCGB22 | blank | blank | Increase of letter of credit amount to cover additional goods for shipment. |
| AMD00002 | approved | blank | false | blank | CRD10001 | 2023-07-10 | HSBC Bank PLC | HBUKGB4B | Winchester Textiles Ltd | GB42HSBC12345678901234 | expiry | 2025-07-10 | blank | 2023-07-10 | Edinburgh Imports Ltd | GB29BARC12345678901222 | Barclays Bank | BARCGB22 | AMD00001 | blank | Extended expiry date by 24 months due to delayed shipment from supplier. |
| AMD00003 | approved | blank | true | blank | CRD10002 | 2024-01-12 | Citibank N.A. | CITIGB2L | Global Electronics GmbH | DE89370400440532013000 | documents | blank | Certificate of Origin, Commercial Invoice | 2024-01-13 | Munich Tech Importers | DE12500105170648489890 | Deutsche Bank AG | DEUTDEFF | blank | blank | Additional documents required for customs clearance at destination. |
| AMD00004 | pending | blank | false | blank | CRD10002 | 2024-02-20 | Citibank N.A. | CITIGB2L | Global Electronics GmbH | DE89370400440532013000 | shipment | blank | blank | 2024-02-21 | Munich Tech Importers | DE12500105170648489890 | Deutsche Bank AG | DEUTDEFF | AMD00003 | Partial shipments now allowed, latest shipment date extended to 2024-10-01. | Shipment terms amended to allow partial deliveries due to supplier constraints. |
| AMD00005 | approved | 99999999.99 | true | USD | CRD10003 | 2023-11-05 | Bank of America | BOFAUS3N | Pacific Steel Works | US11300012345678901234 | amount | blank | blank | 2023-11-06 | Colorado Construction Co. | US111987654321098765 | Wells Fargo | WFBIUS6S | blank | blank | Amended amount reflects major contract expansion for infrastructure project. |
| AMD00006 | approved | blank | false | blank | CRD10004 | 2022-12-12 | Industrial and Commercial Bank of China | ICBKCNBJ | Beijing Machinery Corp | CN12345678901234567890 | expiry | 2024-12-12 | blank | 2022-12-13 | Shanghai Imports Ltd | CN98765432101234567890 | Bank of China | BKCHCNBJ | blank | blank | Expiry extended by 24 months to accommodate revised production schedule. |
| AMD00007 | approved | blank | true | blank | CRD10005 | 2023-06-20 | Royal Bank of Canada | ROYCCAT2 | Maple Timber Supplies | CA123456789012345678 | documents | blank | blank | 2023-06-21 | Vancouver Building Products | blank | Scotiabank | NOSCCATT | blank | blank | Document requirements revised to remove bill of lading for domestic shipments. |
| AMD00008 | pending | blank | false | blank | CRD10006 | 2024-03-18 | JPMorgan Chase | CHASUS33 | Atlantic Seafood Inc. | US987654321123456789 | shipment | blank | blank | 2024-03-19 | New York Food Imports | US111000999888777666 | Bank of America | BOFAUS3N | blank | Amended shipment routing to include Philadelphia port, latest shipment date 2024-09-30. | Adjusted shipment route and dates for seasonal logistics. |
| AMD00009 | pending | blank | false | blank | CRD10007 | 2022-09-11 | Deutsche Bank AG | DEUTDEFF | Frankfurt Engineering GmbH | DE12500105170648489890 | other | blank | blank | 2022-09-12 | Berlin Manufacturing AG | DE89370400440532013000 | Commerzbank | COBADEFF | blank | blank | Correction of spelling error in beneficiary name; no financial impact. |
| AMD00010 | approved | 1000000 | true | EUR | CRD10008 | 2023-05-28 | Banco Santander | BSCHESMM | Valencia Agri Foods | ES9121000418450200051332 | amount | blank | blank | 2023-05-29 | Madrid Produce Importers | ES9121000418450200051333 | BBVA | BBVAESMM | blank | blank | Amended amount to EUR 1,000,000 for expanded export order. |
| AMD00011 | approved | blank | true | blank | CRD10009 | 2022-10-02 | Societe Generale | SOGEFRPP | Paris Construction SAS | FR7630006000011234567890189 | expiry | 2023-10-02 | blank | 2022-10-03 | Lyon Engineering SARL | FR7630006000011234567890222 | BNP Paribas | BNPAFRPP | blank | blank | Expiry extended by 12 months for completion of new building project. |
| AMD00012 | approved | blank | true | blank | CRD10010 | 2023-08-15 | Bank of Montreal | BOFMCAM2 | Montreal Paper Mills | CA987654321012345678 | documents | blank | Packing List, Certificate of Insurance | 2023-08-15 | Toronto Packaging Ltd | blank | TD Canada Trust | TDOMCATTTOR | blank | blank | Additional documents requested for compliance with insurance regulations. |
| AMD00013 | approved | blank | true | blank | CRD10011 | 2024-04-04 | Bank of China | BKCHCNBJ | Shenzhen Electronics Ltd | CN23456789012345678901 | shipment | blank | blank | 2024-04-05 | Guangzhou Importers Co. | CN12345678901234567899 | China Merchants Bank | CMBCCNBS | blank | Changed shipment terms to FOB Shenzhen, latest shipment date 2024-10-15. | Amendment to shipment terms reflecting updated supplier agreement. |
| AMD00014 | approved | blank | true | blank | CRD10012 | 2023-03-10 | BNP Paribas | BNPAFRPP | Nice Maritime SA | FR7630006000011234567890191 | other | blank | blank | 2023-03-11 | Marseille Shipyards | FR7630006000011234567890198 | Societe Generale | SOGEFRPP | blank | blank | Correction of clause 2.1 in the original credit terms due to typographical error. |
| AMD00015 | approved | 50000 | true | EUR | CRD10013 | 2024-05-22 | Deutsche Bank AG | DEUTDEFF | Hamburg Steelworks AG | DE12500105170648489899 | amount | blank | blank | 2024-05-22 | Leipzig Metal Importers | DE89370400440532013009 | Commerzbank | COBADEFF | blank | blank | Amendment to increase amount by EUR 50,000 for unforeseen raw material costs. |
| AMD00016 | approved | blank | false | blank | CRD10014 | 2022-08-19 | HSBC Hong Kong | HSBCHKHH | Hong Kong Textile Corp | HK123456789012345678 | documents | blank | Bill of Lading, Packing List, Commercial Invoice | 2022-08-20 | Tokyo Fashion Imports | blank | Sumitomo Mitsui Banking Corp | SMBCJPJT | blank | blank | Expanded documents required to facilitate customs clearance in Hong Kong. |
| AMD00017 | approved | 100000 | true | GBP | CRD10015 | 2023-10-30 | Barclays Bank | BARCGB22 | Liverpool Metal Works | GB93BARC12345678901234 | amount | blank | blank | 2023-10-31 | Manchester Building Supplies | GB20HSBC12345678901221 | HSBC Bank PLC | HBUKGB4B | blank | blank | Amended amount for additional shipment of steel rods. |
| AMD00018 | approved | blank | true | blank | CRD10016 | 2023-09-25 | Credit Suisse | CRESCHZZ80A | Zurich Medical Supplies | CH9300762011623852957 | expiry | 2026-09-25 | blank | 2023-09-26 | Geneva Health Importers | CH5604835012345678000 | UBS AG | UBSWCHZH80A | blank | blank | Expiry extended by 36 months to accommodate ongoing contract. |
| AMD00019 | pending | blank | false | blank | CRD10017 | 2024-02-03 | Wells Fargo | WFBIUS6S | Seattle Timber LLC | US111222333444555666 | shipment | blank | blank | 2024-02-05 | Portland Building Supplies | US110011223344556677 | Royal Bank of Canada | ROYCCAT2 | blank | Shipment route updated to include Vancouver, Canada, latest date 2024-08-15. | Amendment allows for alternative shipping route due to weather. |
| AMD00020 | cancelled | blank | true | blank | CRD10018 | 2023-04-07 | Bank of Montreal | BOFMCAM2 | Calgary Agri Corp | CA987654321123456789 | other | blank | blank | 2023-04-08 | Winnipeg Food Imports | blank | Scotiabank | NOSCCATT | blank | blank | Final closure of letter of credit following completion of contract. |
What the 250 rows show
from the 250-row sampleApproved (amendment status) stands out: 170 of its 206 rows have is_
- 71%is_
confirmed = true - 2,250,000median amended_
amount - 5amendment types
Median 2,250,000, from 0.0 to 125,000,000.
- string 17
- float 1
- date 3
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
amendment_id | string | Unique identifier for each amendment recordunique | AMD00001 |
original_credit_id | string | Identifier of the original documentary credit being amended | CRD10001 |
issuing_bank_name | string | Name of the bank issuing the amendment | HSBC Bank PLC |
issuing_bank_swift_code | string | SWIFT code of the issuing bank | HBUKGB4B |
beneficiary_name | string | Name of the beneficiary of the credit | Winchester Textiles Ltd |
beneficiary_account_number | string | Account number of the beneficiaryoptional | GB42HSBC12345678901234 |
amendment_type | string | Type of amendment (e.g., amount, expiry, documents, shipment)amount · expiry · documents · shipment · other | amount |
currency | string | Currency code of the amended amount (ISO 4217)12 currencies · optional | GBP |
amended_documents_required | string | Description of amended documents required (if applicable)optional | Commercial Invoice |
amended_shipment_details | string | Details of amended shipment terms (if applicable)optional | Partial shipments now all… |
amendment_description | string | Free-text summary of the amendment | Increase of letter of cre… |
applicant_name | string | Name of the applicant (buyer/importer)optional | Edinburgh Imports Ltd |
applicant_account_number | string | Account number of the applicantoptional | GB29BARC12345678901222 |
advising_bank_name | string | Name of the advising bankoptional | Barclays Bank |
advising_bank_swift_code | string | SWIFT code of the advising bankoptional | BARCGB22 |
previous_amendment_id | string | Identifier of the previous amendment (if this is a chain)optional | AMD00001 |
amendment_status | string | Current status of the amendment (e.g., pending, approved, rejected)pending · approved · rejected · cancelled | approved |
| Numbers 1 column | |||
amended_amount | float | New amount after amendment (if applicable)0 or more · optional | 250000 |
| Dates and times 3 columns | |||
amendment_date | date | Date the amendment was issued | 2023-02-15 |
amended_expiry_date | date | New expiry date after amendment (if applicable)optional | 2025-07-10 |
effective_date | date | Date on which the amendment becomes effective | 2023-02-16 |
| True or false 1 column | |||
is_confirmed | boolean | Indicates if the amendment is confirmed by the advising bankoptional | true |
Use it for
A finance dashboard
The is_
confirmed rate, amended_ amount by amendment_ status and a breakdown of currency. Excel, Power BI or Tableau. Why do 177 of 250 rows have is_
confirmed = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Amendments250AMD00001250000approvedAMD00002approvedAMD00003approved
A software demo
Believable amendments with original_
credit_ id, amendment_ date and issuing_ bank_ name to fill a screen in front of a buyer.
blueprint · swift-mt707-amendment-to-documentary-credit
Behind this dataset
Same schema. As many rows as you need.
These 250 rows came out of a blueprint — 22 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.
- Reference to original LC (field 20)
- LC number being amended (field 21)
- Amendment number sequence
- Date of amendment
- Increase or decrease in amount
- New expiry date if changed
- Document requirements changes
- Latest shipment date if amended
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
- swift-mt707-amendment-to-documentary-credit