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:
- They are defined as plain text in the NX Editor.
- There is no ability or need to Upload/Download EFT Templates, since they can be created and edited in NX Message Definitions.
- 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:
- There are both Commands and Substitution Codes available to create the template and to ensure the output is in the correct format.
- 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