Line Item Fields

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.

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.