CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers

Highlights instances where a different customer remits payment on behalf of the primary customer’s outstanding transactions.

Columns

Name Type Description
ReceivablesCustomerAccountActivitiesAccountId [KEY] Long The unique identifier for the customer account linked to transactions paid by other customers, allowing for accurate tracking of related transactions.
ApplicationId [KEY] Long The unique identifier of the application associated with the transaction, used to track how payments are applied to open balances.
ApplicationDate Date The date when the payment application was made, providing the timeline for how and when the payment was allocated.
ApplicationAmount Decimal The total amount of money applied to the customer account, reflecting how much of the payment was credited against outstanding balances.
ApplicationStatus String The status of the application, such as 'Pending', 'Applied', or 'Unapplied', indicating the current state of the payment.
AccountingDate Date The date when the payment is recorded in the system for accounting purposes, typically representing the date the payment was processed.
ReferenceInstallmentId Long The identifier of the installment related to the transaction, enabling the linkage of payments to specific installments.
ReferenceTransactionNumber String The reference number of the original transaction being paid, helping to tie the payment to the corresponding transaction.
ReferenceTransactionId Long The unique identifier of the transaction being settled by the payment, used for detailed tracking and reconciliation.
StandardReceiptId Long The unique identifier of the receipt generated for the payment, allowing for easy reference to the corresponding receipt.
ReceiptNumber String The unique number assigned to the receipt, used for identification and to track the payment transaction in the system.
EnteredCurrency String The currency in which the payment was originally entered, ensuring accurate currency handling and conversion.
ReceiptMethod String The method used to make the payment, such as 'Check', 'Wire Transfer', or 'Credit Card', indicating the form of payment.
ProcessStatus String The status of the payment processing, such as 'Completed', 'Pending', or 'Failed', providing insight into the transaction's processing state.
IsLatestApplication String Indicates whether this is the latest payment application, helping to track the most recent transaction activity on the account.
CreatedBy String The user who created the payment application record, providing accountability for the entry of payment data.
CreationDate Datetime The date and time when the payment application record was created, serving as a reference point for the timing of payment activities.
LastUpdateDate Datetime The date and time when the payment application record was last updated, providing a history of modifications.
LastUpdatedBy String The user who last updated the payment application record, ensuring accountability for any changes made.
ReferenceTransactionStatus String The status of the referenced transaction, providing information on whether the transaction being paid is open, closed, or pending.
AccountId Long The unique identifier for the account associated with the transaction, helping to link payment applications to customer accounts.
AccountNumber String The account number associated with the payment, used for identification and tracking of customer financial transactions.
CustomerName String The name of the customer linked to the payment, helping to identify which customer account the payment is being applied to.
Finder String A reference or search term used to help locate specific payment application records, improving efficiency in transaction management.
TaxpayerIdentificationNumber String The Tax Indentification Number (TIN) of the customer, used for tax reporting and compliance purposes.
TaxRegistrationNumber String The tax registration number of the customer, required for certain tax filings and reporting.
TransactionLimitByDays Int The maximum number of days allowed for processing the payment application, enforcing time constraints for payment processing.
TransactionStatus String The status of the transaction related to the payment, such as 'Pending', 'Completed', or 'Failed', indicating the current state of the transaction.

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