JDBC Driver for Oracle Sales

Build 24.0.9060

ContactAddresses

Table 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.

Columns

Name Type ReadOnly References Description
AddressNumber [KEY] String False

The unique alternate 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. A list of accepted values is defined in the profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.

PartyNumber [KEY] String False

Contacts.PartyNumber

The alternate unique identifier of the contact to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the contact record with which the address is associated. The default value for PartyNumber is the value specified in the profile option ZCA_PUID_PREFIX concatenated with a unique generated sequence number. You can update the PartyNymber depending on the profile option HZ_GENERATE_PARTY_NUMBER. A list of accepted values is defined in the profile option HZ_GENERATE_PARTY_NUMBER. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task.

AddrElementAttribute1 String False

The additional address element to support flexible address format.

AddrElementAttribute2 String False

The additional address element to support flexible address format.

AddrElementAttribute3 String False

The additional address element to support flexible address format.

AddrElementAttribute4 String False

The additional address element to support flexible address format.

AddrElementAttribute5 String False

The additional address element to support flexible address format.

Address1 String False

The first line for address.

Address2 String False

The second line for address.

Address3 String False

The third line for address.

Address4 String False

The fourth line for address.

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.

AddressLinesPhonetic String False

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

City String False

The city element of Address.

ClliCode String False

The Common Language Location Identifier (CLLI) code.

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.

CreatedByModule String False

The application module that created this organization record. The default value for CreatedByModule is HZ_WS for all Web service based creation.

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 Date False

The date when the address was last validated.

Description String False

An extensive description of the location of the address.

DoNotMailFlag Boolean False

Indicates if this address should be used for mailing. If the value is True, then the address should not be used for mailing. The default value is False.

EffectiveDate Date False

The date when the address becomes effective.

EndDateActive Date False

Date on which this address is no longer active.

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 for this attribute 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 Double 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 Double 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.

ObjectVersionNumber Long False

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 queried.

PartyId Long False

The unique Identifier of the contact to which the 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.

PartySourceSystem String False

The name of external source system of the contact with which the address is associated. Part of Alternate Key for the contact record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the contact record with which the address is associated. A list of accepted values should be pre-defined 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 task.

PartySourceSystemReferenceValue String False

The identifier from external source system for the contact with which the address is associated. Part of Alternate Key (along with PartySourceSystem). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to 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.

PrimaryFlag Boolean False

Indicates if this is the primary address of the contact irrespective of the context. If the value is True, then the address is the primary address of the contact. The default value is False.

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.

StartDateActive Date False

Date on which this address becomes active.

State String False

The state element of Address.

Status String False

The status of the address. A list of accepted values is defined in the lookup HZ_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

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.

ValidationStartDate Date False

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

ValidationStatusCode String False

The standardized status code describing the results of the address validation. The value is internally set by system during address cleansing.

ContactLastUpdateDate Datetime False

The date and time when the opportunity was last updated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Finder String

Input specifying the Finder type.

BindUserPartyId String

The unique identifier of the contact.

PersonProfileId String

The unique identifier of the contact.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060