LocationsV2addresses
LocationsV2addresses
Columns
| Name | Type | SupportedFinders | Description |
| LocationsV2EffectiveEndDate [KEY] | Date | LocationsV2EffectiveEndDate of LocationsV2addresses | |
| LocationsV2EffectiveStartDate [KEY] | Date | LocationsV2EffectiveStartDate of LocationsV2addresses | |
| LocationsV2LocationId [KEY] | Long | LocationsV2LocationId of LocationsV2addresses | |
| EffectiveStartDate [KEY] | Date | PrimaryKey | Effective start date for the location address. |
| EffectiveEndDate [KEY] | Date | PrimaryKey | Effective end date for the location address. |
| AddressLine1 | String | First line of the location address. | |
| AddressLine2 | String | Second line of the location address. | |
| AddressLine3 | String | Third line of the location address. | |
| AddressLine4 | String | Fourth line of the location address. | |
| TownOrCity | String | Town or city of the location address. This value may be required depending on the country specified. | |
| Region1 | String | Primary region in which the address is located. This value may be required depending on the country specified. | |
| Region2 | String | Secondary region withing the primary region. | |
| Region3 | String | Subregion within the secondary region. | |
| Country | String | Country for the location address. | |
| PostalCode | String | Postal code for the location address. | |
| LongPostalCode | String | Long postal code for the location address. Long postal codes are used in some countries in addition to the short postal codes. | |
| AddlAddressAttribute1 | String | Additional address attribute, used by localizations. | |
| AddlAddressAttribute2 | String | Additional address attribute, used by localizations. | |
| AddlAddressAttribute3 | String | Additional address attribute, used by localizations. | |
| AddlAddressAttribute4 | String | Additional address attribute, used by localizations. | |
| AddlAddressAttribute5 | String | Additional address attribute, used by localizations. | |
| TimezoneCode | String | Code of the time zone. | |
| Building | String | Building name of the address. | |
| FloorNumber | String | Floor number of the address. | |
| CreatedBy | String | CreatedBy of LocationsV2addresses | |
| CreationDate | Datetime | CreationDate of LocationsV2addresses | |
| LastUpdatedBy | String | LastUpdatedBy of LocationsV2addresses | |
| LastUpdateDate | Datetime | LastUpdateDate of LocationsV2addresses | |
| ValidationStatusCode | String | Level of accuracy of a location address as determined by an address provider. | |
| Provider | String | Company that has validated a location address. | |
| Latitude | Decimal | Distance between the equator and a location address located to its north or south, expressed in degrees and minutes. | |
| Longitude | Decimal | Distance between the prime meridian and a location address located to its east or west, expressed in degrees and minutes. | |
| Timezone | String | Timezone of LocationsV2addresses | |
| LocAddressUsageId [KEY] | Long | Unique identifier for the address usage type. | |
| AddressUsageType | String | Type of the address usage. | |
| AddressUsageTypeMeaning | String | AddressUsageTypeMeaning of LocationsV2addresses | |
| Finder | String | Finder of LocationsV2addresses | |
| LocationId | Long | FindByLocationIdAfterReload, findByLocationId, PrimaryKey | LocationId of LocationsV2addresses |
| SysEffectiveDate | String | FindByLocationIdAfterReload, findByLocationId | SysEffectiveDate of LocationsV2addresses |
| TransactionId | Long | FindByLocationIdAfterReload | TransactionId of LocationsV2addresses |