Tableau Connector for Oracle Sales Cloud

Build 20.0.7695

ActivityNotes

Note data objects that capture comments, information or instructions for an Oracle Fusion Applications business object.

Columns

Name Type ReadOnly References Description
NoteId [KEY] Long False

Unique Note Identifier. This is the primary key of the notes table.

ActivityNumber [KEY] String False

Activities.ActivityNumber

ContactRelationshipId Long False

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

CorpCurrencyCode String False

Holds Corporate Currency Code from profile

CreatedBy String False

Who column: indicates the user who created the row.

CreationDate Datetime False

Who column: indicates the date and time of the creation of the row.

CreatorPartyId Long False

This is Party Id for the Note Creator

CurcyConvRateType String False

Holds Currency Conversion Rate Type from profile

CurrencyCode String False

Holds currency code of a record

DeleteFlag Bool False

This flag controls if the user has access to delete the record

EmailAddress String False

Email Address of the user who created the Note

FormattedAddress String False

Address of the user who created the Note

FormattedPhoneNumber String False

Phone Number of the user who created the Note

LastUpdateDate Datetime False

Who column: indicates the date and time of the last update of the row.

LastUpdateLogin String False

System attribute to capture the Id of the user who last updated the Note. This is defaulted by the system.

LastUpdatedBy String False

System attribute to capture the Id of the user who last updated the Note. This is defaulted by the system.

NoteTxt String False

This is the column which will store the actual note text.

NoteTypeCode String False

This is the note type code for categorization of note.

ParentNoteId Long False

null

PartyId Long False

Party identifier

PartyName String False

Name of this party

SourceObjectCode String False

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

SourceObjectId String False

This is the source_object_Uid for the source object (such as Activities, Opportunities etc) as defined in OBJECTS Metadata.

UpdateFlag Bool False

This flag controls if the user has access to update the record

VisibilityCode String False

This is the attribute to specify the visibility level of the note.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695