CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications

Tracks standard receipt applications at the site level, mapping applied payments to site-specific invoices or transactions.

Columns

Name Type Description
ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] Long The unique identifier for the bill-to site use in the context of standard receipt applications. This links a specific bill-to site to receipt activities.
ApplicationId [KEY] Long The unique identifier of the application of a standard receipt to a transaction or account. It is used to track and manage the application of customer payments.
ApplicationDate Date The date when the standard receipt application was made. This date is important for accounting and reporting purposes.
ApplicationAmount Decimal The amount applied to the transaction or account in the standard receipt application. It reflects the part of the receipt being allocated.
ApplicationStatus String The status of the receipt application, such as 'Applied', 'Pending', or 'Unapplied'.
AccountingDate Date The accounting date when the application is posted. This date is used for financial reporting and journal entries.
ReferenceInstallmentId Long The identifier for the installment associated with the receipt application. This links the application to specific installments for payment.
ReferenceTransactionNumber String The reference number of the transaction to which the receipt is applied. This helps in tracking and reconciling payment applications.
ReferenceTransactionId Long The identifier for the specific transaction to which the receipt is applied. It ensures that payments are linked to the correct transaction.
ActivityName String The name or description of the activity that triggered the receipt application, such as 'Payment', 'Adjustment', or 'Refund'.
StandardReceiptId Long The unique identifier for the standard receipt. This links the application to the specific receipt record.
ReceiptNumber String The receipt number associated with the standard receipt application. This is used for tracking and identifying the receipt in the system.
EnteredCurrency String The currency in which the receipt application was made. This ensures that transactions in different currencies are handled correctly.
ReceiptMethod String The method used to make the receipt payment, such as 'Cash', 'Check', or 'Wire Transfer'.
ProcessStatus String The status of the process for the receipt application, indicating whether it's in progress, completed, or pending further action.
IsLatestApplication String Indicates whether this application is the latest for the given transaction. This helps in identifying and tracking the most recent application.
CreatedBy String The name or ID of the user who created the receipt application. It is used for audit purposes.
CreationDate Datetime The date and time when the receipt application was created. This timestamp helps track when the application occurred.
LastUpdateDate Datetime The date and time when the receipt application was last updated. This helps track any changes or updates to the application.
LastUpdatedBy String The name or ID of the user who last updated the receipt application. It is used for audit purposes.
CustomerSite String The site number for the customer to which the receipt application is linked. This helps track which location is making the payment.
ReferenceTransactionStatus String The status of the reference transaction to which the receipt is applied. This could be 'Open', 'Closed', or 'In Progress'.
AccountNumber String The customer’s account number associated with the receipt application. This is used to track which customer made the payment.
BillToSiteNumber String The site number for the bill-to address where the receipt is applied. This helps track the billing location for the customer.
BillToSiteUseId Long The identifier for the use of the bill-to site in relation to the receipt application. It helps in linking the receipt application to the right billing location.
CustomerName String The name of the customer who made the payment. This is used to identify the payer in the system.
Finder String A search term used to locate and retrieve receipt application records based on specific criteria.
TaxpayerIdentificationNumber String The unique Tax Indentification Number (TIN) of the customer. This is used for tax reporting and compliance purposes.
TaxRegistrationNumber String The tax registration number of the customer. This number is required for tax-related activities and compliance.
TransactionLimitByDays Int The maximum number of days by which the receipt application can be processed based on the transaction policy.
TransactionStatus String The current status of the transaction, indicating whether it is 'Completed', 'Pending', or 'In Progress'.

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