Creating an eText Template 4-19
it a record name. You should have a data field specifying the segment name as part of
the output data immediately following the new record command.
For DELIMITER_BASED templates, you insert the appropriate data field delimiters in
separate rows between the data fields. After every data field row, you insert a delimiter
row. You can insert a placeholder for an empty field by defining two consecutive
Empty fields are often used for syntax reasons: you must insert placeholders for empty
fields so that the fields that follow can be properly identified.
There are different delimiters to signify data fields, composite data fields, and end of
record. Some formats allow you to choose the delimiter characters. In all cases you
should use the same delimiter consistently for the same purpose to avoid syntax errors.
In DELIMITER_BASED templates, the <POSITION> and <PAD> columns do not apply.
They are omitted from the data tables.
Some DELIMITER_BASED templates have minimum and maximum length
specifications. In those cases Oracle Payments validates the length.
Define Level Command
Some formats require specific additional data levels that are not in the data extract. For
example, some formats require that payments be grouped by payment date. Using the
Define Level command, a payment date group can be defined and referenced as a level
in the template, even though it is not in the input extract file.
When you use the Define Level command you declare a base level that exists in the
extract. The Define Level command inserts a new level one level higher than the base
level of the extract. The new level functions as a grouping of the instances of the base
The Define Level command is a setup command, therefore it must be defined in the
setup table. It has three subcommands:
Base Level Command - defines the level (XML element) from the extract that the
new level is based on. The Define Level command must always have one and only
one base level subcommand.
Grouping Criteria - defines the XML extract elements that are used to group the
instances of the base level to form the instances of the new level. The parameter of
the grouping criteria command is a comma-separated list of elements that specify
the grouping conditions.
The order of the elements determines the hierarchy of the grouping. The instances
of the base level are first divided into groups according to the values of the first
criterion, then each of these groups is subdivided into groups according to the
second criterion, and so on. Each of the final subgroups will be considered as an
instance of the new level.
Group Sort Ascending or Group Sort Descending - defines the sorting of the group.
Insert the <GROUP SORT ASCENDING> or <GROUP SORT DESCENDING>