Locations
The location view object contains information about a delivery or postal address such as building number, street address, postal code, and directions to a location. This view provides physical location information about parties (organizations and people) and customer accounts. Records in the location view provide delivery and postal information about a location through columns such as the LOCATION_DIRECTIONS, POST_OFFICE and TIME_ZONE columns, as well as latitude and longitude information. Data in this view is also used to determine the appropriate tax rates for sales tax and VAT calculations.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.LocationExtractPVO
Primary Keys : LocationId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActualContentSource | Additional content source type column for backward compatibility. |
| AddrElementAttribute1 | The additional address element to support flexible address format. |
| AddrElementAttribute2 | The additional address element to support flexible address format. |
| AddrElementAttribute3 | The additional address element to support flexible address format. |
| AddrElementAttribute4 | The additional address element to support flexible address format. |
| AddrElementAttribute5 | The additional address element to support flexible address format. |
| Address1 | The first line of the address. |
| Address2 | The second line of the address. |
| Address3 | The third line of the address. |
| Address4 | The fourth line of the address. |
| AddressEffectiveDate | Date when the location is valid. |
| AddressExpirationDate | Date when the location is no longer valid |
| AddressLinesPhonetic | Phonetic or Kana representation of the Kanji address lines. It's used in Japan. |
| Attribute1 | A segment for the location descriptive flexfield. |
| Attribute10 | A segment for the location descriptive flexfield. |
| Attribute11 | A segment for the location descriptive flexfield. |
| Attribute12 | A segment for the location descriptive flexfield. |
| Attribute13 | A segment for the location descriptive flexfield. |
| Attribute14 | A segment for the location descriptive flexfield. |
| Attribute15 | A segment for the location descriptive flexfield. |
| Attribute16 | A segment for the location descriptive flexfield. |
| Attribute17 | A segment for the location descriptive flexfield. |
| Attribute18 | A segment for the location descriptive flexfield. |
| Attribute19 | A segment for the location descriptive flexfield. |
| Attribute2 | A segment for the location descriptive flexfield. |
| Attribute20 | A segment for the location descriptive flexfield. |
| Attribute21 | A segment for the location descriptive flexfield. |
| Attribute22 | A segment for the location descriptive flexfield. |
| Attribute23 | A segment for the location descriptive flexfield. |
| Attribute24 | A segment for the location descriptive flexfield. |
| Attribute25 | A segment for the location descriptive flexfield. |
| Attribute26 | A segment for the location descriptive flexfield. |
| Attribute27 | A segment for the location descriptive flexfield. |
| Attribute28 | A segment for the location descriptive flexfield. |
| Attribute29 | A segment for the location descriptive flexfield. |
| Attribute3 | A segment for the location descriptive flexfield. |
| Attribute30 | A segment for the location descriptive flexfield. |
| Attribute4 | A segment for the location descriptive flexfield. |
| Attribute5 | A segment for the location descriptive flexfield. |
| Attribute6 | A segment for the location descriptive flexfield. |
| Attribute7 | A segment for the location descriptive flexfield. |
| Attribute8 | A segment for the location descriptive flexfield. |
| Attribute9 | A segment for the location descriptive flexfield. |
| AttributeCategory | The context name for the location descriptive flexfield. |
| AttributeDate1 | A date segment for the location descriptive flexfield. |
| AttributeDate10 | A date segment for the location descriptive flexfield. |
| AttributeDate11 | A date segment for the location descriptive flexfield. |
| AttributeDate12 | A date segment for the location descriptive flexfield. |
| AttributeDate2 | A date segment for the location descriptive flexfield. |
| AttributeDate3 | A date segment for the location descriptive flexfield. |
| AttributeDate4 | A date segment for the location descriptive flexfield. |
| AttributeDate5 | A date segment for the location descriptive flexfield. |
| AttributeDate6 | A date segment for the location descriptive flexfield. |
| AttributeDate7 | A date segment for the location descriptive flexfield. |
| AttributeDate8 | A date segment for the location descriptive flexfield. |
| AttributeDate9 | A date segment for the location descriptive flexfield. |
| AttributeNumber1 | A number segment for the location descriptive flexfield. |
| AttributeNumber10 | A number segment for the location descriptive flexfield. |
| AttributeNumber11 | A number segment for the location descriptive flexfield. |
| AttributeNumber12 | A number segment for the location descriptive flexfield. |
| AttributeNumber2 | A number segment for the location descriptive flexfield. |
| AttributeNumber3 | A number segment for the location descriptive flexfield. |
| AttributeNumber4 | A number segment for the location descriptive flexfield. |
| AttributeNumber5 | A number segment for the location descriptive flexfield. |
| AttributeNumber6 | A number segment for the location descriptive flexfield. |
| AttributeNumber7 | A number segment for the location descriptive flexfield. |
| AttributeNumber8 | A number segment for the location descriptive flexfield. |
| AttributeNumber9 | A number segment for the location descriptive flexfield. |
| Building | The specific building name or number at a given address. |
| City | The city name of the location. |
| ClliCode | The Common Language Location Identifier (CLLI) code. |
| Comments | The comments for the record. |
| Country | The name of the country. |
| County | The name of the county. |
| CreatedBy | The user who created the record. |
| CreatedByModule | The module through which the record was created. |
| CreationDate | The date and time of creating the record. |
| DateValidated | The date when the address was last validated. |
| Description | The free text description of the record. |
| DoNotValidateFlag | Indicates that a particular location isn't validated, regardless of the current validation status code. If the value is Yes, then the location isn't validated. The default is No. |
| FaLocationId | Foreign key to the FA_LOCATIONS table. |
| FloorNumber | Specific floor number at a given address or in a particular building when building number is provided. |
| HouseType | Indicates the building type for the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. |
| InternalFlag | This is set to Y for identifying internal or legal location. Possible values are Y and N. Default is N. |
| Language | The language used in the location. |
| LastUpdateDate | The date and time of last update of the record. |
| LastUpdateLogin | The login of the user who last updated the record. |
| LastUpdatedBy | The user who last updated the record. |
| Latitude | The latitude information for the location which is used for spatial proximity and containment purposes. |
| LocationDirections | The directions to the address location. |
| LocationId | The identifier of the location. This is a primary key. |
| Longitude | The longitude information for the location which is used for spatial proximity and containment purposes. |
| OrigSystemReference | The identifier for the record from the original system. |
| Position | The primary direction such as North or East that's used to access the location. |
| PostalCode | The postal code element of the address. |
| PostalPlus4Code | The four-digit extension to the United States Postal ZIP code for the address. |
| Province | The name of the province. |
| SalesTaxGeocode | The US Sales Tax Jurisdiction code. Use this field to provide a Jurisdiction Code, also called Geocode, defined by Vertex or Taxware. This value is passed as a ship-to location jurisdiction code to the tax partner API. |
| SalesTaxInsideCityLimits | Indicates whether the location is inside the boundary of a city. Used to calculate state and local taxes in the United States. If the value is 1, then the location is within city limits. |
| ShortDescription | The short description of the location. |
| State | The name of the state. |
| StatusFlag | The record status flag used to soft delete the record. The accepted values are A for active, I for inactive, D for logically deleted, and M for merged. The default is A. |
| TimezoneCode | The code of the time zone for the location. |
| ValidatedFlag | Indicates whether the entity was validated. If the value is Y then the entity was validated. |
| ValidationStatusCode | A standardized status code describing the results of the validation. The value is internally set by system during address cleansing. |