Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesCustomerAccountActivitiesstandardReceiptApplications

Lists standard receipt applications for a customer’s account activities, showing how receipts are allocated to open items.

Columns

Name Type Description
ReceivablesCustomerAccountActivitiesAccountId [KEY] Long The unique identifier for the customer account in the ReceivablesCustomerAccountActivitiesstandardReceiptApplications table, used to associate receipt activities with a specific customer account.
ApplicationId [KEY] Long The unique identifier for each receipt application, used to track individual receipts and their applications to customer accounts.
ApplicationDate Date The date when the receipt application was processed or recorded, representing when the payment was applied to the customer account.
ApplicationAmount Decimal The amount of the receipt applied to the customer account, representing the value of the payment made by the customer.
ApplicationStatus String The current status of the receipt application, indicating whether it is 'Pending', 'Completed', or 'Failed', and helping track the progress of the payment application.
AccountingDate Date The date on which the receipt is recorded in the accounting system, reflecting the financial posting date for the receipt.
ReferenceInstallmentId Long The unique identifier for the installment referenced by the receipt application, indicating which installment the payment is applied to.
ReferenceTransactionNumber String The number of the reference transaction associated with the receipt application, used to link the payment to the transaction being settled.
ReferenceTransactionId Long The unique identifier of the reference transaction associated with the receipt, used to track which transaction the receipt application pertains to.
ActivityName String The name or description of the activity related to the receipt application, used for categorizing the type of transaction or action.
StandardReceiptId Long The unique identifier for the standard receipt record, linking the receipt application to the receipt document.
ReceiptNumber String The unique receipt number assigned to the payment, used for identification and reference in financial reporting and transaction tracking.
EnteredCurrency String The currency code in which the receipt is entered, indicating the currency in which the payment was made.
ReceiptMethod String The method by which the receipt was made, such as cash, cheque, or bank transfer, indicating how the customer paid.
ProcessStatus String The status of the receipt application processing, indicating whether it is 'Processed', 'Pending', or 'Failed'.
IsLatestApplication String A flag indicating whether the current receipt application is the most recent application for the account or transaction.
CreatedBy String The user who created the receipt application record, providing accountability and auditability for the receipt process.
CreationDate Datetime The date and time when the receipt application record was created in the system.
LastUpdateDate Datetime The date and time when the receipt application record was last updated, providing tracking for changes to the record.
LastUpdatedBy String The user who last updated the receipt application record, allowing for audit tracking of modifications.
CustomerSite String The customer site associated with the receipt application, used to specify the location or site for the customer involved in the transaction.
ReferenceTransactionStatus String The status of the reference transaction associated with the receipt application, indicating whether the referenced transaction is paid, partially paid, or outstanding.
AccountId Long The account identifier for the customer account, used to link the receipt application to the customer’s account in the receivables system.
AccountNumber String The account number associated with the customer’s account in the receivables system, providing a reference for the customer’s financial transactions.
CustomerName String The name of the customer associated with the receipt application, used for identifying the customer making the payment.
Finder String A search term or reference used to locate specific receipt application records in the system.
TaxpayerIdentificationNumber String The Tax Indentification Number (TIN) associated with 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 purposes and in accordance with local tax regulations.
TransactionLimitByDays Int The maximum number of days allowed for processing a receipt application, used for managing payment terms and limits for the transaction.
TransactionStatus String The status of the receipt application transaction, indicating whether it is 'Successful', 'Failed', or 'Pending', and reflecting the completion status of the receipt process.

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