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
- Open the Credit Card Mapping window.
- Search or populate to find the relevant credit card type and go to the
XML/Mapping tab.
- 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.
- 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.
- 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.
- Save your changes.