CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesCustomerAccountSiteActivitiescreditMemoApplications

Lists credit memo applications for site-level transactions, allowing offsets or adjustments to outstanding amounts at the site.

Columns

Name Type Description
ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] Long The unique identifier for the bill-to site use in the customer account, indicating how the site is utilized for billing and credit memo applications.
ApplicationId [KEY] Long The unique identifier for the credit memo application, used to reference and track the application of credit memos to customer accounts.
ApplicationDate Date The date when the credit memo application is recorded, providing a timestamp for when the application took place.
ApplicationAmount Decimal The amount of the credit memo applied to the customer's account, reflecting the monetary value of the credit memo allocation.
ApplicationStatus String The current status of the credit memo application, such as 'Pending', 'Completed', or 'Failed', indicating whether the application process was successful.
ReferenceInstallmentId Long The unique identifier for the installment associated with the reference transaction, used to link the credit memo application to a specific installment.
ReferenceTransactionNumber String The transaction number of the reference transaction to which the credit memo is applied, helping to link the credit memo with the originating transaction.
ReferenceTransactionId Long The unique identifier for the reference transaction related to the credit memo application, used for precise tracking and reconciliation.
AccountingDate Date The date assigned to the credit memo application for accounting purposes, ensuring accurate financial reporting and reconciliation.
CreditMemoId Long The unique identifier for the credit memo being applied, used to track the specific credit memo involved in the application process.
CreditMemoNumber String The number assigned to the credit memo, typically used for identification and tracking in reporting and reconciliation.
CreditMemoStatus String The status of the credit memo application, such as 'Approved', 'Pending', or 'Rejected', indicating the current state of the credit memo.
EnteredCurrency String The currency in which the credit memo application is entered, essential for handling multi-currency transactions and conversions.
TransactionType String The type of transaction being applied, indicating whether the application is related to a specific type of customer transaction (for example, payment, charge, adjustment).
ActivityName String The name or description of the activity being recorded, such as 'Credit Memo Application' or similar terms.
IsLatestApplication String Indicates whether this application is the most recent credit memo application for the customer account. Values typically are 'Yes' or 'No'.
CreationDate Datetime The date and time when the credit memo application record was created, providing an audit trail for when the action took place.
CreatedBy String The user who created the credit memo application record, ensuring accountability and traceability of the action.
LastUpdateDate Datetime The date and time when the credit memo application record was last updated, providing a history of modifications made to the record.
LastUpdatedBy String The user who last updated the credit memo application record, ensuring accountability for changes made after the original creation.
BillToSiteNumber String The number identifying the bill-to site where the credit memo application is being processed, providing location-specific information for billing.
ReferenceTransactionStatus String The status of the reference transaction, such as 'Paid', 'Unpaid', or 'Partially Paid', indicating the state of the transaction being referenced.
AccountNumber String The account number of the customer to which the credit memo is applied, helping to identify the specific customer account.
BillToSiteUseId Long The unique identifier for the bill-to site use in the customer account, linking the site use to the credit memo application.
CustomerName String The name of the customer associated with the credit memo application, providing customer-specific information for transaction tracking.
Finder String A search term or identifier used to locate the specific credit memo application record, enhancing data retrieval capabilities.
TaxpayerIdentificationNumber String The Tax Indentification Number (TIN) of the customer, essential for tax reporting and compliance purposes.
TaxRegistrationNumber String The tax registration number of the customer, used for regulatory and tax purposes to identify the customer's tax obligations.
TransactionLimitByDays Int The maximum number of days allowed for processing the transaction related to the credit memo application, defining the time frame for transaction validity.
TransactionStatus String The status of the transaction associated with the credit memo application, such as 'Completed', 'Pending', or 'Failed', providing insight into the transaction's progress.

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