Oracle Fusion · Data dictionary
AR_CASH_RECEIPT_HISTORY_ALL
ReceivablesUsed in 2 subject areas17 reporting columns
Receivables (AR), transaction table (rows scoped across all operating units).
Primary key: CASH_RECEIPT_HISTORY_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_AMOUNT | ● | Acctd amount. | |
| ACCTD_FACTOR_DISCOUNT_AMOUNT | ● | Acctd factor discount amount. | |
| AMOUNT | ● | Amount. | |
| CASH_RECEIPT_HISTORY_ID | PK | ○ | Identifier for the cash receipt history. |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENT_RECORD_FLAG | ● | Indicator (Y/N) for the current record. | |
| EXCHANGE_DATE | ● | Exchange date. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| FACTOR_DISCOUNT_AMOUNT | ● | Factor discount amount. | |
| FIRST_POSTED_RECORD_FLAG | ● | Indicator (Y/N) for the first posted record. | |
| GL_DATE | ● | General ledger date. | |
| GL_POSTED_DATE | ● | General ledger posted date. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| POSTABLE_FLAG | ● | Indicator (Y/N) for the postable. | |
| REVERSAL_GL_DATE | ● | Reversal general ledger date. | |
| REVERSAL_GL_POSTED_DATE | ● | Reversal general ledger posted date. | |
| STATUS | ● | Status. | |
| TRX_DATE | ● | Transaction date. |
2 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_RECEIPT_HISTORY_ALL.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
Need the extract + dbt staging for AR_CASH_RECEIPT_HISTORY_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table