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. |
|
A flag that indicates whether information about this line will print on the customer's bill. Allowed Values:
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:
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. |