SmartFusion Modules > Utility Billing > Bill Run Wizard > Delinquent Report/Late Charges > UB Delinquent Notice Export for Arista (based on the Arista UB Bill with OCR Scanline Format)

6.137 - Updated Prior Reading, Current Reading and Usage from 9 digits to 15 digits

6.132 - Added the late charge and current balance amount minus the late charge to the end of the master record. Changed the billing date field to use the "Notice Date" under the Delinquent Notices section of the Delinquent Report/Late Charges screen.

6.131 - Added OCRScan line information to the export.

6.129 - Added new standard delinquent notice export based on UB Arista bill export for Davie County.

**Unlike other Arista formats, this custom format does not have header records. It is not necessary for this client. This is used to print their cut-off notices which are printed after they have applied their late charges.

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

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 - will use the "Notice Date" under the Delinquent Notices section of the Delinquent Report/Late Charges screen
11 Due Date 10 221-230 MM/DD/YYYY - Payment Due Date entered by the user
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 Charges from current bill run
15 Past Due Amount 12 263-274 Zero-Filled, Decimal Implied Will be the same as the Actual Balance amount
16 Customer Type 6 275-280 Master Code
17 Due After 12 281-292 This field contains the Actual balance + Disconnect fee ( from UB system file)
18 Note 1 70 293-362 Route Number + '-' + Route Sequence
19 Note 2 70 363-432
20 Bank Draft 15 433-447
Message
21 Number of Days of Usage 3 448-450
22 Previous Balance 12 451-462 Zero-Filled, Decimal Implied
Balance before current billing
23 Actual Balance 12 463-474 Zero-Filled, Decimal Implied
24 Contract Amount 12 475-486 Printing zeros- not being passed
25 Budget Billing Amount 12 487-498 Printing zeros- not being passed
26 Cutoff Date 10 499-508 MM/DD/YYYY - User entered
27 OCR Scanline 56 509-564 District 2 digits default 00
Type 2 is selected Account Number 9 digits
Amount due 9 digits current balance on the account
Amount due plus Disconnect Fee On UB System File 9 digits
Bank Code 4 digits Bank Code in ProcessState table for the particular bill run
Check Digit 1 digit
27 OCR Scanline 56 509-564 Bank Code 5 digits Bank Code in ProcessState table for the particular bill run
Type 2 is NOT selected Account Number 8 digits
Amount due 9 digits current balance on the account
Amount due plus Disconnect Fee On UB System File 9 digits Applicable only if 'IncludeDisconnectFeeOnOCR' is set in ConfigurationItem table
Route Number 7 digits
Route Sequence 7 digits
Check Digit 1 digit
29 Cutoff Amount 12 565-576 Zero-filled, Decimal implied
30 Late charge Amount 12 577-588 Decimal implied
31 Current balance minus late charge Amount 12 589-600 Decimal implied The late fee is subtracted if it has already been applied (if the DateCompletedDelinquentReportLateCharges in the ProcessState table has a value) , otherwise it will be the same as the Amount Due)

Customer Detail Record

Field No Description Length Positions Comments
27 Record Code 1 1-1 “D”
28 Transaction Code 6 2-7
29 Transaction Desc 25 8-32
30 Transaction Date 10 33-42 MM/DD/YYYY
31 Prior Reading 15 43-57 Zero-Filled, No Decimal
32 Current Reading 15 58-72 Zero-Filled, No Decimal
33 Usage 15 73-87 Zero-Filled, No Decimal
34 Amount 12 88-99 Zero-Filled, Decimal Implied
35 Meter Serial Number 10 100-109
36 Prior Usage 1 9 110-118 Usage from one month ago. Not being used
37 Prior Usage 2 9 119-127 Usage from two months ago. Not being used
38 Prior Usage 3 9 128-136 Usage from three months ago.Not being used
39 Prior Usage 4 9 137-145 Usage from four months ago.Not being used
40 Prior Usage 5 9 146-154 Usage from five months ago. Not being used
41 Prior Usage 6 9 155-163 Usage from six months ago. Not being used
42 Prior Usage 7 9 164-172 Usage from seven months ago. Not being used
43 Prior Usage 8 9 173-181 Usage from eight months ago.Not being used
44 Prior Usage 9 9 182-190 Usage from nine months ago. Not being used
45 Prior Usage 10 9 191-199 Usage from ten months ago. Not being used
46 Prior Usage 11 9 200-208 Usage from eleven months ago.Not being used
47 Prior Usage 12 9 209-217 Usage from twelve months ago.Not being used
48 Reading Date From 10 218-227 MM/DD/YYYY
49 Reading Date To 10 228-237 MM/DD/YYYY
50 Filler 205 238-442 Space filled