SWIFT MT700 Issue of Documentary Credit
This dataset provides comprehensive details for SWIFT MT700 documentary credits, including issuing and advising bank information, applicant and beneficiary data, credit terms, required documents, and all relevant conditions. It is ideal for trade finance operations, compliance monitoring, and risk assessment in international banking.
Sample rows
preview · 8 of 300 rows · all 44 columns| credit_idstring | available_bystring | presentation_period_daysinteger | partial_shipments_allowedboolean | currencystring | issue_datedate | expiry_datedate | issuing_bank_namestring | issuing_bank_swift_codestring | issuing_bank_address_streetstring | issuing_bank_address_citystring | issuing_bank_address_statestring | issuing_bank_address_postal_codestring | issuing_bank_address_countrystring | advising_bank_namestring | advising_bank_swift_codestring | advising_bank_address_streetstring | advising_bank_address_citystring | advising_bank_address_statestring | advising_bank_address_postal_codestring | advising_bank_address_countrystring | applicant_namestring | applicant_address_streetstring | applicant_address_citystring | applicant_address_statestring | applicant_address_postal_codestring | applicant_address_countrystring | beneficiary_namestring | beneficiary_address_streetstring | beneficiary_address_citystring | beneficiary_address_statestring | beneficiary_address_postal_codestring | beneficiary_address_countrystring | credit_amountfloat | credit_typestring | place_of_expirystring | transshipment_allowedboolean | latest_shipment_datedate | confirmation_instructionsstring | chargesstring | remarksstring | description_of_goodsstring | required_documentsstring | additional_conditionsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BNKUS20240601A1 | payment | 21 | true | USD | 2024-06-01 | 2024-12-01 | First National Bank NA | FNBNUS33XXX | 123 Liberty Ave | New York | NY | 10001 | US | HSBC Bank PLC | HSBCGB2LXXX | 8 Canada Square | London | Greater London | E14 5HQ | UK | Global Importers Inc | 500 Market Street | San Francisco | CA | 94105 | US | Shanghai Electronics Ltd | 88 Pudong Road | Shanghai | blank | 200120 | CN | 120000 | irrevocable | London | false | 2024-11-10 | confirmed | applicant | Standard shipment; goods to arrive before year-end. | Consumer electronics, including tablets and smart devices, as per attached specifications. | Commercial Invoice, Packing List, Bill of Lading, Certificate of Origin | Insurance policy covering full shipment value required. |
| DEUTDE20240601B2 | negotiation | 15 | true | EUR | 2024-06-02 | 2024-08-30 | Deutsche Bank AG | DEUTDEFFXXX | Taunusanlage 12 | Frankfurt | HE | 60325 | DE | BNP Paribas SA | BNPAFRPPXXX | 16 Boulevard des Italiens | Paris | Île-de-France | 75009 | FR | Müller Maschinenbau GmbH | Industriestrasse 45 | Stuttgart | BW | 70174 | DE | TechParts SARL | 10 Rue de la Gare | Lyon | Auvergne-Rhône-Alpes | 69003 | FR | 54000 | irrevocable | Frankfurt | true | 2024-08-15 | unconfirmed | shared | Urgent order for seasonal demand. | Precision machine parts for automotive assembly, steel alloy grade. | Invoice, Certificate of Origin, Packing List | Goods must comply with EU safety standards. |
| SGRBSG20240601C3 | payment | 1 | false | SGD | 2024-06-03 | 2024-06-04 | Standard Chartered Bank Ltd | SCBLSG22XXX | 8 Marina Boulevard | Singapore | blank | 018981 | SG | Bank of China | BKCHCNBJXXX | blank | Beijing | blank | 100032 | CN | Evergreen Holdings Pte Ltd | 15 Raffles Quay | Singapore | blank | 048582 | SG | Qingdao Foods Co Ltd | No. 2 Haier Road | Qingdao | blank | 266101 | CN | 1 | revocable | Singapore | false | 2024-06-04 | unconfirmed | beneficiary | Pilot shipment; trial period ends with expiry. | Sample shipment of food-grade rice (trial consignment). | Invoice, Health Certificate, Export License | blank |
| BNZAU20240601D4 | acceptance | 30 | true | AUD | 2024-06-01 | 2024-12-01 | ANZ Banking Group Ltd | ANZBAU3MXXX | 833 Collins Street | Melbourne | VIC | 3008 | AU | Westpac Banking Corp | WPACNZ2WXXX | 16 Takutai Square | Auckland | blank | 1010 | NZ | Austral Grain Exports Pty Ltd | 45 Flinders Lane | Melbourne | VIC | 3000 | AU | Kiwi Foods Limited | 21 Queen Street | Wellington | blank | 6011 | NZ | 75000 | irrevocable | Auckland | true | 2024-11-25 | confirmed | applicant | Seasonal export contract. | Export of wheat and barley, packed in 50kg sacks for food processing. | Invoice, Packing List, Health Certificate | SGS inspection certificate required. |
| BARCGB20240601E5 | payment | 14 | false | EUR | 2024-06-05 | 2024-09-05 | Barclays Bank PLC | BARCGB22XXX | 1 Churchill Place | London | Greater London | E14 5HP | UK | Santander Bank SA | BSCHESMMXXX | Av. de Cantabria s/n | Madrid | blank | 28042 | ES | BritTrade Solutions Ltd | 88 Bishopsgate | London | Greater London | EC2N 4AY | UK | Iberian Auto SARL | Calle Mayor 12 | Madrid | blank | 28013 | ES | 92000 | irrevocable | Madrid | true | 2024-08-25 | confirmed | shared | Express shipment requested by beneficiary. | Automotive spare parts, brake discs and pads for commercial vehicles. | Invoice, Packing List, Bill of Lading, Certificate of Conformity | Quality certificate from EU authority required. |
| CITINL20240601F6 | negotiation | 10 | true | EUR | 2024-06-06 | 2024-11-06 | Citibank Europe PLC | CITINL2AXXX | Prinses Beatrixlaan 8 | The Hague | South Holland | 2595 AL | NL | ING Bank NV | INGBNL2AXXX | Bijlmerplein 888 | Amsterdam | North Holland | 1102 MG | NL | Dutch Flower BV | Bloemenstraat 10 | Rotterdam | South Holland | 3054 AB | NL | Tokyo Wholesale Ltd | 2 Chome-1 Nihonbashi | Tokyo | blank | 103-0027 | JP | 67000 | irrevocable | Amsterdam | true | 2024-10-25 | silent confirmation | beneficiary | Seasonal promotion for Japanese market. | Fresh cut flowers, tulips and lilies, airfreight shipment. | Invoice, Phytosanitary Certificate, Air Waybill | Compliance with Japanese import regulations. |
| UBSACH20240601G7 | deferred payment | 60 | false | CHF | 2024-06-07 | 2025-06-07 | UBS Switzerland AG | UBSWCHZHXXX | Bahnhofstrasse 45 | Zurich | Zurich | 8001 | CH | Credit Suisse AG | CRESCHZZ80A | Paradeplatz 8 | Zurich | Zurich | 8001 | CH | Alpine Chemicals AG | Industriestrasse 20 | Bern | Bern | 3011 | CH | Madrid Pharma SA | Calle de Goya 54 | Madrid | blank | 28001 | ES | 150000000 | irrevocable | Zurich | false | 2025-05-20 | confirmed | shared | Strategic supply agreement, long-term. | Pharmaceutical raw materials for EU distribution, bulk shipment. | Invoice, Bill of Lading, SGS Inspection Certificate, Export Permit | Full insurance required; compliance with Swiss export law. |
| JPMUS20240601H8 | acceptance | 18 | true | USD | 2024-06-08 | 2024-12-08 | JPMorgan Chase Bank NA | CHASUS33XXX | 383 Madison Ave | New York | NY | 10017 | US | Royal Bank of Canada | ROYCCAT2XXX | 200 Bay Street | Toronto | ON | M5J 2J5 | CA | AmeriFoods Corporation | 7420 Industrial Rd | Dallas | TX | 75247 | US | Maple Leaf Foods Ltd | 39 Eglinton Ave E | Toronto | ON | M4P 1A1 | CA | 98000 | irrevocable | Toronto | false | 2024-11-25 | unconfirmed | applicant | Seasonal supply for year-end holidays. | Frozen poultry products packed for retail distribution. | Invoice, Health Certificate, Packing List | Compliance with USDA and CFIA regulations. |
| HSBCHK20240601I9 | payment | 4 | false | HKD | 2024-06-09 | 2024-07-09 | HSBC Hong Kong Ltd | HSBCHKHHXXX | 1 Queen's Road Central | Hong Kong | blank | 00000 | HK | Hang Seng Bank Ltd | HASEHKHHXXX | 83 Des Voeux Road Central | Hong Kong | blank | 00000 | HK | Asia Textile Holdings Ltd | 36 Nathan Road | Kowloon | blank | 00000 | HK | Bangladesh Garments SARL | Plot 12, Savar | Dhaka | blank | 1216 | BD | 1000 | revocable | Hong Kong | false | 2024-07-05 | unconfirmed | beneficiary | Pilot project; expiry matches shipment. | Samples of cotton textile for clothing production, trial batch. | Invoice, Certificate of Origin, Export License | blank |
| SANTES20240601J10 | deferred payment | 45 | false | EUR | 2024-06-10 | 2025-06-10 | Banco Santander SA | SANTESMMXXX | Av. de Cantabria s/n | Madrid | blank | 28042 | ES | Credit Agricole SA | AGRIFRPPXXX | 12 Place des Etats-Unis | Paris | Île-de-France | 92127 | FR | Iberian Mining Corp | Calle de Alcalá 45 | Madrid | blank | 28014 | ES | Paris Steel SARL | Rue de Rivoli 88 | Paris | Île-de-France | 75001 | FR | 109000000 | irrevocable | Madrid | false | 2025-05-25 | confirmed | shared | Strategic supply, long-term contract. | Bulk iron ore for use in steel manufacturing; annual contract. | Invoice, Bill of Lading, Export Permit, SGS Inspection Certificate | Full insurance and compliance certificates required. |
| CBAAU20240601K11 | payment | 20 | true | AUD | 2024-06-11 | 2024-12-11 | Commonwealth Bank of Australia | CTBAAU2SXXX | 201 Sussex Street | Sydney | NSW | 2000 | AU | Bank of New Zealand | BKNZNZ22XXX | 80 Queen Street | Auckland | blank | 1010 | NZ | Oceania Exporters Pty Ltd | 77 George Street | Sydney | NSW | 2000 | AU | Kiwi Dairy Limited | 101 Lambton Quay | Wellington | blank | 6011 | NZ | 48000 | irrevocable | Wellington | true | 2024-11-20 | unconfirmed | applicant | Standard trade; recurring contract. | Pasteurized milk products, UHT packaged, food grade. | Invoice, Health Certificate, Packing List | Quality check by New Zealand authorities. |
| BNPAFR20240601L12 | payment | 12 | true | EUR | 2024-06-12 | 2024-09-12 | BNP Paribas SA | BNPAFRPPXXX | 16 Boulevard des Italiens | Paris | Île-de-France | 75009 | FR | Commerzbank AG | COBADEFFXXX | Kaiserplatz | Frankfurt | HE | 60311 | DE | Paris Agro SARL | Rue de Lyon 24 | Paris | Île-de-France | 75012 | FR | Berlin Organics GmbH | Alexanderplatz 5 | Berlin | BE | 10178 | DE | 37000 | irrevocable | Frankfurt | false | 2024-08-31 | confirmed | beneficiary | Urgent delivery for autumn sales. | Organic wheat flour, EU certified, packaged for retail. | Invoice, Packing List, Health Certificate | SGS inspection required. |
| BKCHCN20240601M13 | acceptance | 20 | false | CNY | 2024-06-13 | 2024-12-13 | Bank of China | BKCHCNBJXXX | 1 Fuxingmen Nei Dajie | Beijing | blank | 100818 | CN | Sumitomo Mitsui Banking Corp | SMBCJPJTXXX | 1-2 Marunouchi | Tokyo | blank | 100-0005 | JP | Shenzhen Tech Ltd | Technology Park Blvd | Shenzhen | blank | 518057 | CN | Osaka Trading Co Ltd | 4-5 Chome Namba | Osaka | blank | 542-0076 | JP | 57000 | irrevocable | Tokyo | true | 2024-11-30 | silent confirmation | shared | Standard supply, monthly shipments. | Electronic components for consumer products, RoHS compliant. | Invoice, Packing List, Certificate of Origin | Compliance with Japanese import law. |
| BNPAFR20240601N14 | negotiation | 20 | true | EUR | 2024-06-14 | 2024-12-14 | BNP Paribas SA | BNPAFRPPXXX | 16 Boulevard des Italiens | Paris | Île-de-France | 75009 | FR | Banco do Brasil SA | BRASBRRJXXX | Rua Senador Dantas 105 | Rio de Janeiro | RJ | 20031-205 | BR | Paris Cosmetics SARL | Avenue des Champs-Élysées 30 | Paris | Île-de-France | 75008 | FR | Rio Beauty Ltda | Rua Visconde de Pirajá 495 | Rio de Janeiro | RJ | 22410-003 | BR | 39000 | irrevocable | Rio de Janeiro | true | 2024-12-01 | unconfirmed | beneficiary | Promotion for Brazilian summer. | Cosmetic products, creams and lotions, EU certified. | Invoice, Certificate of Origin, Packing List | Compliance with Brazilian ANVISA regulations. |
| ICICIN20240601O15 | payment | 2 | false | AED | 2024-06-15 | 2024-07-15 | ICICI Bank Ltd | ICICINBBXXX | ICICI Towers, Bandra | Mumbai | MH | 400051 | IN | Emirates NBD PJSC | EBILAEADXXX | Baniyas Road | Dubai | blank | 00000 | AE | IndoChem Ltd | Plot 7 MIDC Area | Pune | MH | 411019 | IN | Dubai Trading LLC | Sheikh Zayed Road | Dubai | blank | 00000 | AE | 1800 | revocable | Dubai | false | 2024-07-12 | unconfirmed | shared | Trial shipment; expiry matches delivery. | Sample shipment of chemical reagents for laboratory use. | Invoice, Certificate of Origin, Export License | blank |
| NATFR20240601P16 | negotiation | 14 | true | EUR | 2024-06-16 | 2024-12-16 | Natixis SA | NATXFRPPXXX | 30 avenue Pierre Mendes | Paris | Île-de-France | 75013 | FR | Societe Generale SA | SOGEFRPPXXX | 29 Boulevard Haussmann | Paris | Île-de-France | 75009 | FR | Paris Wines SARL | Rue de Bac 12 | Paris | Île-de-France | 75007 | FR | Tokyo Imports Ltd | 1 Chome Ginza | Tokyo | blank | 104-0061 | JP | 28000 | irrevocable | Tokyo | true | 2024-12-01 | silent confirmation | beneficiary | Seasonal holiday import. | Bottled wine, red and white varieties, French AOC certified. | Invoice, Packing List, Certificate of Origin | Compliance with Japanese import standards. |
| BNPAFR20240601Q17 | payment | 10 | true | EUR | 2024-06-17 | 2024-09-17 | BNP Paribas SA | BNPAFRPPXXX | 16 Boulevard des Italiens | Paris | Île-de-France | 75009 | FR | ABN AMRO Bank NV | ABNANL2AXXX | Gustav Mahlerlaan 10 | Amsterdam | North Holland | 1082 PP | NL | Paris Gourmet SARL | Boulevard Saint-Michel 101 | Paris | Île-de-France | 75005 | FR | Amsterdam Foods BV | Damrak 45 | Amsterdam | North Holland | 1012 LL | NL | 41000 | irrevocable | Amsterdam | false | 2024-09-01 | confirmed | shared | Standard supply, autumn season. | Gourmet cheese selection, refrigerated, Dutch and French origins. | Invoice, Health Certificate, Packing List | Compliance with EU dairy regulations. |
| ABNANL20240601R18 | acceptance | 12 | true | EUR | 2024-06-18 | 2024-12-18 | ABN AMRO Bank NV | ABNANL2AXXX | Gustav Mahlerlaan 10 | Amsterdam | North Holland | 1082 PP | NL | Nordea Bank Abp | NDEAFIHHXXX | Aleksanterinkatu 36B | Helsinki | blank | 00100 | FI | Dutch Dairy BV | Zuiderzeeweg 12 | Amsterdam | North Holland | 1095 KZ | NL | Finland Cheese Oy | Kauppakatu 10 | Helsinki | blank | 00100 | FI | 34000 | irrevocable | Helsinki | true | 2024-12-05 | unconfirmed | shared | Winter supply contract. | Bulk dairy products, cheeses and butter, EU food grade. | Invoice, Packing List, Health Certificate | SGS inspection required. |
| INGBNL20240601S19 | negotiation | 7 | true | EUR | 2024-06-19 | 2024-09-19 | ING Bank NV | INGBNL2AXXX | Bijlmerplein 888 | Amsterdam | North Holland | 1102 MG | NL | Rabobank Nederland | RABONL2UXXX | Croeselaan 18 | Utrecht | Utrecht | 3521 CB | NL | Tulip Growers BV | Bloemenstraat 1 | Leiden | South Holland | 2312 BL | NL | Madrid Imports SA | Calle Serrano 23 | Madrid | blank | 28001 | ES | 26000 | irrevocable | Utrecht | true | 2024-09-10 | silent confirmation | beneficiary | Promotion; urgent delivery for spring. | Fresh cut tulips, airfreight shipment for Spanish market. | Invoice, Phytosanitary Certificate, Air Waybill | Compliance with EU flower import standards. |
| COBADE20240601T20 | payment | 9 | false | EUR | 2024-06-20 | 2024-09-20 | Commerzbank AG | COBADEFFXXX | Kaiserplatz | Frankfurt | HE | 60311 | DE | UniCredit Bank AG | HYVEDEMMXXX | Arabellastrasse 12 | Munich | BY | 81925 | DE | Frankfurt Steel GmbH | Mainzer Landstrasse 200 | Frankfurt | HE | 60327 | DE | Munich Metal BV | Theresienstrasse 15 | Munich | BY | 80333 | DE | 43000 | irrevocable | Munich | false | 2024-09-10 | confirmed | applicant | Urgent project; express delivery. | Steel rods and beams for construction, DIN certified. | Invoice, Certificate of Origin, Packing List | Quality check by German authorities required. |
What the 300 rows show
from the 300-row sampleDeferred payment (available by) stands out: mean presentation_
- 59%partial_
shipments_ allowed = true - 15median presentation_
period_ days - 2credit types
- 3confirmation instructionses
- 3chargeses
- 57beneficiary address countries
Median 15, from 1 to 120.
- string 37
- integer 1
- float 1
- date 3
- boolean 2
Columns
44 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 37 columns | |||
credit_id | string | Unique identifier for the documentary credit issuedunique | BNKUS20240601A1 |
issuing_bank_name | string | Name of the bank issuing the documentary credit | First National Bank NA |
issuing_bank_swift_code | string | SWIFT/BIC code of the issuing bank | FNBNUS33XXX |
issuing_bank_address_street | string | Street address of the issuing bankoptional | 123 Liberty Ave |
issuing_bank_address_city | string | City of the issuing bankoptional | New York |
issuing_bank_address_state | string | State or province of the issuing bankoptional | NY |
issuing_bank_address_postal_code | string | Postal code of the issuing bankoptional | 10001 |
issuing_bank_address_country | string | Country of the issuing bankoptional | US |
advising_bank_name | string | Name of the advising bank | HSBC Bank PLC |
advising_bank_swift_code | string | SWIFT/BIC code of the advising bank | HSBCGB2LXXX |
advising_bank_address_street | string | Street address of the advising bankoptional | 8 Canada Square |
advising_bank_address_city | string | City of the advising bankoptional | London |
advising_bank_address_state | string | State or province of the advising bankoptional | Greater London |
advising_bank_address_postal_code | string | Postal code of the advising bankoptional | E14 5HQ |
advising_bank_address_country | string | Country of the advising bankoptional | UK |
applicant_name | string | Name of the applicant requesting the documentary credit | Global Importers Inc |
applicant_address_street | string | Street address of the applicantoptional | 500 Market Street |
applicant_address_city | string | City of the applicantoptional | San Francisco |
applicant_address_state | string | State or province of the applicantoptional | CA |
applicant_address_postal_code | string | Postal code of the applicantoptional | 94105 |
applicant_address_country | string | Country of the applicantoptional | US |
beneficiary_name | string | Name of the beneficiary under the documentary credit | Shanghai Electronics Ltd |
beneficiary_address_street | string | Street address of the beneficiaryoptional | 88 Pudong Road |
beneficiary_address_city | string | City of the beneficiaryoptional | Shanghai |
beneficiary_address_state | string | State or province of the beneficiaryoptional | Auvergne-Rhône-Alpes |
beneficiary_address_postal_code | string | Postal code of the beneficiaryoptional | 200120 |
beneficiary_address_country | string | Country of the beneficiaryoptional | CN |
currency | string | Currency code for the credit amount (ISO 4217) | USD |
credit_type | string | Type of documentary credit (e.g., irrevocable, revocable)irrevocable · revocable | irrevocable |
available_by | string | Means by which the credit is available (e.g., by payment, by acceptance, by negotiation)payment · acceptance · negotiation · deferred payment | payment |
place_of_expiry | string | Place where the documentary credit expiresoptional | London |
description_of_goods | string | Detailed description of goods or services covered by the credit | Consumer electronics, inc… |
required_documents | string | List of documents required for presentation under the credit (e.g., bill of lading, invoice) | Invoice, Export license |
additional_conditions | string | Any additional terms or conditions specified in the creditoptional | SGS inspection required. |
confirmation_instructions | string | Instructions regarding confirmation of the credit (e.g., confirmed, unconfirmed)confirmed · unconfirmed · silent confirmation · optional | confirmed |
charges | string | Party responsible for charges (e.g., applicant, beneficiary, shared)applicant · beneficiary · shared · optional | applicant |
remarks | string | Any additional remarks or notesoptional | Seasonal holiday import. |
| Numbers 2 columns | |||
credit_amount | float | Total amount of the documentary credit0.01 or more | 120000 |
presentation_period_days | integer | Number of days after shipment within which documents must be presented1 or more · optional | 21 |
| Dates and times 3 columns | |||
issue_date | date | Date the documentary credit was issued | 2024-06-01 |
expiry_date | date | Date the documentary credit expires | 2024-12-01 |
latest_shipment_date | date | Latest date by which shipment must occuroptional | 2024-11-10 |
| True or false 2 columns | |||
partial_shipments_allowed | boolean | Indicates if partial shipments are allowed under the credit | true |
transshipment_allowed | boolean | Indicates if transshipment is allowed under the credit | false |
Use it for
A finance dashboard
The partial_
shipments_ allowed rate, presentation_ period_ days by available_ by and a breakdown of currency. Excel, Power BI or Tableau. Why do the 43 deferred payment rows have a mean presentation_
period_ days of 60.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Credits300BNKUS20240601A121paymentDEUTDE20240601B215negotiat…SGRBSG20240601C31payment
A software demo
Believable credits with issue_
date, expiry_ date and issuing_ bank_ name to fill a screen in front of a buyer.
blueprint · swift-mt700-issue-of-documentary-credit
Behind this dataset
Same schema. As many rows as you need.
These 300 rows came out of a blueprint — 44 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.
- Documentary credit number unique (field 20)
- Form of credit: irrevocable, transferable
- Date of issue
- Date and place of expiry
- Applicant details (importer)
- Beneficiary details (exporter)
- Currency and amount available
- Partial shipments allowed/not allowed
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-mt700-issue-of-documentary-credit