SSIS Components for Oracle Sales Cloud

Build 20.0.7656

ContactPrimaryAddresses

The primary address resource is used to view, create, or modify a primary address of a contact. A primary address is the default communication address of an entity.

Columns

Name Type ReadOnly References Description
AddressNumber [KEY] String False

This is the primary key of the contact primary addresses table.

PartyNumber [KEY] String False

Contacts.PartyNumber

AddressElementAttribute1 String False

The additional address element to support flexible address format.

AddressElementAttribute2 String False

The additional address element to support flexible address format.

AddressElementAttribute3 String False

The additional address element to support flexible address format.

AddressElementAttribute4 String False

The additional address element to support flexible address format.

AddressElementAttribute5 String False

The additional address element to support flexible address format.

AddressId Long False

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

AddressLine1 String False

The first line for address.

AddressLine2 String False

The second line for address.

AddressLine3 String False

The third line for address.

AddressLine4 String False

The fourth line for address.

AddressLinesPhonetic String False

The phonetic or kana representation of the Kanji address lines (used in Japan).

Building String False

The specific building name or number at a given address.

City String False

The city element of Address.

Comments String False

User comments for the address.

CorpCurrencyCode String False

The corporate currency code associated with the addresses. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

Country String False

The country code of the address. This attribute is defined in the TERRITORY_CODE column in the FND_TERRITORY table.

County String False

The county element of Address.

CreatedBy String False

The user who created the address record.

CreationDate Datetime False

The date and time when the address record was created.

CurcyConvRateType String False

The currency conversion rate type associated with the address. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

CurrencyCode String False

The currency code associated with the address. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

DateValidated Datetime False

The date when the address was last validated.

DeleteFlag Boolean False

Indicates if the primary address was deleted. If the value is True, then the primary address is deleted. The default value is False.

Description String False

An extensive description of the location of the address.

FloorNumber String False

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

FormattedAddress String False

The formatted address information.

FormattedMultiLineAddress String False

The formatted multiple line address information.

HouseType String False

The type of building. A list of accepted values is defined in the lookup HZ_HOUSE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.

LastUpdateDate Datetime False

The date when the address data was last updated.

LastUpdatedBy String False

The user who last updated the address record.

LastUpdateLogin String False

The session login associated to the user who last updated the address record.

Latitude Long False

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

LocationDirections String False

The directions to the location.

LocationId Long False

The unique identifier for this location.

Longitude Long False

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

Mailstop String False

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

PartyId Long False

The unique Identifier of the contact to which the primary address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the contact record with which the address is associated.

PostalCode String False

The postal code as defined by the formal countrywide postal system.

PostalPlus4Code String False

The four digit extension to the United States Postal ZIP code.

Province String False

The province element of Address.

SourceSystem String False

The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value of SourceSystem should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.

SourceSystemReferenceValue String False

The identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.

State String False

The state element of Address.

ValidatedFlag Boolean False

Indicates if the location was validated. If the value is True, then the location is validated. The default value is False. The value is internally set by system during address cleansing.

ValidationStatusCode String False

The date when the address validation started. The value is internally set by system during address cleansing.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656