Match Database Columns with XML Tags

Explanation

This activity is used to match information provided in an XML file with relevant database columns used by the IFS Applications to store data.

Prerequisites

In order to perform this activity:

• A credit card type has to be registered in the system.
• Format of the credit card type has to be set to XML.
• You need to know the XML structure of an external XML file.

System Effects

As a result of this activity, a credit card type will be automatically mapped to read a relevant external XML file.

Window

Credit Card Mapping

Related Window Descriptions

Credit Card Mapping

Procedure

1. Open the Credit Card Mapping window.
2. Search or populate to find the relevant credit card type and go to the XML/Mapping tab.
3. In the XML Tag field, enter the xml tag with information that you want to map to a relevant database column. In the DB Column field you can see under what database columns this data will be filed
   Note: Database columns marked with the Mandatory check box have to be mapped.
4. If a database column cannot be directly mapped to an XML tag, but requires string operations (e.g. concatenated value), then define it in the Expression field.
   Note: It is possible to map either expression or an XML tag for a single DB Column.
5. If you are familiar with XLS, you can inspect a preview of an XLS statement that will be created based on the tag in the XLS Preview field.
6. Save your changes.