ASB - Bank Limited
There are two options for generating the ASB Bank Limited EFT File format in a New Zealand database:
New Method
To generate the Citibank Paylink Bank File format via the new method, the Bank File Format on the required Company Bank Details record/s must be set to ASB.
Old Method
To configure the use of the ASB Bank Limited EFT File format via the Old Method:
- The Bank File Format on the required Company Bank Details record/s must be set to PAY64.
- Positions 14-19 of Program Control PAY64 must be set to ASB
The format of the ASB Bank file is a fixed position flat file, with each field of information represented by a set number of positions within each record.
| Header Record | |||
|---|---|---|---|
| Field Name | Type | Length | Description |
| File Type | Numeric | 2 | 12 identifies the file as a direct credit file |
| Bank Number | Numeric | 2 | Unique 2 character number for each NZ bank. Position 1 - 2 of the Company BSB Number from the Company Bank Details window. e.g. 02 |
| Branch Number | Numeric | 4 | Unique 4 character number for each branch of a bank. e.g. Position 3 - 6 of the Company BSB Number from the Company Bank Details window. e.g. 0144 |
| Unique Number | Numeric | 7 | 7 character number unique to the bank's customer. 1st 7 digits of the Company Bank Account Number form the Company Bank Details window |
| Suffix | Numeric | 3 | The 2 character suffix. Remaining digits of the Company Bank Account Number from the Company Bank Details window followed by a space. |
| Due Date | Numeric | 13 | This is the date on which the transactions are to be cleared into the bank system. Direct Credit date keyed in Job Submission parameters from the EFT Processing process followed by 7 spaces. |
| Client Short Name | Alpha/Numeric | 20 |
When Bank File Format = ASB:
When Bank File Format = PAY64:
|
| Filler | Alpha/Numeric | 109 |
| Detailed Transaction Record | |||
|---|---|---|---|
| Field Name | Type | Length | Description |
| Record Type | Numeric | 2 | Fixed value - '13' |
| Bank Name | Numeric | 2 | 2 character number unique to each NZ bank ( First 2 characters of "BSB Number" on the employee Bank Details record |
| Branch Number | Numeric | 4 | 4 character number unique to each branch of a bank. 3rd to 6th characters of "BSB Number" on the employee Bank Details record |
| Unique Number | Numeric | 7 | 7 character number unique to the bank's customer "Account Number" on the employee Bank Details record |
| Suffix | Numeric | 3 |
Concatenation of:
|
| Transaction Code | Numeric | 3 | To contain a valid transaction code: 051 = General Credit - 2nd and subsequent employee Bank Account with Allow/Deduct classification K. e.g. if an employee has a pay record paid on an Allow/Deduct code with a classification of K. 052 = Salary/Wages - Employee Main Bank Account. |
| Amount | Numeric | 10 | Express as cents. Do not include the decimal point. Align right and pad to the left with zero's. e.g. $123.45 expressed as 0000012345 |
| Payee's Name | Alpha/Numeric | 20 | Payee's name. "Account Name" from the employee Bank Details record Space filled if less than 20 characters |
| Internal Ref | Alpha/Numeric | 12 | Left Blank |
| Payee Code | Alpha/Numeric | 12 | "Code" from the employee Bank Details record |
| Payee Reference | Alpha/Numeric | 12 | "Reference" from the employee Bank Details record |
| Payee Particulars | Alpha/Numeric | 12 | "Particulars" from the employee Bank Details record |
| Filler | Alpha/Numeric | 1 | Left Blank / Space filled |
| Payer Name | Alpha/Numeric | 20 | Left Blank / Space filled |
| Payer Code | Alpha/Numeric | 12 | Left Blank / Space filled |
| Payer Reference | Alpha/Numeric | 12 | Left Blank / Space filled |
| payer Particulars | Alpha/Numeric | 12 | Left Blank / Space filled |
| Filler | Alpha/Numeric | 4 | Left Blank / Space filled |
| Trailer Record | |||
|---|---|---|---|
| Field Name | Type | Length | Description |
| Record Type | Numeric | 2 | Fixed Value - '13' to indicate the beginning of a new record. |
| Key Field | Numeric | 2 | Fixed value - '99' to identify this record as the trailer record. |
| Import File Check Total | Numeric | 11 | Use the MT9 algorithm to populate this field. Note: The MT9 algorithm is the sum of all the detail records branch and unique numbers. If the number exceeds 11 characters, the remaining characters are not used. For Example, if the sum is 123456789123, then the import file check total is shortened to 23456789123. |
| Filler | Alpha/Numeric | 6 | Left Blank / Space filled |
| Total Amount | Numeric | 10 | This is the sum of all detail record amounts. Express as cents. Do not include the decimal point. Align right and pad to the left with zeros. e.g. $123.45 expressed as 0000012345 |
| Filler | Alpha/Numeric | 129 | Left Blank / Space filled |
2024