Hexagon Export file format
The import file must be in a tagged ASCII text file format.
The imported file must contain a balancing contra-credit (i.e. debit) and corresponding beneficiary payment instructions. The maximum number of beneficiaries per instruction are 200. If there are more than this number of payments being made, sequentially numbered files will be created.
The Import file will contain two types of ‘tags’:
Control ‘tags’ are used as logical separators and for control totals
Data ‘tags’ are used to map the data to the correct fields in the payment database
Control tags
At the beginning of the import file, two ‘Total’ Control tags are used to validate the number of credit-contras (i.e. debits), and the total value of the instructions in the file. The Control tags used are:
$FN to determine the number of credit-contras in the file
$FT for the total value of the file
$FC payment currency either EUR or GBP (v5 or above)
The logical separator Control ‘tags’ are grouped into ‘start’ and ‘end’ pairs for a set of balancing instructions ($DS & %DE respectively), and for separating Beneficiary payment instructions ($LS & $LE respectively).
Note: The entry control tags must always be preceded and surrounded with instruction control tags.
Data tags
The data ‘tags’ and validating Control ‘tags’ ($FN & $FT) are separated from the data by a colon ‘:’ (no spaces). When entering values, units and decimals must be separated by a period full stop ‘.’
Tag
|
Field Name
|
Indicator
|
Size
|
Description
|
$FN
|
Total number of payment instructions
|
Mandatory
|
5n
|
Control tag indicating no. of credit-contras in file
|
$FT
|
Total amount of import file
|
Mandatory
|
18n
|
Control tag providing total value for the file
|
$FC
|
Currency of import file
|
Optional
|
3a
|
‘GBP’ or ‘EUR’. If field omitted/empty default is GBP
|
$DS
|
Start of balancing set of instructions
|
Mandatory
|
Control tag separator at the start of a balancing set of instructions
| |
F01
|
Debit account number
|
Mandatory
|
8n
|
Acct. number from which debit will be made. Account must exist in the Hexagon portfolio
|
F02
|
Value Date
|
Mandatory
|
6n
|
Date on which payments will credited beneficiary. Date format as per Windows Int.
|
F03
|
Debit Description
|
Optional
|
10x
|
Description which will appear on the Bank statement
|
F04
|
Number of Payments
|
Mandatory
|
3n
|
Control field for the total number of Payments in the balancing set
|
F05
|
Total amount
|
Mandatory
|
12n
|
Total value of payments in this Balancing set
|
$LS
|
Start of individual payment instruction
|
Mandatory
|
Control tag to indicate the starts of an individual payment
| |
S01
|
Beneficiary account number
|
Mandatory
|
8n
|
Account number of beneficiary
|
S02
|
Beneficiary bank sort code
|
Mandatory
|
6n
|
Bank sort code of beneficiary
|
S03
|
Beneficiary name
|
Mandatory
|
18x
|
Name of beneficiary
|
S04
|
Credit amount of individual payment
|
Mandatory
|
11n
|
Amount to be paid to the beneficiary of the payment
|
S05
|
Payment description
|
Optional
|
18a
|
Payment description for beneficiary
|
$LE
|
End of individual payment instruction
|
Mandatory
|
Control tag to indicate the end of an individual payment
| |
$DE
|
End of balancing set of instructions
|
Mandatory
|
Control tag separator at the end of a balancing set of instructions
|