Free tool · No signup

Field Mapping Lab

For each target field, pick which source field (if any) supplies it. The rule is explicit: if the formats don't already match, it's flagged as needing a transformation — not guessed by AI. Anything left unmapped becomes a gap.

Version matters. The target fields below match pain.001.001.03 (ISO 20022 Customer Credit Transfer Initiation, message definition version 3), the same version used in the Payment Message Explorer. Later versions add and rename fields. Always confirm the exact version and any bank-specific rulebook before mapping a real interface against it — see the official ISO 20022 catalogue.

Source · ERP export row

Vendor IBANIBAN

BE68539007547034

Vendor namefree text

Bergman Freight & Logistics NV

Payment amountamount, comma decimal (EU)

12.450,00

CurrencyISO 4217 code

EUR

Due datedate, DD.MM.YYYY

16.03.2026

Invoice referencefree text

INV-2026-4471 / PO 88213

Company codeinternal code

1000

Payment method flaginternal code (T = transfer)

Debtor's bank (BIC)REQUIRED

DbtrAgt / BICFI · expects BIC

Creditor nameREQUIRED

Cdtr / Nm · expects free text

Creditor account (IBAN)REQUIRED

CdtrAcct / IBAN · expects IBAN

Instructed amountREQUIRED

Amt / InstdAmt · expects amount, dot decimal (ISO)

CurrencyREQUIRED

InstdAmt / @Ccy · expects ISO 4217 code

Requested execution dateREQUIRED

ReqdExctnDt · expects date, YYYY-MM-DD (ISO 8601)

End-to-end IDREQUIRED

PmtId / EndToEndId · expects free text, ≤35 chars

Remittance information

RmtInf / Ustrd · expects free text, ≤140 chars

Gaps in this mapping

← Back to path