DERPS File Format
The DERPS file contains information about Direct Entry transactions submitted in an ABA file that have subsequently been returned by the receiving financial institution.
Related file formats: ABA · DEEDS
DERPS File Structure
A DERPS file consists of three record types:
| Record Type | Value | Description |
|---|---|---|
| Header | "0" | Contains file-level information. There is one Header record at the beginning of the file. |
| Detail | "2" | Represents a single returned Direct Entry transaction. There can be one or more Detail records in a file. |
| Trailer | "7" | Contains the total number of returned transactions and control totals used to verify the integrity and completeness of the file. There is one Trailer record at the end of the file. |
The records always appear in the following order:
Header (0)
↓
Detail (2)
Detail (2)
...
Detail (2)
↓
Trailer (7)Example File Structure
Header Record
0 01WBC WESTPAC BANKING CORP. 609332 310726032-797275306Detail Record
2032-001234567 6130000005000EMPLOYEE 01 24687703-22011108 023-130 11234790Remitter Name 29609332CUSTOMER NAME 290726Trailer Record
7999-999 000035797800000000000000357978 000016File Specification
Header Record
| No | Field Name | Position | Length | Description |
|---|---|---|---|---|
| 1 | Record Type | 1 | 1 | "0" |
| 2 | Blank | 2-18 | 17 | Blank filled. |
| 3 | Reel Sequence Number | 19-20 | 2 | "01" |
| 4 | Abbreviation of User's Financial Institution | 21-23 | 3 | The approved Financial Institution abbreviation, "WBC". |
| 5 | Blank | 24-30 | 7 | Blank filled. |
| 6 | Name of User's Financial Institution | 31-56 | 26 | "WESTPAC BANKING CORP." |
| 7 | Number of User Supplying File | 57-62 | 6 | The customer's DE User ID, mapped from the original DE file Header. |
| 8 | Blank | 63-74 | 12 | Blank filled. |
| 9 | Return Date | 75-80 | 6 | The return date of the file, in DDMMYY format. |
| 10 | Trace BSB Number | 81-87 | 7 | The Trace BSB Number from the original file. |
| 11 | Trace Account Number | 88-96 | 9 | The Trace Account Number from the original file. |
| 12 | Blank | 97-160 | 64 | Blank filled. |
Detail Record
| No | Field Name | Position | Length | Description |
|---|---|---|---|---|
| 1 | Record Type | 1 | 1 | "2" |
| 2 | Trace BSB Number | 2-8 | 7 | The Trace BSB Number from the original Detail record. |
| 3 | Trace Account Number | 9-17 | 9 | The Trace Account Number from the original Detail record. |
| 4 | Return Code | 18 | 1 | Return Code: "1" - Invalid BSB Number "2" - Payment Stopped "3" - Account Closed "4" - Customer Deceased "5" - No Account or Incorrect Account Number "6" - Refer to Customer "7" - Deleted "8" - Invalid User ID Number "9" - Technically Invalid |
| 5 | Transaction Code | 19-20 | 2 | The Transaction Code from the original Detail record. |
| 6 | Amount | 21-30 | 10 | The Amount from the original Detail record. |
| 7 | Title of Account | 31-62 | 32 | The Title of Account from the original Detail record. |
| 8 | Lodgement Reference | 63-80 | 18 | The Lodgement Reference from the original Detail record. |
| 9 | Source BSB Number | 81-87 | 7 | The BSB Number from the original Detail record. |
| 10 | Source Account Number | 88-96 | 9 | The Account Number from the original Detail record. |
| 11 | Name of Remitter | 97-112 | 16 | The Name of Remitter from the original Detail record. |
| 12 | Processing Day | 113-114 | 2 | The day of the Processing Date from the original Header record. |
| 13 | Number of User Supplying File | 115-120 | 6 | The Number of User Supplying File from the original Header record. |
| 14 | Name of User Supplying File | 121-146 | 26 | Customer name loaded to the DERPS table. |
| 15 | Processing Date | 147-152 | 6 | The Processing Date from the original Header record. |
| 16 | Blank | 153-160 | 8 | Blank filled. |
Trailer Record
| No | Field Name | Position | Length | Description |
|---|---|---|---|---|
| 1 | Record Type | 1 | 1 | "7" |
| 2 | BSB Format Filler | 2-8 | 7 | "999-999" |
| 3 | Blank | 9-20 | 12 | Blank filled. |
| 4 | Net Total Amount | 21-30 | 10 | The net total amount for the file. |
| 5 | File Credit Total | 31-40 | 10 | The file credit total. |
| 6 | File Debit Total | 41-50 | 10 | The file debit total. |
| 7 | Blank | 51-74 | 24 | Blank filled. |
| 8 | Record Count | 75-80 | 6 | The number of Detail records. Right justified and zero filled. |
| 9 | Blank | 81-160 | 80 | Blank filled. |