Cmdlets for Oracle Sales

Build 24.0.9060

ContactNotes

The note resource is used to capture comments, information, or instructions for a contact.

Columns

Name Type ReadOnly References Description
NoteId [KEY] Long False

This is the primary key of the notes table.

PartyNumber [KEY] String False

Contacts.PartyNumber

ContactRelationshipId Long False

The identifier of the relationship populated when the note is associated with a contact.

CorpCurrencyCode String False

The corporate currency code of the note associated with the contact. 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.

CreatedBy String False

The user who created the note record.

CreationDate Datetime False

The date and time when the note record was created.

CreatorPartyId Long False

The unique party identifier for the note creator.

CurcyConvRateType String False

The currency conversion rate type associated with the note. 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 note. 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.

LastUpdateDate Datetime False

The date when the note data was last updated.

NoteTxt String False

The actual note text.

NoteTypeCode String False

This code for categorization of the note type.

PartyId Long False

The unique Identifier of the contact to which the note 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.

PartyName String False

The name of a contact party.

SourceObjectCode String False

The code of the source object such as Activities, Opportunities, as defined in OBJECTS Metadata.

SourceObjectId String False

The primary key identifier of the source object such as Activities, Opportunities, as defined in OBJECTS Metadata.

VisibilityCode String False

The visibility level of the note.

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.

SourceSystem String

The name of external source system where the contact party is imported from.

SourceSystemReferenceValue String

The unique identifier for the contact party from the external source system.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060