Creating a Custom Format Mapping

Objective

After completing this lesson, you will be able to create a Custom Format Mapping

Creation of Custom Format Mapping

In this lesson, you'll learn how to create a custom format mapping that aligns with requirements of a "Demo Bank" in Maldives, as part of the 'Map Format Data for Payments' process. Additionally, you will learn how to include a field in the payment data that isn't usually part of it by default and how to either encapsulate the file in a bank-specific envelope or rename the file to meet the bank's requirements.

Custom Format Description

The payment file should include credit transfer details for supplier payments. It has a header section with the file's identification, a summary of the amounts, and the total number of transactions in the file. A new batch is created for each payment method. The batch details include the debtor's account information (name and address) and payment details. The payment information section contains the creditor's account details (name and address), transaction reference, amount, execution date, and remittance information. To understand the specific requirements, you might receive from your bank, please refer to the table below.

Custom Format Requirements

IndexLevelNameXML TagMult.Type / CodeCommentFieldNote
 0File﹤File﹥     
+1Header﹤Header﹥[1..1] New file per new company codeFPAYH-ZBUKRNodes with 1-n cardinality on the given level
++2Message Identification﹤MsgId﹥[1..1]text{1,35}Mandatory node, Must be unique valueFPAYHX-RENUM 
++2Creation Date Time﹤CreDtTm﹥[1..1]dateTimedateTime format DD/

SYST-DATLO

:

SYST-TIMLO

 
++2Number of transaction﹤NbTx﹥[1..1] total number of all transactions in the fileAggregationBank-specific Requirements
++2Total Sum﹤Sum﹥[1..1] total sum of the amount in the file. Currency independentAggregationBank-specific Requirements
++2Batch﹤Batch﹥[1..n] New batch per new payment methodFPAYH-RZAWENodes with 1-n cardinality on the given level
+++2Account﹤Acc﹥[1..1]    
++++3Bank Key﹤BIC﹥[0..1]text{11}Mandatory if IBAN is not provided. Must not be in output if IBAN is providedFPAYH-USWIF 
++++3IBAN﹤IBAN﹥[0..1]text{32} FPAYH-UIBAN 
++++3Id﹤Id﹥[0..1]text{8)Mandatory if IBAN is not provided. Must not be in output if IBAN is providedFPAYH-UBKNT_EXT 
+++2Company Name﹤CmpnyNm﹥[1..1]text{1,35} FPAYHX-AUST1 
+++2Company Address﹤CmpnyAdr﹥[1..1]    
++++2City﹤City﹥[1..1]text{1,35} FPAYHX-AUST2 
++++2Street﹤Stret﹥[1..1]text{1,35} FPAYHX-AUST3 
++++2Postal code﹤Pstl﹥[1..1]text{1,35} FPAYHX-AUSTO 
+++3Payment﹤Pmnt﹥[1..n] New Payment with new reference to payment documentFPAYH-DOC1RNodes with 1-n cardinality on the given level
++++3Sequence Number﹤SeqNm﹥[1..1]num{5}Sequence number of paymentCalculationBank-specific Requirements
++++3Email﹤Email﹥[1..1]text{35}Email of the accounting clerk of the business partner.FPAYH-ZREF01Bank-specific Requirements
++++3Reference﹤Ref﹥[1..1]text{35}Transaction referenceFPAYH-DOC1R 
++++3Account﹤Acc﹥[1..1]    
+++++3Bank Key﹤BIC﹥[0..1]text{11}Mandatory if IBAN is not provided. Must not be in output if IBAN is providedFPAYH-ZSWIF 
+++++3IBAN﹤IBAN﹥[0..1]text{32} FPAYH-ZIBAN 
+++++3Id﹤Id﹥[0..1]text{8)Mandatory if IBAN is not provided. Must not be in output if IBAN is providedFPAYH-ZBNKN 
++++3Recipien Name﹤RecNm﹥[1..1]text{1,35} FPAYH-KOINH 
++++3Recipient Addres﹤RecAdr﹥[1..1]    
+++++4City﹤City﹥[1..1]text{1,35} FPAYH-ZORT1 
+++++4Street﹤Stret﹥[1..1]text{1,35} FPAYH-ZSTRA 
+++++4Postal code﹤Pstl﹥[1..1]text{1,35} FPAYH-ZPSTL 
++++3Execution date﹤Dt﹥[1..1] DD/MM/YYYFPAYH-AUSFD 
++++3Amount﹤Amt﹥[1..1]

0 ﹤= decimal

td = 18

fd = 5

 FPAYH-WRBTR 
  CurrencyCcy[1..1]

text

[A-Z]{3,3}

Ccy is attribute of ﹤Amt> node. Example: ﹤Amt Ccy="EUR"> ﹤/Amt>FPAYHX-ISO_WAERS 
++++3Remittance information﹤Rmt﹥[0..1] New remittance information per reference to paid documentFPAYP-DOC2RBank-specific Requirements
+++++4info﹤Info﹥[0..n]text{1,35} FPAYP-XBLNRBank-specific Requirements

System Simulation

In this exercise, you'll discover the necessary steps to create a new format mapping for payments and outgoing payment files.

Log in to track your progress & complete quizzes