Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesCreditMemosreceivablesCreditMemoDistributions

Tracks distribution entries for credit memos, detailing account allocations and supporting ledger postings.

Columns

Name Type Description
ReceivablesCreditMemosCustomerTransactionId [KEY] Long The unique identifier for the customer transaction associated with the credit memo distribution, used for tracking and linking the distribution to its parent transaction.
DistributionId [KEY] Long The unique identifier for the specific credit memo distribution, enabling the tracking and management of different distribution records within a credit memo.
AccountedAmount Decimal The amount of the credit memo distribution recorded in the ledger's currency, used for accounting and financial reporting purposes.
Amount Decimal The amount of the credit memo distribution in the credit memo's currency, representing the value of the distribution for the transaction.
Comments String User-defined comments associated with the credit memo distribution, providing additional context or notes about the distribution.
CreatedBy String The name or identifier of the user who created the credit memo distribution record.
CreationDate Datetime The date and time when the credit memo distribution record was created in the system.
DetailedTaxLineNumber Long The number associated with the detailed tax line of a credit memo line, providing reference to tax-related calculations linked to the distribution.
CreditMemoLineNumber Long The number of the specific credit memo line that is associated with the distribution, helping to connect the distribution to its originating credit memo line.
LastUpdateDate Datetime The date and time when the credit memo distribution record was last updated in the system.
LastUpdatedBy String The name or identifier of the user who last updated the credit memo distribution record.
Percent Decimal The percentage of the total line amount that is allocated to this particular distribution, useful for proportionally dividing amounts.
AccountClass String The class of account associated with the credit memo distribution, such as 'Revenue', 'Receivable', 'Freight', or 'Tax', used for categorization.
AccountCombination String The account code combination for the distribution, specifying the appropriate financial accounts involved in the credit memo distribution.
BindAccountingDate Date The accounting date associated with the credit memo distribution, used for determining when the distribution is recognized in the accounting system.
BindAllowCompletion String Indicates whether the credit memo distribution is allowed to complete the transaction process. Typically marked as 'Y' to allow completion.
BindBillToCustomer String The bill-to customer associated with the credit memo distribution, ensuring the correct customer is linked to the distribution.
BindBillToCustomerNumber String The unique number assigned to the bill-to customer, used for referencing the specific customer associated with the credit memo distribution.
BindBillToSite String The site number for the bill-to customer, ensuring the distribution is correctly linked to the intended site location within the customer's organization.
BindBusinessUnit String The business unit under which the credit memo distribution is processed, helping to categorize and manage financial transactions within the organization.
BindCreditMemoCurrency String The currency used for the credit memo distribution, ensuring that the distribution is recorded in the correct currency for the transaction.
BindCreditMemoStatus String The status of the credit memo distribution, indicating whether it is completed, pending, or in another state in the workflow.
BindCrossReference String A reference identifier that links the credit memo distribution to related transactions or documents, ensuring traceability across systems.
BindDeliveryMethod String The method by which the credit memo distribution is delivered, such as email, printed document, or XML, specifying the format of the distribution.
BindDocumentNumber Long The document number assigned to the credit memo distribution, serving as a unique identifier within the document management system.
BindIntercompany String Indicates whether the credit memo distribution is part of an intercompany transaction, helping to distinguish between internal and external transactions.
BindPrimarySalesperson String The primary salesperson associated with the credit memo distribution, providing sales attribution for the distribution.
BindPrintStatus String Indicates whether the credit memo distribution has been printed or if it is pending printing, used for tracking physical document statuses.
BindPurchaseOrder String The purchase order number linked to the credit memo distribution, ensuring that the distribution is connected to a specific purchase order.
BindShipToCustomerName String The name of the customer receiving the goods or services as per the credit memo distribution, ensuring correct recipient information.
BindShipToSite String The site number for the ship-to customer, ensuring that the distribution is linked to the correct shipping address.
BindTransactionDate Date The date of the transaction for the credit memo distribution, which helps in reporting and determining the accounting period.
BindTransactionNumber String The unique transaction number associated with the credit memo distribution, allowing for identification and traceability of the transaction.
BindTransactionSource String The source from which the credit memo distribution originates, such as a sales order or purchase order.
BindTransactionType String The type of transaction associated with the credit memo distribution, helping to categorize the nature of the distribution.
CustomerTransactionId Long The customer transaction ID associated with the credit memo distribution, ensuring that the distribution is linked to a specific customer transaction.
Finder String A keyword or reference term used to search and identify the credit memo distribution in the system, helping to locate specific records.

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