Utility Account
Entity
Name: Utility Account
Utility Accounts represent the obligation to pay for services rendered to either a person or an organization. Each utility account can be linked to multiple persons or organizations, with ownership specified directly on the account. Utility accounts are linked to one or more commodity service agreements.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_ACCOUNT - JSON View Name:
UTILITY_ACCOUNT#JSON - Ontology Class:
ewok:UtilityBilling.UtilityAccount
Properties
| Name | General Data Type | Oracle Data Type | Relational Column | Required? | Primary Key? | Validations | Related Graph Object |
|---|---|---|---|---|---|---|---|
| utility account id | string | VARCHAR2 | UTILITY_ACCOUNT_ID |
Yes | Yes | Must match regex pattern | ewok:UtilityBilling.UtilityAccount |
| actual start date time | dateTimeStamp | TIMESTAMP | ACTUAL_START_DATE_TIME |
ewok:UtilityBilling.UtilityAccount | |||
| utility account class | string | VARCHAR2 | UTILITY_ACCOUNT_CLASS |
Must match values in enumerated list from graph | ewok:UtilityBilling.UtilityAccountClass | ||
| bill cycle | string | VARCHAR2 | BILL_CYCLE |
ewok:UtilityBilling.UtilityAccount | |||
| division | string | VARCHAR2 | DIVISION |
ewok:UtilityBilling.UtilityAccount | |||
| person id | string | VARCHAR2 | PERSON_ID |
ewok:Person | |||
| organization id | string | VARCHAR2 | ORGANIZATION_ID |
ewok:Organization |