Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesCustomerAccountSiteActivitiescreditMemos

Shows credit memos associated with the customer’s site, covering both standard and on-account credits.

Columns

Name Type Description
ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] Long The unique identifier for the bill-to site use in the context of credit memo applications. It links the site to a specific use for billing purposes in the receivables system.
CreditMemoId [KEY] Long The unique identifier for the credit memo. This helps track and manage the credit memo within the receivables system, including adjustments, applications, and related transactions.
CreditMemoNumber String The number assigned to the credit memo for reference. This number is used to uniquely identify and track credit memo transactions within the system.
CreditMemoDate Date The date when the credit memo was issued. This date is used for record-keeping and determining the application of accounting policies, such as recognition of revenue.
TransactionClass String A classification that identifies the type of transaction represented by the credit memo. Examples may include 'Sales Credit' or 'Returns'.
AccountingDate Date The accounting date for the credit memo. This date is used for the posting of journal entries and reflects the financial period in which the credit memo should be recognized.
PurchaseOrder String The purchase order number associated with the credit memo. This links the credit memo to the specific order that it is crediting.
TotalOriginalAmount Decimal The total original amount of the credit memo before any adjustments or payments. This is used for calculating the credit impact on the customer’s account.
TotalBalanceAmount Decimal The balance remaining on the credit memo after payments or adjustments have been applied.
AvailableAmount Decimal The amount of the credit memo that is still available to be applied to transactions or invoices. This reflects the current status of the credit memo.
TransactionType String The type of transaction represented by the credit memo. This could include values like 'Credit' or 'Refund', which describe how the credit memo affects the customer’s account.
InstallmentId Long The identifier for the installment associated with the credit memo. This is used to track how the credit memo is applied over multiple payments or installments.
CreditMemoCurrency String The currency in which the credit memo is issued. This allows for multi-currency processing and ensures that the credit memo is correctly applied to customer transactions in the appropriate currency.
CreditMemoStatus String The current status of the credit memo, such as 'Open', 'Closed', or 'Pending'. This helps track the lifecycle of the credit memo in the receivables system.
CreatedBy String The name or identifier of the user who created the credit memo in the system. This information is used for audit purposes.
CreationDate Datetime The date and time when the credit memo was created in the system.
LastUpdateDate Datetime The date and time when the credit memo was last updated. This ensures that users can track any changes to the credit memo.
LastUpdatedBy String The name or identifier of the user who last updated the credit memo.
BillToSiteNumber String The unique number identifying the bill-to site where the credit memo is applied. This helps track which location or department within the customer organization is responsible for the credit.
AccountNumber String The customer’s account number associated with the credit memo. This uniquely identifies the customer in the receivables system.
BillToSiteUseId Long The identifier for the specific use of the bill-to site for the credit memo. This is used for tracking how a bill-to site is leveraged in customer account activities.
CustomerName String The name of the customer associated with the credit memo. This is used for identification and reporting purposes.
Finder String A search term used to locate and retrieve credit memo records based on specific criteria.
TaxpayerIdentificationNumber String The unique Tax Indentification Number (TIN) of the customer. This is required for tax reporting and compliance purposes.
TaxRegistrationNumber String The tax registration number of the customer. This is required for the customer’s tax records and reporting.
TransactionLimitByDays Int The time limit, in days, for processing the credit memo transaction. This defines how long the credit memo remains valid for applying to customer transactions.
TransactionStatus String The status of the credit memo transaction, indicating whether the transaction is 'Completed', 'Pending', or in any other state as per the system's workflow.

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