Sales Cloud Address
An object that includes attributes used to store values while creating or updating an address. An address represents the location information of an account, contact or household.
QName: {http://xmlns.oracle.com/apps/crmCommon/salesParties/addressService/}Address
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 |
|
|
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. |
|
AddressId |
long |
The unique address 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 |
The phonetic or Kana representation of the Kanji address lines (used in Japan). |
|
AddressNumber |
string |
The 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. The prefix is the profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number. |
|
AddressPurpose |
The reference to the address purpose child entity associated with the address. |
|
|
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. |
|
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. |
|
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. |
|
DateValidated |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date on which the address was last validated. |
|
Description |
string |
The free text description of the record. |
|
DoNotMailFlag |
boolean |
Indicates whether the address should be used for mailing or not. |
|
EffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The effective date for the address. |
|
EndDateActive |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date after which the record becomes inactive. |
|
FloorNumber |
string |
The specific floor number at a given address when the building number is provided. |
|
FormattedAddress |
string |
The formatted address information. |
|
FormattedMultilineAddress |
string |
The 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 Manage Standard Lookups task in the Setup and Maintenance work area. |
|
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 for spatial proximity and containment purposes. |
|
LocationDirections |
string |
The directions to the location. |
|
LocationId |
long |
The identifier of the location. It is the foreign key to the HZ_LOCATIONS table.
|
|
Longitude |
decimal |
The longitude information for the location for spatial proximity and containment purposes. |
|
Mailstop |
string |
A user-defined code to indicate the mail drop point within the organization. |
|
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. |
|
PartyId |
long |
The unique identifier of the contact party. |
|
PartyNumber |
string |
The unique identification number for the party. |
|
PartySourceSystem |
string |
The name of the external source system of the account, contact, or household with which the address is associated. It is part of the alternate key for the account, contact, or household record (along with PartySourceSystemReferenceValue). One of PartyId, PartyNumber, or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact, or household record. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. |
|
PartySourceSystemReferenceValue |
string |
The identifier for the account, contact, or household from the external source system with which the address is associated. It is part of the alternate key (along with PartySourceSystem). One of PartyId, PartyNumber, or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact, or household record. |
|
PostalCode |
string |
The postal code element of the address. |
|
PostalPlus4Code |
string |
The four digit extension to the United States Postal ZIP code. |
|
PrimaryFlag |
boolean |
Indicates if this is the primary address of the associated object. If the value is Y, then the address is a primary address. |
|
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. |
|
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. |
|
ValidatedFlag |
boolean |
Indicates whether the entity was validated. If the value is Y then the entity was validated. |
|
ValidationStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the validation starts. It is internally set by the system during address cleansing. |
|
ValidationStatusCode |
string |
The standardized status code that describes the results of the validation. |