Line Item Fields

The line item fields include data related to the specific lines and charges that appear on a customer's bill.

Field Description

bill_id

The primary utility identifier of a bill. This is used to disambiguate bills.

Type: VARCHAR(40)

Can Be Empty?: No. Primary Key.

Note: This field is not required if you are sending your billing data in a single file to Oracle Utilities. See Billing Data File Specifications for more information.

bill_segment_id

The unique identifier of the bill segment in the source system.

Type: VARCHAR(40)

Can Be Empty?: No. Primary Key.

Note: This field is not required if you are sending your billing data in a single file to Oracle Utilities. See Billing Data File Specifications for more information.

calculation_header_sequence_number

The identifier for the calculation header within the bill segment. This identifier will typically be 1 unless multiple versions of the rate were in effect during the bill period.

Type: VARCHAR(40)

Can Be Empty?: No. Primary Key.

bill_line_sequence

A system-assigned unique identifier of the bill line item.

Type: VARCHAR(40)

Can Be Empty?: No. Primary Key.

calculated_amount

The calculated amount associated with the bill line item.

Type: DECIMAL(15,2). See Supported Decimal Formats for details.

Can Be Empty?: No.

description_on_bill

The information about the bill line that appears on the customer's bill.

Type: VARCHAR(255)

Can Be Empty?: No.

print

A flag that indicates whether information about this line will print on the customer's bill.

Allowed Values:

  • Y

    Display information on the customer's bill.

  • N

    Do not display information on the customer's bill.

Type: BOOLEAN. See Supported Boolean Formats for more information.

Can Be Empty?: Yes. When empty, this defaults to N.

bill_line_item_type

The category of the line item charge, such as a tax, fee, distribution charge, transmission charge, etc. The categories are defined by the utility. Oracle Utilities Opower will map them to internal categories.

Type: VARCHAR(30)

Can Be Empty?: Yes, but preferred to not be empty.

bill_line_item_unit_of_measure

The unit of measure (UOM) of the line item. There is also a UOM at the segment read for cases when a measured quantity is different than billed quantity.

For example, gas prices are expressed in an amount per therm, but gas meters are expressed in volume.

Type: VARCHAR(30)

Can Be Empty?: Yes.

bill_line_item_time_of_use

The time-of-use code of the service quantity priced on the calculation line. There will be one bill line item per TOU period.

Type: VARCHAR(40)

Can Be Empty?: Yes.

bill_line_item_service_quantity_identifier

The service quantity priced on the calculation line. This value is used to further distinguish between measured quantities that have identical UOM/TOU combinations. For example, this value could distinguish between On-Peak KWH generation and On-Peak KWH consumption for solar customers.

Type: VARCHAR(255)

Can Be Empty?: Yes.

billable_service_quantity

The service quantity priced on the calculation line. For example, On-Peak KWH is 159 kWh.

Type: DECIMAL(18,6). See Supported Decimal Formats for details.

Can Be Empty?: Yes.

base_amount

A value used by calculation lines (such as taxes) that are dependent on other values (such as volumetric charges). The Base Amount shows the total amount derived from the cross-referenced line(s) that the current line then used to calculate its billed amount.

Type: DECIMAL(15,2). See Supported Decimal Formats for details.

Can Be Empty?: Yes.

exempt_amount

The amount of the calculated charge that the customer doesn't have to pay because they are tax exempt.

Type: DECIMAL(15,2). See Supported Decimal Formats for details.

Can Be Empty?: Yes.

measures_peak_quantity

A flag that indicates if the UOM priced on the calculation line is used to measure a peak quantity.

Allowed Values:

  • Y

    Line measures peak quantity.

  • N

    (Default) Line does not measure peak quantity.

Type: BOOLEAN. See Supported Boolean Formats for more information.

Can Be Empty?: Yes.

bill_line_item_updated_at

The date at which the record was updated in the source system. If left blank, the field does not store any data.

Type: DATETIME. See Date and Time Handling for details.

Can Be Empty?: Yes.

Back to Top