Introduction
This page is based on the Check Cancellation File Functional Specifications located at P:\SystemDev\KUALI Project\A-2 Functional Spec Documents\_Feeder Systems\SBS PDP Upload - Business Process.doc
Revision History
Version | Date | Author | Description |
1.0 | 01/21/16
| Modesto Sevilla | Initial specification |
| 2.0 | 04/27/17 | Modesto Sevilla | Modified to be utilized by Aperek and besides cancellation, use it for stale dating and clearing. |
Functional Description
The Check Cancellation File process enables the external systems to cancel an existing disbursed paper check. The file format is based on the Check Reconciliation file format currently used by Wells Fargo Bank.
Requirements
- The check cancellation file process will need to provide:
- Check Number
- Payee ID
- Check Amount
- Use a flat file format (Check Reconciliation format).
- Naming convention for the file is kfschkcancel_[XFER Account]_[YYYYMMDDHHMMSSS].data Ex. kfschkcancel_kfssb_201601211622212.data
- File must be uploaded to XFER (SFTP server)
Uploading Payment Batch Files Through Secure FTP
Instructions are found on the page KFS SFTP Instructions To Upload and Download Files.
Flat file layout for the check reconciliation file (80 characters long)
- Composed of three record types
- Header Record
- Detail Record
- Trailer Record
...
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'T1 ' |
| Credit Count | Numeric | 6 | 4 | 9 | '000000' |
| Credit Amount | Numeric | 11 | 10 | 20 | '00000000000' |
| Debit Count | Numeric | 6 | 21 | 26 | Left Zero Filled. The total number of Detail transactions Ex. '000311' |
| Debit Amount | Numeric | 11 | 27 | 37 | Left Zero Filled, Decimal point implied. The summation of the check amounts in the Detail transactions Ex. '0000007651' is 76.51 |
Sample File
