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 |
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
HEADER
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'H1 ' |
| Account Number | AlphaNumeric | 10 | 4 | 13 | '4759606858' |
| Report ID | AlphaNumeric | 3 | 14 | 16 | 'R12' |
| Print Date | Numeric | 6 | 17 | 22 | MMDDYY - Today's Date |
| Begin Date | Numeric | 6 | 23 | 28 | MMDDYY - Today's Date |
| End Date | Numeric | 6 | 29 | 34 | MMDDYY - Today's Date |
DETAIL
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'R12' |
| Check Number | AlphaNumeric | 10 | 4 | 13 | Left justified |
| Transaction | AlphaNumeric | 3 | 14 | 16 | '037' - Cancel code |
| Issue Date | Numeric | 6 | 17 | 22 | MMDDYY - Check date when check was issued |
| Check Amount | Numeric | 10 | 23 | 32 | Left Zero Filled, Decimal point implied. Ex. '0000007651' is 76.51 |
| Paid Date | Numeric | 6 | 33 | 38 | MMDDYY - Leave blank |
TRAILER
| 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
