Oracle Fusion · Data dictionary
AR_TRANSACTION_HISTORY_ALL
ReceivablesUsed in 1 subject areas13 reporting columns
Receivables (AR), transaction table (rows scoped across all operating units).
Primary key: TRANSACTION_HISTORY_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COMMENTS | ● | Comments. | |
| CURRENT_ACCOUNTED_FLAG | ● | Indicator (Y/N) for the current accounted. | |
| CURRENT_RECORD_FLAG | ● | Indicator (Y/N) for the current record. | |
| EVENT | ● | Event. | |
| GL_DATE | ● | General ledger date. | |
| GL_POSTED_DATE | ● | General ledger posted date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MATURITY_DATE | ● | Maturity date. | |
| POSTABLE_FLAG | ● | Indicator (Y/N) for the postable. | |
| POSTING_CONTROL_ID | ● | Identifier for the posting control. | |
| STATUS | ● | Status. | |
| TRANSACTION_HISTORY_ID | PK | ○ | Identifier for the transaction history. |
| TRX_DATE | ● | Transaction date. |
5 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_TRANSACTION_HISTORY_ALL.
- Greece Notes Receivable - Post Dated Checks and Drafts Report
- Automatic Bills Receivable Remittance Execution Report
- Automatic Bills Receivable Transactions Batch Report
- Close Matured Bills Receivable Execution Report
- Print Bills Receivable 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.
Need the extract + dbt staging for AR_TRANSACTION_HISTORY_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table