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