Utility Bill
Entity
Name: Utility Bill
A statement that itemizes the amount of commodity used, the price for that usage, and the additional fees associated with that usage. These are typically provided monthly.
Details
- Industry Domain:
Customer - Relational Table Name:
UTILITY_BILL - JSON View Name:
UTILITY_BILL#JSON - Ontology Class:
ewok:UtilityBilling.UtilityBill
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 | Yes | Must match regex pattern: ^\S{1,}$ |
ewok:UtilityBilling.UtilityBill |
| utility account id | string | VARCHAR2 | UTILITY_ACCOUNT_ID |
Yes | Must match regex pattern: ^\S{1,}$ |
ewok:UtilityBilling.UtilityAccount | |
| bill date | date | DATE | BILL_DATE |
ewok:UtilityBilling.UtilityBill | |||
| due date | date | DATE | DUE_DATE |
ewok:UtilityBilling.UtilityBill | |||
| currency | string | VARCHAR2 | CURRENCY |
Must match values in enumerated list from graph | uom:Currency | ||
| account current balance amount | double | NUMBER | ACCOUNT_CURRENT_BALANCE_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| account payoff balance amount | double | NUMBER | ACCOUNT_PAYOFF_BALANCE_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| account previous period balance amount | double | NUMBER | ACCOUNT_PREVIOUS_PERIOD_BALANCE_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| total payments amount | double | NUMBER | TOTAL_PAYMENTS_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| total adjustments amount | double | NUMBER | TOTAL_ADJUSTMENTS_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| total bill corrections amount | double | NUMBER | TOTAL_BILL_CORRECTIONS_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| total current charges amount | double | NUMBER | TOTAL_CURRENT_CHARGES_AMOUNT |
ewok:UtilityBilling.UtilityBill | |||
| total balance current period amount | double | NUMBER | TOTAL_BALANCE_CURRENT_PERIOD_AMOUNT |
ewok:UtilityBilling.UtilityBill |