Power BI Connector for Bullhorn CRM

Build 25.0.9539

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539