DB extract report

The DB extract report (DWExtract Report) is automatically run every Sunday evening and saved to your reports folder.  This weekly report is a point-in-time report and cannot be run from Utilmate.

The report is saved as an Excel spreadsheet with five worksheet tabs.

Customer Tab

This is the first tab and contains customer-centric information for all customers. The report is ordered by Customer Status then Account Number.

Columns

•  Account Number
• Sales Cust Number
• Account Name
• Account Manager
• Addr Line 1
• Addr Line 2
• Addr Line 3
• Phone Number
• Bill Cycle
• Customer Status
• ADB Current
• ADB Overdue
• Credit Status
• Treatment Type
• Concession Card Type
• Concession Card Number
• Concession Card Code
• Concession Card Start Date
• Concession Card End Date
• Customer Type
• Customer Sub Type
• Invoice Delivery Method
• Letter Delivery Method
• Payment Method
• ABN Number

Account Tab

This is the second tab and contains account information for all customers. The report is ordered by Customer Status then Account Number.

Columns

• Account Number
• Sales Cust Number
• Account Name
• Site Identifier
• Property Name
• Unit Number
• Unit Type
• Street Number
• Street Name
• Street Type
• Suburb
• State
• Postcode
• Site Type
• Date Connected
• Account Status
• Account Status Date
• Date Terminated
• Closed Reason
• Offering Description
• Offering Start Date
• Price Plan
• Price Plan Start Date
• Metering Class
• Multisite Account
• Site Status
• Life Support Verified
• Classification Code

Meter Tab

This is the third tab and contains meter information for all Site Identifiers.

Columns

• Site identifier
• Meter serial
• Meter code
• Meter register
• Meter type
• Meter status
• Last actual read date
• Multiplier
• Est daily consmp (Estimated Daily Consumption)
• Meter Notes

InvTrans

This is the fourth tab and contains information on the last invoiced usage for customers.

Columns

• Account number
• Site identifier
• Transaction date
• Trans description
• Unit quantity
• Unit rate
• Multiplier
• Net amount
• Tax amount
• Gross amount
• Start date
• Start read
• End date
• End read

ArTrans

This is the fifth tab and contains information on all invoices, adjustments and receipts for customers.

Columns

• Account number
• Type
• Reference
• Amount
• Posted date
• Allocated