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

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.UtilityAccount
utility service contract id string VARCHAR2 UTILITY_SERVICE_CONTRACT_ID Yes   Must match regex pattern 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