JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes

ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId String ReceivablesInvoicesCustomerTransactionId
ReceivablesinvoiceinstallmentsInstallmentId String ReceivablesinvoiceinstallmentsInstallmentId
NoteId String The unique identifier of the note. This is the primary key of the notes table.
SourceObjectCode String This is the source object code for the source object as defined in OBJECTS Metadata.
SourceObjectId String The unique identifier of the parent source object associated to the note.
PartyName String The name of the party.
NoteTxt String The column which stores the actual note text.
NoteTypeCode String The note type code for categorization of note.
VisibilityCode String The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private.
CreatorPartyId String The unique identifier of the party.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
PartyId String The unique identifier of the party.
CorpCurrencyCode String The corporate currency code for extensibility.
CurcyConvRateType String The currency conversion rate type for extensibility.
CurrencyCode String The currency code for extensibility.
ContactRelationshipId String The relationship ID populated when the note is associated with a contact.
ParentNoteId String The unique identifier of the note. This is the primary key of the notes table.
LastUpdatedBy String The unique identifier of the note. This is the primary key of the notes table.
LastUpdateLogin String The login of the user who last updated the record.
EmailAddress String The email address of the user who created the note.
FormattedAddress String The address of the user who created the note.
FormattedPhoneNumber String The phone number of the user who created the note.
UpdateFlag Bool Indicates whether the user can update the note.
DeleteFlag Bool Indicates whether the user has access to delete the note.
NoteNumber String The alternate unique identifier of the note. A user key that is system generated or from an external system.
NoteTitle String The title of the note entered by the user.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462