Utility Bill Service Summary

Entity

Name: Utility Bill Service Summary

A utility bill has one or more utility bill service summaries. For example, a customer with both electricity and gas service has two utility bill service summaries, one for each of the commodities.

Details

Table: 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: ^\S{1,}$ ewok:UtilityBilling.UtilityBill
utility service summary id string VARCHAR2 UTILITY_SERVICE_SUMMARY_ID Yes Yes Must match regex pattern: ^\S{1,}$ ewok:UtilityBilling.UtilityAccount
utility service contract id string VARCHAR2 UTILITY_SERVICE_CONTRACT_ID Yes   Must match regex pattern: ^\S{1,}$ ewok:ServiceContract.Electric
utility location id string VARCHAR2 UTILITY_LOCATION_ID       ewok:Location.Utility
start date date DATE START_DATE       ewok:UtilityBilling.ServiceSummary
end date date DATE END_DATE       ewok:UtilityBilling.ServiceSummary
usage period start date dateTime DATE USAGE_PERIOD_START_DATE       ewok:UtilityBilling.ServiceSummary
usage period end date dateTime DATE USAGE_PERIOD_END_DATE       ewok:UtilityBilling.ServiceSummary
estimated service quantities string VARCHAR2 ESTIMATED_SERVICE_QUANTITIES       ewok:UtilityBilling.ServiceSummary
service contract ending string VARCHAR2 SERVICE_CONTRACT_ENDING       ewok:UtilityBilling.ServiceSummary
utility service summary status string VARCHAR2 UTILITY_SERVICE_SUMMARY_STATUS       ewok:UtilityBilling.ServiceSummary
utility bill cycle code string VARCHAR2 UTILITY_BILL_CYCLE_CODE       ewok:UtilityBilling.ServiceSummary
total amount double NUMBER TOTAL_AMOUNT       ewok:UtilityBilling.ServiceSummary
service contract current balance amount double NUMBER SERVICE_CONTRACT_CURRENT_BALANCE_AMOUNT       ewok:UtilityBilling.ServiceSummary