ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF

Holds custom descriptive flexfields for invoice distributions, aiding specialized reporting or data capture.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long The unique identifier of the customer transaction for the invoice distribution descriptive flexfield, linking the distribution to the main customer transaction.
ReceivablesinvoicedistributionsDistributionId [KEY] Long The unique identifier for the invoice distribution in the descriptive flexfield, used to track the specific allocation of the invoice amount to different accounts.
CustTrxLineGlDistId [KEY] Long The unique identifier of the invoice distribution, linking it to the general ledger distribution for proper accounting and financial reporting.
_FLEX_Context String The context segment of the invoice distribution descriptive flexfield, indicating the specific context or category of the distribution.
_FLEX_Context_DisplayValue String The displayed value for the context segment of the invoice distribution descriptive flexfield, providing a user-friendly display for the context information.
AccountingDate Date The accounting date for the invoice distribution, determining when the financial transaction is recognized in the accounting period.
AllowCompletion String Indicates whether the invoice distribution can be completed. A value of 'Y' means that the distribution is eligible for finalization in the system.
BillingDate Date The billing date of the invoice distribution, which marks when the charges for the distribution are recognized and billed to the customer.
BillToCustomerName String The name of the bill-to customer associated with the invoice distribution, identifying the entity being billed.
BillToCustomerNumber String The unique identifier for the bill-to customer, which links the distribution to the specific customer in the system.
BillToSite String The identifier of the bill-to site associated with the invoice distribution, specifying the location or site of the bill-to customer.
BusinessUnit String The business unit under which the invoice distribution was created, categorizing the distribution within a specific organizational division.
CrossReference String A reference field used to link the distribution to other related records or systems, enabling cross-referencing across different transaction types.
CustomerTransactionId Long The unique identifier of the customer transaction associated with the invoice distribution, helping to link the distribution back to the original customer transaction.
DocumentNumber Long The document number assigned to the invoice distribution, which helps track and identify the specific document in the system.
DueDate Date The due date for the invoice distribution's payment, indicating when the amount should be paid by the customer.
Finder String A field used for searching and locating the distribution based on various criteria, facilitating easier retrieval of records.
FirstPartyTaxRegistration String The tax registration number of the first party involved in the distribution, typically the seller or service provider, for tax and regulatory purposes.
InvoiceCurrencyCode String The currency code used for the invoice distribution, indicating the currency in which the invoice was issued.
InvoiceStatus String The current status of the invoice distribution, indicating whether the distribution is 'Paid', 'Unpaid', or 'Pending'.
LegalEntityIdentifier String The identifier of the legal entity under which the invoice distribution was created, which is necessary for legal and regulatory compliance.
PaymentTerms String The payment terms for the invoice distribution, specifying the conditions under which the invoice is to be paid, such as 'Net 30' or 'Due on receipt'.
PurchaseOrder String The purchase order number associated with the invoice distribution, linking the distribution to the original purchase order.
ShipToCustomerName String The name of the customer receiving the goods or services billed on the distribution, used for delivery and shipping purposes.
ShipToSite String The identifier of the site where the goods or services are delivered, helping to track the location of the shipment.
ThirdPartyTaxRegistration String The tax registration number of a third-party entity involved in the transaction, such as a logistics provider or intermediary, for tax reporting.
TransactionDate Date The date when the transaction related to the invoice distribution occurred, marking the occurrence of the financial event.
TransactionNumber String The transaction number associated with the invoice distribution, providing a unique identifier for the distribution within transaction records.
TransactionSource String The source of the transaction that generated the invoice distribution, such as 'Sales Order' or 'Return', helping to classify the origin of the transaction.
TransactionType String The type of transaction associated with the distribution, such as 'Sale', 'Refund', or 'Credit', which helps categorize the nature of the distribution.

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