ReceivablesReceiptActivity
The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.
Business Views
** Available for extracting data- receivablesReceiptActivitiesExtract**
The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.
Label, Plural Label
Receipt Activities, Receipt Activities
Data Source
Read-optimized data store
Fields
- accountedAmountAppliedFrom (big-decimal)
The portion of the receipt amount that's converted to the ledger currency.
Label
Accounted Amount Applied From
Properties
- inherited
- not nullable
- accountedAmountAppliedTo (big-decimal)
The portion of the transaction amount that's converted to the ledger currency.
Label
Accounted Amount Applied To
Properties
- inherited
- accountedEarnedDiscountTaken (big-decimal)
The earned discount equivalent in the ledger currency converted using the transaction conversion rate.
Label
Accounted Earned Discount Taken
Properties
- inherited
- accountedUnearnedDiscountTaken (big-decimal)
The unearned discount equivalent in the ledger currency converted using the transaction conversion rate.
Label
Accounted Unearned Discount Taken
Properties
- inherited
- accountingDate (date)
The date when the application will post to the General Ledger.
Label
Accounting Date
Properties
- inherited
- not nullable
- amountAppliedFrom (big-decimal)
For cross-currency applications only, the total applied amount in the receipt currency.
Label
Amount Applied From
Properties
- inherited
- applicationDate (date)
The receipt application date.
Label
Application Date
Properties
- inherited
- searchable
- sortable
- not nullable
- applicationPostable (enumeration: PostableIndicator)
The option that indicates whether the item can be posted to General Ledger.
Label
Application Postable
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: PostableIndicator
Properties
- inherited
Valid Values
- N
- Y
-
- applicationReferenceNumber (string)
The displayed reference number used for special applications or receipt-to-receipt applications.
Label
Application Reference Number
Properties
- inherited
- applicationReferenceReason (string)
The application reason code whose context is determined by the application reference type value.
Label
Application Reference Reason
Properties
- inherited
- applicationReferenceType (enumeration: ApplicationReferenceType)
The application reference type that determines the context for the application reference number. A list of accepted values is defined in the lookup type APPLICATION_REF_TYPE.
Label
Application Reference Type
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ApplicationReferenceType
Properties
- inherited
Valid Values
- AP_REFUND_REQUEST
- CHARGEBACK
- CLAIM
- MISC_RECEIPT
- TRANSACTION
-
- applicationRule (string)
The code used to identify which SQL statements in the modules created this record.
Label
Application Rule
Properties
- inherited
- not nullable
- applicationType (enumeration: ApplicationType)
The lookup code used to identify the Receivable Application type. A list of accepted values is defined in the lookup type APPLICATION_TYPE lookup code.
Label
Application Type
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ApplicationType
Properties
- inherited
- searchable
- not nullable
Valid Values
- BR_FUND_RECOVERY
- CASH
- CBAC
- CCCHARGEBACK
- CCREFUND
- CLAIM_INVESTIGATION
- CM
- CMAC
- ONACC
- PREPAY
For a complete list of valid values, see the ApplicationType enumeration type.
-
- appliedAmount (big-decimal)
For ledger currency transactions and receipts, the total applied amount in the ledger currency. For cross-currency transactions and receipts, the total applied amount in the transaction currency.
Label
Applied Amount
Properties
- inherited
- not nullable
- budgetaryControl (enumeration: BudgetaryControlIndicator)
Indicates whether budgeting is enabled on the ledger associated with the standard receipt and its details interfaced to Budgetary Control.
Label
Budgetary Control
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BudgetaryControlIndicator
Properties
- inherited
Valid Values
- N
- Y
-
- budgetaryControlCompleted (enumeration: SubledgerBudgetaryControlCompleteIndicator)
Indicates whether to interface standard receipt accounting information from General Ledger to Budgetary Control.
Label
Budgetary Control Completed
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: SubledgerBudgetaryControlCompleteIndicator
Properties
- inherited
Valid Values
- N
- Y
-
- chargesEarnedDiscount (big-decimal)
The amount of the earned discount taken from the remaining open amount on the item.
Label
Charges Earned Discount
Properties
- inherited
- chargesUnearnedDiscount (big-decimal)
The amount of the unearned discount taken from the remaining open amount on the item.
Label
Charges Unearned Discount
Properties
- inherited
- comments (string)
The user comments for the receipt application.
Label
Comments
Properties
- inherited
- confirmed (enumeration: ConfirmedIndicator)
The option that indicates whether the cash receipt is confirmed. The value No indicates that the cash receipt isn't confirmed. Always use NVL--CONFIRMED_FLAG is Y--when checking this column.
Label
Confirmed
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ConfirmedIndicator
Properties
- inherited
Valid Values
- N
- Y
-
- createdBy (string)
The user who created the Receivable application.
Label
Created By
Properties
- inherited
- not nullable
- crossCurrencyRate (big-decimal)
For cross-currency applications only, the conversion rate used to convert the amount applied in the transaction currency to the amount applied in the receipt currency.
Label
Cross-Currency Rate
Properties
- inherited
- customerReason (string)
The customer reason for deductions and chargebacks associated with an application.
Label
Customer Reason
Properties
- inherited
- searchable
- sortable
- customerReference (string)
The reference provided by the customer for the Receivable application.
Label
Customer Reference
Properties
- inherited
- daysLate (int64)
The number of days between the Receivable application date and the transaction due date.
Label
Days Late
Properties
- inherited
- earnedDiscount (big-decimal)
The amount of earned discount taken toward the application.
Label
Earned Discount
Properties
- inherited
- freightAmountApplied (big-decimal)
The amount applied to the transaction freight.
Label
Freight Amount Applied
Properties
- inherited
- freightEarnedDiscount (big-decimal)
The amount of earned discount taken from the remaining freight amount for the item.
Label
Freight Earned Discount
Properties
- inherited
- freightUnearnedDiscount (big-decimal)
The amount of unearned discount taken from the remaining freight amount for the item.
Label
Freight Unearned Discount
Properties
- inherited
- fundsStatusCode (enumeration: FundsStatus)
Code that identifies the status of the funds update on the receipt application. A list of valid values is defined in the ORA_XCC_FUNDS_STATUS lookup type.
Label
Funds Status Code
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: FundsStatus
Properties
- inherited
Valid Values
- ORA_CAPTURING_EVENT
- ORA_ERROR
- ORA_FAILED
- ORA_INTERFACE_ERROR
- ORA_IN_PROCESS
- ORA_NOT_APPLICABLE
- ORA_NOT_INITIATED
- ORA_PARTIAL
- ORA_PASSED
- ORA_PROCESS_ERROR
For a complete list of valid values, see the FundsStatus enumeration type.
-
- latestApplication (enumeration: DisplayIndicator)
The option that indicates whether the application against the transaction is the latest.
Label
Latest Application
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: DisplayIndicator
Properties
- inherited
- not nullable
Valid Values
- N
- Y
-
- lineAmountApplied (big-decimal)
The amount of the receipt applied to the transaction line amount.
Label
Line Amount Applied
Properties
- inherited
- lineEarnedDiscount (big-decimal)
The amount of the earned discount taken from the remaining open amount on the transaction line.
Label
Line Earned Discount
Properties
- inherited
- lineUnearnedDiscount (big-decimal)
The amount of the unearned discount taken from the remaining open amount on the transaction line.
Label
Line Unearned Discount
Properties
- inherited
- paymentSetId (int64)
The identifier of the payment set of the prepayment application.
Label
Payment Set ID
Properties
- inherited
- postedDate (date)
The date when the application was posted to the General Ledger.
Label
Posted Date
Properties
- inherited
- postedFlag (boolean)
Indicates whether the record is posted to General Ledger. If true, then the record is posted to General Ledger. If false, then the record isn't posted.
Label
Posted
Properties
- inherited
- searchable
- receivableApplicationId (int64)
The identifier of the receipt application to the transaction.
Label
Receivable Application ID
Properties
- inherited
- searchable
- sortable
- not nullable
- receivablesChargesAmountApplied (big-decimal)
The amount of the Receivables charges applied to the transaction.
Label
Receivables Charges Amount Applied
Properties
- inherited
- reversalAccountingDate (date)
The accounting date for both reversed receipts and the accompanying reverse activity.
Label
Reversal Accounting Date
Properties
- inherited
- secondaryApplicationReferenceNumber (string)
The receipt application reference number displayed to the user.
Label
Secondary Application Reference Number
Properties
- inherited
- status (enumeration: PaymentType)
The lookup code used to display the status of the receipt application.
Label
Status
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: PaymentType
Properties
- inherited
- searchable
- not nullable
Valid Values
- ACC
- ACTIVITY
- APP
- OTHER ACC
- UNAPP
- UNID
-
- taxAmountApplied (big-decimal)
The amount of tax associated to the receipt.
Label
Tax Amount Applied
Properties
- inherited
- taxEarnedDiscount (big-decimal)
The amount of earned discount taken from the remaining tax amount for the item.
Label
Tax Earned Discount
Properties
- inherited
- taxUnearnedDiscount (big-decimal)
The amount of unearned discount taken from the remaining tax amount for the item.
Label
Tax Unearned Discount
Properties
- inherited
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- inherited
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- inherited
- searchable
- not nullable
- unearnedDiscountTaken (big-decimal)
The amount of unearned discount taken for the receipt application.
Label
Unearned Discount Taken
Properties
- inherited
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- inherited
- not nullable
- ussglTransactionCodeContext (string)
The context value for the USSGL Transaction Code Flexfield.
Label
USSGL Transaction Code Context
Properties
- inherited
Reference Object
- activity (ReceivablesActivity)
A receivables activity represents various transactions and events that occur within the accounts receivables of a business. This activity encompasses a wide range of actions related to managing and processing receivables. The receivables activity includes details such as business unit, name, description, activity type, active option, GL account source, tax rate code source, and distribution set for miscellaneous receipts. Receivables activities provide default accounting information for all activities in Receivables other than transactions and receipts. The receivables activity types are Adjustment, Bank Error, Bills Receivable Funds Recovery, Credit Card Chargeback, Credit Card Refund, Earned Discount, Late Charges, Miscellaneous Cash, Payment Netting, Prepayments, Receipt Write-offs, Refund, Short Term Debt, and Unearned Discount.
Business Object
ReceivablesActivityFields
- businessUnitId (int64)
The identifier of the business unit associated with the receivables activity.
Label
Business Unit ID
Properties
- searchable
- sortable
- not nullable
- receivablesTransactionId (int64)
The identifier of the receivables activity.
Label
Receivables Transaction ID
Properties
- searchable
- sortable
- not nullable
- businessUnitId (int64)
- appliedCustomerTransaction (ReceivablesTransaction)
The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.
Business Object
ReceivablesTransactionFields
- customerTransactionId (int64)
The identifier of the transaction used when creating the transaction.
Label
Customer Transaction ID
Properties
- searchable
- sortable
- not nullable
- customerTransactionId (int64)
- appliedPaymentSchedule (ReceivablesTransactionPaymentSchedule)
A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.
Business Object
ReceivablesTransactionPaymentScheduleFields
- paymentScheduleId (int64)
The identifier of the payment schedule.
Label
Payment Schedule ID
Properties
- searchable
- sortable
- not nullable
- paymentScheduleId (int64)
- appliedReceiptActivity (ReceivablesReceiptActivity)
The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.
Business Object
ReceivablesReceiptActivityFields
- receivableApplicationId (int64)
The identifier of the receipt application to the transaction.
Label
Receivable Application ID
Properties
- inherited
- searchable
- sortable
- not nullable
- receivableApplicationId (int64)
- balanceForwardBillTransactionAdjustment (BalanceForwardBill)
The Balance Forward Bill Transaction business object consolidates the open transactions belonging to a customer account or customer site into a single bill that's delivered on a regular basis. The balance forward bill contains the previous opening balance, current charges and activities, payments received during the last billing period, and current total outstanding balance.
Business Object
BalanceForwardBillFields
- consolidatedInvoiceId (int64)
The identifier of the balance forward bill.
Label
Consolidated Invoice ID
Properties
- searchable
- sortable
- not nullable
- consolidatedInvoiceId (int64)
- balanceForwardBillTransactionApplication (BalanceForwardBill)
The Balance Forward Bill Transaction business object consolidates the open transactions belonging to a customer account or customer site into a single bill that's delivered on a regular basis. The balance forward bill contains the previous opening balance, current charges and activities, payments received during the last billing period, and current total outstanding balance.
Business Object
BalanceForwardBillFields
- consolidatedInvoiceId (int64)
The identifier of the balance forward bill.
Label
Consolidated Invoice ID
Properties
- searchable
- sortable
- not nullable
- consolidatedInvoiceId (int64)
- billsReceivableTransaction (ReceivablesTransaction)
The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.
Business Object
ReceivablesTransactionFields
- customerTransactionId (int64)
The identifier of the transaction used when creating the transaction.
Label
Customer Transaction ID
Properties
- searchable
- sortable
- not nullable
- customerTransactionId (int64)
- billsReceivableTransactionHistory (BillsReceivableTransactionHistory)
The Bills Receivable Transaction History business object provides the details of each bills receivable transaction, including activities and the life cycle of bills receivable events.
Business Object
BillsReceivableTransactionHistoryFields
- transactionHistoryId (int64)
The identifier of the transaction history for a bill receivable.
Label
Bills Receivable Transaction History Identifier
Properties
- searchable
- sortable
- not nullable
- transactionHistoryId (int64)
- budgetaryControlValidationRequest (BudgetaryControlValidationRequest)
A budgetary control validation request contains the information of each request, such as the type of transaction being validated and the validation result.
Business Object
BudgetaryControlValidationRequestFields
- validationRequestId (int64)
The unique identifier of the budgetary control validation request.
Label
Validation Request ID
Properties
- searchable
- sortable
- not nullable
- validationRequestId (int64)
- cashReceiptHistory (ReceivablesReceiptHistory)
Business Object
ReceivablesReceiptHistoryFields
- cashReceiptHistoryId (int64)
The identifier of the historical cash receipt entry.
Label
Cash Receipt History ID
Properties
- searchable
- sortable
- not nullable
- cashReceiptHistoryId (int64)
- customerTransaction (ReceivablesTransaction)
Business Object
ReceivablesTransactionFields
- customerTransactionId (int64)
The identifier of the transaction used when creating the transaction.
Label
Customer Transaction ID
Properties
- searchable
- sortable
- not nullable
- customerTransactionId (int64)
- earnedDiscountAccount (GeneralLedgerAccount)
A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- chartOfAccountsId (string)
- exceptionReason (ERPLookupCode)
The reason a receipt was applied manually to the transaction.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- generalLedgerAccount (GeneralLedgerAccount)
A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- chartOfAccountsId (string)
- ledger (Ledger)
A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.
Business Object
LedgerFields
- ledgerId (int64)
The unique identifier of the ledger for which the accounting entry is created.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
- ledgerId (int64)
- paymentSchedule (ReceivablesTransactionPaymentSchedule)
A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.
Business Object
ReceivablesTransactionPaymentScheduleFields
- paymentScheduleId (int64)
The identifier of the payment schedule.
Label
Payment Schedule ID
Properties
- searchable
- sortable
- not nullable
- paymentScheduleId (int64)
- receipt (ReceivablesReceipt)
Business Object
ReceivablesReceiptFields
- cashReceiptId (int64)
The identifier of the cash receipt.
Label
Cash Receipt ID
Properties
- searchable
- sortable
- not nullable
- cashReceiptId (int64)
- receivablesReceiptHistory (ReceivablesReceiptHistory)
The receipt history provides information about each step in the lifecycle of a receipt, including history status, accounting date, entered amount, accounted amount, conversion rate, reversal category, and reversal reason.
Business Object
ReceivablesReceiptHistoryFields
- cashReceiptHistoryId (int64)
The identifier of the historical cash receipt entry.
Label
Cash Receipt History ID
Properties
- searchable
- sortable
- not nullable
- cashReceiptHistoryId (int64)
- remittanceReference (ReceivablesRemittanceReference)
The Receivables Receipt Remittance Reference business object provides the number and document reference used to match receipts to transactions.
Business Object
ReceivablesRemittanceReferenceFields
- remittanceReferenceId (int64)
Identifier of the remittance reference.
Label
Remittance Reference Identifier
Properties
- creatable
- searchable
- sortable
- not nullable
- updatable
- remittanceReferenceId (int64)
- ruleSet (ReceivablesApplicationRuleSet)
The Receivables Application Rule Set business object provides the details of how a payment applied to a transaction reduces the open balance of the line, tax, freight, and late charge amounts on the transaction.
Business Object
ReceivablesApplicationRuleSetFields
- ruleSetId (int64)
The identifier of the application rule set.
Label
Rule Set ID
Properties
- searchable
- sortable
- not nullable
- ruleSetId (int64)
- secondaryApplicationReferenceType (ERPLookupCode)
The identifier of the receipt application reference type that determines the context for the SECONDARY_APPLICATION_REF_ID and SECONDARY_APPLICATION_REF_NUM columns. A list of accepted values is defined in the lookup type APPLICATION_REF_TYPE.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- subledgerAccountingEvent (SubledgerAccountingEvent)
A subledger accounting event contains all information related to a specific accounting event and the transactions linked to the event which are used to generate accounting entries. It stores details associated with the accounting event such as the associated accounting event identifier, application identifier, event type, event status, event processing status, and other information associated with the accounting event.
Business Object
SubledgerAccountingEventFields
- eventId (int64)
The unique identifier of the accounting event within an application and event class.
Label
Event Identifier
Properties
- searchable
- sortable
- not nullable
- eventId (int64)
- transactionLine (ReceivablesTransactionLine)
A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.
Business Object
ReceivablesTransactionLineFields
- customerTransactionLineId (int64)
The identifier of the Receivable transaction line.
Label
Customer Transaction Line ID
Properties
- searchable
- sortable
- not nullable
- customerTransactionLineId (int64)
- unearnedDiscountAccount (GeneralLedgerAccount)
A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.
Business Object
GeneralLedgerAccountFields
- chartOfAccountsId (string)
The unique identifier of the chart of accounts.
Label
Chart of Accounts
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- chartOfAccountsId (string)
- accountedAmountAppliedFrom (big-decimal)