|
Field |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
|
Data Element Name |
Account Number |
Check Issue Date |
Check Serial Number |
Check Amount |
Payee |
User Data |
Status |
|
Field Inclusion Requirement |
Required |
Required |
Required |
Required |
Optional |
Optional |
Required |
|
Contents |
Numeric |
MMDDYY |
Numeric |
$$$$$$$$.˘˘ |
Alphanumeric / Blanks Special Characters |
Alphanumeric / Blanks / Special Characters |
0 = Outstanding 1 = Paid 2 = Paid No Issue 3 = Duplicate Paid 4 = Paid Void 5= Void 6 = Deleted 7 = Stop Pay 8 = Paid Over Stop 9 = Stale 10 = Amount Mismatch 11 = Amount Max 12 = Unknown 99 = Not Found |
|
Maximum Length |
19 |
6 or 8 |
9 |
11 |
40 |
20 |
1 |
Additional file format requirements
The month portion of the check issue date must be zero padded when the month is a single character.. If using Excel to create this file, the date column must be set as text. Otherwise you will get a date as “8”” instead of “08”
Fields 5 & 6 may contain A-Z, a-z, 0-9 .)($-?@#!%&_;:~|=+' as well as empty spaces
Sample File
2222222222222222222,08082003,1001,10201,Payee Name 1,fpb3,0
2222222222222222222,08082003,1002,10202,Payee Name 2,fpb3,1
2222222222222222222,08082003,1003,10203,Payee Name 3,fpb3,2
2222222222222222222,08082003,1004,10204,Payee Name 4,fpb3,3
2222222222222222222,08082003,1005,102.05,Payee Name 5,fpb3,4
2222222222222222222,08082003,1006,102.06,Payee Name 6,fpb3,3
2222222222222222222,08082003,1007,102.07,Payee Name 7,fpb3,1
2222222222222222222,08082003,1008,102.08,Payee Name 8,fpb3,1
2222222222222222222,08082003,1009,102.09,Payee’s Name 9,fpb3,1
2222222222222222222,08082003,1010,102.10,Payee’s Name 10,fpb3,1