Ṣíṣe ìdá fáìlì ìsanwó ISO 20022 laifọwọyi pẹ̀lú pain001

Àkótán alákóso / àwọn kókó pàtàkì

ISO 20022 pain.001 (CustomerCreditTransferInitiation) ni structured XML message format tí a fi ń bẹ̀rẹ̀ credit transfers labẹ SEPA (EPC SCT rulebook) àti CBPR+ (SWIFT cross-border messaging standard, dandan fún correspondent banks láti November 2025).

pain001 ⧉ ń ka payment data láti CSV tàbí SQLite, ó ń map rows sí hierarchy pain.001.001.09 (GrpHdr -> PmtInf -> CdtTrfTxInf), ó sì ń render conformant XML file nípasẹ̀ templated generator — laini Python mẹ́ta láti data sí validated XML.

XSD validation ń ṣiṣẹ́ lórí gbogbo generated file kí output tó di pípa mọ́; library náà ń raise descriptive exception tó tọ́ka sí failing element, cardinality tàbí type mismatch, kí errors lè jẹ́ mímú ní generation time dípò bank submission.

CtrlSum àti NbOfTxs ni a ń ṣirò láti transaction set, kì í ṣe kí a tẹ̀ wọ́n manually — ó yọ́ ìdí rejection payment file tó wọ́pọ̀ jù lọ ní SEPA àti CBPR+ processing gateways.

SEPA Credit Transfer (EUR, nínú SEPA zone) àti CBPR+ (cross-border, multi-currency) message variants méjèèjì ni support nípasẹ̀ message_type parameter, pẹ̀lú field-level validation differences tí a ń ṣàkóso internally.

pain001 ⧉ jẹ́ ilé-ìkàwé Python open-source fún dídá ISO 20022 payment initiation files. Ó ń ka payment data láti structured input (CSV tàbí SQLite), ó ń validate data, ó ń render conformant pain.001.001.09 XML document, ó sì ń validate output sí ISO 20022 XSD schema — gbogbo rẹ̀ nínú function call kan.

Àpilẹ̀kọ yìí ṣàlàyé ISO 20022 pain.001 message structure, bí pain001 ṣe ń map input data sí message elements, validation pipeline, àti SEPA vs CBPR+ configuration options.

Ìlànà message ISO 20022 pain.001 #

ISO 20022 pain.001.001.09 (CustomerCreditTransferInitiation) message ní ipele mẹ́ta:

GrpHdr (Group Header) — ọkan fún fáìlì kọọkan:

Element	Àlàyé	Àpẹẹrẹ
`MsgId`	Unique message identifier	`ACME20240115-001`
`CreDtTm`	Ọjọ́ àti àsìkò creation	`2024-01-15T09:00:00`
`NbOfTxs`	Total number of transactions	`3`
`CtrlSum`	Àpapọ̀ gbogbo instructed amounts	`15000.00`
`InitgPty/Nm`	Orúkọ initiating party	`Acme Corp`

PmtInf (Payment Information) — ọkan tàbí ju bẹ́ẹ̀ lọ fún fáìlì kọọkan; ó ń group transactions nípa debtor account àti payment date:

Element	Àlàyé
`PmtInfId`	Payment information identifier
`PmtMtd`	Payment method — `TRF` nigbagbogbo fún credit transfer
`ReqdExctnDt/Dt`	Requested execution date
`Dbtr/Nm`	Orúkọ debtor (sender)
`DbtrAcct/Id/IBAN`	Debtor IBAN
`DbtrAgt/FinInstnId/BICFI`	Debtor bank BIC

CdtTrfTxInf (Credit Transfer Transaction Information) — ọkan tàbí ju bẹ́ẹ̀ lọ fún PmtInf block kọọkan:

Element	Àlàyé
`PmtId/EndToEndId`	End-to-end reference tí a pa mọ́ jálẹ̀ chain
`Amt/InstdAmt`	Instructed amount pẹ̀lú currency attribute
`CdtrAgt/FinInstnId/BICFI`	Creditor bank BIC
`Cdtr/Nm`	Orúkọ creditor (receiver)
`CdtrAcct/Id/IBAN`	Creditor IBAN
`RmtInf/Ustrd`	Unstructured remittance information, bí invoice reference

Dídá XML láti CSV #

pain001 invocation kékeré:

from pain001 import create_xml_v9

create_xml_v9(
    data_file="payments.csv",
    data_file_type="csv",
    xml_file_path="output/pain001.xml"
)

CSV file ń map column names sí message fields. Àpẹẹrẹ kékeré:

id,date,nb_of_txs,ctrl_sum,initiating_party_name,debtor_name,debtor_account_IBAN,debtor_agent_BIC,creditor_name,creditor_account_IBAN,creditor_agent_BIC,instd_amt,instd_amt_ccy,end_to_end_id,remittance_info
1,2024-01-15,1,1000.00,Acme Corp,Acme Corp,GB29NWBK60161331926819,NWBKGB2L,Supplier Ltd,DE89370400440532013000,COBADEFFXXX,1000.00,EUR,ACME20240115001,INV-2024-0042

