Utility Bill Service Line Item
Entity
Name: Utility Bill Service Line Item
A single line from a bill consisting of a quantity, price, and description.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_BILL_SERVICE_LINE_ITEM - JSON View Name:
UTILITY_BILL_SERVICE_LINE_ITEM#JSON - Ontology Class:
ewok:UtilityBilling.ServiceLineItem
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility bill id | string | VARCHAR2 | UTILITY_BILL_ID |
Yes | Must match regex pattern | ewok:UtilityBilling.UtilityBill | |
| utility service summary id | string | VARCHAR2 | UTILITY_SERVICE_SUMMARY_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityBilling.ServiceSummary |
| utility service period id | string | VARCHAR2 | UTILITY_SERVICE_PERIOD_ID |
Yes | Yes | ewok:UtilityBilling.ServicePeriod | |
| utility bill service line sequence | double | NUMBER | UTILITY_BILL_SERVICE_LINE_SEQUENCE |
Yes | Yes | ewok:UtilityBilling.ServiceLineItem | |
| calculated amount | double | NUMBER | CALCULATED_AMOUNT |
ewok:UtilityBilling.ServiceLineItem | |||
| description on bill | string | VARCHAR2 | DESCRIPTION_ON_BILL |
ewok:UtilityBilling.ServiceLineItem | |||
| print line | string | VARCHAR2 | PRINT_LINE |
ewok:UtilityBilling.ServiceLineItem | |||
| utility bill line type | string | VARCHAR2 | UTILITY_BILL_LINE_TYPE |
ewok:UtilityBilling.ServiceLineItem | |||
| commodity measurement type | string | VARCHAR2 | COMMODITY_MEASUREMENT_TYPE |
Must match values in enumerated list from graph | ewok:CommodityMeasurementType | ||
| unit of measure | string | VARCHAR2 | UNIT_OF_MEASURE |
Must match values in enumerated list from graph | uom:UnitOfMeasure | ||
| time of use | string | VARCHAR2 | TIME_OF_USE |
Must match values in enumerated list from graph | ewok:TimeOfUseType | ||
| bill calculation extension | string | VARCHAR2 | BILL_CALCULATION_EXTENSION |
ewok:BillingCalculationType | |||
| usage amount | double | NUMBER | USAGE_AMOUNT |
ewok:UtilityBilling.ServiceLineItem | |||
| calculation basis amount | double | NUMBER | CALCULATION_BASIS_AMOUNT |
ewok:UtilityBilling.ServiceLineItem | |||
| exempt amount | double | NUMBER | EXEMPT_AMOUNT |
ewok:UtilityBilling.ServiceLineItem | |||
| measures peak quantity | string | VARCHAR2 | MEASURES_PEAK_QUANTITY |
ewok:UtilityBilling.ServiceLineItem | |||
| currency | string | VARCHAR2 | CURRENCY |
Must match values in enumerated list from graph | uom:Currency |