...
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. |
...
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)
...
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'H1 ' |
| Account Number | AlphaNumeric | 10 | 4 | 13 | '4759606858*6858' for SBS 'TBD*4741' for Aperek Call KFS help desk for full bank account# |
| 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 |
...
| 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 'TBD057' - Clear code '007' - Void 'TBDSTL' - Stale code 'STP' - Stop Payment |
| 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 blankFill this in for Cleared checks (i.e. 057), leave blank otherwise. |
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 |
...