HousingComplexUtilityAccount
Represents utility accounts that are associated with units in a housing complex. This table supports operational and financial tracking by capturing account information that affects billing, setup, and service coordination.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) for the housing-complex utility-account record in Bullhorn CRM. This value supports cross-referencing and enables workflows that track service accounts, billing activities, and unit-level utility management. |
| Account | String | False |
Captures the utility-account number or Id that is associated with the housing complex. This value supports billing, service verification, and communication with external utility providers. |
| AddressAddress | String | False |
Captures the primary street address for the utility-account service location. This value supports routing, service verification, and address-based billing workflows. |
| AddressAddress2 | String | False |
Captures the supplemental street address line for the utility-account service location. This value supports detailed address validation and assists users during administrative and service-coordination tasks. |
| AddressCity | String | False |
Indicates the city that is associated with the utility-account address. This value supports geographic grouping, service routing, and location-based reporting. |
| AddressCountry | Int | False |
Represents the Id of the country that is associated with the utility-account address. This value supports normalization and ensures consistency with standardized geographic metadata. |
| AddresscountryCode | String | False |
Captures the standardized country code that is associated with the utility-account address. This value supports postal validation and integration workflows that rely on ISO-style country codes. |
| AddresscountryName | String | False |
Captures the country name that is associated with the utility-account address. This value provides human-readable geographic information that is used during review and verification. |
| AddressState | String | False |
Indicates the state or provincial region that is associated with the utility-account address. This value supports region-level routing and contributes to service and billing accuracy. |
| AddressZip | String | False |
Captures the ZIP code that is associated with the utility-account address. This value supports routing precision, address validation, and region-based reporting. |
| BillingContact | Int | False |
Represents the Id of the billing contact that is associated with the utility account. This value supports financial workflows and ensures that billing communication is delivered to the appropriate individual. |
| Comments | String | False |
Captures comments or narrative notes that are associated with the utility account. This information provides administrative context and supports troubleshooting, documentation, and service-history review. |
| DateAdded | Datetime | False |
Indicates the date and time when the utility-account record is created in Bullhorn CRM. This value supports historical tracking and enables audit and lifecycle-reporting workflows. |
| DateConnected | Datetime | False |
Indicates the date when utility service is connected for the associated unit or complex. This value supports service-timeline tracking and helps coordinate move-in and account-activation activities. |
| DateDisconnected | Datetime | False |
Indicates the date when utility service is disconnected. This value supports timeline analysis, billing reconciliation, and move-out coordination for the affected unit or complex. |
| Deposit | String | False |
Captures the deposit amount that is associated with the utility account. This value supports financial tracking, onboarding workflows, and reconciliation of utility-related charges. |
| Fax | String | False |
Captures the fax number that is associated with the utility provider or service contact. This value supports communication workflows for organizations that maintain fax-based processes. |
| MigrateGUID | String | False |
Captures the globally unique migration Id that is associated with data-import workflows. This value supports reconciliation tasks that validate the accurate transfer of utility-account records between systems. |
| Name | String | False |
Captures the name or descriptive label for the utility account. This value supports search operations, identification, and record selection during administrative review. |
| Phone | String | False |
Captures the primary phone number for the utility provider or service contact. This value supports communication workflows that rely on direct contact for scheduling, troubleshooting, or verification. |
| Type | String | False |
Indicates the type of utility service that is associated with the account, such as electricity, water, or gas. This value supports service classification and contributes to reporting and billing logic. |
| UnitId | Int | False |
Represents the Id of the housing-complex unit that is associated with the utility account. This value supports precise mapping of utility services to individual units and ensures accurate linkage for billing and service coordination. |
| IsDeleted | Bool | False |
Returns a value of 'true' if the utility-account record is marked as deleted in Bullhorn CRM. It returns a value of 'false' if the record remains active and available for service tracking, reporting, or administrative workflows. |