AccountContactPoints
The contact point resource is used to view, create, update, and delete contact points for an account. Contact points can be geographical addresses, phone numbers, e-mail IDs, URLs, messenger IDs, and so on.
Columns
| Name | Type | ReadOnly | References | Description |
| ContactPointId [KEY] | Long | True |
The unique identifier of the contact point. | |
| PartyNumber [KEY] | String | False |
Accounts.PartyNumber |
The unique alternate identifier for the account party. |
| ConflictId | Long | False |
The unique identifier of the conflict for the contact point record. This number is used by mobile or portable applications that consume the web service. | |
| ContactPointType | String | False |
The type of Contact Point record. The accepted values are defined in the lookup type COMMUNICATION_TYPE. Sample values include PHONE, EMAIL, and WEB. | |
| CreatedBy | String | True |
The user who created the contact point record. | |
| CreatedByModule | String | False |
The application module that created this contact point record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. You can review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups. | |
| CreationDate | Datetime | True |
The date when the record was created. | |
| DoContactPreferenceFlag | Bool | False |
Indicates whether to use a particular contact method. Defaulted to false. | |
| DoNotContactPreferenceFlag | Bool | False |
Indicates whether the record can be contacted. | |
| DoNotContactReason | String | False |
The reason code for the contact preference. | |
| EmailAddress | String | False |
The email address of the contact point record of type email. | |
| EmailPurpose | String | False |
The purpose of using the EMAIL contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE. The values can be ASSISTANT, PERSONAL, HOME_BUSINESS, BUSINESS, and so on. | |
| FormattedPhoneNumber | String | True |
The formatted phone number of the contact point. | |
| LastUpdateDate | Datetime | True |
The date when the record was last updated. | |
| LastUpdateLogin | String | True |
The login of the user who last updated the record. | |
| LastUpdatedBy | String | True |
The user who last updated the contact point record. | |
| ObjectVersionNumber | Int | False |
The number used to implement optimistic locking for contact point record. This number is incremented every time 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. | |
| PartySourceSystem | String | False |
The name of external source system of the account, contact or household with which the contact point is associated. Part of alternate key for the account, contact or household record along with PartyourceSystemReferenceValue. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. 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 | False |
The unique identifier from external source system for the account, contact or household 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 account, contact or household record with which the address is associated. | |
| PhoneAreaCode | String | False |
The area code for the phone number. | |
| PhoneCountryCode | String | False |
The country code of the phone number. | |
| PhoneExtension | String | False |
The extension number of the phone line number like office desk extension. | |
| PhoneNumber | String | False |
The phone number of the contact point. | |
| PhonePurpose | String | False |
Defines the purpose of using the PHONE contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc. | |
| PhoneType | String | False |
The type of phone contact point. The accepted values are defined in the lookup type ORA_HZ_PHONE_TYPE. The values can be WORK, HOME, FAX, and so on. | |
| PreferenceRequestedBy | String | False |
Indicates if the permission or restriction was created internally or requested by the party. The list of accepted values are defined in the REQUESTED_BY lookup. | |
| PrimaryFlag | Bool | False |
Indicates whether this is the primary contact point of the associated object. If the value is True, then this is the primary contact point. The default value is False. If this attribute isn't explicitly mentioned in the payload, then the value of this attribute is set to null. | |
| RawPhoneNumber | String | False |
The raw phone number on the contact point record of type phone. | |
| SocialNetworkId | String | False |
The unique identifier of the social network. | |
| SocialNetworkName | String | False |
The name of the social network. | |
| SocialNetworkPurpose | String | False |
Defines the purpose of using the IM contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE.Sample values: ASSISTANT,PERSONAL,HOME_BUSINESS,BUSINESS etc. | |
| SourceSystem | String | False |
The name of external source system, which is defined by an administrator as part of system setup. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update. | |
| SourceSystemReferenceValue | String | False |
The unique identifier for the contacts party from the external source system specified in the attribute SourceSystem. It's part of alternate key along with SourceSystemReference, and is mandatory if PK or partyNumberBusinessKey isn't passed in update. | |
| Status | String | False |
Indicates the status of the contact point. The status codes are defined in the lookup HZ_STATUS. The default value is A. | |
| URL | String | False |
The URL of the contact point. | |
| VerificationDate | Date | False |
The date of verification of the phone or email contact point. | |
| VerificationStatus | String | False |
The status of the verification for phone or email contact points. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. The value ORA_PARTIALLY_VALID is applicable only for email. Default value is blank which indicates that values aren't verified. | |
| WebPurpose | String | False |
Defines the purpose of using the WEB contact point. The accepted values are defined in the lookup type CONTACT_POINT_PURPOSE_WEB.Sample values: HOMEPAGE,SALESURL,MARKETINGURL,SUPPORTURL,RSS_FEED etc. | |
| AccountLastUpdateDate | 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. |
| FocusPartyId | String |
The unique identifier of the child account to be returned at the top by the Direct Accounts finder. |
| PartyId | String |
The unique identifier of the party associated to the given account. |
| ParentPartyId | String |
The unique identifier of the account used to search the direct child accounts. |
| BindUserPartyId | String |
The unique identifier of the party. Used in MyAccounts finder. |
| OrganizationProfileId | String |
The unique identifier of the organization. |