ADO.NET Provider for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesCustomerAccountActivitiescreditMemos

Displays credit memos issued to a customer’s account, including on-account memos and standard credit memos.

Columns

Name Type Description
ReceivablesCustomerAccountActivitiesAccountId [KEY] Long The unique identifier for the customer account in the ReceivablesCustomerAccountActivitiescreditMemos table, used to associate credit memo activities with a specific account.
CreditMemoId [KEY] Long The unique identifier of the credit memo in the ReceivablesCustomerAccountActivitiescreditMemos table, used to track individual credit memo transactions.
CreditMemoNumber String The unique number assigned to each credit memo, used for referencing and identifying specific credit memo transactions.
CreditMemoDate Date The date the credit memo was created or issued, representing when the credit memo became effective.
TransactionClass String The classification of the transaction, which could include various types of credit transactions, helping categorize the nature of the credit memo.
AccountingDate Date The accounting date associated with the credit memo, typically representing when the financial impact of the credit memo is recorded in the books.
PurchaseOrder String The purchase order number associated with the credit memo, linking the credit memo to a specific purchase order.
TotalOriginalAmount Decimal The original total amount of the credit memo before any adjustments or payments have been applied.
TotalBalanceAmount Decimal The remaining balance amount of the credit memo, reflecting the amount still available for application after any adjustments.
AvailableAmount Decimal The amount of the credit memo that is still available for future applications or allocations to other transactions.
TransactionType String The type of the transaction, such as credit, refund, or adjustment, used to specify the nature of the credit memo activity.
InstallmentId Long The unique identifier for the installment associated with the credit memo, used to track partial payments or installment-based credit memo applications.
CreditMemoCurrency String The currency code in which the credit memo is issued, indicating the currency used for the credit memo transaction.
CreditMemoStatus String The status of the credit memo, such as 'Open', 'Paid', or 'Cancelled', representing the current state of the credit memo in the system.
CreatedBy String The user who created the credit memo, providing a reference to the individual responsible for initiating the transaction.
CreationDate Datetime The date and time when the credit memo was created in the system, providing an audit trail for when the transaction was recorded.
LastUpdateDate Datetime The date and time when the credit memo was last updated, tracking any changes made to the original record.
LastUpdatedBy String The user who last updated the credit memo, offering accountability and tracking for changes made to the credit memo details.
BillToSiteNumber String The site number for the billing address associated with the credit memo, used for identifying where the credit memo applies.
AccountId Long The account identifier of the customer, linking the credit memo to the customer's account in the ReceivablesCustomerAccountActivitiescreditMemos table.
AccountNumber String The account number associated with the credit memo, used for identifying the customer’s account in the receivables system.
CustomerName String The name of the customer associated with the credit memo, providing clear identification of the customer receiving the credit.
Finder String A search term or reference used to locate specific credit memo records, typically used within the system for querying or filtering data.
TaxpayerIdentificationNumber String The Tax Indentification Number (TIN) of the customer, used for tax reporting and compliance purposes.
TaxRegistrationNumber String The tax registration number associated with the customer, used to identify them for tax and legal purposes in transactions.
TransactionLimitByDays Int The maximum number of days allowed for processing the credit memo transaction, typically used for managing payment terms and limits.
TransactionStatus String The current status of the credit memo transaction, such as 'Pending', 'Completed', or 'Closed', indicating where the credit memo stands in the process.

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