CPA EFT Output Format
The Header and Trailer records are the outer "envelope" of the transaction. The Detail records act as an inner envelope combining similar entries.
Each record ends with a carriage control (line break) character.
Header Record
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Originator's ID | 11-20 | 10 | Alphanumeric | bank_hdr_bank_file_fmt_mst.ach_origin_id
This is the number assigned by the bank for EFT accounts. |
| File Creation No. | 21-24 | 4 | Numeric | bank_file_fmt_mst.last_file
The file creation number must increment by one from one file to the next. |
| Creation Date | 25-30 | 6 | Numeric | GETCurrentDate(CYYDDD)
C=0 YY=10 for 2010 DDD=Year Day |
| Destination Data Centre | 31-35 | 5 | Numeric | bank_hdr_bank_file_fmt_mst.ach_dest_id
This is the bank's institution ID. |
| Reserved Customer-Direct Clearer Communication area | 36-55 | 20 | Alphanumeric | Blank |
| Currency Code Identifier | 56-58 | 3 | Alphanumeric | vendor_mst.curr_code |
| Filler | 59-1464 | 1406 | Alphanumeric | Blank |
Detail Record
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Logical Record Type ID | 1 | 1 | Alpha | C = Credit Payment
D = Debit Payment |
| Logical Record Count | 2 | 9 | Numeric | Count()
Increment by 1 from field 02 in the Header record |
| Origination Control Data | 11 | 10 | Alphanumeric | bank_hdr_bank_file_fmt_mst.ach_origin_id
This is the number assigned by the bank for EFT accounts. |
| File Create Number | 21 | 4 | Numeric | bank_file_fmt_mst.last_file
Must be the same as the field in the Header record |
| CPA Code | 25 | 3 | Numeric | 450
CPA transaction code |
| Amount | 28 | 10 | Numeric | appmt_mst.for_check_amt
Amount of EFT transaction, format $$$$$$$$cc No commas or decimal points. Right justified |
| Due Date Centry | 38 | 1 | >Numeric | 0 (no change in turn of century) |
| Due Date Year | 39 | >2 | >Numeric | GetYear() |
| Due Date Day | 41 | 3 | Numeric | GetDay() |
| Financial Institution Number | 44 | 4 | Numeric | vendor_mst.EFT_bank_num
Institution ID |
| Financial Institution Branch Number | 48 | 5 | Numeric | vendor_mst.transit
Branch or transit number. |
| Account Number | 53 | 12 | Alphanumeric | vendor_mst.account
Field must be left justified, do not zero fill. Enter significant digits only |
| Item Trace Number | 65 | 22 | Numeric | 0000000000000000000000 |
| Stored Trans Type | 87 | 3 | Numeric | 000 |
| Short Name | 90 | 15 | Alphanumeric | bank_hdr_bank_file_fmt_mst.user_name
Your company's name for participant's statements. This appears on most bank statements. Do not enter zeros in the field. |
| Transaction Payee/ Payor name | 105 | 30 | Alphanumeric | Name OR VadRName = vendaddr_mst.name
Vendor or Remit To Vendor Name |
| Name | 135 | 30 | Alphanumeric | |
| Eft Originator ID | 165 | 10 | Alphanumeric | Blank |
| Transaction Origination Xref | 175 | 19 | Alphanumeric | appmt_mst.vend_num + "-" + appmt_mst.check_num
Optional reference field |
| Transaction Return Financial Institution | 194 | 9 | Numeric | The element is formatted as
(a) (b) (c) 9 999 99999 where (a) = constant zero (b) = bank number (bank_addr_mst.bank_number) (c) = branch or transit number (bank_addr_mst.branch_code) If Use Default Account is not selected on the Bank Code Bank File Format form, this value contains bank_addr_mst.bank_number + bank_addr_mst.branch_code. If Use Default Account is selected, this value contains all zeros. |
| Transaction return Account | 203 | 22 | Alphanumeric | bank_hdr_mst.bank_acct_no
If Use Default Account is not selected on the Accounts Payable Parameters form, this field is required; if not then leave blank |
| Originator's Sundry Info | 215 | 15 | Alphanumeric | Blank |
| Stored Trace Number | 230 | 22 | Alphanumeric | Blank |
| Settlement Code | 252 | 2 | Alphanumeric | Blank |
| Invalid Data Element | 254 | 11 | Numeric | 00000000000 |
Trailer Record
| Field Description | Position | Length | Format | Field or Notes |
|---|---|---|---|---|
| Record Type | 1 | 1 | Alpha | Z |
| Record Sequence/Count | 2 | 9 | Numeric | Count()
Increment by 1 from previous record sequence number |
| EFT Originator | 11 | 10 | Numeric | bank_hdr_bank_file_fmt_mst.ach_origin_id
Must be the same as in the Header record |
| File Create Number | 21 | 4 | Numeric | bank_file_fmt_mst.last_file
Must be the same as in the Header record. |
| Value of debits | 25 | 14 | Numeric | 00000000000000
Amount of debit payment transactions (type D). Right-justify with leading zeros. Format $$$$$$$$$$$$cc |
| Number of debits | 39 | 8 | Numeric | 00000000
Total number of debit payment transactions (Type D). Right-justify with leading zeros. |
| Value of credits | 47 | 14 | Numeric | Sum()
Amount of credit payment transactions (Type C). Righ- justify with leading zeros. Format $$$$$$$$$$$$cc |
| Number of credits | 61 | 8 | Numeric | Sum()
Total number of debit payment transactions (Type C). Right-justify with leading zeros. |
| Total Value of Error Corrections 'E' | 69 | 14 | Numeric | 0 |
| Total Number of Error Corrections "E" | 83 | 8 | Numeric | 0 |
| Total Value of Error Corrections "F" | 91 | 14 | Numeric | 0 |
| Total Number of Error Corrections "F" | 105 | 8 | Numeric | 0 |