The Billing Read Export Specification describes the columns and rows contained in the billing read output of AquaCUE. When Billing Reads are exported using the Actions drop-down menu on the Monitor page, a CSV-format spreadsheet file is created. These Billing Read Export files always include the Account IDs, Location IDs, Service Point IDs, Meter IDs, Endpoint IDs and tamper codes along with read data and the read times for up to 100,000 meters per export. Use filters to select registers to include in a Data Export. If more than 100,000 registers are selected, only the first 100,000 records will be exported.
When using the AquaCUE Data Export Service API to make Billing Read calls, use Cycle, Route and District filters to schedule exports of up to 100,000 records.
The following table describes the Billing Read Export file contents:
|Column Name||Max Length||Format||Description|
|Account_ID||32||Text||Identifier of the Account used for billing purposes.|
|Location_ID||40||Text||Unique identifier for the location where the service is being provided|
|Service_Point_ID||40||Text||An identifier used to distinguish between multiple service hookups at the same Location. The combination of Location ID and Service Point ID represents a single point to which a meter is to be attached.|
|Meter_ID||24||Text||Identifier of the meter. It must be unique and is required.|
|Register_Number||1||Text, L, 0, H, 2, or Blank||Register Number is used to identify if a meter is a single or compound meter.|
|Endpoint_SN||20||Text||Serial number of the endpoint paired with the specified meter|
|Read_Method||7||Text||Text indicating how the meter reading was obtained, either AMR, Fixed, Manual, Network or n/a.|
|Current_Read||9||Number||The current meter reading available within the time period requested when the file was submitted to BEACON.|
|Current_Read_Units||8||Text||Units used for the Current_Read. This value is set using pulldown menus on Assets>Facility Settings>Billing Units. One of: GAL, CUBIC_FEET, CF, CCF, KGAL, CUBIC_METER, LITER, IMP, AF, OIL_BARREL, FLUID_BARREL.|
|Current_Read_Time||22||YYYY-MM-DD hh:mm:ss||Date and time of the current read. (2014-09-10 10:39:41)|
|Tamper_Code||7||Text||A code that represents an endpoint condition such as potential leak (L), no usage (U), reverse flow (R), or cut wire (T).|
Billing Read Export Mapping
Use this table to create a spreadsheet to map Billing Read Export fields to corresponding fields in your billing or Customer Information System (CIS). If a given AquaCUE field cannot be mapped, mark it as N/A and include the reasons in this spreadsheet.
|Bill Read Fill Description||Customer CIS Field Name||Customer CIS Field Description|
|Last Update||What Changed||What You Need to Do|
|June 3, 2019||Updated the Current_Read_Unit field to include the following units of measure: GAL, CUBIC_FEET, CF, CCF, KGAL, CUBIC_METER, LITER, IMP, AF, OIL_BARREL, FLUID_BARREL.||No action required.|
|April 10, 2018||Updated the Read_Method field to reflect current export file content.||If desired, revise column names and incorporate the Read_Method in your interface.|
|February 29, 2016||First Post||Map Billing Export Read fields to fields in your CIS database.|