Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesCustomerAccountActivitiesstandardReceipts

Shows standard receipts recorded for a customer’s account, reflecting payments received for goods or services.

Columns

Name Type Description
ReceivablesCustomerAccountActivitiesAccountId [KEY] Long The unique identifier of the customer account in the ReceivablesCustomerAccountActivitiesstandardReceipts table, used to link receipt records with specific customer accounts.
StandardReceiptId [KEY] Long The unique identifier for each standard receipt, used to track and manage the individual receipts that apply to customer transactions.
ReceiptNumber String The number assigned to the receipt for identification and tracking purposes, ensuring that receipts can be easily referenced.
BusinessUnit String The business unit responsible for processing the receipt, typically used to organize and categorize receipts based on the organizational structure.
LegalEntity String The legal entity under which the receipt is processed, used to distinguish between different business entities within an organization.
ReceiptDate Date The date when the receipt was issued or received, used for recording the timing of payment and financial transaction.
AccountingDate Date The accounting date associated with the receipt, used for determining when the receipt is recognized in the financial records.
UnappliedAmount Decimal The amount of the receipt that has not yet been applied to any specific transaction or account balance.
AvailableAmount Decimal The amount of the receipt that is available for application against outstanding transactions or balances.
ReceiptMethod String The method used to process the receipt, such as cash, check, credit card, or electronic transfer.
ProcessStatus String The current status of the receipt in the processing workflow, indicating whether the receipt is completed, pending, or requires further action.
State String The state of the receipt, reflecting its current condition in the system, such as 'New', 'Pending', or 'Applied'.
Currency String The currency used for the receipt transaction, indicating the denomination in which the payment was made.
Amount Decimal The total amount of the receipt, reflecting the total payment made by the customer.
DocumentNumber Long The unique document number associated with the receipt, used for tracking and reference in accounting and transaction systems.
CreatedBy String The user who created the receipt record in the system, used for tracking the source of data entry.
CreationDate Datetime The date and time when the receipt record was created in the system.
LastUpdateDate Datetime The date and time when the receipt record was last updated in the system.
LastUpdatedBy String The user who last updated the receipt record, helping track modifications or changes to the receipt information.
CustomerSite String The customer site associated with the receipt, used to specify the location where the transaction occurred or where payment is applied.
AccountId Long The unique identifier for the customer account to which the receipt is applied, helping link receipts to customer-specific records.
AccountNumber String The account number for the customer account, used to uniquely identify the customer’s account for receipt and payment application.
CustomerName String The name of the customer associated with the receipt, used for identifying the paying party.
Finder String A search term or reference that helps locate specific receipt records within the system, improving data retrieval and reporting.
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 legal and tax reporting in certain jurisdictions.
TransactionLimitByDays Int The maximum number of days allowed for processing a receipt transaction, used to enforce time-based transaction limits.
TransactionStatus String The status of the transaction associated with the receipt, indicating whether it is 'Pending', 'Completed', 'Failed', or in another state.

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