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

Recent Changes:
6.223 - Current and prior readings export has been changed to be out differently depending on the Divide readings by multiplier (Arista Type 2) setting.

6.222 - Initial Wiki implementation

File Header Record 1

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H1”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 2

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H2”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 3

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H3”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 4

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H4”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 5

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H5”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 6

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H6”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 7

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H7”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 8

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H8”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 9

Field No Description Length Positions Comments
1 Record Code 2 1-2 “H9”
2 Message Line 1 55 3-57 hard-coded in the report
3 Blanks 441 58-498

File Header Record 10

Field No Description Length Positions Comments
1 Record Code 3 1-3 “H10”
2 Message Line 1 55 4-58 hard-coded in the report
3 Blanks 441 59-499

File Header Record 11

Field No Description Length Positions Comments
1 Record Code 3 1-3 “H11”
2 Message Line 1 55 4-58 hard-coded in the report
3 Blanks 441 59-499

File Header Record 12

Field No Description Length Positions Comments
1 Record Code 3 1-3 “H12”
2 Message Line 1 55 4-58 hard-coded in the report
3 Blanks 44 59-499

File Header Record 13

Field No Description Length Positions Comments
1 Record Code 3 1-3 “H13”
2 Message Line 1 55 4-58 hard-coded in the report
3 Blanks 441 59-499

Customer Master Record

Field No Description Length Positions Comments
1 Record Code 1 1-1 “M”
2 Account Number 11 2-12
3 Customer Name 50 13-62
4 Address 40 63-102
5 Address2 40 103-142
6 City 20 143-162
7 State 2 163-164
8 Zip Code 10 165-174
9 Service Address 36 175-210
10 Bill Date 10 211-220 MM/DD/YYYY
11 Due Date 10 221-230 MM/DD/YYYY
12 Service Begin Date 10 231-240 MM/DD/YYYY
13 Service End Date 10 241-250 MM/DD/YYYY
14 Current Charges 12 251-262 Zero-Filled, Decimal Implied
15 Past Due Amount 12 263-274 Zero-Filled, Decimal Implied **This
field contains the customers previous
balance less payments received since
that billing.
16 Customer Type 6 275-280
17 Due After 12 281-292 **This field contains the total amount
due for the customer plus the penalty.
It should match the “Past Due Amount”
on the Billing Journal.
18 Note 1 70 293-362
19 Note 2 70 363-432
20 Bank Draft Message 15 433-447
21 Number of Days of Usage 3 448-450 Zero-Filled, 000 if nothing
22 Previous Balance 12 451-462 Zero-Filled, Decimal Implied **This
field contains the customers previous
balance before any current payments
were applied.
23 Actual Balance 12 463-474 Zero-Filled, Decimal Implied **This
field contains the Actual Amount, or the
difference between the billed Contract
Amounts and the Budget Billing Amounts.
24 Contract Amount 12 475-486 Zero-Filled, Decimal Implied **This
field contains the amount from the
Contract Amount field (E/e Customer
Master > Location > Billing Options)
25 Budget Billing Balance 12 487-498 Zero-Filled, Decimal Implied **This
field contains the BBO Balance or Settle
up amount, or the how much the bill would
without Budget Billing
26 Cutoff Date 10 499-508 MM/DD/YYYY
27 Prior Month Usage 9 509-517 Zeroes (not passed)
28 Same Period Prior Year Usage 9 518-526 Zeroes (not passed)
29 Extra Space 1 527-527
30 PIN for EGov website signin 4 528-531

Customer Detail Record

Field No Description Length Positions Comments
31 Record Code 1 1-1 “D”
32 Transaction Code 6 2-7
33 Transaction Description 25 8-32
34 Transaction Date 10 33-42 MM/DD/YYYY
35 Prior Reading 10 43-52 If the Divide readings by multiplier (Arista Type 2) is checked, the readings will be unmultiplied, if not checked, the readings will be presented normally, Zero-Filled, No Decimal
36 Current Reading 10 53-62 If the Divide readings by multiplier (Arista Type 2) is checked, the readings will be unmultiplied, if not checked, the readings will be presented normally, Zero-Filled, No Decimal
37 Usage 9 63-71 Zero-Filled, No Decimal
38 Amount 12 72-83 Zero-Filled, Decimal Implied
39 Meter Serial Number 10 84-93
40 Service Code 6 94-99
41 Multiplier 10 100-109
42 Blanks 110-462 Filler

Note: For each customer there will be one master record and one or more detail records