Oracle Fusion · Data dictionary
AR_CASH_RECEIPTS_ALL
ReceivablesUsed in 9 subject areas25 reporting columns
Receivables (AR), customer cash receipts.
Primary key: CASH_RECEIPT_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_VALUE_DATE | ● | Actual value date. | |
| AMOUNT | ● | Amount. | |
| ANTICIPATED_CLEARING_DATE | ● | Anticipated clearing date. | |
| CASH_RECEIPT_ID | PK | ○ | Identifier for the cash receipt. |
| COMMENTS | ● | Comments. | |
| CONFIRMED_FLAG | ● | Indicator (Y/N) for the confirmed. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUSTOMER_RECEIPT_REFERENCE | ● | Customer receipt reference. | |
| DEPOSIT_DATE | ● | Deposit date. | |
| DOC_SEQUENCE_VALUE | ● | Doc sequence value. | |
| EXCHANGE_DATE | ● | Exchange date. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| FACTOR_DISCOUNT_AMOUNT | ● | Factor discount amount. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MISC_PAYMENT_SOURCE | ● | Misc payment source. | |
| POSTMARK_DATE | ● | Postmark date. | |
| RECEIPT_DATE | ● | Receipt date. | |
| RECEIPT_NUMBER | ● | Receipt number. | |
| REFERENCE_TYPE | ● | Type of reference. | |
| REVERSAL_CATEGORY | ● | Reversal category. | |
| REVERSAL_COMMENTS | ● | Reversal comments. | |
| REVERSAL_DATE | ● | Reversal date. | |
| REVERSAL_REASON_CODE | ● | Code identifying the reversal reason. | |
| STATUS | ● | Status. | |
| TAX_RATE | ● | Tax rate. | |
| TYPE | ● | Type. |
25 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to AR_CASH_RECEIPTS_ALL.
- Auto Reconciliation Execution Report
- Transactions Available for Reconciliation Report
- AR Aging Detail Report
- AR Applied and Unapplied Receipts Register Report
- AR Open Claim Summary and Detail Report
- Cash Settlement Report
- Greece Notes Receivable - Post Dated Checks and Drafts Report
- Open Closed Claim Detail Report
- Receipt History Report
- SEPA Debit Authorization and Bank Detail Check Report
- Vietnam Receipt Voucher Report
- Unclaimed Property Report (United States)
- Document Number Audit Report
- Receipts Days Late Analysis Report
- Receipts Awaiting Bank Clearance Report
- Receipts Awaiting Remittance Report
- Bank Risk Report
- Reversal Status Report
- Automatic Receipt Creation and Remittance Execution Report
- Clear Receipts Automatically Execution Report
- Create Automatic Receipt Write-offs Execution Report
- Format Automatic Receipts Report
- Process Receipts Through Lockbox Execution Report
- Close Matured Bills Receivable Execution Report
- Cash in Transit Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - New COGS and Gross Margin Details Real Time
- Receivables - Adjustments Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Payment Schedules Real Time
- Receivables - Receipt Conversion Rate Adjustments Real Time
- Receivables - Receipts Details Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Subledger Accounting - Journals Real Time
Need the extract + dbt staging for AR_CASH_RECEIPTS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table