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