Output File Layout

SmartFusion Modules > Utility Billing > Bill Run Wizard > Utility Bill Print 

Recent Changes:  

6.40
- Bug fix for a bug that caused certain records to not have current/previous readings and current/previous reading dates.

6.27
- Added the route suffix to the end of the file
Field Length Start End Format
Account Number 10 1 10 numeric left no padding
Tenant Code 2 11 12 blank
Customer Name 30 13 42
Service Street Name 30 43 72
Mailing Street Address 30 73 102
Mailing City 20 103 122
Mailing State 2 123 124
Mailing Zip Code 9 125 133 numeric
Meter Number 15 134 148 numeric pad left 0
Current Read Date 6 149 154 YYMMDD
Current Reading 7 155 161 numeric pad left 0
Previous Read Date 6 162 167 YYMMDD
Previous Reading 7 168 174 numeric pad left 0
Gallons (Units) Used 7 175 181 numeric pad left 0
+ or - Gallons (Units) 1 182 182 blank
Customer Type 1 183 183 I = Terminated
J = New
New (Start) Date 6 184 189 YYMMDD
Termination Date 6 190 195 YYMMDD (000000 for none)
SSN/TaxId 9 196 204 numeric
Home Phone Number 10 205 214 numeric
Work Phone Number 10 215 224 numeric
Route 9 225 233 numeric pad left 0
Sequence 10 234 243 numeric pad left 0
Suffix 10 244 253 numeric pad left 0