Master Data Setup

To set up SEPA functionality in LN, complete the following steps:

  • Enter additional settings in Common and Finance/Logistics (direct debit only)
  • Create an XML layout
  • Maintain mapping elements
  • Modify payment method
  • Create direct debit mandates (optional)
Entering additional settings in Common and Financials

The first step in setting up master data for SEPA direct debits is to enter additional settings in the following sessions:

  • General Company Data (tccom0502m000)
  • Business Partners (tccom4500m000) (optional)
  • CMG Parameters (tfcmg0500m000)
  • In the General Company Data (tccom0102s000) details session, under Registration, enter a creditor identifier and, optionally, a business entity identifier.
FieldDescription
Creditor IdentifierThe creditor identifier is required in the SEPA direct debit file. The identifier entered here will be defaulted to the Direct Debit Mandate Required session, where it can be overwritten.
Business Entity IdentifierThe business entity identifier can optionally be used as an identifier for the direct debit company in the direct debit file.

 

  • In the Business Partners (tccom4100s000) details session, on the Detailed tab, enter the business entity identifier (optional).
  • In the CMG Parameters (tfcmg0100s000) details session, on the Direct Debits tab, enter a number group and series to be used for direct debit mandates.
Creating an XML layout

The first step in setting up master data for SEPA credit transfers is to define an XML layout, using the following sessions:

  • XML Payment/Receipt Layouts (tfcmg0524m000)
  • XML Payment/Receipt Layout (tfcmg0624m000)
  • In the XML Payment/Receipt Layouts (tfcmg0524m000) session, enter a new layout code.
Note

XML layouts are version controlled.

The status can be Initial, Active, or Expired.

FieldDescription
LayoutThe XML layout code.
VersionThe version number, generated automatically.
Receipts/PaymentsIndicates whether the payment method refers to payments or receipts.
SeparatorThe character used for concatenation of mapping elements when multiple LN data is mapped to an XML tag.
Group Payment InformationIf this check box is selected, payment / direct debit files payment information tags are grouped together. As a result, the payment information tag (PmtInf) is specified only once for the combination of bank, payment method, and planned debit date. If this check box is cleared, the payment information is specified for every composed payment line for the direct debit batch.
StatusXML version status, see below.

 

CommandDescription
Initialize LayoutAn empty layout can be initialized. All tags in the ISO 20022 format will be initialized. Initialization can be repeated if the status of the layout is Initial. Initialization can be performed with an overwrite option which is the same as reinitialization, or without overwrite, in which cases modifications are not lost.
Activate LayoutSets the status of the XML layout to Active.
Expire LayoutSets the status of the XML layout to Expired.
Generate XMLStarts the Select Payment / Direct debit Batch for XML File Generation (tfcmg0224m000) session.

 

XML layout version status
StatusDescription
InitialIf the status is Initial, you can change layout details.
Active
  • A layout with status Active cannot be changed.

    To make changes, copy the current layout to a new version number.

    To use the layout with the new version number, complete the following steps:

    • Set the status of the active layout to Expired.
    • Set the status of the layout with the new version number to Active.
ExpiredThe layout can no longer be used.

 

  • Define the layout header fields.
  • Click Save Function
  • On the appropriate menu, click Initialize Layout

LN generates default XML tags and their mappings to payment/ receipt elements. These default values XML tags and their mappings are based on the recommendations as laid down in the EPC (European Payments Council) rulebooks.

Maintaining XML tags

The EPC rulebooks and guidelines allow for bank or country-specific requirements in the XML file to be sent to the bank. These local or specific requirements can be fulfilled using optional XML tags. Therefore, you can add, delete, or edit XML tags in the initialized default layout.

To delete an XML tag, select the appropriate XML-tag line and use the Delete command in the session menu. If the XML tag type is mandatory because it has been specified as a minimum requirement in the EPC Rulebook, the layout line cannot be deleted.

To Edit an XML tag (layout status: Initial), double-click the required XML-tag line to start the XML Payment/Receipt Layout Lines (tfcmg0125m000) details session.

FieldDescription
XML Tag IdentifierThe XML tag number.
XML TagThe XML tag name.
XML Tag DescriptionThe XML tag description.
XML Tag TypeDefines a set of values and the allowable operations on those values. This field indicates what sort of value is expected for this tag. This is compared with the element type of mapping elements. If a mismatch occurs, the user is informed.

For mapping XML elements to LN records, the following data types exist:

  • Attribute
    For example, currency code, quantity
  • Boolean
    Yes/No
  • Date
    Absolute date
  • Decimal Number
  • Node
    Only for parents
  • String
    Alphanumeric code
  • UTC Date
    Time-zone-independent date
Parent XML Tag IdentifierThe number in this field indicates the parent of the current XML tag, which is used to construct the XML tree structure.
Sequence in ParentA parent tag can have multiple child tags. This field indicates the sequence in which the current tag occurs for the parent.
MandatoryIf this check box is selected, the layout line cannot be deleted.
SelectIf this check box is selected, the XML tag will be included in the file generation.
Map to Payment ElementIf this check box is selected, the tag value for this layout line will be set based on one or more LN table fields or variables. Fixed text means the value entered by the user will be used as a (static) tag value. Map to Payment Element and Fixed Text are mutually exclusive.
Fixed TextSee the Map to Payment Element field
Maximum Text CharactersThe maximum number of text characters allowed.
ChoiceIf this check box is selected, the tag is a mutually exclusive choice element. If two child elements are marked as Choice, the user is informed about this when both tags are selected.
TransactionalIf this check box is selected, the data for this line is based on the actual transaction. The transactional tags are repeated as many times as there are transactions.
Sort SequenceThe sequence of the XML tag in the file. Sort sequence is a system-generated sequence of the XML file. After activation, all selected lines should have a non-zero value here. This field is for technical reasons only and disabled for user input.

 

Caution!

Do not to change XML Tag Type, Parent XML Tag Identifier, or Sequence in Parent values unless the format that is required by the bank necessitates this change.

Guidelines for editing

  • If the Selected check box is selected, almost all fields are editable. However, if the tag is generated as, for example, the payment identifier, it only makes sense to change the following fields:
    • XML Tag Description
    • Mandatory
    • Map to Payment Element
    • Fixed Text
    • Maximum Text Characters
    • Choice
  • The value of the Sort Sequence field is generated and cannot be changed.
  • Only when you create a new tag can you change the following fields:
    • XML Tag
    • XML Tag Type
    • Parent XML Tag Identifier
    • Sequence in Parent
    • Choice
    • Transactional Except tags that belong to the group header, all tags must have this check box selected.
  • For a particular local requirement, you can define that a tag is mandatory. If the Map to Payment Element check box is selected, this means that the tag must be mapped, or is already mapped in case of a default generated tag, to data in LN. If this check box is cleared, the tag is entered at runtime and/or a fixed text can be added. The Fixed Text field and the Map to Payment Element check box are mutually exclusive.

To add an XML tag, on the XML Payment/Receipt Layout Lines (tfcmg0125m000) tab, click the New Layout Details button.