ODBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes

The receivables invoice installment notes resource is used to create and find comments, information, or instructions on an invoice installment.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
ReceivablesinvoiceinstallmentsInstallmentId [KEY] Long ReceivablesinvoiceinstallmentsInstallmentId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
NoteId [KEY] Long NoteId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
SourceObjectCode String The code indicating the source object as defined in OBJECTS Metadata. Possible values are Activities, Opportunities, and Sales Business Plan.
SourceObjectId String The unique identifier of the source object as defined in OBJECTS Metadata. Examples are Activities and Opportunities.
PartyName String PartyName of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
NoteTxt String The text of the note on the invoice.
NoteTypeCode String The code for categorization of the note type. A list of valid values is defined in the lookup NoteSourceTypeVA.
VisibilityCode String The visibility level of the note, such as Private, Internal, or External. A list of valid values is defined in the lookup NoteVisibilityLookupVA.
CreatorPartyId Long The unique identifier of the party who created the note.
CreatedBy String CreatedBy of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
CreationDate Datetime CreationDate of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
LastUpdateDate Datetime LastUpdateDate of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
PartyId Long PartyId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
CorpCurrencyCode String The corporate currency code of the note associated with the contact.
CurcyConvRateType String The currency conversion rate type associated with the note.
CurrencyCode String The currency code associated with the note.
ContactRelationshipId Long The unique identifier of the relationship populated when the note is associated with a contact.
ParentNoteId Long The unique identifier of the parent note.
LastUpdatedBy String LastUpdatedBy of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
LastUpdateLogin String LastUpdateLogin of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
EmailAddress String EmailAddress of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
FormattedAddress String FormattedAddress of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
FormattedPhoneNumber String FormattedPhoneNumber of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
UpdateFlag Bool UpdateFlag of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
DeleteFlag Bool DeleteFlag of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
NoteNumber String The alternate unique identifier of the note. A user key that's system generated or from an external system.
NoteTitle String The title of the note entered by the user.
AccountingDate Date AccountingDate of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
AllowCompletion String AllowCompletion of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
BillingDate Date BillingDate of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
BillToCustomerName String BillToCustomerName of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
BillToCustomerNumber String BillToCustomerNumber of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
BillToSite String BillToSite of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
BusinessUnit String BusinessUnit of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
CrossReference String CrossReference of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
CustomerTransactionId Long CustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
DocumentNumber Long DocumentNumber of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
DueDate Date DueDate of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
Finder String Finder of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
FirstPartyTaxRegistration String FirstPartyTaxRegistration of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
InvoiceCurrencyCode String InvoiceCurrencyCode of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
InvoiceStatus String InvoiceStatus of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
LegalEntityIdentifier String LegalEntityIdentifier of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
PaymentTerms String PaymentTerms of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
PurchaseOrder String PurchaseOrder of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
ShipToCustomerName String ShipToCustomerName of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
ShipToSite String ShipToSite of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
ThirdPartyTaxRegistration String ThirdPartyTaxRegistration of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
TransactionDate Date TransactionDate of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
TransactionNumber String TransactionNumber of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
TransactionSource String TransactionSource of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
TransactionType String TransactionType of ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes

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