Address

An address of a trading community member, such as 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

Telex

Contains

Instant Messaging

Contains

Phone

Contains

E-Mail

Contains

Source System Reference

Contains

Electronic File Transfer

Contains

Trading Community Address Additional Information

Contains

Web

Contains

Trading Community Address Purpose

Contains

Contact Preference

Contained by

Marketing Response

Contained by

Partner

Contained by

Household

Contained by

Trading Community Organization Details

Contained by

Relationship

Handled by

Trading Community Group

Handled by

Deal Registration Service

Handled by

Trading Community Organization

Handled by

Sales Account Service

Handled by

Sales Party

Handled by

Marketing Response Service

Handled by

Company and User Registration

Handled by

Sales Party Resource Service

Handled by

Sales Party Territory service

Handled by

Partner Service

Handled by

Partner Program Enrollment Service

Handled by

Trading Community Person Information

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

The date when the location is no longer valid.

AddressLinesPhonetic

string

The phonetic or Kana representation of the Kanji address lines that are used in Japan.

AddressStyle

string

Style of the address.

Addressee

string

The information of the addressee.

City

string

The name of the city.

Comments

string

The comments for the record.

ContactPreference

Contact Preference

The contact preference associated with the record.

ContactPreferenceExistFlag

boolean

Indicator to specify if the 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

The attribute country1 is 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

The date when the address was last validated.

DoNotValidateFlag

boolean

Indicator to specify that a particular location is not eligible for address validation irrespective of the current validation.

Eft

Electronic File Transfer

The electronic file transfer information for the party.

Email

E-Mail

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

The formatted read-only address.

FormattedLocaleAddress

string

The formatted read-only local address.

FormattedMultilineAddress

string

The formatted multi line address of the party site.

GlobalLocationNumber

string

The global location number that uniquely identifies each location in a trading partners enterprise.

HouseType

string

Indicates the building type.

IdentifyingAddressFlag

boolean

Indicator to specify the identifying address for the party. Y stands for the indentifying site and N stands for sites that are not the indentifying site.

InstantMessaging

Instant Messaging

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

The 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

The latitude of the 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

The operating language for the locations.

Longitude

decimal

The longitude of the party address.

Mailstop

string

A user-defined code to indicate a mail drop point within the 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

Source System Reference

The identifier for the record from the original system.

OverallPrimaryFlag

boolean

Indicator to specify if this is the primary address of the contact irrespective of the context. Y stands for primary address and N stands for all others.

PartyId

long

The unique identifier of the contact party.

PartyNameDba

string

Stores the doing-business_as (DBA) party name for a party site. This column is used to store FSIO related legal party name attribute.

PartyNameDivision

string

Stores the division party name for a party site. This column is used to store FSIO related legal party name attribute.

PartyNameLegal

string

Stores the legal party name for a party site. This column is used 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.
  • Primary Key

PartySiteInformation

Trading Community Address Additional Information

The party address information.

PartySiteName

string

The user-defined name for the site.

PartySiteNumber

string

The party site number of the address.

PartySiteType

string

Stores the party site type and is based on the lookup. Currently this is either null or one-time.

PartySiteUse

Trading Community Address Purpose

The information of the party address usage.

PartyUsageCode

string

The usage context of a party's contact point.

Phone

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

The 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

The Telex information associated with the party.

UsageCode

string

The usage code is not used.

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.

Web

Web

The web information related to the record.