Excel Add-In for Oracle Sales

Build 25.0.9434

AccountOrganizationContacts

The account contacts resource is used to view, create, update, and delete an account contact. It refers to a person who functions as a contact for an account.

Columns

Name Type ReadOnly References Description
AccountContactId [KEY] Long True

The unique identifier of the account contact.

PartyNumber [KEY] String False

Accounts.PartyNumber

The unique alternate identifier for the account party.

AccountName String True

The name of the account.

AccountPartyId Long False

The primary key identifier of the object in this relationship.AC Either one of ObjectPartyId, ObjectPartyNumber, and combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.

AccountPartyNumber String False

The public unique identification number for the object party of the relationship. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.

AccountSourceSystem String False

The name of external source system for the object party in the relationship, which are defined by an administrator as part of system setup. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship. The value for this attribute should be predefined using the setup task Manage Trading Community Source Systems.

AccountSourceSystemReferenceValue String False

The identifier for the object party in the relationship from external source system. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship.

AccountUniqueName String True

The unique name of the account.

Comments String False

The comments of the user.

ContactFirstName String True

The first name of the contact record.

ContactLastName String True

The last name of the contact record.

ContactLastUpdateDate Datetime True

The date when the contact record was last updated.

ContactName String True

The name of the contact.

ContactNumber String False

The user-defined identification number for this contact.

ContactPartyId Long False

The primary key identifier of the subject in this relationship. Either one of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.

ContactPartyNumber String False

The public key identifier for the subject party of the relationship. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.

ContactSourceSystem String False

The name of external source system for the subject party in the relationship, which are defined by an administrator as part of system setup. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship. The value for this attribute should be predefined using the setup task Manage Trading Community Source Systems.

ContactSourceSystemReferenceValue String False

The identifier for the subject party in the relationship from external source system. One of SubjectPartyId, SubjectPartyNumber, and a combination of SubjectSourceSystem and SubjectSourceSystemReferenceValue, is used to identify the subject party of the relationship.

CreatedBy String True

The user who created the row.

CreatedByModule String False

The application module that created the record. It's 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 and time when the row was created.

DecisionMakerFlag Bool False

Indicates whether this contact is a decision maker. The values are Y for a decision maker, N for someone who's not the decision maker.

Department String False

The free form text used to name the department for the contact.

DepartmentCode String False

The value of the department code for the contact.

DoCallFlag Bool True

Indicates whether the user can call the contact of an account. The accepted values are True and False or Y and N. Default is False or N.

DoEmailFlag Bool True

Indicates whether the user can email the contact of an account. The accepted values are True and False or Y and N. Default is False or N.

DoNotCallFlag Bool True

Indicates whether you can call the account contact. The accepted values are True and False or Y and N. Default is False or N.

DoNotEmailFlag Bool True

Indicates whether you can email the account contact. The accepted values are True and False or Y and N. Default is False or N.

EmailAddress String True

The e-mail address of the contact person for the account.

EmailVerificationDate Date True

The date of the verification for the email.

EmailVerificationStatus String True

The status of the verification for email. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID, ORA_INVALID and ORA_PARTIALLY_VALID. Default value is blank which indicates that values aren't verified.

FormattedAddress String True

The formatted address of the contact.

FormattedPhoneNumber String True

The primary formatted phone number for the contact person.

InfluenceLevelCode String False

The contact's level of influence in the buying process.

JobTitle String False

The free form text for job title for the contact associated to an account.

JobTitleCode String False

The value of the code for the job title of the contact person.

LastUpdateDate Datetime True

The date and time when the record was last updated.

LastUpdateLogin String True

The login of the user who last updated the row.

LastUpdatedBy String True

The user who last updated the record.

PersonBuyingRole String True

Describes a contact's role in a buying relationship. Sample values are key decision maker, supporting decision maker.

PersonJobTitle String True

The title of the contact's job with deploying organization.

PersonSalesAffinityCode String True

The contact's affinity for the deploying organization.

PhoneVerificationDate Date True

The date of the verification for phone.

PhoneVerificationStatus String True

The status of the verification for phone. Accepted values are defined in the standard lookup type ORA_HZ_VALIDATION_STATUS as ORA_VALID and ORA_INVALID. Default value is blank which indicates that values aren't verified.

PreferredContactFlag Bool False

Indicates whether this contact person is primary contact for the customer. Accepted values are Y and N. Default value is N.

PreferredContactMethod String True

The person's or organization's preferred contact method.

PrimaryCustomerFlag Bool False

Indicates whether this customer is primary customer for the contact. Accepted values are Y and N. Default value is N.

ReferenceUseFlag Bool False

Indicates if this contact can be used as a reference. The values are Y for a contact who will act as a reference, N for a contact who can't act as a reference.

RelationshipId Long True

The unique identifier of the relationship associated with account contact record.

RelationshipRecId Long False

Finds an account contact with the relationship record identifier.

RelationshipSourceSystem String False

The name of external source system for the relationship, which is defined by an administrator as part of system setup. One of ObjectPartyId, ObjectPartyNumber, and a combination of ObjectSourceSystem and ObjectSourceSystemReferenceValue, is used to identify the object party of the relationship. The value for this attribute should be predefined using the setup task Manage Trading Community Source Systems.

RelationshipSourceSystemReferenceValue String False

The identifier for the relationship with the external source system.

SalesAffinityCode String False

The contact's affinity for the deploying organization.

SalesAffinityComments String False

The comments describing the contact's affinity for the deploying organization.

SalesBuyingRoleCode String False

The contact's role in the buying process.

Status String False

Indicates whether this is an active or inactive relationship. The values are A for active, I for inactive. This is an internal column and you're not expected to pass in a value. A list of valid values is defined in the lookup HZ_STATUS. You can review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task. Default value is A.

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.

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.

PartyId String

The unique identifier of the party associated to the given account.

SourceSystem String

Name of external source system.

SourceSystemReferenceValue String

Identifier for this record from external source system.

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