| Name | Description | Type | Additional information |
|---|---|---|---|
| pk_CustomerAccount | integer |
None. |
|
| fk_Customer | integer |
None. |
|
| fk_Esco | integer |
None. |
|
| fk_Utility | integer |
None. |
|
| fk_Plan | integer |
None. |
|
| fk_RevenueClass | character |
None. |
|
| AccountNumber | string |
None. |
|
| ServiceAddress1 | string |
None. |
|
| ServiceAddress2 | string |
None. |
|
| ServiceCity | string |
None. |
|
| ServiceState | string |
None. |
|
| ServiceZip | string |
None. |
|
| CreatedDate | date |
None. |
|
| CreatedBy | integer |
None. |
|
| ModifiedDate | date |
None. |
|
| ModifiedBy | integer |
None. |
|
| InvoicePaid | boolean |
None. |
|
| InvoiceName | string |
None. |
|
| InvoiceDate | date |
None. |
|
| InvoiceRevenueClass | string |
None. |
|
| InvoicePayRate | decimal number |
None. |
|
| InvoicePayoutAmount | decimal number |
None. |
|
| InvoiceNote | string |
None. |
|
| AppUser | AppUser |
None. |
|
| AppUser1 | AppUser |
None. |
|
| Customer | Customer |
None. |
|
| Esco | Esco |
None. |
|
| Plan | Plan |
None. |
|
| Utility | Utility |
None. |