The Route Number and Account Number have been removed from this screen shot. Both columns will be displayed for this Import Type when a file is selected.
File Format:
|
Field Name |
Field Length |
Field Type |
Field Description |
|
household_id |
7 |
N |
From invoice scan line |
|
unit_id |
7 |
N |
From invoice scan line |
|
total_pmt_amt |
10 |
N |
From invoice scan line |
|
due_date |
8 |
Date |
From invoice scan line |
|
Route Number |
9 |
N |
From check/money order |
|
Account Number |
20 |
N |
From check/money order |
|
Check Number |
20 |
N |
From check/money order |
|
Check Amount |
10 |
N |
From check/money order |
|
Deposit Date |
8 |
Date |
mmddyyyy |
Example:
The Route Number and Account Number have been removed from this screen shot. Both columns will be displayed for this Import Type when a file is selected.
The header is required in the standard lockbox file format.