Library náà ń ka ctrl_sum àti nb_of_txs láti CSV row fún single-row files. Fún multi-row files (ọ̀pọ̀ transactions nínú batch kan), pain001 ń compute values wọ̀nyí láti transaction set dípò fífi ìgbàgbọ́ sí input values, èyí tó ń dena mismatches.

SQLite interface ń lo column-name convention kan náà. Pass data_file_type="sqlite" àti path data_file sí SQLite database file; pain001 ń ka payment table by default.

Ìlànà XML tí a dá #

Pain.001.001.09 document tí a render dáadáa fún CSV row lókè:

<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.09">
  <CstmrCdtTrfInitn>
    <GrpHdr>
      <MsgId>ACME20240115-001</MsgId>
      <CreDtTm>2024-01-15T09:00:00</CreDtTm>
      <NbOfTxs>1</NbOfTxs>
      <CtrlSum>1000.00</CtrlSum>
      <InitgPty><Nm>Acme Corp</Nm></InitgPty>
    </GrpHdr>
    <PmtInf>
      <PmtInfId>ACME20240115-PMT-001</PmtInfId>
      <PmtMtd>TRF</PmtMtd>
      <ReqdExctnDt><Dt>2024-01-16</Dt></ReqdExctnDt>
      <Dbtr><Nm>Acme Corp</Nm></Dbtr>
      <DbtrAcct><Id><IBAN>GB29NWBK60161331926819</IBAN></Id></DbtrAcct>
      <DbtrAgt><FinInstnId><BICFI>NWBKGB2L</BICFI></FinInstnId></DbtrAgt>
      <CdtTrfTxInf>
        <PmtId><EndToEndId>ACME20240115001</EndToEndId></PmtId>
        <Amt><InstdAmt Ccy="EUR">1000.00</InstdAmt></Amt>
        <CdtrAgt><FinInstnId><BICFI>COBADEFFXXX</BICFI></FinInstnId></CdtrAgt>
        <Cdtr><Nm>Supplier Ltd</Nm></Cdtr>
        <CdtrAcct><Id><IBAN>DE89370400440532013000</IBAN></Id></CdtrAcct>
        <RmtInf><Ustrd>INV-2024-0042</Ustrd></RmtInf>
      </CdtTrfTxInf>
    </PmtInf>
  </CstmrCdtTrfInitn>
</Document>

XSD validation pipeline #

Lẹ́yìn rendering, pain001 ń validate output sí ISO 20022 pain.001.001.09 XSD schema. Validation ń ṣàyẹ̀wò:

Mandatory element presence: GrpHdr/MsgId, GrpHdr/CreDtTm, GrpHdr/NbOfTxs, GrpHdr/CtrlSum jẹ́ dandan; bí ẹyọ kan bá ṣòfò, validation error yóò ṣẹlẹ̀.
Type constraints: IBAN format, BIC format (characters 8 tàbí 11), amount precision (maximum 18 digits, 5 decimal places).
Cardinality: o kere ju CdtTrfTxInf kan fún PmtInf kọọkan; o kere ju PmtInf kan fún document kọọkan.
Enumeration values: PmtMtd gbọ́dọ̀ jẹ́ TRF fún credit transfers; Ccy gbọ́dọ̀ jẹ́ valid ISO 4217 currency code.

Nígbà tí validation bá kùnà, pain001 ń raise ValidationError pẹ̀lú lxml error message tó ń tọ́ka sí failing XPath expression, element name àti constraint. Èyí ń fi misconfigurations hàn ní generation time dípò bank submission, níbi tí rejection codes sábà máa ń jẹ́ aláìkúnrẹ́rẹ́.

SEPA vs CBPR+ configuration #

