CPA EFT Output Format
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 ( 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 |