ABAFILE EFT Output Format
ANZ,NAB, and WBC all use the standard ABA file format. These banks use transaction code 50 or 13 depending on if the payment is a debit or credit.
ABAFILE (ANZ, NAB, WBC)
Standard Record Type 0
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 0 | 1 | 1 | 0 |
| Blank | 2 | 17 | Must be blank-filled |
| Reel Sequence Number | 19 | 2 | 01 |
| User Financial Institution | 21 | 3 | bank_addr_mst.bank_code
Must be an approved financial institution abbreviation |
| Blank | 24 | 7 | Must be blank-filled |
| User preferred name of user supplying file | 31 | 26 | apparms_mst.EFT_user_name
Must not be all blanks |
| User Identification Number of user supplying file | 57 | 6 | apparms_mst.EFT_user_number
Must be User Identification Number assigned by APCA and User Financial Institutions. Must be numeric. Right justified. Zero filled |
| Description of file contents | 63 | 12 | "VENDOR PMT" |
| Date to be processed | 75 | 6 | Today()
The date when transactions are released to all financial institutions |
| Blank | 81 | 40 | Must be blank-filled. |
Standard Record Type 1
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 1 | 1 | 1 | 1 |
| BSB Number | 2 | 7 | vendor_mst.EFT_bank_num
Format ###-### |
| Account number | 9 | 9 | vendor_mst.account |
| Indicator | 18 | 1 | blank |
| Transaction Code | 19 | 2 | 13 or 50 |
| Amount | 21 | 10 | glbank_mst.check_amt |
| Title of Account | 31 | 32 | parms_mst.company |
| Reference | 63 | 18 | glbank_mst.ref_num+'-'+glbank_mst.check_num |
| BSB Number | 81 | 7 | bank_addr_mst.bank_number
Format ###-### |
| AccountNumber | 88 | 9 | bank_hdr_mst.branch_code |
| Name of Remitter | 97 | 16 | parms_mst.company |
| Amount of withholding Tax | 113 | 8 | 00000000 |
ABAFILE (HSBC, Bankwest)
These banks use the records above, but in addition to those standard records, they request one last record of Type 1 (Transaction Code = 13) that totals all the payments into one credit record with the format shown here:
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 1 | 1 | 1 | 1 |
| BSB Number | 2 | 7 | bank_addr_mst.bank_number
Format ###-### |
| Account number | 9 | 9 | bank_hdr_mst.branch_code |
| Indicator | 18 | 1 | blank |
| Transaction Code | 19 | 2 | 13 |
| Amount | 21 | 10 | dbl_NegativeAmtTotal |
| Title of Account | 31 | 32 | parms_mst.company |
| Reference | 63 | 18 | "Creditor Payments" |
| BSB Number | 81 | 7 | bank_addr_mst.bank_number
Format ###-### |
| AccountNumber | 88 | 9 | bank_hdr_mst.branch_code |
| Name of Remitter | 97 | 16 | parms_mst.company |
| Amount of withholding Tax | 113 | 8 | 00000000 |
ABAFILE (CBA)
This bank uses the standard formats shows above, but it requires two records for each transaction (Transaction Code = 50 followed by this one with Transaction Code = 13):
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 1 | 1 | 1 | 1 |
| BSB Number | 2 | 7 | bank_addr_mst.bank_number
Format ###-### |
| Account number | 9 | 9 | bank_hdr_mst.branch_code |
| Indicator | 18 | 1 | blank |
| Transaction Code | 19 | 2 | 13 |
| Amount | 21 | 10 | DomCheckAmt |
| Title of Account | 31 | 32 | parms_mst.company |
| Reference | 63 | 18 | "Payment" |
| BSB Number | 81 | 7 | bank_addr_mst.bank_number
Format ###-### |
| AccountNumber | 88 | 9 | bank_hdr_mst.branch_code |
| Name of Remitter | 97 | 16 | parms_mst.company |
| Amount of withholding Tax | 113 | 8 | 00000000 |