Power BI Connector for Oracle Sales

Build 24.0.9060

AccountNotes

The note resource is used to capture comments, information, or instructions for an account.

Columns

Name Type ReadOnly References Description
NoteId [KEY] Long False

This is the primary key of the notes table.

PartyNumber [KEY] String False

Accounts.PartyNumber

The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.

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

Indicates the user who created the row.

CreationDate Datetime False

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.

LastUpdateDate Datetime False

Indicates the date and time of the last update of the row.

AccountLastUpdateDate Datetime False

The date and time when the opportunity was last updated.

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.

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.

VisibilityCode String False

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

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.

SourceSystem String

Name of external source system.

SourceSystemReferenceValue String

Identifier for this record from external source system.

OrganizationProfileId String

The unique identifier of the organization.

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