Location Profile
Profile of a location.
QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/}LocationProfile
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 |
|---|---|
|
Contained by |
|
|
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. |
|
Building |
string |
The specific building name or number at a given address. |
|
City |
string |
The name of the city. |
|
Country |
string |
The name of the country. |
|
County |
string |
The name of the county. |
|
CreatedBy |
string |
The user who 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. |
|
EffectiveEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date at the end of the date range within which the row is effective. |
|
EffectiveLatestChange |
string |
Date Effective Entity: 'Y' indicates that this row represents the latest change in the day. |
|
EffectiveSequence |
int |
The date effective entity. Indicates the order of different changes made during a day. The lowest value represents the earliest change in the day. |
|
EffectiveStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date at the beginning of the date range within which the row is effective. |
|
FloorNumber |
string |
The specific floor number at a given address or in a particular building when building number is provided. |
|
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. |
|
LocationId |
long |
The identifier of the location. It is the foreign key to the HZ_LOCATIONS table. |
|
LocationProfileId |
long |
The unique identifier for a location profile. This attribute is system-generated and a primary key.
|
|
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. |
|
PostalCode |
string |
The postal code element of the address. |
|
Province |
string |
The name of the province. |
|
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
|
State |
string |
The name of the state. |
|
ValidationSstFlag |
boolean |
The flag to indicate if this record is denormalized into the HZ_LOCATIONS table as the single source of truth for validated address information. |
|
ValidationStatusCode |
string |
The standardized status code describing the results of the validation. Lookup: HZ_ADDR_VAL_STATUS. |