ADO.NET Provider for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF

Leverages global descriptive flexfields for invoice installments, handling cross-border or specialized business needs.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long The unique identifier of the customer transaction associated with the installment in the ReceivablesInvoices system, linking the installment to the broader transaction context.
ReceivablesinvoiceinstallmentsInstallmentId [KEY] Long The unique identifier for the specific installment, enabling tracking and management of individual payments or balances due on an invoice.
PaymentScheduleId [KEY] Long The unique identifier for the payment schedule tied to the installment, used to track and manage the timing and structure of installment payments.
_FLEX_Context String The context segment for the invoice installment's descriptive flexfield, providing additional customizable information specific to the business or accounting needs.
_FLEX_Context_DisplayValue String The displayed value of the flexfield context segment for the installment, providing a human-readable representation of the context used for customization.
AccountingDate Date The date when the installment transaction was posted to the accounting system, influencing the financial reporting period for the installment.
AllowCompletion String A flag that determines whether the installment is eligible for completion, used to control whether further actions such as payment processing can occur.
BillingDate Date The date when the installment was billed to the customer, impacting the payment due date and financial reporting for the installment.
BillToCustomerName String The name of the customer responsible for paying the installment, identifying the customer associated with the billing.
BillToCustomerNumber String The customer number assigned to the billing customer, facilitating identification and reconciliation of billing records.
BillToSite String The site associated with the bill-to customer, identifying the location linked to the billing address for the installment.
BusinessUnit String The business unit under which the invoice installment was issued, helping to classify and report the installment by organizational division.
CrossReference String A reference field used to link the installment to related transactions or records, such as sales orders or credit memos, for reconciliation and auditing.
CustomerTransactionId Long The unique identifier for the transaction tied to the installment, ensuring the installment is linked to the broader customer transaction.
DocumentNumber Long The unique document number associated with the installment, used to track and manage invoice-related documents.
DueDate Date The date by which the installment payment is due, determining when the customer is expected to pay.
Finder String A search field used for locating specific installments based on various attributes, improving the efficiency of retrieving installment data.
FirstPartyTaxRegistration String The tax registration number of the first party involved in the installment transaction, typically the seller or service provider, for tax reporting purposes.
InvoiceCurrencyCode String The currency code used for the installment amount, indicating the currency in which the installment payment should be made.
InvoiceStatus String The status of the invoice associated with the installment, indicating whether the invoice is 'Paid', 'Open', or 'Partially Paid'.
LegalEntityIdentifier String The unique identifier of the legal entity responsible for managing the invoice installment, providing clarity on which business unit or entity the installment belongs to.
PaymentTerms String The payment terms associated with the installment, defining the payment schedule and conditions, such as 'Net 30' or 'Due on Receipt'.
PurchaseOrder String The purchase order number linked to the installment, associating it with a specific purchase agreement and tracking the goods or services ordered.
ShipToCustomerName String The name of the customer receiving the goods or services billed for the installment, typically used in shipping and delivery documentation.
ShipToSite String The site where the goods or services related to the installment are delivered, helping track the destination of the shipped items.
ThirdPartyTaxRegistration String The tax registration number of any third-party entity involved in the transaction, such as a logistics or external service provider, for tax reporting purposes.
TransactionDate Date The date on which the transaction that generated the installment was completed, marking when the financial event was officially recorded.
TransactionNumber String The transaction number assigned to the installment, serving as a unique identifier for tracking the financial transaction.
TransactionSource String The source of the transaction generating the installment, such as 'Sales Order', 'Credit Memo', or 'Refund', helping categorize the nature of the installment.
TransactionType String The type of transaction that created the installment, such as 'Sale', 'Refund', or 'Credit', assisting in classification and reporting.

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