Address
An address associated with a trading community member. For example, Oracle Corporation is located at 500 Oracle Parkway, Redwood Shores, CA.
QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/}PartySite
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 |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
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. |
|
AddressExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date when the location is no longer valid. |
|
AddressLinesPhonetic |
string |
Phonetic or Kana representation of the Kanji address lines (used in Japan). |
|
AddressStyle |
string |
The style of the address. |
|
Addressee |
string |
Addressee information. |
|
City |
string |
The name of the city. |
|
Comments |
string |
The comments for the record. |
|
ContactPreference |
The contact preference associated with the record. |
|
|
ContactPreferenceExistFlag |
boolean |
Indicates if this contact is primary contact for the party. |
|
CorpCurrencyCode |
string |
The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework. |
|
Country |
string |
The name of the country. |
|
Country1 |
string |
Not used. |
|
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. |
|
CurcyConvRateType |
string |
The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework. |
|
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. |
|
DUNSNumberC |
string |
The nine-digit identification number that is assigned to business entities by Dun and Bradstreet. |
|
DateValidated |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date the address was last validated. |
|
DoNotValidateFlag |
boolean |
Indicates whether a particular location is ineligible for address validation regardless of the current validation. |
|
Eft |
Electronic file transfer information for the party. |
|
|
|
The email address associated with the record. |
|
|
EmailAddress |
string |
The email address associated with the record. |
|
EndDateActive |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date after which the record becomes inactive. |
|
FormattedAddress |
string |
Formatted read-only address. |
|
FormattedLocaleAddress |
string |
Formatted read-only local address. |
|
FormattedMultilineAddress |
string |
Formatted multi line address of party site. |
|
GlobalLocationNumber |
string |
Global location number that uniquely identifies each location in a trading partners enterprise. |
|
HouseType |
string |
Attribute to Indicate the building type. |
|
IdentifyingAddressFlag |
boolean |
Indicates if this is the identifying address for the party. Y for the indentifying, N for sites that are not the indentifying site. |
|
InstantMessaging |
The instant messaging information related to the record. |
|
|
InternalFlag |
boolean |
The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES. |
|
Language |
string |
Operating Language for the party site. |
|
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 |
Latitude of party address. |
|
LocationDirections |
string |
Directions to the location. |
|
LocationId |
long |
The identifier of the location. It is the foreign key to the HZ_LOCATIONS table. |
|
LocationLanguage |
string |
Operating Language for the locations. |
|
Longitude |
decimal |
Longitude of party address. |
|
Mailstop |
string |
A user-defined code to indicate a mail drop point within their organization. |
|
ObjectVersionNumber1 |
int |
The attribute is used to implement optimistic 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 detect whether another session has updated the row since it was last queried. |
|
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. |
|
|
OverallPrimaryFlag |
boolean |
Indicates if this is the primary Address of this contact irrespective of the Context. Y for primary Address, N for all others. |
|
PartyId |
long |
The unique identifier of the contact party. |
|
PartyNameDba |
string |
Will store the doing-business_as (DBA) Party name for a party site. This column is to store FSIO related legal party name attribute. |
|
PartyNameDivision |
string |
Will store the division party name for a party site. This column is to store FSIO related legal party name attribute. |
|
PartyNameLegal |
string |
Will store the legal party name for a party site. This column is to store FSIO related legal party name attribute. |
|
PartySiteId |
long |
The identifier for the party site. It is the foreign key to the HZ_PARTY_SITES table.
|
|
PartySiteInformation |
Party address information. |
|
|
PartySiteName |
string |
User-defined name for the site. |
|
PartySiteNumber |
string |
Party site number of the address. |
|
PartySiteType |
string |
This stores the party site type and is based on the lookup. Currently this can be null or One-Time. |
|
PartySiteUse |
The use or purpose of the party site. |
|
|
PartyUsageCode |
string |
The usage context of a party's contact point. |
|
Phone |
The phone information for the entity. |
|
|
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 |
Four digit extension to the United States Postal ZIP code. |
|
Province |
string |
The name of the province. |
|
RelationshipId |
long |
The relationship identifier for the record. |
|
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
|
StartDateActive |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date on which the record becomes active. |
|
State |
string |
The name of the state. |
|
Status |
string |
The status of the record. |
|
Telex |
Telex information associated with the party. |
|
|
UsageCode |
string |
Not used. |
|
ValidatedFlag |
boolean |
Indicates whether the entity was validated. If the value is Y then the entity was validated. |
|
ValidationStatusCode |
string |
Standardized status code describing the results of the validation. |
|
Web |
The web information related to the record. |