Cheque Import File Specification

The cheque import file contains the fields below. Each field has a required length and format specification.

Field #	Field Name	Format	Length	Comments
1	Account Number (mandatory field)	Numeric	12	- Account number on which the cheques are drawn. - Edited to available list of accounts. - Multiple accounts can be submitted on a single file.
2	Cheque Serial Number (mandatory field)	Numeric	Up to 9	- Edited to ensure no duplicates within the input file itself or the local issued file database.
3	Cheque Amount (mandatory field)	Numeric	15	- Dollar amount of cheque can range from .01 – 999,999,999.99 - Cents may be omitted unless required.
4	Cheque Issue Date (optional field)	Numeric	8	- This field must be YYYYMMDD format. - Issued date is to be assigned to cheque, otherwise the default is current date. - Edited for stale dates (> 6months old).
5	Payee Name (optional field)	Alpha-Numeric	30	- Commas must not be entered as part of Payee Name.

Sample Import File (sample.txt)

"018000091618","00051314","300.46","19970920","Example Cheque #1"

"018000091618","00051315","390.46","19970920","Example Cheque #2"

"018000091618","00091413","23.00","19970920","Example Cheque #3"

"018000091618","00900119","41.45","19970920","Example Cheque #4"

"018000091618","00900117","145.46","19970920","Example Cheque #5"

"018000091618","00900118","120.46","19970920","Example Cheque #6"