Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes

Stores notes or instructions for specific invoice installments, ensuring clarity around partial payment obligations.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long The unique identifier of the customer transaction related to the invoice installment, allowing the attachment of notes to specific invoice transactions.
ReceivablesinvoiceinstallmentsInstallmentId [KEY] Long The unique identifier of the specific installment within the invoice, allowing notes to be tied to individual installments for better tracking.
NoteId [KEY] Long The unique identifier of the note, used to track and manage individual notes associated with an invoice installment.
SourceObjectCode String The code identifying the source object that generated the note, such as Activities, Opportunities, or Sales Business Plan, for easier categorization of notes.
SourceObjectId String The unique identifier of the source object, such as Activities or Opportunities, linked to the note for contextual reference.
PartyName String The name of the party that is associated with the note, often used to identify the customer or entity related to the note.
NoteTxt String The full text of the note associated with the invoice installment, allowing users to add detailed comments or information about the transaction.
NoteTypeCode String The code used to categorize the type of note. Examples might include different types of notes like 'Payment Information' or 'Customer Request'.
VisibilityCode String The visibility level of the note, such as Private, Internal, or External, controlling who can see the note within the system.
CreatorPartyId Long The unique identifier of the party who created the note, allowing traceability of note creation.
CreatedBy String The name of the user who created the note, for accountability and auditing purposes.
CreationDate Datetime The timestamp indicating when the note was created, helping track the note's lifecycle.
LastUpdateDate Datetime The timestamp of the last update to the note, useful for understanding when the note was last modified.
PartyId Long The unique identifier of the party involved with the note, which could be the customer or another party associated with the note.
CorpCurrencyCode String The corporate currency code associated with the note, reflecting the currency used for the note's financial context.
CurcyConvRateType String The currency conversion rate type used for any currency conversions applied to the note, such as 'Spot', 'Corporate', or 'User'.
CurrencyCode String The currency code associated with the note, indicating the currency used for the note's transaction or information.
ContactRelationshipId Long The unique identifier for the relationship between the note and a contact, facilitating the association of notes to specific contacts.
ParentNoteId Long The unique identifier of the parent note, allowing for the creation of note hierarchies when a note is linked to another.
LastUpdatedBy String The name of the user who last updated the note, for tracking updates and changes made to the note.
LastUpdateLogin String The user login associated with the last update made to the note, providing a traceable log of system interactions.
EmailAddress String The email address associated with the note, particularly useful for notes related to communications.
FormattedAddress String The formatted address related to the note, which could be useful in shipping or billing contexts.
FormattedPhoneNumber String The formatted phone number related to the note, providing easy access to contact information.
UpdateFlag Bool A flag indicating whether the note is marked for update, used to track whether the note is undergoing changes.
DeleteFlag Bool A flag indicating whether the note is marked for deletion, allowing the system to track deletions of notes.
NoteNumber String The alternate unique identifier of the note, either system-generated or from an external system, providing an alternative reference for the note.
NoteTitle String The title or summary of the note, providing a brief description of the note's content or purpose.
AccountingDate Date The date when the note's related financial transaction is accounted for, influencing the financial records for the installment.
AllowCompletion String A flag that determines whether the note can be completed or finalized, typically used for workflow management.
BillingDate Date The date when billing related to the note was processed, impacting when payments are due.
BillToCustomerName String The name of the customer being billed for the invoice installment, helping to identify the customer associated with the note.
BillToCustomerNumber String The account number of the customer billed for the installment, enabling easy cross-referencing of billing information.
BillToSite String The site or location associated with the billing address of the customer, used for accurate shipping and billing.
BusinessUnit String The business unit within the organization that generated the note, useful for reporting and financial categorization.
CrossReference String A reference field used to link the note to related transactions or documents, improving the traceability of the note.
CustomerTransactionId Long The unique identifier of the customer transaction tied to the note, linking it to the specific transaction it relates to.
DocumentNumber Long The unique document number tied to the note, aiding in the identification of related documents and transactions.
DueDate Date The due date for any actions or payments related to the note, setting expectations for follow-up actions.
Finder String A field used for searching and locating specific notes within the system based on certain attributes or keywords.
FirstPartyTaxRegistration String The tax registration number of the first party involved in the transaction, typically the seller or service provider, for tax compliance.
InvoiceCurrencyCode String The currency code associated with the invoice linked to the note, indicating the payment currency for the invoice.
InvoiceStatus String The status of the invoice linked to the note, such as 'Paid', 'Unpaid', 'Overdue', or 'Partial', affecting payment and collection processes.
LegalEntityIdentifier String The unique identifier of the legal entity managing the invoice, used for distinguishing between different business entities within the organization.
PaymentTerms String The payment terms for the invoice linked to the note, such as 'Net 30' or 'Due on Receipt', defining the payment schedule.
PurchaseOrder String The purchase order number related to the invoice, linking the note to the original purchase agreement.
ShipToCustomerName String The name of the customer receiving the shipment linked to the note, relevant in shipping and delivery contexts.
ShipToSite String The site or location where the goods or services linked to the note are shipped, helping to track delivery destinations.
ThirdPartyTaxRegistration String The tax registration number of any third-party entity involved in the transaction, often used in international or multi-party transactions for tax purposes.
TransactionDate Date The date when the transaction generating the note occurred, helping to track and report financial activities.
TransactionNumber String The transaction number linked to the note, providing a unique reference for the transaction associated with the note.
TransactionSource String The source of the transaction that generated the note, such as 'Sales Order' or 'Credit Memo', providing context for the origin of the note.
TransactionType String The type of transaction generating the note, such as 'Sale', 'Refund', or 'Adjustment', classifying the nature of the financial event.

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