Location Details
The details about a geographical or physical location. For example, 500 Oracle Parkway, Redwood Shores, CA 94065.
QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/}Location
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Handled by |
|
Handled by |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AddrElementAttribute1 |
string |
The additional address element to support flexible address format. |
AddrElementAttribute2 |
string |
The additional address element to support flexible address format. |
AddrElementAttribute3 |
string |
The additional address element to support flexible address format. |
AddrElementAttribute4 |
string |
The additional address element to support flexible address format. |
AddrElementAttribute5 |
string |
The additional address element to support flexible address format. |
Address1 |
string |
The first line of the address. |
Address2 |
string |
The second line of the address. |
Address3 |
string |
The third line of the address. |
Address4 |
string |
The fourth line of the address. |
AddressEffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the address becomes effective. |
AddressExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the address is no longer active. |
AddressLinesPhonetic |
string |
The phonetic or kana representation of the Kanji address lines (used in Japan). |
AddressStyle |
string |
The context value for Flexible Address Format descriptive flex field. Do not use this column, join to the FND_TERRITORIES table via COUNTRY = TERRITORY_CODE to retrieve the address style for the country. |
Building |
string |
The specific building name or number at a given address. |
City |
string |
The name of the city. |
ClliCode |
string |
Common Language Location Identifier (CLLI) code. |
Comments |
string |
The comments for the record. |
Country |
string |
The name of the country. |
County |
string |
The name of the county. |
CreatedBy |
string |
The user who created the record. |
CreatedByModule |
string |
The module that created the record. |
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
DateValidated |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the address was last validated. |
Description |
string |
The free text description of the record. |
Distance |
decimal |
The distance from the input location. |
DoNotValidateFlag |
boolean |
Indicates that a particular location should not validated, regardless of the current validation status code. If the value is Yes, then the location is not validated. The default is No. |
EffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the location becomes valid. |
FaLocationId |
long |
Foreign key to the FA_LOCATIONS table. |
FloorNumber |
string |
The floor number of the address. |
GeometryStatusCode |
string |
The spatial data integration status for given location. |
HouseType |
string |
Indicates the building type for the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE. |
InternalFlag |
boolean |
The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES. |
Language |
string |
The language used in the location. |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
LastUpdateLogin |
string |
The login of the user who last updated the record. |
LastUpdatedBy |
string |
The user who last updated the record. |
Latitude |
decimal |
The latitude information for the address. The latitude information for the location is used for spatial proximity and containment purposes. |
LocationDirections |
string |
The directions to the address location. |
LocationId |
long |
The identifier of the location. It is the foreign key to the HZ_LOCATIONS table.
|
LocationInformation |
The detailed information about the location. |
|
LocationLocale |
The location or address information in the local language. |
|
LocationProfile |
The profile information of the location. |
|
Longitude |
decimal |
The longitude information for the address. The longitude information for the location is used for spatial proximity and containment purposes. |
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
OrigSystem |
string |
The source system name. |
OrigSystemReference |
string |
The identifier for the record from the original system. |
OriginalSystemReference |
The identifier for the record from the original system. |
|
Position |
string |
The primary direction such as North or East that is used to access the location. |
PostalCode |
string |
The postal code element of the address. |
PostalPlus4Code |
string |
The four-digit extension to the United States Postal ZIP code for the address. |
Province |
string |
The name of the province. |
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
SalesTaxGeocode |
string |
The US Sales Tax Jurisdiction code. This provides a Jurisdiction Code (also called as Geocode) defined by either Vertex or Taxware. This value is passed as a ship-to location jurisdiction code to the tax partner API. |
SalesTaxInsideCityLimits |
string |
Indicates if 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 |
string |
The short description of the location. |
State |
string |
The name of the state. |
StatusFlag |
boolean |
The record status flag used to soft delete the record. The accepted values are: 'A' (active), 'I' (inactive), 'D' (logically deleted), and 'M' (merged). The default is 'A'. |
TimezoneCode |
string |
The code of the time zone for the location. |
ValidatedFlag |
boolean |
Indicates whether the entity was validated. If the value is Y then the entity was validated. |
ValidationStatusCode |
string |
A standardized status code describing the results of the validation. The value is internally set by system during address cleansing. |