Sales Cloud Primary Address

An object that includes attributes used to store values while creating or updating a primary address. A primary address is the default communication address of an entity irrespective of the address purpose.

QName: {http://xmlns.oracle.com/apps/crmCommon/salesParties/commonService/}PrimaryAddress

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

Sales Cloud Account

Contained by

Sales Cloud Household

Contained by

Sales Cloud Contact

Handled by

Sales Cloud Contact

Handled by

Sales Cloud Household

Handled by

Sales Cloud Account

Attributes

The following table describes attributes in the service data object.

Name Type Description

AddressElementAttribute1

string

Additional address element to support flexible address format.

AddressElementAttribute2

string

Additional address element to support flexible address format.

AddressElementAttribute3

string

Additional address element to support flexible address format.

AddressElementAttribute4

string

Additional address element to support flexible address format.

AddressElementAttribute5

string

Additional address element to support flexible address format.

AddressId

long

First line for address.
  • Primary Key

AddressLine1

string

Second line for address.

AddressLine2

string

Third line for address.

AddressLine3

string

Fourth line for address.

AddressLine4

string

Address internal unique identifier that is internally generated during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update.

AddressLinesPhonetic

string

Phonetic or Kana representation of the Kanji address lines (used in Japan).

AddressNumber

string

Alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.

Building

string

Specific building name or number at a given address.

City

string

The name of the city.

Comments

string

The comments for the record.

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.

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.

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.

DateValidated

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date the address was last validated.

DeleteFlag

boolean

Indicates whether the record can be deleted or not.

Description

string

The free text description of the record.

FloorNumber

string

Specific floor number at a given address or in a particular building when building number is provided.

FormattedAddress

string

Formatted address information.

FormattedMultiLineAddress

string

Formatted multiple line address information.

HouseType

string

Indicates the building type. A list of valid values is defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.

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

Used to store latitude information for the location for spatial proximity and containment purposes.

LocationDirections

string

Directions to the location.

LocationId

long

The identifier of the location. It is the foreign key to the HZ_LOCATIONS table.

Longitude

decimal

Used to store longitude Information for the location for spatial proximity and containment purposes.

Mailstop

string

A user-defined code to indicate a mail drop point within their organization.

PartyId

long

The unique identifier of the contact party.

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.

SourceSystem

string

The source system name where the record originated.

SourceSystemReferenceValue

string

The identifier for the record from an external source system.

State

string

The name of the state.

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.