CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

UploadReceivablesInvoicesNote

Inserts or updates an invoice note in Receivables, capturing contextual information or instructions for the bill.

Input

Name Type Description
CustomerTransactionId String The unique identifier of the customer transaction associated with the invoice. This ID is used to link the note to a specific transaction for tracking purposes.
SourceObjectCode String The code indicating the source object as defined in OBJECTS Metadata. Valid values include Activities, Opportunities, and Sales Business Plan. This helps to identify the origin of the note.
SourceObjectId String The unique identifier of the source object in OBJECTS Metadata, such as Activities or Opportunities. This allows the system to associate the note with a particular object or record.
NoteTxt String The content or text of the note associated with the invoice. This field contains the actual information or message to be recorded for the invoice.
NoteTypeCode String The code used to categorize the note type. Valid values are defined in the NoteSourceTypeVA table. This helps classify the note for easier identification and reporting.
VisibilityCode String Indicates the visibility level of the note, such as Private, Internal, or External. Valid values are defined in the NoteVisibilityLookupVA table. This determines who can view the note.
CreatorPartyId Long The unique identifier of the party who created the note. This links the note to the user or entity responsible for its creation.
CorpCurrencyCode String The corporate currency code associated with the note. This typically represents the company’s base currency for financial reporting purposes.
CurcyConvRateType String The type of currency conversion rate used for the note. This defines how the exchange rate is applied if the note involves foreign currencies.
CurrencyCode String The currency code associated with the note, indicating the currency in which the note's values are recorded. This ensures proper currency handling for financial data.
ContactRelationshipId Long The unique identifier of the relationship formed when the note is linked to a contact. This helps associate the note with a specific customer or supplier.
ParentNoteId Long The unique identifier of the parent note, if the note is a child note. This allows hierarchical relationships between notes to be tracked.
NoteNumber String An alternate unique identifier for the note. This identifier can be system-generated or come from an external system, providing a reference for the note.
NoteTitle String The title provided by the user for the note. This serves as a brief description or subject for the note, helping to summarize its content.

Result Set Columns

Name Type Description
NoteId Long The unique identifier assigned to the note. This serves as the primary key for the notes table, ensuring each note can be uniquely referenced.
SourceObjectCode String The code indicating the source object as defined in OBJECTS Metadata. Examples include Activities, Opportunities, and Sales Business Plan. This links the note to its origin.
SourceObjectId String The unique identifier of the source object in OBJECTS Metadata, such as Activities or Opportunities. This links the note to a specific object or entity.
PartyName String The name of the party associated with the note. This identifies the individual or organization that is the subject of the note.
NoteTxt String The content or text of the note attached to the invoice. This is the main body of the note, providing context or information related to the invoice.
NoteTypeCode String The categorization code for the note type, as defined in the NoteSourceTypeVA table. This helps classify the note for organizational or reporting purposes.
VisibilityCode String The visibility level of the note, such as Private, Internal, or External, defined in the NoteVisibilityLookupVA table. This determines the note’s access permissions.
CreatorPartyId Long The unique identifier of the party who created the note. This identifies the user or entity responsible for the creation of the note.
CreatedBy String The user who created the note record. This helps track the individual responsible for the note’s creation.
CreationDate Datetime The date when the note was created. This timestamp is important for auditing and tracking the history of the note.
LastUpdateDate Datetime The date when the note record was last updated. This helps determine the freshness of the information associated with the note.
PartyId Long The unique identifier of the party to which the note is associated. This links the note to a specific individual or organization.
CorpCurrencyCode String The corporate currency code used in the context of the note. This indicates the currency in which the note's financial information is recorded.
CurcyConvRateType String The currency conversion rate type applied to the note. This helps in cases where currency conversion is needed to match different currencies.
CurrencyCode String The currency code associated with the note. This is used to determine the currency in which the note’s values are reported.
ContactRelationshipId Long The unique identifier for the relationship populated when the note is linked to a contact. This tracks the contact linked to the note.
ParentNoteId Long The unique identifier for the parent note, if applicable. This creates a hierarchical relationship between the note and its parent.
LastUpdatedBy String The user who last updated the note record. This helps identify the individual responsible for the most recent changes to the note.
LastUpdateLogin String The login ID of the user who last updated the record. This provides a way to track user access to the note.
EmailAddress String The email address of the user who created the note. This is useful for contacting the creator of the note.
FormattedAddress String The address of the user who created the note. This provides additional contact information for the creator.
FormattedPhoneNumber String The phone number of the user who created the note. This provides another method of contacting the creator.
UpdateFlag Bool Indicates whether the user has permission to update the note. This flag helps control user access and modification rights.
DeleteFlag Bool Indicates whether the user has permission to delete the note. This flag helps control user access and deletion rights.
NoteNumber String The unique identifier for the note, which can be system-generated or sourced externally. This helps to reference and track the note.
NoteTitle String The title provided by the user for the note. This helps to summarize the purpose or subject of the note.

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