ADO.NET Provider for Oracle Fusion Cloud Financials

Build 25.0.9434

InvoicesavailablePrepayments

Lists prepayments not yet applied to invoices, indicating funds available to offset future payables.

Columns

Name Type Description
InvoicesInvoiceId [KEY] Long Unique identifier of the invoice associated with available prepayments, used to link the prepayment to the corresponding invoice.
InvoiceNumber String Unique number of the invoice, used for identifying and referencing the invoice in the context of available prepayments.
LineNumber [KEY] Long Line number associated with the invoice available prepayment, helping to distinguish between multiple lines within the same invoice.
Description String Description of the available prepayment, providing details about the transaction or prepayment.
SupplierSite String Supplier site associated with the available prepayment, indicating the location or branch of the supplier where the prepayment is applied.
PurchaseOrder String Purchase order number linked to the available prepayment, used to match the prepayment to the specific purchase order.
Currency String Currency used for the available prepayment, indicating the type of currency in which the prepayment was made.
AvailableAmount Decimal The amount of prepayment available to be applied to the invoice, indicating how much of the prepayment can be used.
IncludedTax Decimal The tax amount included in the available prepayment, specifying the portion of the tax associated with the prepayment.
Finder String Search term or identifier used to locate and retrieve specific available prepayment records, helping to enhance the ability to search and filter prepayments.
InvoiceId Long Unique identifier for the invoice related to the available prepayment, assisting in linking the prepayment to its corresponding invoice.
CUReferenceNumber Int Reference number mapping child aggregates with parent tables, providing the connection between related data entities.
EffectiveDate Date Date parameter used to fetch resources that are effective as of a specified start date, ensuring accurate retrieval of time-sensitive data.

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