ReceivablesMiscellaneousCashReceiptDistribution
The miscellaneous cash receipt distribution is the process of allocating or distributing cash receipts received from miscellaneous sources across various accounts or categories within the accounts receivables. Miscellaneous cash refers to nonrevenue income, such as stock revenue, interest income, and investment income. This distribution ensures that the cash received is appropriately applied to outstanding invoices, credits, or other receivable entries, reflecting accurate financial information within the organization's accounting system. The miscellaneous cash distribution includes details such as receipt type, status, business unit, receipt method, receipt number, receivables activity, distribution set, reference, currency, entered amount, accounted amount, tax rate code, tax account, receipt date, accounting entries, and accounting date. The miscellaneous cash distribution stores one record for each receipt distribution.
Business Views
** Available for extracting data- receivablesMiscellaneousCashReceiptDistributionsExtract**
The miscellaneous cash receipt distribution is the process of allocating or distributing cash receipts received from miscellaneous sources across various accounts or categories within the accounts receivables. Miscellaneous cash refers to nonrevenue income, such as stock revenue, interest income, and investment income. This distribution ensures that the cash received is appropriately applied to outstanding invoices, credits, or other receivable entries, reflecting accurate financial information within the organization's accounting system. The miscellaneous cash distribution includes details such as receipt type, status, business unit, receipt method, receipt number, receivables activity, distribution set, reference, currency, entered amount, accounted amount, tax rate code, tax account, receipt date, accounting entries, and accounting date. The miscellaneous cash distribution stores one record for each receipt distribution.
Label, Plural Label
Receivables Miscellaneous Cash Receipt Distributions, Receivables Miscellaneous Cash Receipt Distributions
Data Source
Read-optimized data store
Fields
- accountedAmount (big-decimal)
The distribution conversion date.
Label
Accounted Amount
Properties
- not nullable
- accountingDate (date)
The accounting date of the miscellaneous cash distribution.
Label
Accounting Date
Properties
- not nullable
- amount (big-decimal)
The amount of the miscellaneous cash distribution.
Label
Amount
Properties
- not nullable
- applyDate (date)
The application date of the miscellaneous cash distribution.
Label
Apply Date
Properties
- searchable
- sortable
- not nullable
- budgetaryControlCompleteFlag (boolean)
Indicates whether to interface standard receipt accounting information from General Ledger to Budgetary Control.
Label
Budgetary Control Complete
- budgetaryControlFlag (boolean)
Indicates whether budgeting is enabled on the ledger associated with the standard receipt and the details populated in Budgetary Control.
Label
Budgetary Control
- comments (string)
The user-entered comments for the miscellaneous cash distribution.
Label
Comments
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- fundsStatusCode (enumeration: FundsStatus)
Code that indicates the status of the funds update on the miscellaneous cash distributions. 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
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.
-
- generalLedgerPostedDate (date)
The posting date of the miscellaneous cash distribution.
Label
General Ledger Posted Date
- miscellaneousCashDistributionId (int64)
The primary key of the miscellaneous cash distribution.
Label
Miscellaneous Cash Distribution ID
Properties
- searchable
- sortable
- not nullable
- percentage (big-decimal)
The percentage of the total receipt amount for this miscellaneous cash distribution.
Label
Percentage
- 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
- searchable
- reversalGeneralLedgerDate (date)
The reversal accounting date of the miscellaneous cash distribution.
Label
Reversal General Ledger Date
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- ussglTransactionCode (string)
Label
USSGL Transaction Code
- ussglTransactionCodeContext (string)
Label
USSGL Transaction Code Context
Reference Object
- 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)
- businessUnit (BusinessUnit)
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- 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)
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)
- receipt (ReceivablesReceipt)
The receivables receipt contains information about receipts, including receipt number, receipt method, receipt type, status, business unit, customer, receipt date, amount, and total applied amount. One record is created for each receipt.
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)
- 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)
- accountedAmount (big-decimal)