Sample File
TRANSACTION DATE,ACCOUNT NUMBER,ACCOUNT NAME,CCY,CLOSING BALANCE,AMOUNT,TRANSACTION CODE,NARRATIVE,SERIAL
20130821,032515285179,"Clients Receipts",AUD,+15674.40,-340.00,209,"DIRECT DEBIT RETURNED 200813 LODGEMENT REF 12350 ANSWER 6 ",0200813
20130821,032515285179,"Clients Receipts",AUD,+15674.40,-50.00,209,"DIRECT DEBIT RETURNED 200813 LODGEMENT REF 11555 ANSWER 6 ",0200813
20130821,032515285179,"Clients Receipts",AUD,+15674.40,-257.30,209,"DIRECT DEBIT RETURNED 210813 LODGEMENT REF 13466 ANSWER 6 ",0210813
20130821,032515285179,"Clients Receipts",AUD,+15674.40,-152.00,209,"DIRECT DEBIT RETURNED 210813 LODGEMENT REF 12439 ANSWER 6 ",0210813
20130821,032515285179,"Clients Receipts",AUD,+15674.40,+68.94,262,"DEPOSIT DE DRAW DECRBAL DE DRAW ID456167 AUSTRALIANPREMIERFINANCEP",DECRBAL
20130821,032515285179,"Clients Receipts",AUD,+15674.40,+10778.49,262,"DEPOSIT DE DRAW DECRBAL DE DRAW ID456167 AUSTRALIANPREMIERFINANCEP",DECRBAL
Field | Field Name | Length | Format | Comments |
---|---|---|---|---|
1 | Customer Reference Number | 20 | AN | The number by which the Biller identifies the account that is being paid. |
2 | Payment Instruction Type | 2 | N | A code indicating the type of instruction: 05 = Payment, 15 = Error Correction and 25 = Reversal. |
3 | Amount | 12 | N | The date of the Payment or Error Correction, 2 digits of cents implied. |
4 | Date of Payment | 8 | N | The date that the Payment or Error Correction was accepted by the Payer Institution, in DD/MM/YY format. |
5 | Time of Payment | 8 | N | The time that the Payment or Error Correction was accepted by the Payer Institution, in HH:MM:SS format. |
6 | Payment Method | 3 | N |
A code indicating the method of Payment: 001 = Debit Account, 101 = Visa, 201 = MasterCard and 301 = Other Credit Card. |
7 | Transaction Receipt Number | 21 | AN | The receipt number provided to the customer on successful completion of a payment. |
Example of the above
546309,05,1.00,03/07/06,22:18:39,001,BBL200607030010712478
546317,05,32.00,03/07/06,22:19:16,001,ANZ20060703477748
533666,25,20.00,03/07/06,22:20:03,201,STG2006070322335