Utility Bill Service Usage
Entity
Name: Utility Bill Service Usage
The utility bill service usage identifies the usage amounts for the commodities being billed for the utility bill and all the utility bill service periods.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_BILL_SERVICE_USAGE - JSON View Name:
UTILITY_BILL_SERVICE_USAGE#JSON - Ontology Class:
ewok:UtilityBilling.ServiceUsage
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 |
| commodity measurement type | string | VARCHAR2 | COMMODITY_MEASUREMENT_TYPE |
Yes | Must match values in enumerated list from graph | ewok:CommodityMeasurementType | |
| unit of measure | string | VARCHAR2 | UNIT_OF_MEASURE |
Yes | Must match values in enumerated list from graph | uom:UnitOfMeasure | |
| time of use | string | VARCHAR2 | TIME_OF_USE |
Yes | Must match values in enumerated list from graph | ewok:TimeOfUseType | |
| bill calculation extension | string | VARCHAR2 | BILL_CALCULATION_EXTENSION |
Yes | ewok:BillingCalculationType | ||
| start date time | dateTime | DATE | START_DATE_TIME |
ewok:UtilityBilling.ServiceUsage | |||
| end date time | dateTime | DATE | END_DATE_TIME |
ewok:UtilityBilling.ServiceUsage | |||
| usage amount | double | NUMBER | USAGE_AMOUNT |
ewok:UtilityBilling.ServiceUsage |