SEPA Credit Transfer (ISO 20022 pain.001.001.09 labẹ EPC SCT rulebook) àti CBPR+ (SWIFT's Cross-Border Payments and Reporting Plus standard) ń lo message schema kan náà, ṣùgbọ́n wọ́n yàtọ̀ ní mandatory field sets àti value constraints:

Aspect	SEPA SCT	CBPR+
Currency	EUR nìkan	Multi-currency
IBAN mandatory	Bẹ́ẹ̀ ni	Bẹ́ẹ̀ ni (creditor)
BIC mandatory	Rárá (SEPA zone routing)	Bẹ́ẹ̀ ni
Charge bearer (`ChrgBr`)	`SLEV`	`DEBT`, `CRED`, tàbí `SHAR`
Scope	SEPA zone (orílẹ̀-èdè 36)	Global correspondent banking

Ṣètò message type nípasẹ̀ payment_initiation_message_type parameter:

create_xml_v9(
    data_file="payments.csv",
    data_file_type="csv",
    xml_file_path="output/pain001.xml",
    payment_initiation_message_type="pain.001.001.09"  # default; also accepts "pain.001.001.03" for legacy SEPA
)

CBPR+ compliance di dandan fún SWIFT correspondent banking ní November 2023 fún inbound messages àti November 2025 fún outbound. Dídá pain.001 files tó conform sí CBPR+ ń bẹ̀rẹ̀ pé BIC field wà ní kíkún àti pé ChrgBr element wà.

Ìbéèrè tí a máa ń béèrè #

Kí ni ìyàtọ̀ láàárín pain.001 àti pain.008? pain.001 (CustomerCreditTransferInitiation) ń bẹ̀rẹ̀ credit transfer — banki sender ń debit account sender, ó sì ń credit receiver. pain.008 (CustomerDirectDebitInitiation) ń bẹ̀rẹ̀ direct debit — banki creditor ń gba owó láti debtor. Library pain001 ń generate pain.001 files nìkan.

ISO 20022 version wo ni pain001 ń target? Primary target ni pain.001.001.09, version tí CBPR+ ń fẹ́ àti tí EPC fi dandan fún new SEPA implementations. Library náà tún support pain.001.001.03 (legacy SEPA version) nípasẹ̀ payment_initiation_message_type parameter fún organisations tó ṣi ń lo older bank interfaces.

Ṣé pain001 lè ṣàkóso debtor accounts púpọ̀ nínú fáìlì kan? Bẹ́ẹ̀ ni. A lè produce ọ̀pọ̀ PmtInf blocks pẹ̀lú debtor IBANs tó yàtọ̀ nípa grouping CSV rows pẹ̀lú debtor account values tó yàtọ̀. pain001 ń create PmtInf block kan fún unique combination kọọkan ti (debtor IBAN, execution date), pẹ̀lú gbogbo matching transactions tí a nest gẹ́gẹ́ bí CdtTrfTxInf children.

Kí ló ṣẹlẹ̀ tí XSD validation bá kùnà? pain001 ń raise pain001.exceptions.ValidationError pẹ̀lú lxml validation message. XML file kì í kọ sí disk tí validation bá kùnà, nítorí náà valid files nìkan ni yóò dé output path. Àwọn common failure causes ni: IBAN nínú wrong format, BIC tí kì í ṣe characters 8 tàbí 11, currency code tí kò sí ní ISO 4217, tàbí missing mandatory elements nígbà tí required CSV column kò sí.

Àwọn ìtọ́kasí #

European Payments Council. SEPA Credit Transfer Scheme Customer-to-Bank Implementation Guidelines (v1.1). EPC, 2023. https://www.europeanpaymentscouncil.eu/document-library/implementation-guidelines/sepa-credit-transfer-scheme-customer-bank
SWIFT. CBPR+ Usage Guidelines — Customer Credit Transfer Initiation (pain.001). SWIFT Standards, 2023. https://www.swift.com/standards/iso-20022/cbpr-plus-usage-guidelines
ISO. ISO 20022 — Financial services — Universal financial industry message scheme. ISO.org, 2023. https://www.iso20022.org/
Rousseau, S. pain001 — ISO 20022 payment file generator. GitHub, 2023. https://github.com/sebastienrousseau/pain001

A ṣe àtúnyẹ̀wò kẹ́yìn 2026-05-24.

Àyẹ̀wò àkọ́kọ́ 2026-08-28.

Tun àpilẹkọ yìí jade

Ṣíṣe ìdá fáìlì ìsanwó ISO 20022 laifọwọyi pẹ̀lú pain001 — Sebastien Rousseau

pain001 jẹ́ ilé-ìkàwé Python open-source tó ń dá àwọn fáìlì ìsanwó XML ISO 20022 pain.001.001.09 láti data CSV tàbí SQLite, pẹ̀lú ìfọwọ́sí XSD laifọwọyi, iṣiro control-sum, àti support fún SEPA SCT àti CBPR+ cross-border message formats.

A ti fun àpilẹkọ yìí ni iwe-ẹri labẹ Creative Commons Attribution 4.0 International. Atunjade nilo idanimọ si URL akọkọ.

Ṣíṣe ìdá fáìlì ìsanwó ISO 20022 laifọwọyi pẹ̀lú pain001 — Sebastien Rousseau

pain001 jẹ́ ilé-ìkàwé Python open-source tó ń dá àwọn fáìlì ìsanwó XML ISO 20022 pain.001.001.09 láti data CSV tàbí SQLite, pẹ̀lú ìfọwọ́sí XSD laifọwọyi, iṣiro control-sum, àti support fún SEPA SCT àti CBPR+ cross-border message formats.

Originally published at https://sebastienrousseau.com/yo/2023-09-29-sise-ida-faili-isanwo-iso-20022/ by Sebastien Rousseau.
Licensed under CC-BY-4.0.

SEBASTIEN ROUSSEAU FOUNDER · ENGINEER