ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

InvoicesinvoiceInstallmentsinvoiceInstallmentDff

Allows user-defined flexfields for invoice installments, enabling specialized reporting on partial payments or custom categories.

Columns

Name Type Description
InvoicesInvoiceId [KEY] Long Unique identifier of the invoice associated with the installment descriptive flexfield, linking the flexfield data to its corresponding invoice.
InvoiceinstallmentsInstallmentNumber [KEY] Long Unique number assigned to the installment within the invoice, identifying the installment in relation to the invoice.
InvoiceId [KEY] Long The unique identifier for the invoice to which the installment descriptive flexfield is linked, providing context for the flexfield.
InstallmentNumber [KEY] Long The number used to uniquely identify an installment within the invoice, helping to track and differentiate each installment.
_FLEX_Context String Context name for the descriptive flexfield, indicating the specific context in which the flexfield data is being used for the installment.
_FLEX_Context_DisplayValue String Display value for the descriptive flexfield context, offering a human-readable version of the context name for easier understanding.
Finder String Search term or identifier used to locate and retrieve specific descriptive flexfield records related to invoice installments.
CUReferenceNumber Int Reference number that maps child aggregates to parent tables, linking flexfield data with related entities in the database.
EffectiveDate Date Date parameter used to fetch resources that are effective as of a specified start date, ensuring accurate and relevant data retrieval.

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