Domestic extended format
Payment upload file type.
- A valid file must have a Header Record, one or more Transaction Records and a Control Record (including a hash total).
- Fields must not contain commas.
- Each Transaction Record can vary in length.
- Each line must end with a carriage return (CR=x’oD’) and line feed (LF=x’oA’) pair of characters in that order.
Example: Complete MTS file
2,0101230456789000,50,221300,TEST CUST1,,,,WAGES,DEMONSTRATION COMP,,,WAGES
2,0604750123456002,50,80000,TEST CUST2,,,,WAGES,DEMONSTRATION COMP,,,WAGES
2,0303210987654030,50,82400,TEST CUST3,,,,WAGES,DEMONSTRATION COMP,,,WAGES
2,1161001234567040,50,119700,TEST CUST4,,,,WAGES,DEMONSTRATION COMP,,,WAGES
3, 503400,4,70192802466
File specifications: Record 1 - MTS Header Record
Example:
1,,,,,,20060725,20060725,
Characters | Type | Contents | Mandatory | |
|---|---|---|---|---|
Record type | 1 digit | Numbers | 1 | Yes |
Subscriber ID | Up to 16 digits | Numbers | Empty field | No |
Batch number | Up to 2 digits | Numbers | Empty field | No |
Null | Up to 4 digits | Numbers | Empty field | No |
Subscriber's account number | 15 digits | Numbers | Empty field | No |
Batch type | 1 digit | Numbers | Empty field | No |
Batch due date | 8 digits | Numbers | YYYYMMDD | Yes |
Batch creation date | 8 digits | Numbers | YYYYMMDD | Yes |
File specifications: Record 2 - Transaction Record
Example:
2,0101230456789000,50,221300,TEST CUST1,,,,WAGES,DEMONSTRATION COMP,,,WAGES
2,0604750123456002,50,80000,TEST CUST2,,,,WAGES,DEMONSTRATION COMP,,,WAGES
Characters | Type | Contents | Mandatory | |
|---|---|---|---|---|
Record type | 1 digit | Numbers | 2 | Yes |
Account number | 15 or 16 digits | Numbers | BBBBBBAAAAAAASS or BBBBBBAAAAAAASSS | Yes |
Transaction code | 2 digits | Numbers | 50 (standard credit) | Yes |
Amount | Up to 11 digits | Numbers | The amount in cents. No dollar signs, commas or decimal points | Yes |
Other party name | Up to 20 characters | Characters or numbers | Party receiving payment | Yes |
Other party reference | Up to 12 characters | Characters or numbers | Other party statement details | Yes |
Other party analysis code | Up to 12 characters | Characters or numbers | Other party statement details | Yes |
Other party alpha reference | Up to 12 characters | Characters or numbers | Not used (but must be allowed for) | No |
Other party particulars | Up to 12 characters | Characters or numbers | Other party statement details | No |
Subscriber name | Up to 20 characters | Characters or numbers | Name of party making payment | No |
Subscriber's analysis code | Up to 12 characters | Characters or numbers | Details on your statement | No |
Subscriber's reference | Up to 12 characters | Characters or numbers | Details on your statement | No |
Subscriber's particulars | Up to 12 characters | Characters or numbers | Details on your statement | No |
Note: Account numbers can be 15 or 16 digits long depending on the suffix length. For example, if a 00 suffix is entered, it will automatically be updated to 000. If a 25 suffix is entered, it will be updated to 025. A suffix cannot be greater than 99.
File specifications: Record 3 - Control Record
Example:
3, 503400,4,70192802466
Characters | Type | Contents | Mandatory | |
|---|---|---|---|---|
Record type | 1 digit | Numbers | 3 | Yes |
Batch total amount | Up to 11 digits | Numbers | The amount in cents. No dollar signs, commas or decimal points | Yes |
Number of transactions | Up to 5 digits | Numbers | Total number of transactions | Yes |
Hash total | 11 digits | Numbers | Sum of branch and account numbers, overflow ignored | Yes |
Note: The hash total is calculated using the branch and base account numbers in each transaction record. The bank number and account suffix are not used when calculating the hash total.
File specifications: Account number
Example:
01-0123-0456789-00
Bank account | Branch number | Base account number | Suffix | |
|---|---|---|---|---|
Example account number | 01 | 0123 | 0456789 | 00 |
If used or not | Not used for calculation | Used for calculation | Used for calculation (the last 7 digits only) | No used for calculation |
To calculate the hash total use the following example:
Branch and base numbers combined | |
|---|---|
01-0123-0456789-00 | 1,230,456,789 |
06-0475-0123456-02 | 4,750,123,456 |
03-0321-0987654-30 | 3,210,987,654 |
11-6100-1234567-040 | 61,001,234,567 |
Hash total | 70,192,802,466 |
Note:
- The hash total is calculated adding the branch and the account numbers in each transaction record.
- The bank number and account suffix are not used when calculating the hash total.
- If the base number is 8 digits then the left most digit is excluded from the calculations.
- If the hash total is more than 11 characters, exclude the extra characters on the left end.