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 location is valid. |
|
AddressExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the location is no longer valid. |
|
AddressLinesPhonetic |
string |
The phonetic or kana representation of the kanji address lines (used in Japan). |
|
AddressStyle |
string |
Used as 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 |
The 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 the address was last validated. |
|
Description |
string |
The free text description of the record. |
|
Distance |
decimal |
The distance from the input location. |
|
DoNotValidateFlag |
boolean |
A new attribute that indicates that a particular location is not eligible for address validation regardless of the current validation status code. The default is "No" meaning that by default, all address are eligible for validation. This attribute is not unset on update. |
|
EffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the location is valid. |
|
FaLocationId |
long |
Foreign key to the FA_LOCATIONS table. |
|
FloorNumber |
string |
The specific floor number at a given address or in a particular building when building number is provided. |
|
GeometryStatusCode |
string |
The spatial data integration status for given location. This attribute is not used in Fusion version 1. |
|
HouseType |
string |
A new attribute to indicate the building type. |
|
InternalFlag |
boolean |
The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES. |
|
Language |
string |
The operating language for the locations. |
|
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 location. |
|
LocationDirections |
string |
The directions to the 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 details about a location or address in the local language. |
|
|
LocationProfile |
The profile information for a location. |
|
|
Longitude |
decimal |
The longitude information for the location. |
|
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. |
|
Province |
string |
The name of the province. |
|
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
|
SalesTaxGeocode |
string |
The United States sales tax jurisdiction code. Use this field to provide a jurisdiction code (also called as geocode) defined by wither 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. Value '1' is for locations inside the city limits and '0' is for locations outside the city limits. Defaults to null if '1'. |
|
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 foreign key to FND_TIMEZONES_B.TIMEZONE_CODE. |
|
ValidatedFlag |
boolean |
Indicates whether the entity was validated. If the value is Y then the entity was validated. |
|
ValidationStatusCode |
string |
The standardized status code describing the results of the validation. Lookup: HZ_ADDR_VAL_STATUS. |