Excel Add-In for Oracle Sales

Build 25.0.9434

SalesLeadsNotes

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

Columns

Name Type ReadOnly References Description
NoteId [KEY] Long True

The unique identifier of the note. This is the primary key of the notes table.

LeadId [KEY] String False

SalesLeads.LeadId

LeadId

ContactRelationshipId Long False

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

CorpCurrencyCode String False

The corporate currency code for extensibility.

CreatedBy String True

The user who created the record.

CreationDate Datetime True

The date when the record was created.

CreatorPartyId Long False

The unique identifier of the party.

CurcyConvRateType String False

The currency conversion rate type for extensibility.

CurrencyCode String False

The currency code for extensibility.

DeleteFlag Bool True

Indicates whether the user has access to delete the note.

EmailAddress String True

The email address of the user who created the note.

FormattedAddress String True

The address of the user who created the note.

FormattedPhoneNumber String True

The phone number of the user who created the note.

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 unique identifier of the note. This is the primary key of the notes table.

NoteNumber String False

The alternate unique identifier of the note. A user key that's system generated or from an external system.

NoteTitle String False

The title of the note entered by the user.

NoteTxt String False

The column which stores the actual note text.

NoteTypeCode String False

The note type code for categorization of note.

ParentNoteId Long False

The unique identifier of the note. This is the primary key of the notes table.

PartyId Long True

The unique identifier of the party.

PartyName String True

The name of the party.

SourceObjectCode String False

This is the source object code for the source object as defined in OBJECTS Metadata.

SourceObjectId String False

The unique identifier of the parent source object associated to the note.

UpdateFlag Bool True

Indicates whether the user can update the note.

VisibilityCode String False

The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private.

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.

ContactId String

The unique identifier of the Contact.

SysEffectiveDate String

SysEffectiveDate.

ResourcePartyIdRest String

The unique identifier of the Resource.

RestCreationDateLower String

Finds the leads that are created before the date specified.

RestCreationDateUpper String

Finds the leads with the specified creation date.

RestRecordSet String

Finds the leads with the specified record set value.

RestStatusCode String

Finds the leads with the specified status code.

Name String

Finds the leads with the specified name.

LeadNumber String

Finds the leads with the specified lead number.

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