Skip to Content
Product Information
Author's profile photo Bettina Anders

Integrating specific fields in XSL Transformation for custom payment file generation

In this blog, we want to show how you can easily integrate supported special fields into an XSL Transformation for custom payment files.

As example for one of these supported special fields, we are taking the Payment Purpose introduced in release 2208 and with release 2302 now available for XSL Transformation.

Source of this field is a wire or bank transfer, so this means it is transaction-based and we need to integrate it accordingly into the XSLT structure. Additionally, the bank configuration needs to be set up so that the system determines the XSL Transformation to be used.

Bank%20Transfer%20with%20Payment%20Purpose%20and%20XSLT%20Bank%20Transfer

Bank Transfer with Payment Purpose and XSLT Bank Transfer

In our code snippet example, we want to put this into the section for Regulatory Reporting into the XML tag <Cd>, in combination with the country of the receiving bank in tag <Ctry>.
To get the country of the receiving bank, we can use the bank’s address and there grab the CountryCode. To retrieve the value of the payment purpose field, we need to check for it as “PaymentMediumSpecificField” with the id “GLO_PAY_PURPOSE” and grab it via its “Value/Code” value.

Bringing us to the following code snippet for the payment purpose inclusion:

<xsl:for-each select="PaymentMediumSpecificField">
<xsl:choose>
<xsl:when test="ID = 'GLO_PAY_PURPOSE'">
<RgltryRptg>
<DbtCdtRptgInd>
<Dtls>
<Ctry>
<xsl:value-of select="../PaymentTransactionDestinatedBankAccount/Bank/Address/PhysicalAddress/CountryCode"/>
</Ctry>
<Cd>
<xsl:value-of select= "Value/Code"/>
</Cd>
</Dtls>
</DbtCdtRptgIndv
</RgltryRptg>
</xsl:when>
</xsl:choose>
</xsl:for-each>

Upon creation of the bank file for above screenshot example, the corresponding data is filled accordingly into the generated payment file:

Payment%20Purpose%20information%20in%20tag%20RgltryRptg

Payment Purpose information in tag RgltryRptg

Keep in mind that the integration of a field can differ for each bank format, hence kindly check with your bank for the specification guide.

More information on payment purpose and XSL Transformations, especially in regards to payment file generation, can be found here:

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.