BOA - Bank of AmericaANZ - ANZ Bank Limited

There are two options for generating the ANZ File format in a New Zealand database:

To generate the ANZ Bank File format via the new method, the Bank File Format on the required Company Bank Details record/s must be set to ANZ.

 

To configure the use of the ANZ 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

 

The file contents are formatted like a CSV file with the comma character separating each field, but the file is generated with a .TXT extension.

 

Header Record      
Field Name Type Length Description
Record Type Numeric 1 Fixed value - '1'
Subscriber ID Numeric 16 Left Blank
Batch Number Numeric 2 Left Blank
Filler Numeric 4 Left Blank
Subscriber's Acct No Numeric 15 Left Blank
Batch Type Numeric 1 Left Blank
Batch Due Date Numeric 8 Direct Credit Date keyed in job submission parameters in the form YYYYMMDD
Batch Creation Date Numeric 8

When Bank File Format = ANZ:

  • Date the file was created in CCYYMMDD format

When Bank File Format = PAY64:

  • Direct Credit Date from EFT Processing in CCYYMMDD format

 

Detailed Transaction Record      
Field Name Type Length Description
Record Type Numeric 2 Fixed Value - '2'
Account Number Numeric 16 Employees BSB number followed by the employee's bank account number.
e.g. 06015123456701
Transaction Code Numeric 2 Fixed value - '52' - Salary Payment
Amount Alpha/Numeric 11 The amount is in cents. No dollar signs, commas or decimal points
Other Party Name Alpha/Numeric 20 Party Receiving Payment, employee's Bank Account Name
Other Party Reference Alpha/Numeric 12 Other Party Statement Details. Employee Reference Field from Bank Details
Other Party Analysis Code Alpha/Numeric 12 Other Party Statement Details. Employee Code field from Bank Details
Other Party Alpha Reference Alpha/Numeric 12 Left Blank
Other Party Particulars Alpha/Numeric 12 Other Party Statement Details. Employee Particulars field from Bank Details
Subscribers Name Alpha/Numeric 20 Name of Party making the payment. Account Name from Company Bank Details window
Subscribers Analysis Code Alpha/Numeric 12 Left Blank
Subscribers Reference Alpha/Numeric 12 Left Blank
Subscribers Particulars Alpha/Numeric 12 Left Blank