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. |