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:UtilityBillServiceUsage
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:UtilityBill | |
| utility service summary id | string | VARCHAR2 | UTILITY_SERVICE_SUMMARY_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityBillServiceSummary |
| 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:TimeOfUse | ||
| bill calculation extension | string | VARCHAR2 | BILL_CALCULATION_EXTENSION |
ewok:BillingCalculationType | |||
| start date time | dateTime | DATE | START_DATE_TIME |
ewok:UtilityBillServiceUsage | |||
| end date time | dateTime | DATE | END_DATE_TIME |
ewok:UtilityBillServiceUsage | |||
| usage amount | double | NUMBER | USAGE_AMOUNT |
ewok:UtilityBillServiceUsage |