Configuring a Text Template

In reports, the Text Template option enables the user to produce SWIFT format report statements for transaction communication between the bank users. Here, the following screenshot shows a sample SWIFT MT940 statement in text format created using the text template in Sigma Studio.


SWIFT MT940 also called as Customer Statement Message, is an account statement that provides detailed information about all the entries booked to an account.

The SWIFT MT940 template that is used for the sample report on this page is as follows:

{1:F01${SENDER_BIC}0000000000}{2:${RECEIVER_BIC}}{4:  
:20:${TRANS_REF_NUMBER}  
:25:${ACC_IDENTIFICATION}  
:28C:${STATEMENT_NUMBER}  
:60F:${BALANCE_INDICATOR}${STATEMENT_DATE?string
("yyMMdd")}${CURRENCY_CODE}${AMOUNT?string.computer?replace(".", ",")}  
<#list STMT_TRANS_DETAIL as TRANS>  
:86:${TRANS.RMTTR_TXN_REF} ${TRANS.PAYER_ID} ${TRANS.BANCK_DESC}  
</#list>  
:62F:${BALANCE_INDICATOR}${STATEMENT_DATE?string("yyMMdd")}${CURRENCY_CODE}${AMOUNT?string.computer?replace(".", ",")}  
-}

Perform the following steps in Sigma Studio to configure the template settings:

1. Click Manage > Report.
   
   
   

   The Information Report page appears.
   
   
   
   

2. Provide all the necessary details. Refer Configuring a Complex Report – Sample 1 for more information on configuration part in Studio.
3. In Report Maintenance tab, select the data source in Data Source Name field based on the data to be used for creating the text template. Refer Configuring Data Source for SWIFT MT940 Report for more information on creating a data aggregator combining data sources.
4. Click the Template Designer icon.
   
   
   

   The Template Designer page appears with the list of report parts on the left-hand side of the page and the list of layout tabs on the right-hand side of the page.
   
   

5. Select the type of field from the left-hand side of the page. In this example, Report Header field is selected.

   By default, the page header and footer options are disabled. You can either toggle on the options and use those or retain the default settings.
   
   

6. Select the Statement Layout ( ) tab on the right-hand side of the page. A list of existing statements appears on this tab.
   
   
7. Click Add Content to create new content.
   
   
   The Create Template page appears.
   
   
8. Provide a unique template name in Template ID field.
9. Provide the template description in Description field if required.
10. Switch to Text in Template Type field.
    
    
    
    

11. Enter the statement in Text Template box and click Save.

    When you try to exit the Template screen, before saving the configured template, a warning pop-up message appears, as shown in the following screen shot:
    

    • Click Cancel, if you do not want to exit the Template screen.
    • Click Ok, if you want to exit the Template screen.

    

    It is important to pass the correct data names from the datasource as parameters in the text template or an error may occur since this feature is case sensitive.

12. Now, drag and drop the created text template into the design section.
    
    
13. You can disable the Data Grid option in order to avoid displaying the data columns on the report if required.
    
    
14. Click Save () to save the template.
15. Choose TXT format in Select Allowed Format field.
    
    
16. Perform the other configurations and save the report.
17. Login to Sigma and generate the created report in TXT format. Refer Generating Complex Report in Sigma - Sample 1 for more information on generating reports in Sigma.

The following screenshot shows the text report with MT940 statement created using the text template in Sigma Studio: