ODBC Driver for Bullhorn CRM

Build 25.0.9539

LocationVersion

Stores versioned snapshots of Location records. This table supports historical tracking and analysis by preserving earlier states that provide context for location-related decisions.

Columns

Name Type ReadOnly Description
Id [KEY] Int False

Represents the unique identifier (Id) of the LocationVersion record. This value distinguishes each version that is created for a Location and enables the system to maintain historical accuracy across updates.

AddressAddress1 String False

Captures the first address line that is associated with the Location version. This value helps define the physical worksite or billing location that applies for the specified effective date range.

AddressAddress2 String False

Captures the second address line that is associated with the Location version. This information supports more precise address definitions for mailing, invoicing, or regulatory use.

AddressCity String False

Specifies the city that is associated with the Location version. This field contributes to accurate geographic, tax, and reporting configurations.

AddressCountry Int False

Indicates the Id of the country that is linked to the Location version. This association ensures that regional rules and localization settings are applied correctly.

AddresscountryCode String False

Captures the standardized country code that is associated with the Location version. This code supports integrations and external systems that require internationally recognized formats.

AddresscountryName String False

Stores the full country name that is associated with the Location version. This value improves readability in user interfaces and audit tools.

AddressState String False

Specifies the state or province that is associated with the Location version. This field is used in regional reporting, compliance, and jurisdiction-based calculations.

AddressZip String False

Captures the ZIP or postal code that is associated with the Location version. This value enables accurate tax determination, distance mapping, and location-based filtering.

BillTo Bool False

Returns a value of 'true' when the Location version is designated as a billing destination. It returns a value of 'false' when billing is not directed to this version.

DateAdded Datetime False

Indicates the datetime when the LocationVersion record is created. This timestamp enables chronological auditing and version history reconstruction.

DateLastModified Datetime False

Captures the datetime when the LocationVersion record is last updated. This information supports change tracking and helps identify the most recent version changes.

Description String False

Provides a descriptive summary that is associated with the Location version. This narrative helps users understand the purpose or context of the version within a broader operational workflow.

EffectiveDate Date False

Specifies the effective date that is applied to the Location version. This field determines when the version's details begin to take effect within Bullhorn CRM.

EffectiveEndDate Date False

Captures the end date that defines when the Location version is no longer active. This value enables the system to determine version validity during historical lookups and reporting.

IsFirst Bool False

Returns a value of 'true' when the LocationVersion record represents the first version created for the Location. It returns a value of 'false' when the record is not the first version.

LocationCode String False

Stores the unique code that is associated with the Location version. This code supports internal mapping, reporting, and systems that reference Locations by short-form identifiers.

SoldTo Bool False

Returns a value of 'true' when the Location version is designated as a sold-to location for billing or customer accounts. It returns a value of 'false' when it is not designated for sold-to purposes.

Status String False

Represents the operational status that is assigned to the Location version. This field is used to determine whether the version is active, inactive, or pending within organizational workflows.

Title String False

Specifies the title or descriptor that is associated with the Location version. This value helps categorize and identify versions in user-facing interfaces.

Worksite Bool False

Returns a value of 'true' when the Location version functions as a worksite. It returns a value of 'false' when it does not represent a worksite.

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