| DESCRIPTION OF RECORD FORMATS - CPA 005 1464-BYTE EFT FILE | |||||
| Character Position | Field Size | Format | Field Name | Data Requirements | |
| HEADER RECORD | |||||
| 01 | 01-01 | 1 | AN | Record Type | A |
| 02 | 02-10 | 9 | N | Record Count | 000000001 |
| 03 | 11-20 | 10 | AN | Client Number | 10-digit client number |
| 04 | 21-24 | 4 | AN | File Creation Number | 4-digit number (numeric) to identify this file |
| 05 | 25-30 | 6 | N | File Creation Date | Format 0YYDDD |
| 06 | 31-35 | 5 | N | Processing Center | The centre where the file will be processed (5-digit Institution ID) |
| 07 | 36-55 | 20 | AN | Reserved | Leave blank |
| 08 | 56-58 | 3 | AN | Destination Currency Code ID | "USD" or "CAD" - if blank, defaults to the currency of service |
| 09 | 59-1464 | 1406 | AN | Filler | Leave blank |
| BASIC PAYMENT RECORD | |||||
| 01 | 01-01 | 1 | AN | Record Type | C |
| 02 | 02-10 | 9 | N | Record Count | Increment by 1 |
| 03 | 11-20 | 10 | AN | Client Number | 10-digit client number |
| 04 | 21-24 | 4 | AN | File Creation Number | Number to identify this file |
| SEGMENT ONE | |||||
| 05 | 25-27 | 3 | AN | Transaction Code | 3-digit transaction code as defined by the CPA |
| 06 | 28-37 | 10 | N | Amount | Payment amount format (implied decimal) |
| 07 | 38-43 | 6 | N | Payment Date | Format 0YYDDD - cannot be more than 30 days in the past or 173 in the future |
| 08 | 44-52 | 9 | N | CAD Financial Institution and Branch Transit # | 0999 Bank Number plus 99999 Branch Transit |
| 09 | 53-64 | 12 | AN | Account Number | Enter all significant digits |
| 10 | 65-86 | 22 | N | Reserved | Zero fill |
| 11 | 87-89 | 3 | N | Reserved | Zero fill |
| 12 | 90-104 | 15 | AN | Client Short Name | One word, all CAPS. Will appear on customer statements. (No zeros) |
| 13 | 105-134 | 30 | AN | Customer Name | All CAPS. If missing, payment will reject. |
| 14 | 135-164 | 30 | AN | Client Name | All CAPS. Client Long name. |
| 15 | 165-174 | 10 | AN | Client Number | 10-digit EFT account number assigned by bank |
| 16 | 175-193 | 19 | AN | Customer Number | Client-assigned ID number (some banks require). |
| 17 | 194-202 | 9 | N | Reserved | Zero fill |
| 18 | 203-214 | 12 | AN | Reserved | Blank |
| 19 | 215-229 | 15 | AN | Client Sundry Information | Optional to client; electronic message printed on some customer bank stmts |
| 20 | 230-251 | 22 | AN | Reserved | Blank |
| 21 | 252-253 | 2 | AN | Reserved | Blank |
| 22 | 254-264 | 11 | AN | Reserved | Blank |
| TRAILER RECORD | |||||
| 01 | 01-01 | 1 | AN | Record Type | Z |
| 02 | 02-10 | 9 | N | Record Count | Increment by 1 |
| 03 | 11-20 | 10 | AN | Client Number | Must be the same as the Header |
| 04 | 21-24 | 4 | AN | File Creation Number | Number to identify this file. Must be different (or higher) from previous numbers. |
| 05 | 25-38 | 14 | N | Reserved | Zero fill |
| 06 | 39-46 | 8 | N | Reserved | Zero fill |
| 07 | 47-60 | 14 | N | Total Amount of Transactions | Total amount of record type C transactions. Right justify with leading zeros. Format with implied decimal. |
| 08 | 61-68 | 8 | N | Total Number of Transactions | Number of record type C transactions |
| 09 | 69-1464 | 1396 | N | Filler | Zero fill |
