EFT Template

Because the EFT output needs to be plain text (as opposed to formatted text in Word or HTML), EFT templates are still defined in Code Setup/Message Definitions, but with significant differences:

  1. They are defined as plain text in the NX Editor.
  2. There is no ability or need to Upload/Download EFT Templates, since they can be created and edited in NX Message Definitions.
  3. The EFT file generated is a plain text file downloaded to the users local or network drive for use with their banks software.

The following principles apply when defining an EFT Template:

  1. There are both Commands and Substitution Codes available to create the template and to ensure the output is in the correct format.
  2. Commands are wrapped in {{ and }} delimiters.

Valid Commands are:

Command Description Example
Writefield Used to define that data which is to be output data from Tourplan and can also define the length of that data {{writefield "trntot" 10"}}
Writetext Used to define a specific block of text to be output {{writetext "7999-999            "}}
Moneyformat Defines the format of any amounts to be output include in-fill character to use {{moneyformat " cents " "0"}}
Dateformat Defines the format of any dates to be output {{dateformat "yymmdd"}}
Newline Tells the output engine to insert a new line character {{newline}}
Data Tells the output engine the this is the data section and will repeat once for each transaction {{data}}
/Data Tells the output engine the this is the end of the data section {{/data}}

For details of EFT message substitution codes, see EFT Substitution Codes

Example EFT Fixed Field Length Format

Example EFT Fixed Length Output

 

Example EFT Comma Delimited Format

Example EFT Comma Delimited Output