MCP Server for Oracle Sales

Build 25.0.9440

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440